Prev: SQL Server 2000 on Win 2008
Next: How can aspnet get login rights
From: Tony Johansson on 5 Jan 2010 07:47
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: Uri Dimant on 5 Jan 2010 08:15
Tony
Is it stand alone computer?If SQL logins are disabled then very sad, you
just lock yourself out of the SQL installation.







"Tony Johansson" <johansson.andersson(a)telia.com> wrote in message
news:7mG0n.14287$U5.218066(a)newsb.telia.net...
> 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 08:43
I can login using windows security and use SQL Server Management Studio
Express from my windows account Tony.
I'm an administrator on my computer. This computer is not part of any
network.

I don't know what you mean by saying " If SQL login are disabled that very
sad, you
just lock yourself out of the SQL installation."
The only thing I have done which I have mentionen in my
provious mail it to uncheck the sysadmin server role for the following two
users
BUILTIN\Users
BUILTIN\administator

As I mentioned my sa account is also disabled.

I just want to set back my sysadmin server role on my two account. Is that
possible ?
BUILDIN\Users
BUILTIN}Administrator


//Tony



"Uri Dimant" <urid(a)iscar.co.il> skrev i meddelandet
news:eWj01jgjKHA.1648(a)TK2MSFTNGP05.phx.gbl...
> Tony
> Is it stand alone computer?If SQL logins are disabled then very sad, you
> just lock yourself out of the SQL installation.
>
>
>
>
>
>
>
> "Tony Johansson" <johansson.andersson(a)telia.com> wrote in message
> news:7mG0n.14287$U5.218066(a)newsb.telia.net...
>> 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: Uri Dimant on 5 Jan 2010 09:10
Tony
Well, so if you are an admin and can login , go just the login properties
and check sysadmin account for BuiltIn Admin

Am I missing something?


"Tony Johansson" <johansson.andersson(a)telia.com> wrote in message
news:4mH0n.14290$U5.217942(a)newsb.telia.net...
>I can login using windows security and use SQL Server Management Studio
>Express from my windows account Tony.
> I'm an administrator on my computer. This computer is not part of any
> network.
>
> I don't know what you mean by saying " If SQL login are disabled that very
> sad, you
> just lock yourself out of the SQL installation."
> The only thing I have done which I have mentionen in my
> provious mail it to uncheck the sysadmin server role for the following two
> users
> BUILTIN\Users
> BUILTIN\administator
>
> As I mentioned my sa account is also disabled.
>
> I just want to set back my sysadmin server role on my two account. Is
> that possible ?
> BUILDIN\Users
> BUILTIN}Administrator
>
>
> //Tony
>
>
>
> "Uri Dimant" <urid(a)iscar.co.il> skrev i meddelandet
> news:eWj01jgjKHA.1648(a)TK2MSFTNGP05.phx.gbl...
>> Tony
>> Is it stand alone computer?If SQL logins are disabled then very sad, you
>> just lock yourself out of the SQL installation.
>>
>>
>>
>>
>>
>>
>>
>> "Tony Johansson" <johansson.andersson(a)telia.com> wrote in message
>> news:7mG0n.14287$U5.218066(a)newsb.telia.net...
>>> 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: Jeffrey Williams on 5 Jan 2010 21:30
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  |  Next  |  Last
Pages: 1 2 3 4
Prev: SQL Server 2000 on Win 2008
Next: How can aspnet get login rights