Issues with connecting to SQL Server from Cognos

[sag4cognos]

Hello All,

I am currently using Cognos 8.4 with SQL Server 2008.
I have created an active data source connection.

^User ID:^?Password:;LOCAL;OL;DBInfo_Type=MS;Provider=SQLOLEDB;User ID=%s;Password=%s;Data Source=REW12;Integrated Security=SSPI;Provider_String=Initial Catalog=SMDW;Application=SQL;@COLSEQ=

The issue here is, everytime I run the report, Cognos asks for userid and password. I wanted to configure it in such a way, that it captures the login credentials from the active server directory groups, instead of me providing the login details.

Any suggestions, please. ???

Thanks,
Sagar

[simon.hodgkiss]

Have you created a signon that "Everyone" group can use?

In IBM Cognos Administration > Configuration select your data source, then select the connection.  Now create new signon.  Give it an appropriate name and configure with the signon credentials of a DBO for your SQL DB.  Next select the appropriate group who should have access to the signon (for simplicity "Everyone" in this example).

Also ensure that the "Everyone" group has Read, Execute, Traverse permissions to the signon.

Hope that helps.