Re: SA PW
From: Donna Lambert [MS] (dlambert@online.microsoft.com)
Date: 08/13/02
- Next message: wondering: "security patches"
- Previous message: Donna Lambert [MS]: "RE: Users on a DB are dropped without any intervention"
- In reply to: Sue Hoegemeier: "Re: SA PW"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
From: dlambert@online.microsoft.com (Donna Lambert [MS]) Date: Tue, 13 Aug 2002 14:41:01 GMT
Jim,
Sue is correct. Your best bet is to access SQL with NT authentication,
with an account that has sysadmin role on the server (as she said, by
default builtin\local administrators is in this group).
And I'm assuming you've tried a blank pw? Sometimes people are surprised
to find that their DBA left the pw blank.
Hope that helps.
Donna Lambert
Microsoft SQL Server Support
Disclaimer:
This posting is provided “AS IS” with no warranties, and confers no rights.
Are you secure? For information about the Microsoft Strategic Technology
Protection Program and to order your FREE Security Tool Kit, please visit
http://www.microsoft.com/security.
Recent viruses on the Internet underscore the threat to all computer users
and highlight challenges facing the entire industry in providing security
that everyone needs to conduct business. I encourage you to sign up to
receive automatic notification of Microsoft Security Bulletins by visiting
http://www.microsoft.com/technet/treeview/default.asp?url=/technet/security/
bulletin/notify.asp. For more information on security, our Strategic
Technology Protection Program and to order your FREE Security Tool Kit,
please visit http://www.microsoft.com/security. We will be happy to answer
any questions or provide assistance with your security needs.
--------------------
| From: Sue Hoegemeier <Sue_H@nomail.please>
| Subject: Re: SA PW
| Date: Mon, 12 Aug 2002 18:12:06 -0600
| Message-ID: <1djgluocgrl7nlfqvqh7l63ka6918ji2hg@4ax.com>
| References: <ulghkv559ajt4f@corp.supernews.com>
| X-Newsreader: Forte Agent 1.91/32.564
| MIME-Version: 1.0
| Content-Type: text/plain; charset=us-ascii
| Content-Transfer-Encoding: 7bit
| Newsgroups: microsoft.public.sqlserver.security
| NNTP-Posting-Host: 67.234.211.177
| Lines: 1
| Path: cpmsftngxa10!tkmsftngp01!tkmsftngp13
| Xref: cpmsftngxa10 microsoft.public.sqlserver.security:7668
| X-Tomcat-NG: microsoft.public.sqlserver.security
|
| 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
| >
|
|
- Next message: wondering: "security patches"
- Previous message: Donna Lambert [MS]: "RE: Users on a DB are dropped without any intervention"
- In reply to: Sue Hoegemeier: "Re: SA PW"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Relevant Pages
|
