Citrix XenApp failed to connect to the Data Store


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
Solution:

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

An unexpected error occurred. Check that the server name is correct, that the server is on, that Citrix XenApp is installed on this server, and that the Citrix MFCOM Service is running.


Error Message:

An unexpected error occurred. Check that the server name is correct, that the server is on, that Citrix XenApp is installed on this server, and that the Citrix MFCOM Service is running.

Citrix-Error

 

 

 

 

 

 

 

 

 

Cause for this issue:

There are multiple possible causes for this issue.  Possible resolutions are given below.

Cause1: Network COM+ will not be installed or not enabled.

Solution: Install Network COM+ in the Windows2008 or 2003 roles.

Cause2: The user is not a member of the Distributed COM Users group on the server

Solution: Add the user to the BUILT-IN\Distributed COM Users group on the server you are connecting to. The recommendation is to do this using nested group, such as a Citrix Admins group.

The above solutions are the common points for this issue.

I still have the problem after doing the above configuration and also I got ODBC error in event viewer.

I also made an attempt to configure the ODBC FileDSN and give the file path of C:\Program Files (x86)\Citrix\Independent Management Architecture\MF20.dsn where the authentication fails.

Solution to my Problem:

In the windows services, select the service “Citrix Independent Management architecture” and give your user account or common user account in the logon as menu option which has admin privileges.

Do the same for Citrix WMI service where it is a dependent service for CIMA.

Restart that service and this helps me to overcome the above error.

Citirx-CIMA