Nov
27
2014
With the JTDS JDBC driver that comes with Railo, it is possible, given that Railo in running on a Windows Server, to user a Windows Domain account to authenicate a database connection - all you need to do is add domain= to the connection string
this.datasources['TEST1']={ class:'net.sourceforge.jtds.jdbc.Driver' ,connectionString:'jdbc:jtds:sqlserver://SQLA01:1433/TEST;domain=myDomain;' ,username="myUsername" ,password="myPassword" };
You can also not pass usesername and password, and it will use the windows account that is running the Railo server. However, this requires ntlmauth.dll to be saved to c:\windows\system32. You will have to restart Railo service to pick this up.