October 21, 2011 at 3:40 am
DMarvez (10/19/2011)
So, we got a request to drop these two users from SQL Server as part of a corporate security effort.I've read the post on the BuiltIn\Administrator account but can't see to find anything on dropping SA if that's even possible.
I've renamed it on my test system and that's not a problem but attempts to drop it completely always fail. I've read that it belongs to DBO and as such, is linked to all databases and cannot be dropped.
Just wanted to check here to see if I'm off base with telling them that SA can't be dropped.
Are any of these instances clustered, if so do not remove builtin admins without first provisioning the cluster service account and the sql server service account into the SQL server instance.
Details at this link
If you already removed it and cant start the instance see my article at this link[/url]
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
Viewing post 16 (of 15 total)
You must be logged in to reply to this topic. Login to reply