SQL 2005 Instances Security On Same Server

Posted on 2007-10-03
Last Modified: 2010-03-19
If I have a default instance of SQL 2005 server on a Windows 2003 Server box, and I add a couple of named instances, and some of the users are duplicated throughout the different instances, can I be sure that the Server Roles I give to a user in one instance won't give that user the same role in another instance?

Example, on a server named ACT:


Can I be sure that the domain1\user1 login does NOT have sysadmin on the named instance ACT\RED, or in the default instance?

It seems that way.  I'm just checking here to be sure.

Question by:gateguard
    LVL 42

    Accepted Solution

    Yes, you can be sure.  Server roles are maintained by server and database roles are maintained by database.  Never will the permissions granted to a role in one instance apply to the same role in another instance.

    Author Comment


    Featured Post

    Why You Should Analyze Threat Actor TTPs

    After years of analyzing threat actor behavior, it’s become clear that at any given time there are specific tactics, techniques, and procedures (TTPs) that are particularly prevalent. By analyzing and understanding these TTPs, you can dramatically enhance your security program.

    Join & Write a Comment

    by Mark Wills PIVOT is a great facility and solves many an EAV (Entity - Attribute - Value) type transformation where we need the information held as data within a column to become columns in their own right. Now, in some cases that is relatively…
    Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
    how to add IIS SMTP to handle application/Scanner relays into office 365.
    In this tutorial you'll learn about bandwidth monitoring with flows and packet sniffing with our network monitoring solution PRTG Network Monitor ( If you're interested in additional methods for monitoring bandwidt…

    745 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

    16 Experts available now in Live!

    Get 1:1 Help Now