Post has been published on Varinder Sandhu 's Blog
Post has been published on http://www.varindersandhu.in/2013/01/22/sql-server-authentication-mode-windows-mode-and-mixed-mode/
SQL Server - Authentication Mode ā Windows Mode and Mixed 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"; //-->
SQL Server ā Authentication Mode
During the installation of SQL Server you can choose the authentication mode for Database Instance. SQL Server support the two authentication mode as
Windows authentication mode:
Windows Authentication mode enables Windows Authentication and disables SQL Server Authentication. Ā Even if you choose Windows Authentication mode during SQL Server installation āsaā user is created but disable for SQL Server Authentication. But later we you can use āsaā user by enabling for SQL Server Authentication .Any window user can configure as system administrator for the SQL Server Instance.
Mixed authentication mode
Mixed modeĀ enables both Windows AuthenticationĀ andĀ SQL ServerĀ Authentication. If we choose the mixed modeĀ authentication then we have to provide the strong password for the āsaā user.
Windows Authentication is always available and cannot be disabled.
āsaā isĀ built-in SQL Server system administrator user.