SQL Error: 18456, SQLState: 28000 error when attempting test NSD Item Import AMIE SCCM

  • 7012279
  • 01-Jul-2009
  • 29-May-2013

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

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:
  1. Right click on DBMS & select properties
  2. A window will open, choose security and under the "Server Authentication" section, click on the both Windows & SQL Server Authentication.
  3. Restart your DBMS.

Cause

The problem in this case was the SQL authentication was set to Windows Only.

Additional Information

Formerly known as 1000680