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

Version 1

    Details

    SQL Error: 18456, SQLState: 28000
    [2009-06-30 09:31:55,185]ERROR154560[TP-Processor62] (JDBCExceptionReporter.java:58) - Login failed for user


    Resolution

    Ensure the proper permissions and also check that the activity log or management log to see if the problem is shown. The problem in this case was that the authentication was set to windows only and this needed to be changed. Changes can be made in the management console via options on the user radio check boxes for SQL Server Authentication which need to be active.