How to give user access to manage sqlserver 2005 remotely?

#1

We have sqlserver 2005 running on a domain controller.

How can we give a user rights to access/manage the sqlserver without them
having any access to change/view things on the domain controller?

Thanks

#2

How using Active Directory can I give access to a particualt use on managemnt
sutdio?

Thanks

#3

When you say you want to give them "rights to access/manage the sqlserver",
what is it you want them to be able to do?
--
Rick Byham, MSFT
(Implies no warranty or rights)

"Steen Schlüter Persson" <steen (AT) REMOVETHISasavaenget (DOT) dk> wrote

Quote:

You don't give access to Management Studio via AD. You can use Managemenst
Studio to grant specific AD users and/or AD Groups access to administrer
the SQL instance. You can either give the user/group full sysadmin right
to the SQL instance or you can be more granular and then only give them
access to certain things. They can then access the SQL Instance from a
locally installed Management Studio.
It's also possible to give them access to just RDP to the server and then
run Management Studio on the server itself, but depending on what oyu want
to deny them from doing it might be a bigger task to lock stuff down on
the server.

--
Regards
Steen Schlüter Persson (DK)

"ghurty" <ghurty (AT) discussions (DOT) microsoft.com> wrote in message
news:03037F7E-CE4D-493A-9ED4-AE0F9CB6FB85 (AT) microsoft (DOT) com...
How using Active Directory can I give access to a particualt use on
managemnt
sutdio?

Thanks

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

How to give user access to manage sqlserver 2005 remotely?

microsoft.public.sqlserver.tools microsoft.public.sqlserver.tools

How to give user access to manage sqlserver 2005 remotely? - 01-07-2010 , 01:37 AM

Re: How to give user access to manage sqlserver 2005 remotely? - 01-07-2010 , 07:09 AM

Re: How to give user access to manage sqlserver 2005 remotely? - 01-08-2010 , 10:05 AM