Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2003

    Unanswered: Connection Failed: SQl SErver Error 18456

    I am runnig a program through Microsoft Access 2000 that uses SQL server and is run on 8 different machines. It has worked great for months but yesterday this message appeared:

    Connection Failed:
    SQL State: '28000'
    SQL Server Error: 18456
    [Microsoft][ODBC SQL Server Driver][SQL Server]Login Failed for User 'SA'.

    And when I try to use Outlook, this message is displayed:

    The Microsoft Exchange Server Computer is not available. Either there are network problems or thhe Microsoft Exchange Server is down for mmaintenance.

    Obvious problems with the SQL recognition but it seems to be up and running fine.

    Any help appreciated.

  2. #2
    Join Date
    Aug 2002
    Make sure no change in SA's password and try connecting with other user with ADMIN privileges.
    --Satya SKJ
    Microsoft SQL Server MVP

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts