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 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
> >
>
>|||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\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
> >
>
>|||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
>|||Hi
You should probably rebuild the master database using rebuildm.exe as
there may be other things wrong.
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/coprompt/cp_rebuildm_6dbt.asp
John
Showing posts with label sysadmin. Show all posts
Showing posts with label sysadmin. Show all posts
Wednesday, March 7, 2012
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
a0209129
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@.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 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...
>
>
|||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\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 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 should probably rebuild the master database using rebuildm.exe as
there may be other things wrong.
http://msdn.microsoft.com/library/de...uildm_6dbt.asp
John
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
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@.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 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...
>
>
|||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\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 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 should probably rebuild the master database using rebuildm.exe as
there may be other things wrong.
http://msdn.microsoft.com/library/de...uildm_6dbt.asp
John
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
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
Saturday, February 25, 2012
Only members of sysadmin role are allowed to update or delete jobs owned by a different login
Question to those who may have had this same error- it seems that I am not able to delete some of the reports that I have created. This just started happening recently and according to our system admin nothing has changed as far as permissions are concernced. We installed SP2 the other day and I was wondering if this could have anything to do with the error message below
by the way I am a member of the sysadmin group
thanks in advance
km
System.Web.Services.Protocols.SoapException: Server was unable to process request. > System.Data.SqlClient.SqlException: Only members of sysadmin role are allowed to update or delete jobs owned by a different login. Only members of sysadmin role are allowed to update or delete jobs owned by a different login. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at Microsoft.ReportingServices.Library.InstrumentedSqlCommand.ExecuteNonQuery() at Microsoft.ReportingServices.Library.DBInterface.DeleteObject(String objectName) at Microsoft.ReportingServices.Library.RSService._DeleteItem(String item) at Microsoft.ReportingServices.Library.RSService.ExecuteBatch(Guid batchId) at Microsoft.ReportingServices.WebServer.ReportingService2005.ExecuteBatch() End of inner exception stack trace
my bad
I need to move this over to SSRS
km
|||Moved to RS as requested.
The error though is more general than RS, in fact it is a standard SQL Server Agent message. Unless there is a bug, I'd say you really are not a member of sysadmins, or at least not in the context of the RS WS call that is doing the work on yoru behalf. That may be the issue, the security context used by the WS itself. Perhaps run a profiler trace and see what login is being used, and also what job it is trying to delete. You can then verify the job owner. There should not be a problem as you are managing a RS created job, so RS should be able to delete its own jobs... maybe it is a RS thing?
|||Thanksyour info did the trick-- the account used was not a member of sysadmin-- my bad
thanks again
kam
|||
hi kam,
how did you solved the issue? i've added myself as the sysadmin on the server, but i'm still getting the same error. is there any other sysadmin than the sqladmin? thanks.
DK
|||actually, i've found the answer. whatever account used on the app pool need to have sysadmin, as this is the account that is updating/deleting the report. thanks.Only members of sysadmin role are allowed to update or delete jobs owned by a different login
Question to those who may have had this same error- it seems that I am not able to delete some of the reports that I have created. This just started happening recently and according to our system admin nothing has changed as far as permissions are concernced. We installed SP2 the other day and I was wondering if this could have anything to do with the error message below
by the way I am a member of the sysadmin group
thanks in advance
km
System.Web.Services.Protocols.SoapException: Server was unable to process request. > System.Data.SqlClient.SqlException: Only members of sysadmin role are allowed to update or delete jobs owned by a different login. Only members of sysadmin role are allowed to update or delete jobs owned by a different login. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at Microsoft.ReportingServices.Library.InstrumentedSqlCommand.ExecuteNonQuery() at Microsoft.ReportingServices.Library.DBInterface.DeleteObject(String objectName) at Microsoft.ReportingServices.Library.RSService._DeleteItem(String item) at Microsoft.ReportingServices.Library.RSService.ExecuteBatch(Guid batchId) at Microsoft.ReportingServices.WebServer.ReportingService2005.ExecuteBatch() End of inner exception stack trace
my bad
I need to move this over to SSRS
km
|||Moved to RS as requested.
The error though is more general than RS, in fact it is a standard SQL Server Agent message. Unless there is a bug, I'd say you really are not a member of sysadmins, or at least not in the context of the RS WS call that is doing the work on yoru behalf. That may be the issue, the security context used by the WS itself. Perhaps run a profiler trace and see what login is being used, and also what job it is trying to delete. You can then verify the job owner. There should not be a problem as you are managing a RS created job, so RS should be able to delete its own jobs... maybe it is a RS thing?
|||Thanksyour info did the trick-- the account used was not a member of sysadmin-- my bad
thanks again
kam|||
hi kam,
how did you solved the issue? i've added myself as the sysadmin on the server, but i'm still getting the same error. is there any other sysadmin than the sqladmin? thanks.
DK
|||actually, i've found the answer. whatever account used on the app pool need to have sysadmin, as this is the account that is updating/deleting the report. thanks.
Subscribe to:
Posts (Atom)