SA password

Jun 18, 2009 7 Replies

Help me refresh my memory. I believe there is a method of changing the sa password.


Log in into SQL Server as Windows Administrator and reset the password of sa

In SO Admin go to File>Connect. Connect to the db. Once connected go to Database > Change Password

Send me an email an I will send yo a sql script

Afshin Alikhani - snipped-for-privacy@retailrealm.co.uk Retail Realm = = = = = = = = = "Bill Cunningham" wrote in message news: snipped-for-privacy@microsoft.com...

HOW TO CHANGE PASSWORD TO MSDE SERVER?

GO TO PROMPT WINDOW AND POINT TO C:\PROGRAM FILES\MICROSOFT SQL SERVER\

  1. We did the follwing:
  2. connected to sql server via osql:
  3. osql -S -E
  4. sp_password NULL, '','sa'
  5. go
  6. This changed password of sa and you were able to work with your application (mircosoft retail management software).

"Bill Cunningham" wrote in message news: snipped-for-privacy@microsoft.com...

Join the Discussion

Have something to add? Share your thoughts — no account required.

Didn't find your answer?

Ask the community — no account required