No announcement yet.

Mirth Service not starting with SQL Server 2005

  • Filter
  • Time
  • Show
Clear All
new posts

  • Mirth Service not starting with SQL Server 2005

    I have set up Mirth before with the MIRTHDB database held in SQL Server and I didn't have any major problems.

    I'm now trying to install the Mirth service on another server running SQL Server 2005. I want to put the MIRTHDB into SQL Server. I ran the script to create the database and have created a SQL login to own the database. I can successfully connect to the database using this login.

    I can start the Mirth service if I use the default derby database.

    However when I try to run the Mirth service with SQL Server it fails to start. The connection information is as follows:

    Type: sqlserver2005
    URL: jdbc:jtds:sqlserver://localhost:1433/mirthdb
    Username: mydatabaseowner
    Password: mypassword

    The error log has a number of messages similar to the output below. I have monitored the SQL Server with the profile tools supplied by MS and I cannot see any sign that the Mirth Service is trying to establish a connection to the database server. I would be grateful if someone could help me solve this problem. Thanks.

    WARN 2008-06-20 12:54:58,308 [SslListener0-1] com.webreach.mirth.server.controllers.Configuratio nController: could not retrieve status of database
    java.sql.SQLException: I/O Error: DB server closed connection.
    at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCor
    at net.sourceforge.jtds.jdbc.TdsCore.login(TdsCore.ja va:599)
    at net.sourceforge.jtds.jdbc.ConnectionJDBC2.<init>(C
    at net.sourceforge.jtds.jdbc.ConnectionJDBC3.<init>(C
    at net.sourceforge.jtds.jdbc.Driver.connect(Driver.ja va:178)
    at java.sql.DriverManager.getConnection(Unknown Source)
    at java.sql.DriverManager.getConnection(Unknown Source)
    at com.ibatis.common.jdbc.SimpleDataSource.popConnect ion(
    at com.ibatis.common.jdbc.SimpleDataSource.getConnect ion(
    at com.webreach.mirth.server.controllers.Configuratio nController.getStatus( :631)
    at com.webreach.mirth.server.servlets.ConfigurationSe rvlet.doPost(
    at javax.servlet.http.HttpServlet.service(HttpServlet .java:616)
    at javax.servlet.http.HttpServlet.service(HttpServlet .java:689)
    at org.mortbay.jetty.servlet.ServletHolder.handle(Ser
    at org.mortbay.jetty.servlet.ServletHandler.dispatch(
    at org.mortbay.jetty.servlet.ServletHandler.handle(Se
    at org.mortbay.http.HttpContext.handle(HttpContext.ja va:1530)
    at org.mortbay.http.HttpContext.handle(HttpContext.ja va:1482)
    at org.mortbay.http.HttpServer.service(HttpServer.jav a:909)
    at org.mortbay.http.HttpConnection.service(HttpConnec
    at org.mortbay.http.HttpConnection.handleNext(HttpCon
    at org.mortbay.http.HttpConnection.handle(HttpConnect
    at org.mortbay.http.SocketListener.handleConnection(S
    at org.mortbay.util.ThreadedServer.handle(ThreadedSer
    at org.mortbay.util.ThreadPool$
    Caused by: DB server closed connection.
    at net.sourceforge.jtds.jdbc.SharedSocket.readPacket(
    at net.sourceforge.jtds.jdbc.SharedSocket.getNetPacke t(
    at net.sourceforge.jtds.jdbc.ResponseStream.getPacket (
    at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCor
    ... 24 more

  • #2
    Re:Mirth Service not starting with SQL Server 2005

    I've found a solution to the problem myself. It is something to do with ssl certificates. To fix the problem amend the connection string by adding a ssl=request property. e.g.



    • #3
      Re:Mirth Service not starting with SQL Server 2005

      B) Thanks for posting your solution!
      Jon Bartels

      Zen is hiring!!!!
      Talented healthcare IT professionals wanted. Engineers to sales to management.
      Good benefits, great working environment, genuinely interesting work.