Re: Login help
From: Allan Mitchell (allan@no-spam.SQLDTS.com)
- Next message: zens: "Replication snapshot failure"
- Previous message: John Bell: "Re: security in development environnement"
- In reply to: DS: "Login help"
- Next in thread: DS: "Re: Login help"
- Reply: DS: "Re: Login help"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
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
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 > >