NT Access Level for DBA's

From: Tariq (tariq@nodirectemail.com)
Date: 05/27/02 

From: "Tariq" <tariq@nodirectemail.com>
Date: Mon, 27 May 2002 00:49:09 -0700

Hi

I posted this on the general newsgroup, but I think this
one group is more appropriate.

Our NT administrators won't grant DBA's more than a normal
user access to servers running MS SQL Server 7/2000. Some
of the problems encountered because of this:
- Unable to restart MS SQL Server / Agent Services
- Unable to change service start up account
- Unable to see SQL Server counters when running the
performance monitor
(NT Administrators do the server install, so we do not
need admin for that)

Is there a recommendation from Microsoft to what NT/2000
access level DBA's require to be able to administer SQL
Server? Something to argue my case for a higher security
level. What is your experience?

I do not want to be an NT Admin, but I would like to be
able to administer SQL Server properly.

Thanks in advance,
Tariq

Relevant Pages

  • Re: Clustering and SA Role
    ... It helps if your Domain/Enterprise Administrators, Server Administrators, ... > I guess the issue is that in SQL2000 one could remove local admin group ... > legitimately getting into SQL Server. ... Trust for sure simplifies management in many ...
    (microsoft.public.sqlserver.clustering)
  • RE: Restricting Access to BUILTINAdministrators
    ... SQL Server Security: Security Admins ... Removing the Builtin Administrators - Some Pitfalls to Avoid ... > and remove access to each of the databases on the server. ...
    (microsoft.public.sqlserver.security)
  • Re: Account to Run SQL under?
    ... you use AD Global Groups to grant the SQL Server DBAs administrative access, ... How to impede Windows NT administrators from administering a clustered ... with great power comes great responsibility. ... If you do not want local administrators to have system admin access rights then all you need to so is restrict the BUILTIN\Administrators rights. ...
    (microsoft.public.sqlserver.server)
  • Re: Lost SA Password
    ... Try logging on as a member of the local Administrators group and ... executing the script with a trusted connection: ... BUILTIN\Administrators SQL Server login. ... > The 'sa' password is not known, and the default database ...
    (microsoft.public.sqlserver.security)
  • OpenDataSource "Unspecified Error" connecting to Excel file
    ... the file is on the local Sql Server. ... Even if I add domain users to the server administrator role, ... administrators group on the Sql Server, ... local administrators group on the Sql Server? ...
    (microsoft.public.sqlserver.connect)