If you are unable to create a new account, please email support@bspsoftware.com

 

Issue authenticating data source connection to SSAS server

Started by oscarca, 25 Feb 2021 03:06:03 AM

Previous topic - Next topic

oscarca

Hello fellow Cognoise members,

I have recently moved both my Cognos Analytics (11.1.4) application and SQL server to two new servers. The SQL server migration went fine and also the Cognos installation went well. After that I imported the CA deployment file that I exported from the old Cognos server. Now the application looks exactly like it did before and my Active directory user login works. All of my jdbc data sources using the Microsoft SQL Server (Native client) connection type works but not the Microsoft Analysis Services ODBO data sources. The Microsoft SQL Server (Native client) uses a signon for the authentication of the connection string but not the Microsoft Analysis Services ODBO, it should use the Windows Authentication. If I validate the connection string with the Cognos Service Account it works but not if I use an regular account even though it has all the permissions in on the SSAS server and cube. Is it mandatory to install the Kerberos Config application on the SQL Server for Cognos to be able to communicate to the SSAS with Active Directory ?. Any guidence or tips are very appreciated.

Best regards,
Oscar

Steve

Just wondering if you have installed the database drivers on the new instance of Cognos?

oscarca

Hi Steve,

Yes all the drivers has been installed onto the new server. So the drivers seems to work since I actually can connect with my service account. Everytime I try to access a report with a regular account that uses an SSAS connection a window pops up prompting me to enter my credentials. It seems that Cognos is not able to pass the AD information to the server where SQL server is installed to authenticate me.