Welcome to MSDN Blogs Sign in | Join | Help

SQL Server Engine Tips

Guidelines, Best Practices, TSQL and SQL Programming Tips & Tricks.
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];

 

Published Saturday, August 27, 2005 1:44 PM by SQL Server Engine Team

Comments

# Renaming SA in SQL 2005 @ Wednesday, August 31, 2005 10:58 AM

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

John Baker's WebLog

# SQL DB Collection ? Blog Archive » Renaming sa account in SQL Server 2005 @ Monday, August 07, 2006 10:12 AM

PingBack from http://sqldb.sufx.net/?p=67

SQL DB Collection ? Blog Archive » Renaming sa account in SQL Server 2005

# re: Renaming sa account in SQL Server 2005 @ Saturday, August 12, 2006 8:53 AM

Hi,

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

thx
Nilton Pinheiro

Nilton Pinheiro

# Attack on SQL Server 2005 SA account @ Wednesday, October 17, 2007 10:55 AM

Attack on SQL Server 2005 SA account

Nathan Westby

# Upgrade for SQL Server 2008 can fail if you have renamed the 'sa' account @ Tuesday, September 09, 2008 10:38 PM

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

PSS SQL Server Engineers

# car insurance » Upgrade for SQL Server 2008 can fail if you have renamed the ’sa’ account @ Tuesday, September 09, 2008 10:47 PM

PingBack from http://hoursfunnywallpaper.cn/?p=5415

car insurance » Upgrade for SQL Server 2008 can fail if you have renamed the ’sa’ account

# funny wallpaper » Upgrade for SQL Server 2008 can fail if you have renamed the ’sa’ account @ Tuesday, September 09, 2008 10:54 PM

PingBack from http://housesfunnywallpaper.cn/?p=4940

funny wallpaper » Upgrade for SQL Server 2008 can fail if you have renamed the ’sa’ account

# Upgrade for SQL Server 2008 can fail if you have renamed the ’sa’ account : EasyCoded @ Tuesday, September 09, 2008 11:00 PM

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

Upgrade for SQL Server 2008 can fail if you have renamed the ’sa’ account : EasyCoded

# Rinominare login SA in SQL 2000 | hilpers @ Friday, January 23, 2009 12:35 AM

PingBack from http://www.hilpers.it/2534390-rinominare-login-sa-in-sql

Rinominare login SA in SQL 2000 | hilpers

# SQL Server Engine Tips Renaming sa account in SQL Server 2005 | fix my credit @ Tuesday, June 16, 2009 9:39 PM

PingBack from http://fixmycrediteasily.info/story.php?id=468

SQL Server Engine Tips Renaming sa account in SQL Server 2005 | fix my credit

Anonymous comments are disabled
Page view tracker