Configure MSSQL on a different server?

[JayByrd721]

Is there a config file or connection string that can be updated to allow the pacsdb to run on a seperate server? My db of choice is MSSQL.

 

Apologies if this is a duplicate post but I'm having trouble finding how to configure this.  Plus, it is my first attempt at installing dcm4chee. I am working with Version 2.17.1-mssql, JDK7 (update 10), and JRE7 on Win2008-64 (SQL Server 2005).

[Damien Evans]

Yes, in fact better performance can usually be realized if the database resides on another server because it reduces IO contention.  The place to configure it is within the JBoss datasource files:

• server/default/deploy/pacs-mssql-ds.xml for the main database (pacsdb)
• server/default/deploy/arr-mssql-ds.xml for the audit record database (arrdb)

Within these files you will see the properties that are used to connect to the database.  Right now they probably say "localhost" with "1433" for the port number.  Change these values to suit your situation.  This change will need a restart, and it's best to make the change when the application is not shut down.  Please make sure that you have enabled your SQL Server for network access via TCP and that the firewall is allowing connections through the appropriate port.

 -- Damien

On Mon, Jan 7, 2013 at 9:08 PM, JayByrd721 <jcoll...@gmail.com> wrote:

Is there a config file or connection string that can be updated to allow the pacsdb to run on a seperate server? My db of choice is MSSQL.

 

Apologies if this is a duplicate post but I'm having trouble finding how to configure this.  Plus, it is my first attempt at installing dcm4chee. I am working with Version 2.17.1-mssql, JDK7 (update 10), and JRE7 on Win2008-64 (SQL Server 2005).

--
You received this message because you are subscribed to the Google Groups "dcm4che" group.
To post to this group, send email to dcm...@googlegroups.com.
To unsubscribe from this group, send email to dcm4che+u...@googlegroups.com.
Visit this group at http://groups.google.com/group/dcm4che?hl=en.
 
 

[Michael Pariona Alfaro]

Hola,

Estoy utilizando la version (dcm4chee-2.17.1-mssql) ,java jdk7 , sqlserver 2012 express,

pero tengo el mismo problema con los driver de jdbc. como puedo configurar estos drivers?

[Alvaro G. [Andor]]

Hi,

According to the MSSQL install instructions ( http://www.dcm4che.org/confluence/display/ee2/Microsoft+SQL+Server ) edit your datasource file ( pacs-mssql-ds.xml ) and edit your JDBC URL accordingly your database server configuration ( jdbc:sqlserver://localhost:1433;SelectMethod=cursor;DatabaseName=pacsdb )

Regards.

El 13/10/15 a las 1:40, Michael Pariona Alfaro escribió:

--

You received this message because you are subscribed to the Google Groups "dcm4che" group.

To unsubscribe from this group and stop receiving emails from it, send an email to dcm4che+u...@googlegroups.com.

To post to this group, send email to dcm...@googlegroups.com.

Visit this group at http://groups.google.com/group/dcm4che.
For more options, visit https://groups.google.com/d/optout.