Citrix Xen Application DataStore Move

To move SQL database from the old server to the new server:

• Stop IMA service on all Citrix servers
• Take a full backup of the data store DB from the old server
• Restore the backup to the new SQL server
• Edit the MF20.DSN ODBC file on Zone data collector server
• Change the old server to the new server
• Run the following command

C:> dsmaint config /user:sql-username /pwd:sql-password /dsn:"C:\Program Files\Citrix\Independent Management Architecture\MF20.dsn"

C:> dsmaint recreatelhc

• Start the IMA service
• Do the same thing for the rest of the servers

Windows 2008 UAC

I have SQL 2008 x64 (mixed mode) installed on Windows 2008 x64. When trying to login to SQL using my Domain Admins account, I get the following error:

Login failed for user 'DOMAIN\username'. Reason: Token-based server access validation failed with an infrastructure error. Check for previous errors. [CLIENT: X.X.X.X]

answer? "Run as administrator" the SQL Server Management Studio!!

Apparently UAC does not pass your user group membership properly to the SQL Server Management Studio.