#sql server authentication

Microsoft SQL Server, a leading database management system, is critical in many businesses. As a result, users frequently need to connect to SQL Server databases and be authenticated before interacting with the data.  

This article explores SQL Server authentication, its different methods, and how authentication works in various scenarios. 

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.

Note:

Windows Authentication is always available and cannot be disabled.