Unable to connect to MSSQL server using windows authentication
SummaryWhen 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 MessagesTest connectivity fails. "connection couldn't be established."
Steps to ReproduceCreate a data source in WAS using Windows authentication.
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.
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