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.
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.