Today I needed my XenApp 6.5 server to check something in my lab and I wasn’t able to run the discovery of my XenApp farm. I checked the services and they were running fine (IMA, MFCOM etc). In the event log however I saw these nice messages:
- Event ID 3889
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 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.
- 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)CitrixIndependent Management Architecturemf20.dsn
I recently moved my SQL database (hosted on hyper-v machine) from 1 server to another (complete new server as old hardware needed replacement) and SQL server VM was moved (no restore, exported VM and imported VM). IP addresses are the same etc.
With the following command I got the database connection back and restarted the IMA service.
C:Usersadministrator.CTXTST>dsmaint config /user:domain/user/pwd:password /dsn:”C:Program Files (x86)CitrixIndependent Management Architecturemf20.dsn”
After this I was able to connect to my XenApp environment again :).