Can't edit logins or server roles

From: rmunson8 (rmunson8_at_discussions.microsoft.com)
Date: 09/10/04


Date: Fri, 10 Sep 2004 08:41:02 -0700

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: Getting the sa password with SQLDMO
    ... SQL Server stores passwords using a one-way hash so you can't read the ... conditional password change by attempting a connection using the expected sa ... password and, if it fails, connect using a different sysadmin role member ... member can change the sa password. ...
    (microsoft.public.sqlserver.programming)
  • Re: DTS Sucess but fails to go to next step when scheduled
    ... If == a member of the sysadmin role then log in as the account under which the ... Now try the package ... If!= A member of the sysadmin rol then log in as the proxy accunt and try the ... Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP) www.SQLDTS.com - The site for all your DTS needs. ...
    (microsoft.public.sqlserver.dts)
  • Re: SQL Server 7 Permissions!
    ... SQL Server MVP ... > The user is the user I'm using and is not sysadmin. ... Or member of the Windows Administrators ...
    (microsoft.public.sqlserver.programming)
  • Re: SQL Server 7 Permissions!
    ... SQL Server MVP ... > The user is the user I'm using and is not sysadmin. ... Or member of the Windows Administrators ...
    (microsoft.public.sqlserver.security)
  • Re: sp_change_users_login use after restore
    ... The user was a member of the sysadmin role, once I took the role out, ... In that case the login will will be 'dbo' in the ... > SQL Server MVP ...
    (microsoft.public.sqlserver.security)