Windows authentication SQL server named instance

Situation:

I've read this tech note.

http://support.adeptia.com/entries/21261437-connecting-to-ms-sql-using-windows-authentication

However I'm now using JTDS since I have a named instance of SQL server for backend and logs. How should I modify my connection URL to use integrated security in this case?

 

Solution:

Below are the values of the parameters that we have used in the server-configure.properties (ServerKernel\etc) file:

URL:  jdbc:jtds:sqlserver://<<serverName>>:1433/DatabaseName;instance=INSTANCENAME;useNTLMv2=true;domain=domainName

Driver Class: net.sourceforge.jtds.jdbc.Driver

User Name: User name of the windows machine

Password: Password of windows machine

1) Modify the respective URL, Driver Class, Username, and Password property fields

 

2) The same modifications need to be implemented in quartz.properties file as well

 

3) Restart Adeptia Services after making the changes.

 

Have more questions? Submit a request

0 Comments

Article is closed for comments.