Re: SA password recovery

From: Dan Guzman (
Date: 03/18/03

From: "Dan Guzman" <>
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

    EXEC sp_password NULL, 'NewSaPassword', 'sa'

Hope this helps.
Dan Guzman
SQL Server MVP
SQL FAQ links (courtesy  Neil Pike):
"alan" <> wrote in message
> Is there any method / utility to recover or reset a
> forgotten SA password?