Friday, March 23, 2012

Named instance and JDBC driver

I have named SQL Server 200 instance installed.
I am trying to connect to connect this named instance using
java application which using JDBC driver ?
anybody knows how can I connect named instance using JDBC driver ?
thank you for timely help
jagdishYou have to use the port number for the named sql server instance:

e.g.

jdbc:microsoft:sqlserver://servername:portnumber;user=XXX;password=YYY

No comments:

Post a Comment