Post has been published on Varinder Sandhu 's Blog
Post has been published on http://www.varindersandhu.in/2013/01/25/sql-server-change-the-authentication-mode-enable-sa-login/
SQL Server - Change the Authentication Mode – Enable sa login
During the installation of SQL Server if you choose the windows authentication mode and sa login is disabled. With the help of following steps you can change the authentication mode from windows to SQL Server authentication mode.
<!-- google_ad_client = "pub-2404605494811633"; google_alternate_color = "FFFFFF"; google_ad_width = 468; google_ad_height = 60; google_ad_format = "468x60_as"; google_ad_type = "text_image"; google_ad_channel =""; google_color_border = "FFFFFF"; google_color_link = "0000FF"; google_color_bg = "FFFFFF"; google_color_text = "000000"; google_color_url = "008000"; google_ui_features = "rc:6"; //-->
Change the Authentication Mode
In SQL Server Management Studio Object Explorer, right-click the server, and then click Properties.
SQL Server – Change the Authentication Mode – Enable sa login
On the Security page, you will find “Server Authentication” section. In this section you can change your current Server Authentication Mode.
SQL Server – Change the Authentication Mode – Enable sa login
In the SQL Server Management Studio dialog box, click OK, to acknowledge the need to restart SQL Server.
SQL Server – Change the Authentication Mode – Enable sa login
Enable sa login using Management Studio
In Object Explorer, expand Security, expand Logins, right-click sa, and then click Properties.
On the General page, you may have to create and confirm a password for the sa login.
SQL Server – Change the Authentication Mode – Enable sa login
On the Status page, in the Login section, click Enabled, and then click OK.
SQL Server – Change the Authentication Mode – Enable sa login
If you have any question/suggestion, please share as comment.