Support Article

Unable to connect to MSSQL server using windows authentication

SA-32793

Summary



When using Pega 7 installed on Websphere (WAS) and MSSQL Server a database connection using Windows authentication fails to connect. The connection to the same database is successful when a direct user ID and password are used.


Error Messages



Test connectivity fails. "connection couldn't be established."


Steps to Reproduce



Create a data source in WAS using Windows authentication.


Root Cause

This is caused by a limitation of the MS SQL JDBC driver. Unix systems using the JDBC driver cannot connect to a system using Windows authentication. As such, if WAS is being hosted on a unix system, Windows Authentication is not a supported option for connecting WAS to the database.


Resolution



Another method of authentication must be used as Windows authentication is not supported under the described scenario.

Published January 23, 2017 - Updated January 31, 2017

Have a question? Get answers now.

Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.