Link to home
Start Free TrialLog in
Avatar of ntefft
ntefft

asked on

How can I enable audit logging on multiple SQL 2005 servers at once?

Id like to enable auditing of both failed and successful logins on multiple systems running Microsoft SQL 2005 Express.
I know its easy to do via the Management Studio.  I just go into the server properties, choose security, and select Both failed and successful logins
Since I have over 100 systems I need to modify, Im looking for some automated way to do it.  Be it a command or a registry entry, just something I can push down without having to individually go into each server.

Thanks.
ASKER CERTIFIED SOLUTION
Avatar of Raja Jegan R
Raja Jegan R
Flag of India image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial