Issue:
When attempting to test a new connection from the Spectrum Management Console to an MS SQL server, the following error is encountered:
“The connection test failed. Reason: Exception while trying to connect to DataSource: new connection: java.sql.SQLException: Login failed for user ‘username’.”
Cause:
This is caused by not having the SQL Server configured properly for use with Spectrum Technology Platform.
SQL Server authentication is off by default, but that is how the JDBC driver for Spectrum tries to authenticate a user.
SQL Server authentication is off by default, but that is how the JDBC driver for Spectrum tries to authenticate a user.
Solution:
To resolve this issue, please follow these steps:
- Open SQL Server Management Studio.
- Right-click on the database server and select “Properties”.
- Go to the “Security” option and ensure that “SQL Server and Windows authentication mode” is checked.
- Enable TCP/IP connection in SQL Configuration Manager.
- Restart your SQL server.
By performing these steps, the problem with the login failure for the user should be resolved.
