I have now probably done a very silly thing
in [Programming SQL]
|
From: Tony Johansson on 6 Jan 2010 07:27 Many many many thanks Jeffrey Williams(I give you a gold medal) I followed the document that you passed in the mail and now I have granted the the relevant user back to the sysadmin server role. It was just enough to follow the document below. I was easy and very good explained so it was just to follow what it said and then it worked. http://blogs.msdn.com/raulga/archive/2007/07/12/disaster-recovery-what-to-do-when-the-sa-account-password-is-lost-in-sql-server-2005.aspx One question I how did you manage to find such an execllent document ? I have been looking for such a document but haven't find any. //Tony "Jeffrey Williams" <jeff.williams3188(a)verizon.net> skrev i meddelandet news:DDD721FA-6CC3-4C2F-ABE5-490ABBF3386E(a)microsoft.com... > See these entries for instructions on how to enable DAC in SQL Server > Express: > > http://blogs.msdn.com/sqlexpress/archive/2005/09/08/462609.aspx > http://msdn.microsoft.com/en-us/library/ms189595(SQL.90).aspx > http://blogs.msdn.com/raulga/archive/2007/07/12/disaster-recovery-what-to-do-when-the-sa-account-password-is-lost-in-sql-server-2005.aspx > > If you review these, you should be able to get this fixed. > > Jeff > > "Tony Johansson" <johansson.andersson(a)telia.com> wrote in message > news:axG0n.14289$U5.218132(a)newsb.telia.net... >> The sa account is disabled because there is a red arrow poining down on >> the >> sa icon in the Logins section. >> So if I try this command >> alter login sa enable >> I get this error message >> Msg 15151, Level 16, State 1, Line 1 >> Cannot alter the login 'sa', because it does not exist or you do not have >> permission >> >> So is it any other way to enable the sa account so I can >> use it to set sysadmin on the builtin\administrator >> >> //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: Jeffrey Williams on 6 Jan 2010 21:10 I googled it - but, I already knew what I was searching for which is 99% of the problem. I can't recall right now what I used for the search, but it was along the lines of: sql server 2005 express reset sa password "Tony Johansson" <johansson.andersson(a)telia.com> wrote in message news:Wk%0n.14322$U5.218568(a)newsb.telia.net... > Many many many thanks Jeffrey Williams(I give you a gold medal) I followed > the document that you passed in the mail and now I have granted the the > relevant user back to the sysadmin server role. > It was just enough to follow the document below. I was easy and very good > explained so it was just to follow what it said > and then it worked. > http://blogs.msdn.com/raulga/archive/2007/07/12/disaster-recovery-what-to-do-when-the-sa-account-password-is-lost-in-sql-server-2005.aspx > > One question I how did you manage to find such an execllent document ? > I have been looking for such a document but haven't find any. > > > //Tony > > "Jeffrey Williams" <jeff.williams3188(a)verizon.net> skrev i meddelandet > news:DDD721FA-6CC3-4C2F-ABE5-490ABBF3386E(a)microsoft.com... >> See these entries for instructions on how to enable DAC in SQL Server >> Express: >> >> http://blogs.msdn.com/sqlexpress/archive/2005/09/08/462609.aspx >> http://msdn.microsoft.com/en-us/library/ms189595(SQL.90).aspx >> http://blogs.msdn.com/raulga/archive/2007/07/12/disaster-recovery-what-to-do-when-the-sa-account-password-is-lost-in-sql-server-2005.aspx >> >> If you review these, you should be able to get this fixed. >> >> Jeff >> >> "Tony Johansson" <johansson.andersson(a)telia.com> wrote in message >> news:axG0n.14289$U5.218132(a)newsb.telia.net... >>> The sa account is disabled because there is a red arrow poining down on >>> the >>> sa icon in the Logins section. >>> So if I try this command >>> alter login sa enable >>> I get this error message >>> Msg 15151, Level 16, State 1, Line 1 >>> Cannot alter the login 'sa', because it does not exist or you do not >>> have >>> permission >>> >>> So is it any other way to enable the sa account so I can >>> use it to set sysadmin on the builtin\administrator >>> >>> //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 >>>>> >>>> >>>> >>> >>> > >
First
|
Prev
|
Pages: 1 2 3 4 Prev: SQL Server 2000 on Win 2008 Next: How can aspnet get login rights |