FM data source connectivity issue

[SianK]

**** Apologies if this question is been already addressed in this forum. I checked through few posts and could not find the answer ****

I have a Cognos 10.2.2 64 bit multi server installation and the content store is in SQL server. The content store & audit is connected using the windows authentication in cognos configuration.

Mys issue is when I create a data source connection (eg: - to the audit data base) from portal it works without any issues, and used native SQL server type and also used the authentication of service account.  However when I tried to create the native data source connection from FM to the same audit data source, FM is asking the user name and password and I have provided the user name and  password for service account and also tried with a cognos BI user as well. In both cases it is failed. But an odbc connection by creating an ODBC worked. however I needed to create odbc in all  servers where I have dispatacher/report server. The FM is installed in the server where I have content manager installed as well (it is also connected to audit and works well).

My query is can I connect to a data source from FM using native client? also does this needs the ODBC created in all the servers?

[MFGF]

**** Apologies if this question is been already addressed in this forum. I checked through few posts and could not find the answer ****

I have a Cognos 10.2.2 64 bit multi server installation and the content store is in SQL server. The content store & audit is connected using the windows authentication in cognos configuration.

Mys issue is when I create a data source connection (eg: - to the audit data base) from portal it works without any issues, and used native SQL server type and also used the authentication of service account.  However when I tried to create the native data source connection from FM to the same audit data source, FM is asking the user name and password and I have provided the user name and  password for service account and also tried with a cognos BI user as well. In both cases it is failed. But an odbc connection by creating an ODBC worked. however I needed to create odbc in all  servers where I have dispatacher/report server. The FM is installed in the server where I have content manager installed as well (it is also connected to audit and works well).

My query is can I connect to a data source from FM using native client? also does this needs the ODBC created in all the servers?

My guess is you don't have the SQL Server client libraries installed on the server you have FM on? They need to be on the same physical machine for it to be able to connect.

Cheers!

MF.

[SianK]

Thank you MF, I was also thinking the same way, but content manager is installed in the same server. Content content store is also in MS SQL server, so this is slightly confusing me.  Content store and audit can be connected without any issue and why FM is not.

The only query is that content manager uses 64bit and FM looks for 32 bit. I am looking to investigate this way now 

[MFGF]

Thank you MF, I was also thinking the same way, but content manager is installed in the same server. Content content store is also in MS SQL server, so this is slightly confusing me.  Content store and audit can be connected without any issue and why FM is not.

The only query is that content manager uses 64bit and FM looks for 32 bit. I am looking to investigate this way now

The connection to the content store does not use the SQL Server client libraries - it is a JDBC connection. You need to install the SQL Server client libraries on that machine to be able to connect using SQL Server Native Client (or OLE DB or ODBC). If, however, you want to connect via JDBC, you do not need the client libraries.

Cheers!

MF.

[SianK]

Thanks MF, we installed the 32 bit client libraries and it worked when supplying the SQL authentication. However if we use integrated security (to use Cognos service credentials, CM is configured this way as well) option from the portal data source connection, it still asking the user name and password from FM. I am confused about this now. Any thoughts

[MFGF]

Thanks MF, we installed the 32 bit client libraries and it worked when supplying the SQL authentication. However if we use integrated security (to use Cognos service credentials, CM is configured this way as well) option from the portal data source connection, it still asking the user name and password from FM. I am confused about this now. Any thoughts

That's odd. Have you checked that the IBM Cognos service on the machine with FM installed has the correct Log On information defined? Did you also configure the JDBC connection when setting up the data source connection? What happens if you try the JDBC connection?

MF.