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.