Any tips on how to create a datasource that connects to MS SQL Server 2008
with windows authentication? I can connect via SQL authentication, but not
with windows. With windows, I get “Login failed for user ”. I
have tried both the Microsoft and jTDS drivers.
The Windows user that would be connecting to your database, is the user Tomcat runs under. (see the User Name column in task manager, or the Service details)
It will probably be Network Service or Local Service. You can change that user in the Services window > detail page of the Tomcat/Lucee service > Log on, to match a valid Windows user for your MSSQL database. This user also must have the privileges to run Tomcat / access the web files, but shouldn’t be able to take over your server.
Then, use the JTDS driver, enter all database details, except the username+password (leave them empty).
Save it, test it.
Paul KlinkenbergOp 8 sep. 2015, om 23:31 heeft Strom <@Strom> het volgende geschreven:
Any tips on how to create a datasource that connects to MS SQL Server 2008 with windows authentication? I can connect via SQL authentication, but not with windows. With windows, I get “Login failed for user ”. I have tried both the Microsoft and jTDS drivers.
Thanks Paul! That solved it. If others have this problem, make sure the
ntlm.dll is in the ‘java.library.path’.On Wednesday, September 9, 2015 at 1:15:28 AM UTC-7, Paul Klinkenberg wrote:
Hi,
The Windows user that would be connecting to your database, is the user
Tomcat runs under. (see the User Name column in task manager, or the
Service details)
It will probably be Network Service or Local Service. You can change that
user in the Services window > detail page of the Tomcat/Lucee service > Log
on, to match a valid Windows user for your MSSQL database. This user also
must have the privileges to run Tomcat / access the web files, but
shouldn’t be able to take over your server.
Then, use the JTDS driver, enter all database details, except the
username+password (leave them empty).
Save it, test it.
Op 8 sep. 2015, om 23:31 heeft Strom <kill...@gmail.com <javascript:>> het volgende geschreven:
Any tips on how to create a datasource that connects to MS SQL Server 2008
with windows authentication? I can connect via SQL authentication, but not
with windows. With windows, I get “Login failed for user ”. I
have tried both the Microsoft and jTDS drivers.
Thanks!
–
See Lucee at CFCamp Oct 22 & 23 2015 @ Munich Airport, Germany - Get your
ticket NOW - http://www.cfcamp.org/