How to configure SQL Server with Windows Authentication

How to configure SQL Server with Windows Authentication

Symptom

When trying to configure a SQL Server database using Windows Authentication as part of the 360eyes database configuration, the following error is returned: "The driver is not configured for integrated authentication".

Environment

  • 360Eyes 2020.3 and later versions.
  • Microsoft SQL Server
  • Microsoft Windows
  • SAP BusinessObjects Enterprise XI 3.1
  • SAP BusinessObjects Business Intelligence 4.0
  • SAP BusinessObjects Business Intelligence 4.1
  • SAP BusinessObjects Business Intelligence 4.2
  • SAP BusinessObjects Business Intelligence 4.3

Resolution

1. To allow Windows Authentication on SQL Server, download the file sqljdbc_12.2.0.0_enu.zip file using this link: Download File.
Identify the dll file that match your JVM version running on your system:
  • mssql-jdbc_auth-12.2.0.x86.dll if using a 32-bit JVM
  • mssql-jdbc_auth-12.2.0.x64.dll if using a 64-bit JVM


2. Copy this file to any folder listed in the system path (the PATH environment variable on Windows environments only).
For example :
  1. C:\Windows\System32
If it doesn't work, you can directly place it in the Java bin and lib folders.
For example :
  1. C:\Program Files\Java\jre1.8.0_291\bin
  2. C:\Program Files\Java\jre1.8.0_291\lib
More information is available directly on SQL Server driver documentation.

3. Then restart the installation (you must close the wizard). When configuring the 360Eyes DB, you must set the domain user, and leave the user and password empty:



4. The same can be done for the BOE Audit database configuration if needed. Finish the installation as usual.

Check that you have a single SQL Server JDBC driver in C:\360eyes\libs named mssql-jdbc-12.2.0.jre8.jar. Having multiple versions can generate issues during this particular configuration.

Check that the port number provided is the correct one. Do not hesitate to test with empty port number like:  jdbc:sqlserver://localhost;databaseName=AdventureWorks;integratedSecurity=true;

Keywords

SQLServer, Windows Authentication

Product

Product or Product version

  • 360Eyes

Languages

  • English

    • Related Articles

    • DB011/DB02 - How to configure the 360Suite database with SQL Server AD Domain account

      Symptom When configuring the database in the Web Platform Administration Console with a AD Domain account for SQL Server, you encounter one of the following errors : - DB012: Could not find driver - DB011: This driver is not configured for integrated ...

    • How to install 360Eyes on SQL Server on Azure

      Symptom Installing 360Eyes using SQL Server on Azure. Environment 360Eyes SAP BusinessObjects Enterprise XI 3.1 SAP BusinessObjects Business Intelligence 4.0 SAP BusinessObjects Business Intelligence 4.1 SAP BusinessObjects Business Intelligence 4.2 ...

    • How to enable AD authentication in 360Suite

      Context You want 360Suite to use AD authentication the same way BusinessObjects does it. Procedure As part of the AD authentication configuration on the Business Objects server, two files will have been created and saved on “C:\Windows\” directory ...

    • Error : "java.sql.SQLException: I/O Error: SSO Failed: Native SSPI library not loaded"

      Symptom When running a 360eyes job (from the CMC or the GUI), the following error is received: "The program failed to run and supplied the following information: com.gbs.a.h: Error during Database update/migration: com.gbs.a.h: Error during ...

    • Connection error on SQL Server : DB server closed connection

      Symptom Error message : SQL Server : Error : java.io.IOException: DB server closed connection Where to find the information : When connecting 360Suite / 360Eyes to SQL Server database Environment Product : 360Suite / 360Eyes Product Version : All ...