Re: MSDE 2000 SA Account Password

From: itme (netadmin_at_kolcraft.com)
Date: 08/28/03 

Date: Wed, 27 Aug 2003 18:03:20 -0700

Russell, it worked great!! Thanks so much!

>-----Original Message-----
>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.h
tml
>
>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
    ... 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 ... if you have another account that runs as sysadmin and you use ... > I have a test server running MSDE 2000. ...
    (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)
  • Transfer users calendar to new employee
    ... We have an executive assistant leaving her job in a couple weeks. ... the person who schedules manager meetings so she has lot's of resources ... I could delete her account when she leaves, then create an account for the ... allow the new "owner" to manage the existing reservations and maintain her ...
    (microsoft.public.exchange2000.admin)
  • Re: Is my hotmail account hacked?
    ... > access time to the account or others. ... regular basis (so any potential hacker can't use the Forgot Password ... and other spyware when using public computers, ... Do you go leaving sticky notes on your monitor, ...
    (microsoft.public.internet.mail)
  • Re: Well Ordering the Reals
    ... >> Russell said: ... >>> reals could be specified in any book of finite length while still ... >>> leaving CH undecided. ... subject matter, deliberately? ...
    (sci.math)