Here's a little free utility that will do this for you.
http://www.eeye.com/html/Research/Tools/sqlworm.html
For more "complete" scanning of individual machines, try the Microsoft
Security Baseline Analyzer
http://www.microsoft.com/technet/treeview/default.asp?url=/technet/security/
tools/Tools/MBSAhome.asp
-----Original Message-----
From: Luís Ganhão [mailto:luis.[Email Address Removed] Wednesday, August 14, 2002 8:28 AM
To: [Email Address Removed] Password's
Hi all,
I would like to know if it's possible in SQL Server to create a script that
tries to connect to Databases with blank password or password equal to the
user name.
I have to check 10 SQL Servers.
In Oracle it's very easy, I hope it's the same in SQL Server.
If anyone have a script like this, please send it to me.
TIA,
Luís Manuel Martins Ganhão
Novabase, Desenvolvimento à Medida
Serviços de Valor Acrescentado
DBA Oracle Certified Professional 8i
Av. Engº Duarte Pacheco, Torre 1 - 9º
1099-078 Lisboa
Tel: 351213836300
Tlm +351967610858
http://novabase.pt
CONFIDENCIALIDADE: Este e-mail é confidencial e apenas pode ser lido,
copiado ou utilizado pelo destinatário. Se o recebeu por engano, por favor
contacte o remetente através de e-mail ou pelo telefone + 351 21 383 63 00.
Agradecemos ainda que apague este e-mail e não divulgue o respectivo
conteúdo.
CONFIDENTIALITY: This e-mail is confidential and may be privileged. It may
be read, copied and used only by the intended recipient. If you have
received it in error, please contact the sender immediately by return e-mail
or by phoning + 351 21 383 63 00. Then please delete this e-mail and do not
disclose its contents to any person.
CONFIDENTIALITY NOTICE: The information contained in this message is legally
privileged and confidential information intended only for the use of the
individual or entity named above. If the reader of this message is not the
intended recipient, or the employee or agent responsible to deliver it to
the intended recipient, you are hereby notified that any release,
dissemination, distribution, or copying of this communication is strictly
prohibited. If you have received this communication in error, please notify
the author immediately by replying to this message and delete the original
message.
Thank you.
MS Sql Server LazyDBA home page