How to trouble shoot and restore the access?

  • Connection failed:

    SQLState: '28000'

    SQL Server Error: 18456

    [Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'xxx\xxxx'.

    How to trouble shoot and restore the access?

    Do any one know this?

  • something missing from your post is the state

    with the state, you know what the actual problem is:

    http://blogs.msdn.com/b/sql_protocols/archive/2006/02/21/536201.aspx

    ERROR STATE ERROR DESCRIPTION

    2 and 5 Invalid userid

    6 Attempt to use a Windows login name with SQL Authentication

    7 Login disabled and password mismatch

    8 Password mismatch

    9 Invalid password

    11 and 12 Valid login but server access failure

    13 SQL Server service paused

    18 Change password required

    Lowell


    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

  • not really a whole lot of information to work with. looks like your username or password is incorrect, or someone has removed access to the database instance for that particular account.

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

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