Please check out www.kaztechsolutions.co.uk for more of my technical posts, alternately please call us on 01932 268289.
Recently ran in to an error where I couldn't connect to any XenApp server using the AppCenter and I was getting the following errors within the system event log.
Event ID 3989
Citrix XenApp failed to connect to the Data Store. ODBC error while connecting to the database: 28000 -> [Microsoft][ODBC SQL Server Driver][SQL Server]Login failed. The login is from an untrusted domain and cannot be used with Windows authentication.
Event ID 3632
The server running Citrix XenApp failed to connect to the data store. Invalid database user name or password. Please make sure they are correct. If not, use DSMAINT CONFIG to change them. Error: IMA_RESULT_ACCESS_DENIED Indirect: 0 Server: DSN file: C:\Program Files (x86)\Citrix\Independent Management Architecture\mf20.dsn
Event ID 3612
The server running Citrix XenApp failed to connect to the Data Store IMA_RESULT_ACCESS_DENIED. Invalid database user name or password. Please make sure they are correct. If not, use DSMAINT CONFIG to change them.
Now it turns out that the farm was configured to use the administrator account for access to the datastore and when the domain administrator password was changed these errors start to appear.
To get round this issue (Not use the domain admin account!!!) run the following DSMAINT command and set the correct password for the administrator account.
DSMAINT CONFIG /user:domain\administrator /pwd:password
Ideally you should change the account used for this to a different account that is used for XenApp only.