VERIFIED SOLUTION i
X

Resolve "Login failed for user" when connecting to SQL server through Spectrum Management Console

Issue

When trying to test a new connection from the Spectrum Management Console to a MS SQL server the following error occurs: 


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.

 

Resolution

UPDATED: August 21, 2017


This problem should be resolved by following the below steps.
  1. Open your SQL Server Management Studio.
  2. Right click on the database server and go to properties.
  3. Choose the security option and check "SQL Server and Windows authentication mode".
  4. Enable TCP/IP connection in SQL Configuration Manager.
  5. Restart your SQL server.

Environment Details

Spectrum Versions: All supported versions

 

Downloads

  • No Downloads