Only sysadmin can do that.. but I am one

Hi all.
We recently have been getting strange messages from SQL Server. Going into
EM and right clicking the server and selecting properties... I get a message
saying that "Only members of the sysadmin role can access this feature."
But I have administrator priveleges on the machine.
I try logging in with the SA username and password. It works but it also
tells me that I am not a sysadmin.
I tried re-installing the service pack but it won't even let me start
stating that I need to be a sysadmin to install it.
So I tried re-installing SQL Server and restoring my databases... still no
luck.
Does anyone have any ideas as to what it going on?
--
Michael
a0209129As a start, use IS_SRVROLEMEMBER function to see what SQL Server is thinking
about your login.
Are you saying you are getting this error message even with SA login?
--
HTH,
Vyas, MVP (SQL Server)
SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
"a0209129" <a0209129@.discussions.microsoft.com> wrote in message
news:6F86FA51-D67E-499D-A47D-8448742BBEE9@.microsoft.com...
> Hi all.
> We recently have been getting strange messages from SQL Server. Going
> into
> EM and right clicking the server and selecting properties... I get a
> message
> saying that "Only members of the sysadmin role can access this feature."
> But I have administrator priveleges on the machine.
> I try logging in with the SA username and password. It works but it also
> tells me that I am not a sysadmin.
> I tried re-installing the service pack but it won't even let me start
> stating that I need to be a sysadmin to install it.
> So I tried re-installing SQL Server and restoring my databases... still no
> luck.
> Does anyone have any ideas as to what it going on?
> --
> Michael
> a0209129
>|||Hi
You will have to check who the instance is registered under in EM, by
editing the registration.
If that is ok, you may want to check who is actually in the system
administrators role using
EXEC sp_helpsrvrolemember 'sysadmin'
BUILTIN\Administrators may have been removed. sa can't be removed from the
system administrators role.
John
"a0209129" <a0209129@.discussions.microsoft.com> wrote in message
news:6F86FA51-D67E-499D-A47D-8448742BBEE9@.microsoft.com...
> Hi all.
> We recently have been getting strange messages from SQL Server. Going
> into
> EM and right clicking the server and selecting properties... I get a
> message
> saying that "Only members of the sysadmin role can access this feature."
> But I have administrator priveleges on the machine.
> I try logging in with the SA username and password. It works but it also
> tells me that I am not a sysadmin.
> I tried re-installing the service pack but it won't even let me start
> stating that I need to be a sysadmin to install it.
> So I tried re-installing SQL Server and restoring my databases... still no
> luck.
> Does anyone have any ideas as to what it going on?
> --
> Michael
> a0209129
>|||Yes, I am getting the error with the SA login. When I try select
IS_SRVROLEMEMBER('sysadmin', 'my_login') it responds with a 1 just like it
does with the SA.
--
Michael
a0209129
"Narayana Vyas Kondreddi" wrote:

> As a start, use IS_SRVROLEMEMBER function to see what SQL Server is thinki
ng
> about your login.
> Are you saying you are getting this error message even with SA login?
> --
> HTH,
> Vyas, MVP (SQL Server)
> SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
>
> "a0209129" <a0209129@.discussions.microsoft.com> wrote in message
> news:6F86FA51-D67E-499D-A47D-8448742BBEE9@.microsoft.com...
>
>|||Thanks, John.
When I try that command, I get the following message
Server: Msg 15412, Level 11, State 1, Procedure sp_helpsrvrolemember, Line 1
0
'sysadmin' is not a known fixed role.
Michael
a0209129
"John Bell" wrote:

> Hi
> You will have to check who the instance is registered under in EM, by
> editing the registration.
> If that is ok, you may want to check who is actually in the system
> administrators role using
> EXEC sp_helpsrvrolemember 'sysadmin'
> BUILTIN\Administrators may have been removed. sa can't be removed from the
> system administrators role.
> John
>
> "a0209129" <a0209129@.discussions.microsoft.com> wrote in message
> news:6F86FA51-D67E-499D-A47D-8448742BBEE9@.microsoft.com...
>
>|||Huh... if I do a select * from spt_values it returns no records at all.
I guess that's the reason. But how do I put them back? Can I put them
back? Can I insert into spt_values select * from
<someOtherServer>.master.dbo.spt_values?
--
Michael
a0209129
"a0209129" wrote:

> Hi all.
> We recently have been getting strange messages from SQL Server. Going int
o
> EM and right clicking the server and selecting properties... I get a messa
ge
> saying that "Only members of the sysadmin role can access this feature."
> But I have administrator priveleges on the machine.
> I try logging in with the SA username and password. It works but it also
> tells me that I am not a sysadmin.
> I tried re-installing the service pack but it won't even let me start
> stating that I need to be a sysadmin to install it.
> So I tried re-installing SQL Server and restoring my databases... still no
> luck.
> Does anyone have any ideas as to what it going on?
> --
> Michael
> a0209129
>|||Hi
You should probably rebuild the master database using rebuildm.exe as
there may be other things wrong.
http://msdn.microsoft.com/library/d...>
ldm_6dbt.asp
John