Citrix IMA service not able to connect to the database
I changed the domain admin password and I think its tied into the ODBC database connection between our citrix servers and our citrix database. When I run the app center the autodiscovery fails, in the event viewer I see the error it states "Citrix XenApp failed to connect to the data store, ODBC error while connection to the database."
I went through the ODBC connections and I don't see one for this, I looked in admin tools and in c:\windows\syswow64 because this is a x64 server but I don't see a connection for it. Where can I find this connection so I can change the creds and get this working?
I went through the ODBC connections and I don't see one for this, I looked in admin tools and in c:\windows\syswow64 because this is a x64 server but I don't see a connection for it. Where can I find this connection so I can change the creds and get this working?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Good memory I found it. However I don't see a field to enter a password it does have a UID and that is the administrator account but no password feild
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Im unable to get it to work Im not sure what Im doing wrong. I stop the IMA service, open command prompt then navigate to the location of the mf20.dsn and run this command
dsmaint config /user:domain\username /pwd:password /dsn:"C:\Program Files (x86)\Citrix\Independent Management Architecture\mf20.dsn"
I get this error: failed to connect to the data store. This setting will be reverted back to previous setting
Unable to change configuration settings
Please verify parameters and data source
Do you see anything Im doing wrong?
dsmaint config /user:domain\username /pwd:password /dsn:"C:\Program Files (x86)\Citrix\Independent Management Architecture\mf20.dsn"
I get this error: failed to connect to the data store. This setting will be reverted back to previous setting
Unable to change configuration settings
Please verify parameters and data source
Do you see anything Im doing wrong?
how many xenapp servers?
ASKER
5 servers
on one, go to services.msc, sort on the logon as column, change the passwords for every service that uses the old account, restart those services, now run the command.
ASKER
None of the services use the account in question
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
It did not so I added it as a valid logon to the DB I gave the account all the permissions I could. I can logon to the DB from the server with that user account now but when I run the command on the citrix server I still get the same errors (I did shut down the IMA service before running the command on the citrix server).
ASKER
I got it I had the command written in notepad so I didn't have to retype and I had the password in there wrong. Thanks for the help
The account you are logged in with and running the dsmaint command, is it a full farm administrator? If not, run the command logged in as a user who is a full farm administrator.
Great, glad you got it resolved. Do the exact same process on the other 4 servers.
ASKER