Post reply

question on sa user

  • September 17, 2008 at 1:08 pm

    #193625

    Hi, when I installed sql server 2005 in one of our servers, I think sa user was created. I want to know the password of sa user. How can I find that?

    Thanks!

  • September 17, 2008 at 1:59 pm

    #873251

    SQL 2005 requires a password to be entered during installation if mixed mode is selected. It doesn't set a default. There's no practical way of decrypting the stored passwords

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • September 17, 2008 at 3:05 pm

    #873282

    I do'nt remember what mode was selected during the installation. Usually what mode do we have to select while installing sql 2005? So that I shall be careful in selecting teh correct mode.

    Thanks.

  • September 17, 2008 at 5:19 pm

    #873310

    If you have an SA account, then mixed mode was selected during installation. Which mode you choose depends on your environment and your security requirements. Mircosoft recommends using Windows Authentication when possible.

    Greg

  • September 17, 2008 at 11:07 pm

    #873387

    If you are Admin to the widows server you can change the sa password.

    Rajesh Kasturi

  • September 18, 2008 at 3:40 am

    #873465

    I don't really know how you can find the sa password but i beleive you do not need looking for it when you can change it very easily. All you need do is either double-click or right-click the sa login and select properties. Type a new password and reconfirm it. Then, you are done. The new passowrd will be working immediately. How about that?

Viewing 6 posts - 1 through 5 (of 5 total)

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