Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

I've a need probably most of you already solved in some way: beside (automatically) creating users (DB + users on single DBs) on multiple SQLServer instances, I need to keep "track" of them and, eventually, re-create them.

I was thinking of a software doing so.

Visual Studio Database features seems not managing users/logins very well and it seems overkill to me.

UPDATE: What I need a suggestion on how to keep track of users' access to every specific DB on several SQL Server instance.

share|improve this question
1  
Could you add a little more detail of what it is that you need to do? Are you looking for full central management? Or to automatically copy users between instances? If you're looking for a strategy then we can help. If you're looking for a product recommendation then this isn't the right place. –  squillman Aug 20 '12 at 11:17
    
It looks like you're looking for a product/package, not a specific answer to a question. –  Bob Aug 20 '12 at 12:12
    
You might get a better answer to this on dba.stackexchange.com , however you need to provide a lot more detail about what you're trying to do (do you only care about log-in/log-out? Do you need t track commands issued? etc.) - Let me know if you would like this question migrated. –  voretaq7 Aug 21 '12 at 5:41

1 Answer 1

You can try out ApexSQL Comply - it's a SQL Server auditing and compliance tool that provides a wide range of possibilities for auditing access, changes, and security on multiple SQL Server instances, databases, and objects. It can audit executed queries, warnings encountered on tables, stored procedures, functions, and views. All audited information is saved in a centralized auditing repository, and provided for reporting and analysis via centralized web-based reporting module

Disclaimer: I work as a Product Support Engineer at ApexSQL

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.