Results 1 to 3 of 3
  1. #1
    Join Date
    Aug 2003
    Posts
    30

    Unanswered: How to change "sa" password after installation?

    I just installed MS SQL SERVER2000, but seems the password I was setting didn't look good. So I want to change it, but how? Thanks!

  2. #2
    Join Date
    May 2004
    Posts
    7
    run stored procedure using account with sysadmin role priveleges

    sp_password @new = 'newprd' , @loginame = 'sa'

    ask if you have any questions

  3. #3
    Join Date
    Aug 2003
    Posts
    30
    Quote Originally Posted by simas
    run stored procedure using account with sysadmin role priveleges

    sp_password @new = 'newprd' , @loginame = 'sa'

    ask if you have any questions

    I've figured it out, thanks!

Posting Permissions

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