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

 

11.0.7 connection to Microsoft Analysis Services 2016 / XMLA issues

Started by khanberg, 25 Sep 2017 06:57:23 AM

Previous topic - Next topic

khanberg

We have been waiting for 11.0.7 for a long time now, but when it finally arrives, we cannot get any SSAS connections to work properly.

Our test environment consist of MS SQL 2016-SP1 (Windows Server 2012 R2) and Cognos Analytics 11.0.7 (Windows Server 2012 R2)

We have installed appropriate 64bit driver (Analysis Services OLE DB Provider for Microsoft SQL ServerĀ® 2016).

When testing the datasource we get an error:
XOD-CON-0001 Failed to connect to OLE DB for the provider (Microsoft Analysis Services 2016) and server (cognosdw01). The data provider returned an error message: "The '-1' locale is not supported.".

It seems it is parsing a invalid locale in the connection string:
Connection string:
"^User ID:^
Password:;LOCAL;M16;SERVER=cognosdw01;UID=%s;PWD=%s;LCID=en-us"

As far as I can see the supported locales needs to be 4 digit code (ie 1033).

The SSAS instans is running "danish-norwegian" collation. We have tried with "Latin_1_General". Same result.

Any ideas?