Summary: Configuring MSSQL Server windows authentication for Quark Publishing Platform


Solution:

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

https://docs.microsoft.com/en-us/sql/connect/jdbc/download-microsoft-jdbc-driver-for-sql-server


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 Database.properties(located under Platform Server/conf) uncomment only following 2 entries and update the database details:


qpp.jdbc.driverClassName = com.microsoft.sqlserver.jdbc.SQLServerDriver
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.