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

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


Novell Service Desk


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


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.


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

Additional Information

Formerly known as 1000680