You can translate the question and the replies:

Windows Authentication - This driver is not configured for integrated authentication

Hi Team, Below is my datasource configuration Adapter -> Microsoft SQL Server 2017 (MS Driver) Class Path ->MSSQL-jdbc-7.x uri -> jdbc:sqlserver://yourhost;IntegratedSecurity=true;databaseName=yourdatabasename Username & Password are empty I am trying to use windows authentication by using IntegratedSecurity = True in the URI. It is working fine when I configure the above parameters in VDP datasource, but the same is not working in denodo job scheduler and it is throwing below error "**This driver is not configured for integrated authentication.**"
Windows Authentication This driver is not configured for integrated authentication
user
07-07-2023 12:13:45 -0400
code

1 Answer

Hi, I did some test and I was able to configure Integrated Security both on VDP and on Scheduler server. This Knowledge Base guide turned out very useful: [ACCESSING MS SQL SERVER USING WINDOWS AUTHENTICATION - Steps using dll](https://community.denodo.com/kb/en/view/document/Accessing%20MS%20SQL%20Server%20using%20Windows%20Authentication). Some important point: * In my connection string in addition to *InegratedSecurity=true* I've added *trustServerCertificate=true* and *encrypt=false*. * Depending to your class path check inside `<DENODO_HOME>/lib/extensions/jdbc-drivers/<your_classpath>` and get the required Microsoft Driver version. As the guide explains, make sure to download the right version from [Download Microsoft JDBC Driver for SQL Server](https://learn.microsoft.com/en-us/sql/connect/jdbc/release-notes-for-the-jdbc-driver?view=sql-server-ver16). e.g. for classpath *MSSQL-jdbc-7.x* I added a file *mssql-jdbcauth-10.2.0.x64.dll* under *DenodoPlatform8.0\extensions\thirdparty\dll* * After adding the driver restart VDP/scheduler server. Hope this helps
Denodo Team
11-07-2023 03:53:46 -0400
code
You must sign in to add an answer. If you do not have an account, you can register here