Connecting to MS SQL using Windows Authentication

Following are the steps for connecting to Microsoft SQL Server using Windows Authentication

A. Installation Instructions for the Microsoft Windows version of the JDBC Driver


1. Use the 4.0 version of the Microsoft JDBC jar and sqljdbc_auth.dll available here

- http://www.microsoft.com/en-us/download/details.aspx?id=11774

2. Download sqljdbc_<version>_<language>.exe to a temporary directory.

3.  Run sqljdbc_<version>_<language>.exe. 

4. Enter an installation directory when prompted. We recommend that you unpack this zip file in “C:\Program Files\MSSQL_WindowsAuthentication” with the default directory.

B.      Installing the JAR in Adeptia:

1. Copy the sqljdbc_auth.dll from “C:\Program Files\MSSQL_WindowsAuthentication\sqljdbc_4.1\enu\auth\x64” to “<<Adeptia Installation Directory>>/ServerKernel/ext/dll

If you don’t find the “dll” folder under “ext”, create the folder.

2. Stop Kernel and Webrunner of Adeptia

3. Edit the launcher.properties at the
<<Adeptia Installation Directory>>/ServerKernel/etc

And add the segment highlighted in red.

 

4. Start the Kernel and Webrunner as the user that have access to the SQL Server Database.

5. Go to the Develop > Services > Connector > Database Driver

6. Create a new driver “MSSQL_WindowsAuthentication_SQLJDBC4” and use the jar at “C:\Program Files\MSSQL_WindowsAuthentication\sqljdbc_4.1\enu\sqljdbc4.jar

7. Use the driver class name “com.microsoft.sqlserver.jdbc.SQLServerDriver

8. Save the Database Driver Activity

9. Go to the Develop > Services > Connector > Database Info

10. Create a new info and use the URL as

jdbc:sqlserver://<<Database Server>>:<<port>>;databaseName=<<Database Name>>;integratedSecurity=true;

No need to enter the username or password.

11. Test the connection.

Have more questions? Submit a request

1 Comments

Article is closed for comments.