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!
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