I have now probably done a very silly thing
in [Programming SQL]
|
From: Abba on 5 Jan 2010 05:22 What version of SQLServer? "Tony Johansson" <johansson.andersson(a)telia.com> wrote in message news:gnE0n.14285$U5.218151(a)newsb.telia.net... > > I have looked but haven't found any procedure that point out how I restart > in single-user mode and > once started that way, I can login using DAC and reset account privileges. > > Can you point out any site where I can find this kind of information. > > //Tony > > > "Jeffrey Williams" <jeff.williams3188(a)verizon.net> skrev i meddelandet > news:0B89C9D8-4143-42EF-86F7-1496010C7002(a)microsoft.com... >> If you are using mixed authentication mode and know the 'sa' password, >> log on with the 'sa' account and modify the accounts you need to be >> sysadmin. Personally, I would not add that property back in to the >> builtin\administrator account - I normally remove that privilege anyways. >> >> If you don't have 'sa' access - you need to shut down SQL Server and >> restart in single-user mode. Once started that way, you can login using >> DAC and reset account privileges. You can lookup the procedure in books >> online. >> >> Jeff >> >> "Tony Johansson" <johansson.andersson(a)telia.com> wrote in message >> news:Nkv0n.14279$U5.218013(a)newsb.telia.net... >>> Hello! >>> >>> I have now done a very silly thing. >>> >>> I have been playing around to get a better understanding how all this >>> works. >>> >>> I have right click and take properies on the builtin\administrator and >>> then select the server Roles and here I have >>> unchecked the sysadmin. >>> >>> This mean that I can't check this sysadmin for builtin\administrator any >>> more the errro message is >>> user does not have permission to perform this action. Is there any >>> workaround to fix this >>> >>> //Tony >>> > >
From: Andrew Morton on 5 Jan 2010 05:40 Tony Johansson wrote: > I have looked but haven't found any procedure that point out how I > restart in single-user mode and > once started that way, I can login using DAC and reset account > privileges. > Can you point out any site where I can find this kind of information. "Starting SQL Server in Single-User Mode" http://msdn.microsoft.com/en-us/library/ms188236.aspx Andrew
From: Uri Dimant on 5 Jan 2010 05:54 Tony Go to the Config Manager and add a powerfull account for SQL Server ... restart the service "Tony Johansson" <johansson.andersson(a)telia.com> wrote in message news:gnE0n.14285$U5.218151(a)newsb.telia.net... > > I have looked but haven't found any procedure that point out how I restart > in single-user mode and > once started that way, I can login using DAC and reset account privileges. > > Can you point out any site where I can find this kind of information. > > //Tony > > > "Jeffrey Williams" <jeff.williams3188(a)verizon.net> skrev i meddelandet > news:0B89C9D8-4143-42EF-86F7-1496010C7002(a)microsoft.com... >> If you are using mixed authentication mode and know the 'sa' password, >> log on with the 'sa' account and modify the accounts you need to be >> sysadmin. Personally, I would not add that property back in to the >> builtin\administrator account - I normally remove that privilege anyways. >> >> If you don't have 'sa' access - you need to shut down SQL Server and >> restart in single-user mode. Once started that way, you can login using >> DAC and reset account privileges. You can lookup the procedure in books >> online. >> >> Jeff >> >> "Tony Johansson" <johansson.andersson(a)telia.com> wrote in message >> news:Nkv0n.14279$U5.218013(a)newsb.telia.net... >>> Hello! >>> >>> I have now done a very silly thing. >>> >>> I have been playing around to get a better understanding how all this >>> works. >>> >>> I have right click and take properies on the builtin\administrator and >>> then select the server Roles and here I have >>> unchecked the sysadmin. >>> >>> This mean that I can't check this sysadmin for builtin\administrator any >>> more the errro message is >>> user does not have permission to perform this action. Is there any >>> workaround to fix this >>> >>> //Tony >>> > >
From: Tony Johansson on 5 Jan 2010 07:35 Can you describe step by step how I set the sysadmin server role back on BUILTIN\Administrator and not how I do that in general. I'm not so good at SQL Server. //Tony "Uri Dimant" <urid(a)iscar.co.il> skrev i meddelandet news:Ofs$4TejKHA.2188(a)TK2MSFTNGP04.phx.gbl... > Tony > The 'best practice' is that SQL Server runs under domain account and not > as Local Admin , but I am seeing lot of business that do the oppoiste:-) > > So sure , before uchecking the sysadmin you would have added an account > that sql server runs under then restart the service and then uncheck. > > Well as Jeffrey pointed , log in as sa in change it back > > > > > "Tony Johansson" <johansson.andersson(a)telia.com> wrote in message > news:Nkv0n.14279$U5.218013(a)newsb.telia.net... >> Hello! >> >> I have now done a very silly thing. >> >> I have been playing around to get a better understanding how all this >> works. >> >> I have right click and take properies on the builtin\administrator and >> then select the server Roles and here I have >> unchecked the sysadmin. >> >> This mean that I can't check this sysadmin for builtin\administrator any >> more the errro message is >> user does not have permission to perform this action. Is there any >> workaround to fix this >> >> //Tony >> > >
From: Tony Johansson on 5 Jan 2010 07:43 I use SQL Server Express 2005 At the top below object explorer in SQL Server Management Studio Express it says HEMPC\SQLEXPRESS (SQL Server 9.0.4053 - HEMPC\Tony) //Tony "Abba" <sql_help(a)aaa.com> skrev i meddelandet news:eqmesFfjKHA.5052(a)TK2MSFTNGP04.phx.gbl... > What version of SQLServer? > > "Tony Johansson" <johansson.andersson(a)telia.com> wrote in message > news:gnE0n.14285$U5.218151(a)newsb.telia.net... >> >> I have looked but haven't found any procedure that point out how I >> restart in single-user mode and >> once started that way, I can login using DAC and reset account >> privileges. >> >> Can you point out any site where I can find this kind of information. >> >> //Tony >> >> >> "Jeffrey Williams" <jeff.williams3188(a)verizon.net> skrev i meddelandet >> news:0B89C9D8-4143-42EF-86F7-1496010C7002(a)microsoft.com... >>> If you are using mixed authentication mode and know the 'sa' password, >>> log on with the 'sa' account and modify the accounts you need to be >>> sysadmin. Personally, I would not add that property back in to the >>> builtin\administrator account - I normally remove that privilege >>> anyways. >>> >>> If you don't have 'sa' access - you need to shut down SQL Server and >>> restart in single-user mode. Once started that way, you can login using >>> DAC and reset account privileges. You can lookup the procedure in books >>> online. >>> >>> Jeff >>> >>> "Tony Johansson" <johansson.andersson(a)telia.com> wrote in message >>> news:Nkv0n.14279$U5.218013(a)newsb.telia.net... >>>> Hello! >>>> >>>> I have now done a very silly thing. >>>> >>>> I have been playing around to get a better understanding how all this >>>> works. >>>> >>>> I have right click and take properies on the builtin\administrator and >>>> then select the server Roles and here I have >>>> unchecked the sysadmin. >>>> >>>> This mean that I can't check this sysadmin for builtin\administrator >>>> any more the errro message is >>>> user does not have permission to perform this action. Is there any >>>> workaround to fix this >>>> >>>> //Tony >>>> >> >> > >
First
|
Prev
|
Next
|
Last
Pages: 1 2 3 4 Prev: SQL Server 2000 on Win 2008 Next: How can aspnet get login rights |