web stats
Microsoft SQL Server Instance not recognized - Mirth Community

Go Back   Mirth Community > Mirth Connect > Support

Reply
 
Thread Tools Display Modes
  #1  
Old 09-13-2006, 07:14 AM
nshaik nshaik is offline
Mirth Guru
 
Join Date: Sep 2006
Posts: 302
nshaik
Default 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



Reply With Quote
  #2  
Old 09-13-2006, 11:35 AM
chrisl chrisl is offline
Mirth Employee
 
Join Date: Aug 2006
Posts: 967
chrisl is an unknown quantity at this point
Default 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
Reply With Quote
  #3  
Old 09-13-2006, 12:06 PM
chrisl chrisl is offline
Mirth Employee
 
Join Date: Aug 2006
Posts: 967
chrisl is an unknown quantity at this point
Default 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
Reply With Quote
Reply

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Microsoft SQL server billp@mcmc.net Support 4 07-15-2012 11:51 AM
Microsoft Access question jhon Support 4 01-20-2009 08:48 AM
java 1.5 instance and JAVA_HOME d_m Support 3 09-23-2008 11:26 PM
OBX segments of type 'ST' are not recognized docinthebox Support 0 01-14-2008 09:34 AM
Variables not recognized in DBwriter destination r_kerry Support 2 11-23-2007 05:42 AM


All times are GMT -8. The time now is 01:40 PM.


Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2020, vBulletin Solutions, Inc.
Mirth Corporation