Microsoft SQL Server Instance not recognized

[nshaik]

----------------------------------
Environment:
Windows 2000 Server w/SP4, Microsoft SQL Server 2000 w/SP3a
Mirth v1.1, Java Version 1.5.0 (build 1.5.0_08-b03)
[line=#808080]
----------------------------------

Name of the Server: TestServer

Name of SQL Server Instance: TestServer\netsdk
----------------------------------

Setup channel to write to database.

Destination Database: jdbc:jtds:sqlserver://TestServer\\netsdk:1433/TestDB

Getting Exception: Unknown server host name 'TestServer\\netsdk'

NOTE: First tried with a single back-slash ("") before the instance name and then tried with two back slashs (escape sequence) like shown above. Same exception on both cases.

-NS

[chrisl]

Re: Microsoft SQL Server Instance not recognized

TestServer\netsdk isn't a valid hostname for JDBC, so it's throwing the exception. All connection strings need to be in the format:

sqlserver://serverort/dbname

Server can either be the IP address of the machine or the actual computer name.

[chrisl]

Re: Microsoft SQL Server Instance not recognized

This is from Da Buddhaman on the Developer Forum:

Look for the domain property at jTDS JDBC Driver for your answer.

You SQL Server connection string could be something like this:
jdbc:jtds:sqlserver://localhost:1433;databaseName=mydatabase;domain=mydo main