Re: Can't edit logins or server roles

From: Sue Hoegemeier (Sue_H_at_nomail.please)
Date: 09/10/04 

Date: Fri, 10 Sep 2004 10:42:28 -0600

A windows local admin may have sysadmin access for a SQL Server
running on that box as by default SQL Server adds the Windows group
BUILTIN\Administrators (local admins) and members of this group are
sysadmins by default. However, that doesn't mean that this can't be
changed. Some people remove the BUILTIN\Administrators group and
others have changed what SQL Server server role this group belongs to.
So on a default installation with nothing changed, a windows local
admin would have sysadmin access in SQL Server but that can be
changed. I would guess that this is the case on the server were you
don't seem to be a member of sysadmins. You can check your role
membership using IS_MEMBER or IS_SRVROLEMEMBER which are explained and
documented in books online.

-Sue

On Fri, 10 Sep 2004 08:41:02 -0700, "rmunson8"
<rmunson8@discussions.microsoft.com> wrote:

>I am running SQL Server 2000 and am a member of the windows Administrators
>group.
>
>In Enterprise Manager, I am unable to get to the Properties of any of the
>Security Logins, and am unable to view any of the ServerRoles.
>
>My understanding is that to do so, I would need to be a member of the
>sysadmin role, and should be a part of that role by default if I am a member
>of the windows Administrators group. However, that doesn't seem to be the
>case.
>
>Any ideas why I can't perform any of the sysadmin functions even though I am
>the computer's admin?

Relevant Pages

  • Re: SQL Login
    ... The sa login account is a member of that role as well. ... Dejan Sarka, SQL Server MVP ... > But how do we add the User X to the sysadmin / ...
    (microsoft.public.sqlserver.security)
  • Re: permissions not working
    ... at the windows NT level they have sysadmin rights because I did not ... It is likely that the user in question is a member of the Windows Administrators group on the SQL Server. ... Administrators group members access the SQL Server via membership of the BUILTIN\Administrators login are sysadmin role members by default in SQL 2000. ...
    (microsoft.public.sqlserver.security)
  • Re: XP_CMDSHELL
    ... When master..xp_cmdshell is called by a user who is a member of the sysadmin ... fixedserver role, master..xp_cmdshell will be executed under the account's ... security context in which the SQL Server service is running. ...
    (microsoft.public.sqlserver.programming)
  • Re: permissions required for executing CDOSys stored procedures
    ... he is by default member of the sysadmin server ... role on the SQL Server database unless steps are taken to prevent that. ... sysadmin and who has not been granted specific execute permissions on the ... it is possible to GRANT EXECUTE ON sp_OACreate TO ...
    (microsoft.public.sqlserver.security)
  • Re: Sharepoint index problems in SQL Server.
    ... The Administrator account is a sysadmin and have all the access to all the ... > database is master and language US_English? ... >> I've set back the account localsystem for both SQL Server and Microsoft ...
    (microsoft.public.sqlserver.fulltext)