SQL server Security

Posted on 2011-10-03
Medium Priority
Last Modified: 2012-05-12
I have multiple SQL servers (SQL 2000, 2005 and 2008). I want to create and deploy a security policy/Sec best practices to tighten up security on these servers. Can anyone give recommendations or point me in the right direction?
Question by:DEFclub
LVL 25

Accepted Solution

jogos earned 2000 total points
ID: 36908597
Multiple servers/instances so the easiest way is to centralise (most off) the authorisation in AD-groups and then instance per instance see that the correct rights are assinged that apply for that version of sql.

A good start is to make an inventory on what exists http://www.mssqltips.com/sqlservertip/1881/sql-server-security-audit-report/

'tighten up' can also mean to make difference in how you try to connect to db. So application roles (from 2005) can limit access to only trough a specific application.  

Author Closing Comment

ID: 36932695

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

If you are like me and like multiple layers of protection, read on!
This shares a stored procedure to retrieve permissions for a given user on the current database or across all databases on a server.
Nobody understands Phishing better than an anti-spam company. That’s why we are providing Phishing Awareness Training to our customers. According to a report by Verizon, only 3% of targeted users report malicious emails to management. With compan…
In a question here at Experts Exchange (https://www.experts-exchange.com/questions/29062564/Adobe-acrobat-reader-DC.html), a member asked how to create a signature in Adobe Acrobat Reader DC (the free Reader product, not the paid, full Acrobat produ…

864 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question