Connecting to MSSQL SERVER NAMED INSTANCE

[kchan]

Hi,

I was able to connect to MSSQL through JBOSS fine when the server was on our site. But now we moved it off to another site where aparently there is a MSSQL 7 server and a MSSQL2000 server on the same IP address. In MSSQL enterprise manager I was able to successfully register this database by entering for example the address "123.123.123.123\InstanceName" but in JBOSS i tried to replace the IP i had before with this and it doesn't work. I think the problem is that JBOSS does not recognize the backslash. Any Ideas on how to connect??

[kchan]

O, I forgot, I am running JBOSS 3.0.2

[jasonbrome]

Which MSSQL JDBC driver are you using? (Microsoft, i-net, DataDirect?)

It varies between different vendors - e.g. using the i-net Opta driver, for the SQL server instanced named 'myinstance' on IP 192.168.2.201

jdbc:inetdae7:192.168.2.201/myinstance

I'm not so familiar with the other drivers, but try putting either a forward slash, or two backslashes between the host name and the instance name in your connection string.

Jason