Possible to deny sa access to Database?

Posted on 2006-03-23
Last Modified: 2009-07-29
Is it possible to deny a system administrator access to a particular database?  The situtation is this...we are installing an application and database on a client's server.  They would like us to use their SQL Server to host the database for maintenance issues but we don't want to allow them unfettered access to the database.  Is this possible and how?

Question by:Brian Crowe
    LVL 75

    Accepted Solution

    You cannot deny sa to specific databases.  You can deny sa from the whole server by setting SQL Server to use Windows Authentication only.
    LVL 18

    Expert Comment

    Cant comment on SQL 2005 as i dont know enough about it yet,  but if this is SQL 2000 then irrespective of what SQL permissions are granted, if someone stops sql and attatches the DBs to another SQL database then the'll bypass the security.   The only thing you can do is either secure the box itself (ie not on clients server) or encrypt the database.

    LVL 27

    Expert Comment

    acperkins is right. The sa has rights in every database.
    LVL 34

    Author Comment

    by:Brian Crowe
    That's what I figured.  I just wanted to make sure that I wasn't missing something.  Thank you all for your comments.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Looking for New Ways to Advertise?

    Engage with tech pros in our community with native advertising, as a Vendor Expert, and more.

    I recently came across an interesting Question In EE ( and was puzzled about how to achieve that using SSIS out of the box tasks, which was i…
    International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
    Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
    Via a live example, show how to backup a database, simulate a failure backup the tail of the database transaction log and perform the restore.

    760 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

    12 Experts available now in Live!

    Get 1:1 Help Now