File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes JDBC and Relational Databases and the fly likes Datasource for non-default instance of SQL Server Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "Datasource for non-default instance of SQL Server" Watch "Datasource for non-default instance of SQL Server" New topic

Datasource for non-default instance of SQL Server

Ramaswamy Srinivasan
Ranch Hand

Joined: Aug 31, 2004
Posts: 295
Dear All,

We are experiencing this situation now. On our database server, we are planning to create a non-default instance of the SQL Server Database.

On our application server, we need to configure a datasource to point to this database, which will be looked up by the application code and used for connectivity.

The information will look something like this.

Datasource Name : java:comp/env/jdbc/
Driver : net.sourceforge.jtds.jdbc.Driver
Connection URL : jdbc:jtds:sqlserver://

Here, 1433 is the default port to which the default instance of the SQL will be listening to. If we create a non-default instance, the port will change, and the name of the datasource will change too.

In that case, how do we create the datasource for the non-default instance?
How would the URL field look like, provided we have the host:port info.

Requesting you to kindly help me. Thanks in advance for the reply!!
Paul Sturrock

Joined: Apr 14, 2004
Posts: 10336

An "instance" in SQL Server terms is a distinct server, not a database. Is it an instance you mean? If it is I think you address it by simply changing the port numebr to the number the named instance is listening on.

JavaRanch FAQ HowToAskQuestionsOnJavaRanch
I agree. Here's the link:
subject: Datasource for non-default instance of SQL Server
It's not a secret anymore!