COGNOiSe.com - The IBM Cognos Community

IBM Cognos Analytics Platform => Cognos Analytics => Administration and Security => Topic started by: Matt_85 on 04 Jun 2016 03:06:17 PM

Title: Connection to SSAS datasource
Post by: Matt_85 on 04 Jun 2016 03:06:17 PM
Hi,

I have a windows machine(Machine A) on which i have Cognos 11 and SQL server 2012 express edition installed and a seperate machine (Machine B) on which SQL server 2012 developer edition is installed.

Machine B hosts the database and SSAS cubes. Iam able to create and connect datasource from Cognos adminstration for database.

But when i create datasource for SSAS, i get the error :XQE-DS-0006 Unable to logon to the data source.

Can someone please help me.

Regards,
Matt
Title: Re: Connection to SSAS datasource
Post by: MFGF on 08 Jun 2016 10:17:52 AM
Quote from: Matt_85 on 04 Jun 2016 03:06:17 PM
Hi,

I have a windows machine(Machine A) on which i have Cognos 11 and SQL server 2012 express edition installed and a seperate machine (Machine B) on which SQL server 2012 developer edition is installed.

Machine B hosts the database and SSAS cubes. Iam able to create and connect datasource from Cognos adminstration for database.

But when i create datasource for SSAS, i get the error :XQE-DS-0006 Unable to logon to the data source.

Can someone please help me.

Regards,
Matt

How are you authenticating your connection to SSAS?

MF.
Title: Re: Connection to SSAS datasource
Post by: DaHammer on 12 Jun 2016 09:11:21 AM
This might be silly to ask, but have you deployed SSAS drivers on Machine A? You need SSAS OLE DB drivers. Google for SQL Server [version] Feature Pack.

P.S. The admins of this site used to be smart ... Which idiot's idea was it to require "human verification" for every post?  :o
Title: Re: Connection to SSAS datasource
Post by: MFGF on 13 Jun 2016 03:20:43 AM
Quote from: DaHammer on 12 Jun 2016 09:11:21 AM
P.S. The admins of this site used to be smart ... Which idiot's idea was it to require "human verification" for every post?  :o

It's only for the first couple, and it prevents bots posting spam. :)

MF.
Title: Re: Connection to SSAS datasource
Post by: DaHammer on 13 Jun 2016 09:43:01 AM
I see you are as active as I recall, MFGF ... Long time no hear. This is Darek, the guy who used to own this site ...
Title: Re: Connection to SSAS datasource
Post by: MFGF on 13 Jun 2016 11:22:25 AM
Quote from: DaHammer on 13 Jun 2016 09:43:01 AM
I see you are as active as I recall, MFGF ... Long time no hear. This is Darek, the guy who used to own this site ...

Ahhh! Nice to see you on here again after all these years Dariusz!! Lots of new members won't realise this, but many of the posts under the guise of "Cognoise Administrator" are yours as well as all the posts under "Darek", which means you're responsible for lots of outstanding answers on these pages! We owe you a huge vote of thanks!! :)

Cheers!

MF.
Title: Re: Connection to SSAS datasource
Post by: sdf on 01 Aug 2016 10:10:40 PM
Hi,

Is there anyway of connecting the new Tm1 10.3 with CA 11?
Im not particularly sure how the authentication will be handled and where? from CA or Tm1 10.3 (on cloud?) or a proxy server?