Renaming sa | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Renaming sa

I am wondering if there is any possible way to rename ‘sa’ to any other name say some unguessable name.
What you can do is drop the user sa and have a other name for it
Why?
Are you trying to prevent other admins for entering your server? If so, this might help you:http://support.microsoft.com/default.aspx?scid=kb;EN-US;263712

Frank Kalis
Microsoft SQL Server MVP
http://www.insidesql.de
Ich unterstütze PASS Deutschland e.V. http://www.sqlpass.de)

BOL clarifies:
Although sa is a built-in administrator login, do not use it routinely. Instead, make system administrators members of the sysadmin fixed server role, and have them log on using their own logins. Use sa only when there is no other way to log in to an instance of Microsoft® SQL Server™ (for example, when other system administrators are unavailable or have forgotten their passwords).
Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
]]>