Re: SA password recovery

From: Brad Feaker (brad.feaker@morgankeegan.com)
Date: 03/18/03 

From: "Brad Feaker" <brad.feaker@morgankeegan.com>
Date: Tue, 18 Mar 2003 13:00:05 -0800

This assumes you are running mixed mode security ;-)

Brad Feaker
DBA
Morgan Keegan & Company
Please post all replies to newsgroup

>-----Original Message-----
>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?
>
>
>.
>

Relevant Pages

  • Re: SQL Server 7 Permissions!
    ... Or member of the Windows Administrators group? ... Tibor Karaszi, SQL Server MVP ... > problem with permissions - I set permissions on tables for a user (that ...
    (microsoft.public.sqlserver.programming)
  • Re: SQL Server 7 Permissions!
    ... Or member of the Windows Administrators group? ... Tibor Karaszi, SQL Server MVP ... > problem with permissions - I set permissions on tables for a user (that ...
    (microsoft.public.sqlserver.security)
  • Re: sp_change_users_login use after restore
    ... The user was a member of the sysadmin role, once I took the role out, ... In that case the login will will be 'dbo' in the ... > SQL Server MVP ...
    (microsoft.public.sqlserver.security)
  • Re: How do I deleting all but the last 3 records entered
    ... Tibor Karaszi, SQL Server MVP ... "SamIAm" wrote in message ... > I have a system where each member can only have 3 records in a table. ...
    (microsoft.public.sqlserver.programming)
  • Re: Getting the sa password with SQLDMO
    ... SQL Server stores passwords using a one-way hash so you can't read the ... conditional password change by attempting a connection using the expected sa ... password and, if it fails, connect using a different sysadmin role member ... member can change the sa password. ...
    (microsoft.public.sqlserver.programming)