Sql server DB connection to cognos

[sravs]

Hi,

we have unix servers and oracle databases connected to the cognos and working fine. But now few of our users need sql server connected to the cognos. so can I directly enter SQL SERVER database connection string information and connect to the sql server database or do I neeed to install sql server on our server and then connect to SQL server Database.

Thanks!

[MFGF]

Hi,

we have unix servers and oracle databases connected to the cognos and working fine. But now few of our users need sql server connected to the cognos. so can I directly enter SQL SERVER database connection string information and connect to the sql server database or do I neeed to install sql server on our server and then connect to SQL server Database.

Thanks!

Hi,

You need just the SQL Server client tools installed on the Cognos server to be able to connect successfully to SQL Server on a different server. If you want to use JDBC access you will need Microsoft's sqljdbc4.jar file on your Cognos server too.

Cheers!

MF.

[sravs]

ok thanks.. this helps me a lot