Additional Prerequisites for Microsoft SQL Server Database
Perform the following steps to configure Microsoft SQL Server database with Windows Authentication User using JDBC Driver:
-
Download and extract the Microsoft JDBC driver from Microsoft.
-
Depending on the operating system (32-bit/64-bit), select mssql-jdbc_auth.dll file.
-
Make the mssql-jdbc_auth.dll file visible to the JVM so that the JDBC driver has access to the native library (.dll). For example, copy the .dll file to any folder which has an easy and simplified location/path.
-
Add the path to the folder containing the .dll to the system path environment variable.
-
Restart web-application server.
Note
-
Windows authentication uses the Windows user account to log on to SQL Server. This overrides the values provided in the configuration parameters for Connection User and Connection Password of the IdentityIQ application.
-
To use Windows authentication, ensure that the member systems are in the trusted domain.