---
title: "SQLServer Domain Authentication for DataSync Agent"
canonical: "https://docs.perspectium.com/space/Lithium/2327031/SQLServer%20Domain%20Authentication%20for%20DataSync%20Agent"
format: markdown
---
To authenticate the SQLServer domain, you can change the  <database_parms>  tag within the  agent.xml  to include  integratedSecurity=true .  <database_type>sqlserver</database_type>
<database_server>myserver.net</database_server>
<database_port>1433</database_port>
<database_user>MyDomain\MyUser</database_user>
 
<database_parms>integratedSecurity=true</database_parms> This will call for the library  mssql-jdbc_auth.dll  for the Windows domain authentication.  The DataSync Agent comes with version 12.8.1 of the  Microsoft JDBC Driver SQL Server  so you will want to download the same version of the Windows domain authentication DLL ( mssql-jdbc_auth-12.8.1.x86.dll  or  mssql-jdbc_auth-12.8.1.x64.dll  depending on your Windows version). You can find the download link  here . The DLL should be place into the bin folder of where your Java is installed. For example, if you have Java 17 installed, you would place the DLL into a folder such as  C:\Program Files\Java\jdk-17\bin . Running as a Service If you are running the DataSync Agent as a Windows service then you will also want to make sure the service is running as the same user that you are authenticating with. To do so, follow these steps:  Troubleshooting If you are running into errors within the  perspectium.log  file like: ERROR SQLSubscriber - test_subscribe - Unable to connect to database: This driver is not configured for integrated authentication. ClientConnectionId: …….
ERROR Scheduler - Unable to connect to database: This driver is not configured for integrated authentication. ClientConnectionId: …….
java.lang.IllegalStateException: Unable to connect to database: This driver is not configured for integrated authentication. ClientConnectionId: …….
com.microsoft.sqlserver.jdbc.AuthenticationJNI <clinit>
WARNING: Failed to load the sqljdbc_auth.dll cause : no sqljdbc_auth in java.library.path Then you are likely missing the driver,  mssql-jdbc_auth-12.8.1.x86.dll  or  mssql-jdbc_auth-12.8.1.x64.dll  depending on your Windows version . You can find a download link for the DLL  here .  The package contains both 32 and 64 bit versions, use the version appropriate for your Windows which generally is 64 bit. The DLL should be place into the bin folder of where your Java is installed. For example, if you have Java 17 installed, you would place the DLL into a folder such as  C:\Program Files\Java\jdk-17\bin . If you already have the driver then check the environment variable path  (My Computer > Properties > Advance Settings ). The path should contain the location of where the DLL is installed which should be the path of your Java installation folder. If the path of your Java is not there, then add it the path.