Search This Blog

Thursday, March 10, 2011

jTDS with sqlserver instance

jTDS is an open source 100% pure Java (type 4) JDBC 3.0 driver for Microsoft SQL Server (6.5, 7, 2000, 2005 and 2008).
when connecting to sqlserver instance instance a valid jdbc url should looks like this:
jdbc:jtds:sqlserver://YanivServer:1433/mydb;instance=myInstance;user=sa;password=xyz

make sure the next stuff is configured and running:
open the "sql server configuration manager "

  • sql browser service (its turn off by default) is running 
  • goto sqlserver network configuration  -> 
    •  the protocol of the instance , and make sure the  TCP/IP  is enabled.

enjoy 
Yaniv Tzanany

No comments: