| Author |
Jedi-level question, please help!
|
|
| captain 2003-04-29, 11:46 pm |
| Hello everyone. I have been away for awhile. Been busy with a new product at work. Hope everyone is doing well. I haven't used Active Directory much before or since completing my MCSE and could use a little help. I have a server running SQL and want to create a user account that can have administrative rights only to that server, but still have access to network resources. I basically just want the user to have full access to services and the entire server. What is the most effective way to do this? | |
| enforcer 2003-04-30, 5:18 am |
| Is the SQL server a Domain controller or just a member server.
If it just a member server, create a SQL global group make the user a member. then add the SQL global account to the local admins group on the SQL server | |
| captain 2003-04-30, 12:10 pm |
| Appreciate the response, but in essence, I would like to create a user account that can administer only this member server. Rather than log in with the admin account, I want to use an account that has high-level rights, but don't want to give the account full admin rights. I can create a user account and add it to the Server Operators group, but I need a little more rights than that. Appreciate your input. | |
| enforcer 2003-04-30, 12:19 pm |
| that's what the above solution does.
you create a global domain account (in active directory users)called SQLADMIN for example, make the user a member of it.
on the SQL server you add the <domain name>/SQLADMIN account to the local administrator account.
therefore whenever the user logs onto the SQL server he will have admin rights to it. | |
| captain 2003-04-30, 1:45 pm |
| I misunderstood you the first time. Appreciate it. I will do that now! | |
| enforcer 2003-04-30, 1:53 pm |
| 
Glad to help | |
| captain 2003-04-30, 3:18 pm |
| Hey, thanks a lot! It worked nicely. Now I feel like I just wasted thousands of dollars on my MCSE, but I learned something and I appreciate it! | |
| everetjo 2003-04-30, 3:31 pm |
| good show marty |
|
|
|