I've been working on a site this week where AAC had been configured to use an MSDE database whilst the production SQL infrastructure was still being built. All well and good, and later the db would just be migrated over to the SQL servers and the AAC boxes configured to point to the new database hosts. 

 Nothing amazing or out of the ordinary there, until I came to reconfigure the AAC boxes - having backed up the database, and restored it to the new SQL cluster, I used the AAC server configuration tool to 'point' to the new DB.

It would get so far (just past COM+, about 20% of the progress bar) and fail with 'The server configuration tool failed to complete successfully'. VERY useful.

No event log, no useful error, no logs in Program Files\Citrix\Access Gateway\Logs.

Pointing the configuration back to the MSDE database didn't work either, so I uninstalled AAC and reinstalled it. Pointing to the new database failed again.

Thankfully I had an image of the server before AAC, and after lots of to-ing and fro-ing, determined that the issue was that the Transaction Logs on the SQL database had growth restricted to 10mb.

Unrestricted it and all fine :-)

What a painful few hours that was. I really like AAC but when it goes wrong, it does go *really* wrong.