Data mart can’t be started. couldn’t connect to source database. check your settings.

Product:
Cognos Controller 10.1.1
Windows 2008 R2 server
FAP Financial Analytics Publisher
Citrix server

Symptom:
When you click Start for the data mart in FAP manager you get a error message. You have installed the FAP client software on several Citrix servers, but it does not work on one of the servers.
You can login – and you can see the log table in FAP manager, you can even click on STOP button under data mart tab, to stop the FAP process. But you can not start it again.

Error message:
Data mart can’t be started. couldn’t connect to source database. check your settings.

Cause:
On the not working Citrix server you have installed this SQL driver
SQL Server 2008 R2 Native Client version 10.52.4000.0
but on the working Citrix server you have installed this SQL driver
SQL Server Native Client version 9.00.1399.06
SQL Server Native Client version 9.00.5000.00 will also work fine.

Solution:
Log in to Citrix Windows Server as local administrator
Go to Control Panel
Go to Program and Features
Uninstall Microsoft SQL Server 2008 native client
Download and install sqlncli_x64.msi from Microsoft web site.

Test the FAP client program again.