Post reply

Multiple Admin accounts, but need different access

  • July 20, 2011 at 2:20 pm

    #254134

    How do you set up multiple SQL Server admins on various severs, but limit access to a subset of the admins?

    We have multiple people here who need admin access to some (SQL) servers, but not others. For example, the server with payroll on it needs to be restricted to one or two admin users. What's the best way to resolve that while using Windows Authentication?

    Edit: resolved confusing statement.

    The greatest enemy of knowledge is not ignorance, it is the illusion of knowledge. - Stephen Hawking

  • July 20, 2011 at 4:13 pm

    #1356085

    I would:

    1. Create an Active Directory group that corresponded to each database instance, e.g. PayrollSqlSysAdmins.

    2. Add the relevant AD User Accounts into the AD Groups.

    3. Add each AD Group to the sysadmin Fixed Server Role on the relevant database instance.

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

  • July 20, 2011 at 4:18 pm

    #1356089

    Thank you opc.three, I'll pass that along.

    The greatest enemy of knowledge is not ignorance, it is the illusion of knowledge. - Stephen Hawking

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply