Summary: Configuring MSSQL Server windows authentication for Quark Publishing Platform

1. Download latest Microsoft JDBC Driver for SQL Server from:   

2. Run sqljdbc_6.0.8112.100_enu.exe, it will extract files in the folder 'Microsoft JDBC Driver 6.0 for SQL Server'. In our case, we extracted it to 'C:\sqljdbc6\Microsoft JDBC Driver 6.0 for SQL Server'.

3. Copy sqljdbc_auth.dll  from C:\sqljdbc6\Microsoft JDBC Driver 6.0 for SQL Server\sqljdbc_6.0\enu\auth\x64 into C:\Program Files\Quark\Quark Publishing Platform\Server\jre1.7-windows\bin.

4. Copy sqljdbc41.jar from C:\sqljdbc6\Microsoft JDBC Driver 6.0 for SQL Server\sqljdbc_6.0\enu\jre7 into C:\Program Files\Quark\Quark Publishing Platform\Server\dependencies and remove the old sqljdbc4.jar file.

5. Open under Platform Server/conf) uncomment only following 2 entries and update the database details:

qpp.jdbc.driverClassName =
qpp.jdbc.url = jdbc:sqlserver://<your-host-name>\\<instanceName>;databaseName=qppdb;integratedSecurity=true;

6. Ensure that Windows authentication user is present in the database server logins and properly mapped to the Platform Server database and given the db_owner role.

7. Start Platform Server.