To authenticate the SQLServer domain, you can change the <database_parms> tag within the agent.xml to include integratedSecurity=true.
This will call for the library mssql-jdbc_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
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.
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:
Find the installed service in Windows Services, e.g. Perspectium DataSync Agent.
Right-click on the service and choose Properties. Then, go to the Log On tab and input the user that you are authenticating in the This account field.
WARNING: You must ensure that you are running the agent as the user that is being authenticated to the domain. That user must also have read/write access to the directory structure of the DataSync Agent.
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.
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-12.8.1.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. The package contains both 32 and 64 bit versions, use the version appropriate for your Windows which generally is 64 bit.
Place this dll in the extlib folder of the Agent's root directory.