Connection from FM to SQLServer2012 doesn't complete

[LEO]

hi,

I have below environment.

Cognos 10.2 FM on Windows2007.
SQL Server 2012(on remote machine)

I am able to connect to the Cognos connection. And also able to publish the package from FM to the COgnos BI server.

But when i try to do "Test Connection" from Framework Manager, it doesn't complete and keep on running endlessly?

I installed SQL Server 2012 64 bit Developer edition on system where FM is installed.

I checked the cogserver.log:
The error message it gives is:

Response         Failure   FM   CM-REQ-4159 Content Manager returned an error in the response header. The error "cmAuthenticateFailed CM-CAM-4005 Unable to authenticate. Check your security directory server connection and confirm the credentials entered at login." can be found in the response SOAP header.

Since, FM is a 32 Bit, do i need to install any additional drivers to connect from FM?

Any help on this issue please?

Thanks & Regards,
Ramesh

[cognostechie]

You don't even need to install SQL Server client on the machine that has FM. The only time that will be required is when the datasource in Cognos is created using 'SQL Server 2012 Native Client'. If the datasource is created using 'SQL Server OLE DB' then SQL client is not required on the FM server. The login that FM uses is the one embedded in the datasource so you might want to check that. It seems that the credentials required for Content Store are valid because you can publish a package. FM, at any time, is connected to two databases.

1> Content Store which is a database used by Cognos to host the reports and packages
2> The database which contains the data which the reports will present

Check the credentials required for (2) and see if they are the same as stored in the datasource. Also, open FM, right-click on the datasource and 'Test'. Also, check if it can reach your directory server (Ex: Active Directory)

[LEO]

hi,

Thank You.

Earlier we were having the SQL Server 2008 R2, to which i was able to connect, Test connection and publish also.
Recently, the db has been upgraded to 2012. The Connection Administration is not accessible to us.

From another system with similar setup, we are able to successfully Test the connection in FM.

When i do "Test Connection" to datasource in FM, it never ends up.

I checked the cogserver.log:
The error message it gives is:

Response         Failure   FM   CM-REQ-4159 Content Manager returned an error in the response header. The error "cmAuthenticateFailed CM-CAM-4005 Unable to authenticate. Check your security directory server connection and confirm the credentials entered at login." can be found in the response SOAP header.

Regards,
Ramesh

[MFGF]

hi,

Thank You.

Earlier we were having the SQL Server 2008 R2, to which i was able to connect, Test connection and publish also.
Recently, the db has been upgraded to 2012. The Connection Administration is not accessible to us.

From another system with similar setup, we are able to successfully Test the connection in FM.

When i do "Test Connection" to datasource in FM, it never ends up.

I checked the cogserver.log:
The error message it gives is:

Response         Failure   FM   CM-REQ-4159 Content Manager returned an error in the response header. The error "cmAuthenticateFailed CM-CAM-4005 Unable to authenticate. Check your security directory server connection and confirm the credentials entered at login." can be found in the response SOAP header.

Regards,
Ramesh

Hi,

How are you connecting to SQL Server? Native Client? JDBC? ODBC?

I suspect the issue is that you are using native client, and you don't have the SQL Server 2012 Native Client libraries installed on your FM machine.

MF.

[LEO]

hi,

I have installed Native Client on FM.
I checked for these files "sqlncli11.dll" , "s11ch_sqlncli.chm" and "sqlnclir11.rll" are available in system32 and SysWoW64 folders.

Do i need to install something else to complete the Sql Native Client driver installation?

Regards,
Ramesh

[bdbits]

Those would be the right drivers, and I think I am right in assuming you used the installer and did not just copy files, so that the registry entries and such were also set properly. Also, the 64-bit client also installs the 32-bit client. You sure the data source connection is not defined with JDBC drivers? That would be a different install.

I think I might install SSMS on the FM box and see if you can connect with that to ensure the native functionality is working properly.

[cognostechie]

hi,

I have installed Native Client on FM.
I checked for these files "sqlncli11.dll" , "s11ch_sqlncli.chm" and "sqlnclir11.rll" are available in system32 and SysWoW64 folders.

Do i need to install something else to complete the Sql Native Client driver installation?

Regards,
Ramesh

You can also go to Cognos Admin and change the properties in the Data Sources. If you change it to use OLE DB then it wont need anything else.
I did this in our current environment and it worked. We don't need to install SQL new version an any FM machine now.

[LEO]

hi,

SSL was implemented on the cognos server which was having the data source i was trying to connect. And it needed certificates to be installed on my machine where Framework is installed. I got those steps to implement and yet to try and see if that resolves the issue.

However, I installed sql server 2008 R2 along side the sql server 2012 and tried test connection to another cognos server where SSL was not implemented, it worked fine and i was able to connect successfully to the data source.

Thank you all of you for various options suggested.

regards,
ramesh