Results 1 to 2 of 2
  1. #1
    Join Date
    Dec 2003
    Posts
    1

    Unanswered: Login failed for user sa, error 18456

    Hi All,

    We have an application which uses SQL Server 2K through MDAC 2.5 on Windows 2K Pro.

    After an year of no any problems we started to get 18456 error periodically. What we are doing to fix it is seting "sa" password to let's say "password" one.

    It works for some days, but then error appears again, and recovery way is all the same - to set "sa" password to "password".

    Any suggeston what can corrupt "sa"'s password?
    How to be protected from it? (any patches?)

    Thanks,
    Alla

  2. #2
    Join Date
    Nov 2003
    Location
    FRANCE
    Posts
    393
    Just maybe...

    check your registry maybe the login mode changes

    \HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL
    Server\**DatabaseName**\MSSQLServer\LoginMode

    must be set at 2
    to use tha sa login

Posting Permissions

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