Login help
From: DS (Dan_Schwaner@Yahoo.Com)
Date: 02/16/03
- Next message: Sylvain: "security in development environnement"
- Previous message: Jasper Smith: "Re: Problem Updating View after running sp3"
- Next in thread: Allan Mitchell: "Re: Login help"
- Reply: Allan Mitchell: "Re: Login help"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
From: "DS" <Dan_Schwaner@Yahoo.Com> Date: Sat, 15 Feb 2003 19:20:43 -0500
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
- Next message: Sylvain: "security in development environnement"
- Previous message: Jasper Smith: "Re: Problem Updating View after running sp3"
- Next in thread: Allan Mitchell: "Re: Login help"
- Reply: Allan Mitchell: "Re: Login help"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]