Renaming sa account in SQL Server 2005


SQL Server 2005 introduces a revamped security model including users and schema separation & more granular grantable permissions. ALTER LOGIN statement in SQL Server 2005 allows you to disable the sa account and rename it. This is a good security measure to take on SQL Servers running in mixed authentication mode for example. The statements to rename and disable sa account is below:

 

ALTER LOGIN sa DISABLE;


ALTER LOGIN sa WITH NAME = [sys-admin];


 

Comments (10)

  1. I had been asked last week if you could rename the SA account.  I replied "No you can not, it’s…

  2. Hi,

    Is possível enable [sys-admin] and use it?

    thx

    Nilton Pinheiro

  3. Attack on SQL Server 2005 SA account

  4. Gail Shaw, a SQL MVP, presented me with a new issue for SQL Server 2008 I had not heard of before. It