Announcement

Collapse
No announcement yet.

Microsoft SQL Server Instance not recognized

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Microsoft SQL Server Instance not recognized

    ----------------------------------
    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




  • #2
    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.
    Chris Lang

    Comment


    • #3
      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
      Chris Lang

      Comment

      Working...
      X