Environment
Novell Service Desk
Situation
The following error is seen when attempting to login:
SQL Error: 18456, SQLState: 28000
[2009-06-30 09:31:55,185]ERROR154560[TP-Processor62] (JDBCExceptionReporter.java:58) - Login failed for user
SQL Error: 18456, SQLState: 28000
[2009-06-30 09:31:55,185]ERROR154560[TP-Processor62] (JDBCExceptionReporter.java:58) - Login failed for user
Resolution
Ensure proper permissions.
Also check the SQL activity or SQL management logs to see if the problem is shown.
Changes can be made in the SQL Server Management Console:
Also check the SQL activity or SQL management logs to see if the problem is shown.
Changes can be made in the SQL Server Management Console:
- Right click on DBMS & select properties
- A window will open, choose security and under the "Server Authentication" section, click on the both Windows & SQL Server Authentication.
- Restart your DBMS.
Cause
The problem in this case was the SQL authentication was set to Windows Only.
Additional Information
Formerly known as 1000680