Using MSSQL (9/10) DB and Named Instances
I have noticed that there are no instructions as to how to set up the software if the database is running Named Instances (aka the software is not the only service using the database and there are separate servers installed running side-by-side).
So the following is a list of instructions on how to get it working as I figured it out:
1. Install the server with false server info
2. Shut down the server service if it is running.
3. open the file C:\Adventnet\ME\SupportCenter\Server\default\deploy\mssql-ds.xml
It should look something like this...
4. Change the connection url to look like the following :
5. save the file and start the server again (you may have to create the actual database 'supportcenter')
6. all done!
Enjoy your new setup of SC+!
Bryen Begg
Computer Systems Technician
So the following is a list of instructions on how to get it working as I figured it out:
1. Install the server with false server info
2. Shut down the server service if it is running.
3. open the file C:\Adventnet\ME\SupportCenter\Server\default\deploy\mssql-ds.xml
It should look something like this...
<?xml version="1.0" encoding="UTF-8"?>
<!-- ===================================================================== -->
<!-- -->
<!-- JBoss Server Configuration -->
<!-- -->
<!-- ===================================================================== -->
<!-- $Id: mssql-ds.xml,v 1.1 2007/03/09 05:31:43 vinu Exp $ -->
<!-- ==================================================================== -->
<!-- Datasource config for MySQL using 2.0.11 driver -->
<!-- ==================================================================== -->
<datasources>
<local-tx-datasource>
<jndi-name>MSSQLDS</jndi-name>
<connection-url>jdbc:jtds:sqlserver://<SERVER>:<PORT #>;DatabaseName=supportcenter;Tds=8.0;PrepareSql=3;XaEmulation=false;</connection-url>
<driver-class>net.sourceforge.jtds.jdbc.Driver</driver-class>
<user-name><DB USERNAME></user-name>
<password><DB PASSWORD></password>
</local-tx-datasource>
</datasources>
4. Change the connection url to look like the following :
...
<connection-url>jdbc:jtds:sqlserver://<SERVER>:<PORT #>;instance=<INSTNACE NAME>;DatabaseName=supportcenter;Tds=8.0;PrepareSql=3;XaEmulation=false;</connection-url>
...
5. save the file and start the server again (you may have to create the actual database 'supportcenter')
6. all done!
Enjoy your new setup of SC+!
Bryen Begg
Computer Systems Technician