| Author |
Only sysadmin can do that.. but I am one
|
|
| a0209129 2005-07-24, 1:26 pm |
| 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
| |
| Narayana Vyas Kondreddi 2005-07-24, 8:24 pm |
| As 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@microso
ft.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
>
| |
| John Bell 2005-07-24, 8:24 pm |
| 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\Administrato
rs 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@microso
ft.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
>
| |
| a0209129 2005-07-24, 8:24 pm |
| Yes, I am getting the error with the SA login. When I try select
IS_SRVROLEMEMBER('sy
sadmin', '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 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@microso
ft.com...
>
>
>
| |
| a0209129 2005-07-24, 8:24 pm |
| Thanks, John.
When I try that command, I get the following message
Server: Msg 15412, Level 11, State 1, Procedure sp_helpsrvrolemember
, Line 10
'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\Administrato
rs 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@microso
ft.com...
>
>
>
| |
| a0209129 2005-07-24, 8:24 pm |
| 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 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
>
| |
|
|
|
|