<style>
.release-box {
height: 30px;
width: 100px;
padding-top: 8px;
text-align: center;
border-radius: 5px;
font-weight: bold;
background-color: #d4af37;
border-color: #FCE28A;
}
.release-box:hover {
cursor: hand;
cursor: pointer;
opacity: .9;
}
</style>
<meta name="robots" content="noindex">
<div class="release-box">
<a href="https://docs.perspectium.com/display/gold" style="text-decoration: none; color: #FFFFFF; display: block;">
Gold
</a>
</div> |
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 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:
|
WARNING: 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, sqljdbc_auth.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 sqljdbc_auth.dll.
For example the path might be C:\Perspectium\Perspectium_Replicator_Agent\bin\…\extlib;
If it is missing you can find a download link from our third party libraries list here, under sqljdbc or the direct link. You can download the packaged .tar.gz file, unzip the file, and just take the sqljdbc_auth.dll. This package contains both 32 and 64 bit versions, use the 64 bit. These are found under the enu/auth/x64 path of the downloaded file.
If you are using an agent with version 3.8.0 or above, 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.
