ARTICLE

Enable and Rename SA account in SQL Server 2005/2008

Posted by Nipun Tomar in Articles | SQL Server 2012 on July 09, 2009

Tags: ALTER, ALTER LOGIN, sa DISABLE, sa WITH NAME, SQL Server 2005/2008

This Article shows How to Enable/Disable sa Account in SQL Server.

Tweet
10586
0

0

Reader Level: Beginner

Beginner

All the accounts in the Sql server 2005/2008 can be enabled, disabled and renamed(for security reasons) as below-

--To disable sa login--
ALTER LOGIN sa DISABLE
--To enable sa login--
ALTER LOGIN sa ENABLE
--To rename sa account--
ALTER LOGIN sa WITH NAME = [NewAccountName]

Login to add your contents and source code to this article

Related Articles

post comment

TOP LEADERS

TRENDING UP

Learn MVC (Model view controller) Step by Step in 7 days – Day 3 Learn C# Corner - Home Using Border Radius and Gradients in CSS3: Part I Learn C# Corner - Footer Learn .NET and C# in 60 Days Lab13(Day 5): - Classes and objects iPhone 5 First Look Samsung Galaxy Note Review WCF - Authentication and Authorization in Enterprise Architecting How to write a good article on C# Corner How to Display Data in ListBox From SQL Database in ASP.NET

Become a Sponsor

MOST LIKED ARTICLE

Learn .NET in 60 days – Part 1 (13 Labs) Working with ProgressBar in C# Resizable TextBox in ASP.NET using AjaxControlToolKit Word Processing with an Extended Rich Text Box Control Notepad in C#

PREMIUM SPONSORS

Introducing MaxV - one click. infinite control. Hyper-V Hosting from MaximumASP.

Finally – a virtual platform that delivers next-generation Windows Server 2008 Hyper-V virtualization technology from a managed hosting partner you can truly depend on. Visit www.maximumasp.com/max for a FREE 30 day trial. Hurry offer ends soon. Climb aboard the MaxV platform and take advantage of High Availability, Intelligent Monitoring, Recurrent Backups, and Scalability – with no hassle or hidden fees. As a managed hosting partner focused solely on Microsoft technologies since 2000, MaximumASP is uniquely qualified to provide the superior support that our business is built on. Unparalleled expertise with Microsoft technologies lead to working directly with Microsoft as first to offer IIS 7 and SQL 2008 betas in a hosted environment; partnering in the Go Live Program for Hyper-V; and product co-launches built on WS 2008 with Hyper-V technology.

ASP.NET 4 Hosting

Get 2 Months Free of ASP.NET Hosting for Only $4.95/month! Receive FREE MS SQL and MySQL Databases Including ASP.NET 4/3.5, MVC 3.0, Silverlight 4, Windows 2008/IIS 7.0 Plus FREE IIS 7 Modules. Host UNLIMITED ASP.NET Web Sites - Click Here!

LATEST JOBS

Applying for job Metro Style App Developer .NET Developer WPF or Silverlight exp Boston MA ASP .Net Developers Split Testing Designer .NET Developer Web Developer Application Engineer Expert .NET Developer Application Developer

View All Jobs |Post a New Job

Become a Sponsor

WHITEPAPERS AND BOOKS

Essentials of Capacity Planning: Microsoft SharePoint Server 2010 Chapter 15: Customizing the Display Chapter 9: OpenType Font Support Successfirmations: Think, Reveal, Receive SharePoint Designer 2010 Essentials Building Standalone Data-Driven Applications using SQL Server Compact 4.0 Programming XML with C# Reporting with Reports Viewer in Visual Studio 2005 Programming C# for Beginners Programming Windows Common Dialogs with Visual C# 2010