Its very simple to reset the sa password for SQL 2005.
Just log in using 'Windows authentication' account and run the below query.
exec sp_password @new = 'somepwd', @loginame = 'sa'
ofcourse change the 'somepwd' to the password you want to set.
Enjoy!
Tuesday, March 20, 2007
Subscribe to:
Posts (Atom)
