SQL server Security

Posted on 2011-10-03
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

    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

    '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


    Featured Post

    Highfive Gives IT Their Time Back

    Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

    Join & Write a Comment

    I thought I'd write this up for anyone who has a request to create an anonymous whistle-blower-type submission form created using SharePoint 2010 (this would probably work the same for 2013). It's not 100% fool-proof but it's as close as you can get…
    This story has been written with permission from the scammed victim, a valued client of mine – identity protected by request.
    It is a freely distributed piece of software for such tasks as photo retouching, image composition and image authoring. It works on many operating systems, in many languages.
    Sending a Secure fax is easy with eFax Corporate ( First, Just open a new email message.  In the To field, type your recipient's fax number You can even send a secure international fax — just include t…

    755 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

    Need Help in Real-Time?

    Connect with top rated Experts

    21 Experts available now in Live!

    Get 1:1 Help Now