Re: Login help

From: Allan Mitchell (allan@no-spam.SQLDTS.com)
Date: 02/16/03 

From: "Allan Mitchell" <allan@no-spam.SQLDTS.com>
Date: Sun, 16 Feb 2003 11:07:43 -0000

So you are saying that you have nobody configured as a sysadmin except sa ?
What about the service accounts ?

You can go to

HKLM\Software\microsoft\MSSQLServer\MSSQLServer

and change the value of LoginMode to 2

providing of course you have permission onto that key

Not something I would normally do though. 

-- 
Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org
"DS" <Dan_Schwaner@Yahoo.Com> wrote in message
news:#h#kXHV1CHA.1180@TK2MSFTNGP12...
> I am using SQL 2000 Client SP3 on Win2k Pro SP3. I reconfigured mixed mode
> to Windows Integrated login mode without giving Windows/Admins group
> sufficient right. Now I cannot:
>
> 1. Login to add/remove SQL/Logins because all the admin roles belong to
"sa"
> account.
> 2. "sa" is sql/login, it cannot be used as Windows integrated.
> 3. Windows/Administrator cannot change login mode becaue it does not have
> sql/admin role.
>
> How can I get around this without reinstalling sql server ?
>
> tia
>
> Dan
>
>