Define Data Server Connection in Cognos v11

for Microsoft SQL Server:

JDBC URL is:
jdbc:server://<server name>\<instance>:<port number>;DATABASE=<database name>

This is the format I was able to make it test successfully. Make sure your port number is correct. To find out SQL server port, please see previous post.

This also worked:
jdbc:server//<server name>:<port number>;DATABASE=<database name>;INSTANCENAME=<instance name>

You can also use a datasource connection already defined in Cognos Administration provided the JDBC connection for that datasource is enabled and configured (DQM enabled). You just have to check the Allow web-based modeling checkbox. You can find this checkbox in Connection tab of Properties for the datasource.