Post reply

SQL Server Error 18456

  • April 6, 2006 at 8:49 pm

    #112480

    Hello guys,

    When creating an ODBC connection, we're currently getting the error saying:

    Connection failed:

    SQLState" '28000'

    SQL Server Error: 18456

    [Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'XXX'

     

    What are the things we need to check?

     

    Regards,

    Timber

  • April 6, 2006 at 9:00 pm

    #631398

    Just off the top of my head:

    Make sure the server is set to accept the type of login you're using (SQL Server, Windows authentication, or mixed mode)

    Make sure the user id has been set up and that the user's default database exists and the user can access it

     

    And then again, I might be wrong ...
    David Webb

  • April 24, 2006 at 10:11 am

    #633846

    I am getting the same error however this only happens when i access it through a terminal server not my local worstation... did u get the problem resolved?

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply