Re: Rights for a DBA

From: Roger Abell [MVP] (mvpNoSpam_at_asu.edu)
Date: 11/12/05 

Date: Sat, 12 Nov 2005 11:36:25 -0700

You can do as Steve has said to give them start/stop etc permissions
on the services of SQL, and also make sure that you have given them
permissions on the storage areas the SQL Server uses as they will
need this for creating new databases.
If you really, really want to make sure they are restricted from having
admin capability on the machine, then you must make sure that SQL
Server is not configured to run as Local System.

"Dave Morrow" <davemorrow@hotmail.com> wrote in message
news:e4a1Bhm5FHA.3416@TK2MSFTNGP15.phx.gbl...
> Hi all. I've run into a rather perplexing problem with respect to giving
> access rights to a DBA. I have given the DBA System Administrator rights
> within SQLServer 2000 which is running on the server but would prefer to
> not give him Administrator rights to the Windows 2000 server itself.
> Unfortunately, he needs to be able to stop and start the SQL Server
> services (SQLServer and SQLServerAgent). Does anyone know how I can
> achieve this without granting full administrator rights to the server?
>

Relevant Pages

  • Re: SQL CE Synching Problems
    ... Have you granted IUSER_ServerName access to your publication within SQL ... It looks like the permissions problem is getting access to the publication. ... so the issue has to be between the server tools and the publisher. ... > A request to send data to the computer running IIS has failed. ...
    (microsoft.public.sqlserver.ce)
  • Re: SQL CE Synching Problems
    ... install location of SQL CE instead of under Inetpub like I had done before. ... > so the issue has to be between the server tools and the publisher. ... >>I ran the wizard again to check all the permissions and this is what it ... >> A request to send data to the computer running IIS has failed. ...
    (microsoft.public.sqlserver.ce)
  • Re: Disable Sysadmin to view metadata in SQL2005
    ... you are looking for a DRM solution for your database. ... Server does not provide such a solution. ... SQL Server Engine ... If the permissions are not granular ...
    (microsoft.public.sqlserver.security)
  • Re: Restore leaves DB in Loading state
    ... I think your problem may have something to do with permissions. ... SQL Agent account controlling the job or the context the job runs under does ... Senior Database Administrator ... I support the Professional Association for SQL Server ...
    (microsoft.public.sqlserver.server)
  • SQL/IIS/Active Directory
    ... A Win2k service is running under a domain ... The domain account has permissions to SQL ... service which in turn accesses the SQL server data via ...
    (microsoft.public.sqlserver.security)