COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => COGNOS Connection => Topic started by: paloalto_cognos on 16 Mar 2011 02:37:11 PM

Title: Configure Database in cognos connection
Post by: paloalto_cognos on 16 Mar 2011 02:37:11 PM
Hi,

I'm not able to configure databases in cognos connection.

database - sql server 2005
O/S - windows xp professional sp2
cognos version 8.4

I have configures sql server as windows authentication mode.
Installed all samples but gives an error of login failed everytime I try to add datasource to cognos connection.

Please help..!
Title: Re: Configure Database in cognos connection
Post by: NimrodA on 16 Mar 2011 04:29:02 PM
Can you log into SQL Server with the credentials you supply to Cognos when adding the DB?
Title: Re: Configure Database in cognos connection
Post by: AussiePete2011 on 16 Mar 2011 05:12:14 PM
Hi there

This might be what you are after
https://www-304.ibm.com/support/docview.wss?uid=swg21341889

Cheers
Peter B