Re: MSDE 2000 SA Account Password

From: Russell Fields (rlfields_at_sprynet.com)
Date: 08/27/03 

Date: Wed, 27 Aug 2003 10:50:12 -0400

Did you try just leaving the '-P' off of the command line?

If you have forgotten the sa password, you can reset the password by
logging in as a member of the sysadmin fixed server role and using
sp_password.
http://faq.oneandone.co.uk/server/ms_windows_servers/10.html

Of course, if you have another account that runs as sysadmin and you use
trusted connections, then you do not have the password lying around in
scripts. Recommended.

Russell Fields

PS - Here is a post (from the University of Chicago!) about resetting the
password.
http://security.uchicago.edu/windows/mssql/index.shtml

"itme" <netadmin@kolcraft.com> wrote in message
news:0b6b01c36c98$7f107680$a401280a@phx.gbl...
> SQL Newbie.
>
> I have a test server running MSDE 2000. I am trying to
> access the database but I don't know the sa account
> password. At a command propmt, I type osql -U sa -P
> with a number of passwords and leaving it blank and it
> returns the message "Failed login for account 'sa' "
> Does anyone know how I can reset this account or what the
> default password is for MSDE 2000? No Service Packs have
> been applied.
>
> Thank You

Relevant Pages

  • Re: MSDE 2000 SA Account Password
    ... Russell, it worked great!! ... >> I have a test server running MSDE 2000. ... >> access the database but I don't know the sa account ... >> with a number of passwords and leaving it blank and it ...
    (microsoft.public.sqlserver.security)
  • Re: MSDE 2000 SA Account Password
    ... I did try logging in without a password but it didn't ... I did not try leaving the -P off. ... >> I have a test server running MSDE 2000. ... >> access the database but I don't know the sa account ...
    (microsoft.public.sqlserver.security)
  • RE: Password disappears
    ... account password will be reset to empty automatic. ... SBS infected by Trojan horse. ... Configure account lockout policy. ...
    (microsoft.public.windows.server.sbs)
  • RE: Quick question on resetting computer accounts in AD
    ... and recreating the account. ... Is it okay to use the reset account function? ... SBS Server Management console does not have "Reset Account" command to ... In fact, the SBS Server Management console has already integrated ADUC, you ...
    (microsoft.public.windows.server.sbs)
  • RE: Reset of local user password deleted compressed folders
    ... I suggest you search the hard disk to confirm if the files are deleted. ... For any of the following resolutions to work, the user's original account ... This password recovery disk must have ... Click "use your password reset disk". ...
    (microsoft.public.windowsxp.security_admin)