Connection to SSAS datasource

[Matt_85]

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

[MFGF]

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.

[DaHammer]

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

[MFGF]

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.

[DaHammer]

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 ...

[MFGF]

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.

[sdf]

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?