Re: SA PW

From: Sue Hoegemeier (Sue_H@nomail.please)
Date: 08/13/02 

From: Sue Hoegemeier <Sue_H@nomail.please>
Date: Mon, 12 Aug 2002 18:12:06 -0600

You can't retrieve the password but you can reset it. Log
onto SQL Server using a sysadmin account or if
BUILTIN\Admins is still on the server as a sysadmin you can
log in using a Windows NT local admin account. Then reset
the password using sp_password, e.gl
exec sp_password NULL, 'NewPassword', 'sa'

-Sue

On Mon, 12 Aug 2002 18:39:26 -0500, "jim" <jim@here.com>
wrote:

>Major problem. Just took over a network from someone who left on bad terms.
>Before he left he changed the SA PW on one of our SQL servers. Need to know
>if there is a way to recover the PW. Server is running fine, so this is not
>a major problem yet, but..... you never know
>
>Thanks
>

Relevant Pages

  • Re: Reset Identity Column
    ... Either truncate the table (it will automatically be reset) ... Wayne Snyder, MCDBA, SQL Server MVP ... I have an identity column that ... However it keeps counting from the last ...
    (microsoft.public.sqlserver.server)
  • Re: Lost SA Password
    ... There is one other way to get reset your sa password to blank and reset the ... Copy the master data file and log file to another SQL Server. ... Attach the database as mastersa or some thing like that. ... >>Also don't have sa login, ...
    (microsoft.public.sqlserver.security)
  • Re: reset the size of temp db
    ... Tibor Karaszi, SQL Server MVP ... "Anuradha" wrote in message ... > I tried restarting the sql server but it is not reset. ...
    (microsoft.public.sqlserver.server)
  • Table access privileges
    ... I'm not super familiar with all of the forms of SQL Server replication, ... I have reset those so that you can ... added and that the final destination system had permission reset on more ... SQL Server 2000 on all machines. ...
    (microsoft.public.sqlserver.replication)
  • Passwords getting reset?
    ... we have a SQL Server 7.0 application running on NT. ... We are having problems with the passwords getting reset or expired. ... there a stored proc that we can add some kind of trace statement that ...
    (microsoft.public.sqlserver.security)