Re: sa account - hpw to reset a 'compromised' pw

From: Narayana Vyas Kondreddi (answer_me@hotmail.com)
Date: 10/25/02 

From: "Narayana Vyas Kondreddi" <answer_me@hotmail.com>
Date: Fri, 25 Oct 2002 17:47:45 +0100

Which operating system is your SQL Server on? See if this helps:
http://vyaskn.tripod.com/administration_faq.htm#q9 

--
HTH,
Vyas, MVP (SQL Server)
SQL Server FAQ, articles, code samples, interview questions and more @
http://vyaskn.tripod.com/
"Alan Dean" <a.r.dean@bham.ac.uk> wrote in message
news:1f7801c27c09$67f059f0$3bef2ecf@TKMSFTNGXA10...
I'm running msde.
System was attacked by the SQLSpida worm.
Patches / virus signatures etc processed but the original
blank password for sa is now set to some 'random four
character value' (quote from the sqlspida info on the web).
I now cannot get 'in' to reset this password.
msde is used as a component of other apps (e.g. Altiris
DS). I cannot re-install this without accessing sql
database via sa account.
I can find nothing on web or MS about how to circumvent
this 'hacked' password 'set' for sa by the sqlspida worm.
Can anyone provide a solution?
Thanks,  Alan

Relevant Pages

  • xx
    ... Open machine which has SQL server with Admin rights go to ... OPEN server,open secururity there change password for ... >I'm running msde. ... >this 'hacked' password 'set' for sa by the sqlspida worm. ...
    (microsoft.public.sqlserver.security)
  • Re: SQL 2000 installation advice needed
    ... this option when installing SQL Server? ... > If you mean with that the local administrator account, ... > Security is not very important to me. ... >> Ghost backups of the operating system, and will backup the database daily. ...
    (microsoft.public.sqlserver.setup)
  • Re: Cannot upgrade a licensed sql2000 to a MSDN 2005
    ... SQL Server Edition Operating System Compatibility (Warning) ... Installing SQL Server 2005' in Microsoft SQL Server Books Online. ... Microsoft Online Community Support ...
    (microsoft.public.sqlserver.setup)
  • SQL Query Analyzer Connectivity to a remote SQL Server
    ... I connect to a remote SQL Server with DBAdmin rights, ... that server from any operating system, when i connect query analyzer through ... Windows2000 Professioanl Operating system (IN WHICH SQL Server2000 also ...
    (microsoft.public.sqlserver.connect)
  • Re: Trying to figure this one out
    ... The operating system is WIndows 2000 ... It is also running SQL Server 2000 Standard ... I've never used either of those drivers, but I've had good experiences with the free jTDS driver. ...
    (comp.lang.java.databases)