Results 1 to 4 of 4
  1. #1
    Join Date
    Jan 2005
    Posts
    1

    Unanswered: Can't connect via EM after changing sa password?

    A client of mine changed his SA password "because it hadn't been changed in a while". Now nobody can get into Enterprise Manager - opening EM or trying to right-click > Connect on the server yields an error:


    Code:
    A connection could not be established to SERVER1.
    
    Reason: login failed for user 'sa'.
    
    Please verify SQL Server is running and check your SQL Server Registration 
    properties (by right-clicking on the SERVER1 node) and try again.

    Of course, if I right-click on the SERVER1 node, I get the same message.

    My client remembers the password he set; I managed to use it to get into Query Analyzer, which I thouhght was weird. But no luck with Enterprise Manager. It's just trying to log in as sa without prompting for a pw.

    I already tried running sp_Password in Query Analyzer to change the pw back to what it was. Still can't connect to the SQL Server via Enterprise Manager.

    What can I do?

  2. #2
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    Did you edit the sql server registration and change the password there?

    EDIT: And while I'm Here

    Now nobody can get into Enterprise Manager
    SCARY

    Sorry Rudy
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

  3. #3
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Provided Answers: 1
    Unclear from your post: have you tried editing the connection properties, or are you not able to get to that point?

    If it won't even let you right-click on the registration to edit the properties, then try dropping the registration and creating a new one.
    If it's not practically useful, then it's practically useless.

    blindman
    www.chess.com: "sqlblindman"
    www.LobsterShot.blogspot.com

  4. #4
    Join Date
    Jul 2003
    Location
    San Antonio, TX
    Posts
    3,662
    Unless BUILTIN\Administrators local group is removed from SQL Server security, you can logon as a local admin or as a member of that group and easily change the SA password.
    "The data in a record depends on the Key to the record, the Whole Key, and
    nothing but the Key, so help me Codd."

Posting Permissions

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