How can I disable or rename SA account in SQL Server 2005?

Next>>         SQL Server tutorial  

SQL Server - disable or rename SA account in SQL Server 2005 - Feb 27, 2010 at 11:50 AM by Shuchi Gauri

How can I disable or rename SA account in SQL Server 2005?

ALTER command enables us to disable/rename SA account.
ALTER LOGIN sa DISABLE;
ALTER LOGIN sa WITH NAME = [sys-admin];

SQL Server - disable or rename SA account in SQL Server 2005 - May 05, 2009 at 22:00 PM by Rajmeet Ghai

How can I disable or rename SA account in SQL Server 2005?

SA account in SQL server can be renamed or disabled using ALTER LOGIN command.

ALTERLOGINsa DISABLE; --to disable

ALTERLOGINsa WITHNAME=[Admin-Sys]; -- to rename to a different name

SQL Server - disable or rename SA account in SQL Server 2005 - June 21, 2009 at 09:00 AM by Amit Satpute

SQL Server 2005 has granular grantable permissions.
Its ALTER LOGIN statement can be used to disable the SA account and rename it.

The statements to rename and disable sa account is below:
ALTER LOGIN sa DISABLE;
ALTER LOGIN sa WITH NAME = [sys-admin];

Next>>

Also read

What are the Authentication Modes in SQL Server?

SQL Server supports two security (authentication) modes: Windows Authentication and Mixed mode ............

SQL Profiler

What are the tasks performed by SQL Profiler?
How can you use the SQL Profiler to ensure database security?
How can you reduce the amount of data collected by a trace?
What is SQL Profiler?
When do you use SQL Profiler?............

What security features are available for stored procedures?

Answer - Database users can have permission to execute a stored procedure without being......

Describe in brief authentication modes in SQL server.

Answer - This is the default and recommended security mode. In this mode, access to SQL server is controlled by Windows NT.....

SQL Server 2005 Analysis Services

What is SQL Server 2005 Analysis Services (SSAS)? What are the new features with SQL Server 2005 Analysis Services (SSAS)? What are SQL Server Analysis Services cubes? Explain the purpose of synchronization feature provided in Analysis Services 2005. Explain the new features of SQL Server 2005 Analysis Services (SSAS)...........