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

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