Mixed Mode | Varinder Sandhu

SQL Server – Change the Authentication Mode – Enable sa login

Varinder Sandhu SQL, SQL-Advanced, SQL-Tips and Tricks, Varinder Sandhu

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. Change the Authentication Mode In SQL Server Management Studio Object Explorer, right-click the server, and then click Properties. On the Security page, you will find “Server Authentication” section. In this section you can change your current Server Authentication Mode. In the SQL Server

SQL Server – Authentication Mode – Windows Mode and Mixed Mode

Varinder Sandhu SQL, SQL-Advanced, SQL-Tips and Tricks, Varinder Sandhu

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