How to drop builtin\administrators account from sql server
-
Hi there I want to drop 'builtin\administrators' from sql server with a SQL query or stored procedure. I logged in with sa user and i don't know how to drop administrators account. In fact i want to remove windows authentication security login. How can i do that? Thanx.
-
Hi there I want to drop 'builtin\administrators' from sql server with a SQL query or stored procedure. I logged in with sa user and i don't know how to drop administrators account. In fact i want to remove windows authentication security login. How can i do that? Thanx.
I'm pretty sure the authentication modes for SQL 2005 are 'Windows Authentication only' and 'Mixed mode' (both). There should only be a couple of built-in accounts - can you just remove their permissions in the management console?
Mark Churchill Director Dunn & Churchill
-
I'm pretty sure the authentication modes for SQL 2005 are 'Windows Authentication only' and 'Mixed mode' (both). There should only be a couple of built-in accounts - can you just remove their permissions in the management console?
Mark Churchill Director Dunn & Churchill
Yes . I can remove the login 'BUILTIN\Administrator' or other built-in accounts with management console but i can't remove it with SQL query . My problem is remove with sql query . How can I do this ?
DMASTER
-
Yes . I can remove the login 'BUILTIN\Administrator' or other built-in accounts with management console but i can't remove it with SQL query . My problem is remove with sql query . How can I do this ?
DMASTER