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/mysqlserver.mysite.com
Driver : net.sourceforge.jtds.jdbc.Driver
Connection URL :
jdbc:jtds:sqlserver://mysqlserver.mysite.com:1433
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!!