SQL Server - Datasource

[ryanbalz]

Dear Experts,

I am trying to create a new SQL Server 2005 datasource within cognos however I am not sure on the properties of the connection string.

Let us suppose i can access the database by following this path on my network: xx.xx.xx.xx\database running on default port 1433.

Then all I need to do is set the server connection property, being xx.xx.xx.xx:1433\quality. Then I would insert the database name and the sql server agent that has been created for authentication.

Is this the correct procedure? am i following the correct semantics for the server name?  will be really greateful for your feedback.

Regards.

[Grim]

Is your Cognos install on a Windows machine as well? If yes, just install the MS SQL DB client on the same box and use a native connection. SHould only need to specify server, port and DB name from there.

[ryanbalz]

Hi Grim,

I don't have access to the server but if I am not mistaken installation is running on a linux environment. From your comment it seems that the administrators need to install something at server side. If yes, based on our environment do you have any idea what they need to install?

This is the approach I am following:

• Went into cognos administration and selected the option to create a new datasource (web based)
• Selected "SQL Server 2005 native connection"
• Then inserted the connection properties as specified previously.

Do I need to do anything else?

Thanks for your help.

[Grim]

If you are using Linux then you will need to use the MS SQL JDBC connection, or IBM Cognos Virtual View Manager (VVM).

MS SQL JDBC
http://msdn.microsoft.com/en-us/sqlserver/aa937724.aspx