How to give user access to manage sqlserver 2005 remotely?

[ghurty]

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

[Uri Dimant]

Hi
He/She should NOT be a member of local admin group /domain admin group....
Create a login in the Windows machine hosts SQL Server and add login to the
SQL Server...

"ghurty" <ghu...@discussions.microsoft.com> wrote in message
news:7DB82773-309E-4A64...@microsoft.com...

[imarkic84]

You should give access or permision to specific user on management
studio of sql server.

[ghurty]

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

Thanks

[Steen Schl�ter Persson]

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" <ghu...@discussions.microsoft.com> wrote in message

news:03037F7E-CE4D-493A...@microsoft.com...

[Rick Byham, MSFT]

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" <st...@REMOVETHISasavaenget.dk> wrote in message
news:uJ5Ytu5j...@TK2MSFTNGP04.phx.gbl...