IT-Stuffs

 Enabling  MS SQL Server to Mixed Mode Authentication

 To enable mixed mode Authentication in Microsoft SQL Server please follow the steps below.

       To change security authentication mode to mixed mode
             Step 1: Open SQL Server Management Studio and login with Windows Authentication.
                                           


             Step 1:  In SQL Server Management Studio Object Explorer, right-click the server, and then 
                           click Properties.                                       
 
              Step 2: On the Security page, under Server authentication, select SQL Server and Windows
                           Authentication mode, and then click OK.
                                       

              Step 3: In the SQL Server Management Studio dialog box, click OK to acknowledge the
                           requirement to restart SQL Server.



        To Enable the SA Login by using Management Studio

              Step 1 :In Object Explorer, expand Security, expand Logins, right-click  Sa, and then click
                          Properties.

                                               
              Step 2: On the General page, create and confirm a new highly secure password for the Sa
                           login.
                                               
              Step 3: On the Status page, in the Login section, click Enabled, and then click OK.
                                           
                   Now your SQL Server Authentication is enabled and you are able to login with the Sa
                   and password which newly created.