Problem Conneting MS SQL 2005

[Former Member]

Hi All,

We have a requirement to connect to MS SQL 2005, We have uploaded the sqljdbc.jar and depolyed and MII 12.0 server.

We have configured the Data Server with following details.

JDBCDriver com.microsoft.sqlserver.jdbc.SQLServerDriver 
ServerURL jdbc:sqlserver://<Server_IP>;databaseName=<dbName>; 

When we try to see the Status of the connection it shows status as Stopped.

The same server I am able to connect using Java Program.

Please help me on this issue.

Rupesh

[subramaniyan_thangavel · Accepted solution]

Hi

First , Check your JDBC driver , Did you installed JDBC driver for SQL server 2005?

Second, ServerURL should have be like this

jdbc:sqlserver://<servername>:1433;databaseName=<dbname>

[Former Member · Accepted solution]

Thanks all,

Our problem has been solved, We actually deployed wrong version of Driver.

Thanks for all your Suppport.

Rupesh