Re: SA password recovery

From: Dan Guzman (danguzman@nospam-earthlink.net)
Date: 03/18/03


From: "Dan Guzman" <danguzman@nospam-earthlink.net>
Date: Tue, 18 Mar 2003 09:42:26 -0600


You can connect using Query Analyzer as a sysadmin role member (e.g.
trusted connection by a member of the local admin group) and execute
sp_password:

    EXEC sp_password NULL, 'NewSaPassword', 'sa'

-- 
Hope this helps.
Dan Guzman
SQL Server MVP
-----------------------
SQL FAQ links (courtesy  Neil Pike):
http://www.ntfaq.com/Articles/Index.cfm?DepartmentID=800
http://www.sqlserverfaq.com
http://www.mssqlserver.com/faq
-----------------------
"alan" <aviens@trgusa.com> wrote in message
news:0e9101c2ed5d$e87eca00$a601280a@phx.gbl...
> Is there any method / utility to recover or reset a
> forgotten SA password?