|
sql
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
SA user lost SYSADMIN RIGHTSHi,
We have a serious situation here: Both the SA user and BUILTIN\Administrator have lost their SYSADMIN- rights. I thought that SA was hardcoded to be a sysadmin?? How is this possible? How can I re-enable these rights? Thanks for your help! Hi
You cannot remove sysadmin right from 'SA'. Where do you see it? Show quoteHide quote "atdmpp" <atd***@gmail.com> wrote in message news:b9379755-efdf-4b5d-a746-3fca628e3701@e1g2000hsh.googlegroups.com... > Hi, > > We have a serious situation here: > Both the SA user and BUILTIN\Administrator have lost their SYSADMIN- > rights. > > I thought that SA was hardcoded to be a sysadmin?? > > How is this possible? > How can I re-enable these rights? > > Thanks for your help!
Show quote
Hide quote
On Nov 19, 11:29 am, "Uri Dimant" <u***@iscar.co.il> wrote: Hi,> Hi > You cannot remove sysadmin right from 'SA'. Where do you see it? > > "atdmpp" <atd***@gmail.com> wrote in message > > news:b9379755-efdf-4b5d-a746-3fca628e3701@e1g2000hsh.googlegroups.com... > > > Hi, > > > We have a serious situation here: > > Both the SA user and BUILTIN\Administrator have lost their SYSADMIN- > > rights. > > > I thought that SA was hardcoded to be a sysadmin?? > > > How is this possible? > > How can I re-enable these rights? > > > Thanks for your help! We are using SQL Server 2000 SP4. It happens for example when I open Enterprise Manager, right-click on my instance and then choose Properties. Then I get an errormsg: "Only members of the sysadmin role can access this feature". Another example is that I cannot open any of the user-properties. Thanks for the help. Re-register the server using the 'sa' account and password.
Then modify your login to be a member of Sysadmin -- Show quoteHide quoteEkrem Önsoy "atdmpp" <atd***@gmail.com> wrote in message news:6442cd77-a005-47b9-828f-7f53d92c7d6f@n20g2000hsh.googlegroups.com... > On Nov 19, 11:29 am, "Uri Dimant" <u***@iscar.co.il> wrote: >> Hi >> You cannot remove sysadmin right from 'SA'. Where do you see it? >> >> "atdmpp" <atd***@gmail.com> wrote in message >> >> news:b9379755-efdf-4b5d-a746-3fca628e3701@e1g2000hsh.googlegroups.com... >> >> > Hi, >> >> > We have a serious situation here: >> > Both the SA user and BUILTIN\Administrator have lost their SYSADMIN- >> > rights. >> >> > I thought that SA was hardcoded to be a sysadmin?? >> >> > How is this possible? >> > How can I re-enable these rights? >> >> > Thanks for your help! > > Hi, > > We are using SQL Server 2000 SP4. > It happens for example when I open Enterprise Manager, right-click on > my instance and then choose Properties. > Then I get an errormsg: "Only members of the sysadmin role can access > this feature". > Another example is that I cannot open any of the user-properties. > > Thanks for the help. On Nov 19, 11:47 am, Ekrem Önsoy <ek***@btegitim.com> wrote:
Show quoteHide quote > Re-register the server using the 'sa' account and password. I can see the users but not their properties and therefore can also> > Then modify your login to be a member of Sysadmin > > -- > Ekrem Önsoy > > "atdmpp" <atd***@gmail.com> wrote in message > > news:6442cd77-a005-47b9-828f-7f53d92c7d6f@n20g2000hsh.googlegroups.com... > > > On Nov 19, 11:29 am, "Uri Dimant" <u***@iscar.co.il> wrote: > >> Hi > >> You cannot remove sysadmin right from 'SA'. Where do you see it? > > >> "atdmpp" <atd***@gmail.com> wrote in message > > >>news:b9379755-efdf-4b5d-a746-3fca628e3701@e1g2000hsh.googlegroups.com... > > >> > Hi, > > >> > We have a serious situation here: > >> > Both the SA user and BUILTIN\Administrator have lost their SYSADMIN- > >> > rights. > > >> > I thought that SA was hardcoded to be a sysadmin?? > > >> > How is this possible? > >> > How can I re-enable these rights? > > >> > Thanks for your help! > > > Hi, > > > We are using SQL Server 2000 SP4. > > It happens for example when I open Enterprise Manager, right-click on > > my instance and then choose Properties. > > Then I get an errormsg: "Only members of the sysadmin role can access > > this feature". > > Another example is that I cannot open any of the user-properties. > > > Thanks for the help. not change the properties. I can not see the Server Roles.. Open up Enterprise Manager,
- Right click on your SQL Server 2000 Instance (i.e. Ekrem-Pc\SQLServer2000) DELETE SQL Server Registration. - Right click on the SQL Server Group, New SQL Server Registration. And keep going... -- Ekrem Önsoy "atdmpp" <atd***@gmail.com> wrote in message On Nov 19, 11:47 am, Ekrem Önsoy <ek***@btegitim.com> wrote:news:5c5126a1-8f7b-4d67-8f0a-33f59ec5b5f2@l1g2000hsa.googlegroups.com... Show quoteHide quote > Re-register the server using the 'sa' account and password. I can see the users but not their properties and therefore can also> > Then modify your login to be a member of Sysadmin > > -- > Ekrem Önsoy > > "atdmpp" <atd***@gmail.com> wrote in message > > news:6442cd77-a005-47b9-828f-7f53d92c7d6f@n20g2000hsh.googlegroups.com... > > > On Nov 19, 11:29 am, "Uri Dimant" <u***@iscar.co.il> wrote: > >> Hi > >> You cannot remove sysadmin right from 'SA'. Where do you see it? > > >> "atdmpp" <atd***@gmail.com> wrote in message > > >>news:b9379755-efdf-4b5d-a746-3fca628e3701@e1g2000hsh.googlegroups.com... > > >> > Hi, > > >> > We have a serious situation here: > >> > Both the SA user and BUILTIN\Administrator have lost their SYSADMIN- > >> > rights. > > >> > I thought that SA was hardcoded to be a sysadmin?? > > >> > How is this possible? > >> > How can I re-enable these rights? > > >> > Thanks for your help! > > > Hi, > > > We are using SQL Server 2000 SP4. > > It happens for example when I open Enterprise Manager, right-click on > > my instance and then choose Properties. > > Then I get an errormsg: "Only members of the sysadmin role can access > > this feature". > > Another example is that I cannot open any of the user-properties. > > > Thanks for the help. not change the properties. I can not see the Server Roles.. Did you re-register your instance in Enterprise Manager?
-- Tibor Karaszi, SQL Server MVP http://www.karaszi.com/sqlserver/default.asp http://sqlblog.com/blogs/tibor_karaszi "atdmpp" <atd***@gmail.com> wrote in message On Nov 19, 11:47 am, Ekrem Önsoy <ek***@btegitim.com> wrote:news:5c5126a1-8f7b-4d67-8f0a-33f59ec5b5f2@l1g2000hsa.googlegroups.com... Show quoteHide quote > Re-register the server using the 'sa' account and password. I can see the users but not their properties and therefore can also> > Then modify your login to be a member of Sysadmin > > -- > Ekrem Önsoy > > "atdmpp" <atd***@gmail.com> wrote in message > > news:6442cd77-a005-47b9-828f-7f53d92c7d6f@n20g2000hsh.googlegroups.com... > > > On Nov 19, 11:29 am, "Uri Dimant" <u***@iscar.co.il> wrote: > >> Hi > >> You cannot remove sysadmin right from 'SA'. Where do you see it? > > >> "atdmpp" <atd***@gmail.com> wrote in message > > >>news:b9379755-efdf-4b5d-a746-3fca628e3701@e1g2000hsh.googlegroups.com... > > >> > Hi, > > >> > We have a serious situation here: > >> > Both the SA user and BUILTIN\Administrator have lost their SYSADMIN- > >> > rights. > > >> > I thought that SA was hardcoded to be a sysadmin?? > > >> > How is this possible? > >> > How can I re-enable these rights? > > >> > Thanks for your help! > > > Hi, > > > We are using SQL Server 2000 SP4. > > It happens for example when I open Enterprise Manager, right-click on > > my instance and then choose Properties. > > Then I get an errormsg: "Only members of the sysadmin role can access > > this feature". > > Another example is that I cannot open any of the user-properties. > > > Thanks for the help. not change the properties. I can not see the Server Roles..  
Thread options
Other interesting topics
|
|||||||||||||||||||||||
