Mirth Connect SQLSVR2008R2 w/ Windows Authentication only

mercredi 22 octobre 2014

All, this is my first post but I have looked extensively for solutions to Mirth under Windows Auth mode.

I am curious as to whether it is really possible. I've seen other's say it works for them but haven't seen a post with complete config options.

Here's my setup and results:



SQL Server 2008 Std Edition Windows Auth only (can't change)

Windows Server 2003 32bit VM (VMWare)

Mirth: 3.0.3.7171

Java: 1.7.0_71-b14 (From Oracle: Windows x86 Offline 28.09 MB jre-7u71-windows-i586.exe)

sqljdbc4.jar in C:\Program Files\Mirth Connect\custom-lib

sqljdbc_auth.dll in c:\Program Files\jre7\java\lib (x86 version)

MirthConnect user exists with same username/pwd as SQLServer login username/pwd



1. MirthConnect service running as local system:



Config:

database = sqlserver

database.url = jdbc:http://sqlserverhostname:1433;databaseName=MirthConnect;domain=hos tname;integratedSecurity=true (also tried with no domain)

database.username =

database.password =



Application Error:

Unable to Launch Application



Details:

java.net.ConnectException: Connection refused: connect



Mirth Log:

ERROR 2014-10-22 09:24:03,437 [Thread-1] com.mirth.connect.server.Mirth: Error establishing connection to database, aborting startup. This driver is not configured for integrated authentication. ClientConnectionId:a276f335-27c4-4d65-a0c8-2ad06eb5ef11

INFO 2014-10-22 09:24:03,437 [Thread-4] com.mirth.connect.server.Mirth: shutting down mirth due to normal request





2. MirthConnect service running as MirthConnect:



Config:

database = sqlserver

database.url = jdbc:http://sqlserverhostname:1433;databaseName=MirthConnect;domain=hos tname;integratedSecurity=true

database.username = MirthConnect

database.password = *****



Same errors. Assuming this is incorrect since integratedSecurity and username/pwd settings are in conflict.





3. Attempting to run without integrated security with username/pwd set:

ERROR 2014-10-22 10:33:35,580 [Thread-1] com.mirth.connect.server.Mirth: Error establishing connection to database, aborting startup. Login failed for user ''. ClientConnectionId:081cff0c-f511-4806-98e1-de1a2c88e09b

INFO 2014-10-22 10:33:35,596 [Thread-4] com.mirth.connect.server.Mirth: shutting down mirth due to normal request



Obviously due to Windows Auth Only.



I'm beginning to think it's not really using the MS driver. Any pointers would be great. If this is adequately covered in another post or FAQ please respond with link. Thanks!





Mirth Connect SQLSVR2008R2 w/ Windows Authentication only

0 commentaires:

Enregistrer un commentaire