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:
Post a Comment