---
title: "SQLServer Domain Authentication for DataSync Agent"
canonical: "https://docs.perspectium.com/space/helium/2114806/SQLServer%20Domain%20Authentication%20for%20DataSync%20Agent"
format: markdown
---
To authenticate the SQLServer domain, you can change the  <database_parms>  tag w ithin the  agent.xml  to include  integratedSecurity=true .  This will call for the library   sqljdbc_auth.dll   for the windows domain authentication. <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> 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-8.2.0.x64.dll. In Windows, if you already have the driver then check the environment variable path (My Computer > Properties > Advance Settings). The path should contain the location of  mssql-jdbc_auth-8.2.0.x64.dll . For example the path might be  C:\Program Files\Java\jdk1.8.0_251 ; If it is missing, you can find a download link  here . You can download the packaged  mssql-jdbc_auth.zip , unzip the file, and just take the  mssql-jdbc_auth-8.2.0.x64.dll . This package contains both 32 and 64 bit versions,   use the 64 bit . These are  found under  mssql-jdbc_auth /x64  path of the downloaded file . If you are using an agent with version 3.8.0 or above (or any release such as Argon and newer), place this dll in the  extlib  folder of the root directory. If you are using an agent with version below 3.8.0 place this dll in the  lib  folder of the root directory. Can't find what you're looking for?     See  the FAQ  or browse the  Perspectium Community Forum .