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

• Anonymous
  August 31, 2005
  I had been asked last week if you could rename the SA account.  I replied "No you can not, it's...

• Anonymous
  August 07, 2006
  PingBack from http://sqldb.sufx.net/?p=67

• Anonymous
  August 12, 2006
  Hi,
  
  Is possível enable [sys-admin] and use it?
  
  thx
  Nilton Pinheiro

• Anonymous
  October 17, 2007
  Attack on SQL Server 2005 SA account

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

• Anonymous
  September 09, 2008
  PingBack from http://hoursfunnywallpaper.cn/?p=5415

• Anonymous
  September 09, 2008
  PingBack from http://housesfunnywallpaper.cn/?p=4940

• Anonymous
  September 09, 2008
  PingBack from http://www.easycoded.com/upgrade-for-sql-server-2008-can-fail-if-you-have-renamed-the-sa-account/

• Anonymous
  January 22, 2009
  PingBack from http://www.hilpers.it/2534390-rinominare-login-sa-in-sql

• Anonymous
  June 16, 2009
  PingBack from http://fixmycrediteasily.info/story.php?id=468