Getting error OP-ERR-0068 when testing the connection to a MS cube

[BI-forme]

Hello,

I am trying to connect to a MS Analysis Cube (SQL2005) and Cognos 8.3.
When I test the connection i get this message: OP-ERR-0068 Logon failure.

What can I do to fixed this ?

Thanks!

BI forme.

[kolonell]

Hi BI-Forme

What is the signon type you use for this connection ? note that  when you use SSO to MSAS then you'll always get this
error when testing even though the connection works when using in FM or Report Studio.

[cfbos]

I am using Active-Directory and SSO.
When I set [Allow anonymouse access?] in Cognos Configuration to [trUE] I still get the same error.
I can't add the connection to FM, so I can't make a package or report.

[kolonell]

What type of SSO? IdentityMapping isn't allowed by MSAS 2005 so kerberos sso needed

[BI-forme]

Hi kolonell,

Thanks for the reply.
I use(d) IdentityMapping.
I will look at 'kerberos'.
It's new for me, but found a lot off hits at the knowledge-base at Cognos ;D
I will let you know.

BI-forme.

[kolonell]

Good luck !  :P

Kerberos can be easy to set up if all goes well ... sometimes it can be a nightmare to debug though.