Microsoft SQL server (MSSQL) change Server Authentication

Microsoft SQL server MSSQL 
(all the versions) gives 2 modes of of authentication: Windows Authentication mode or SQL Server and Windows Authentication mode (mixed). While in the installation you can chose which method you want to use, and later on you can change this using Microsoft Management Studio


  1. Open Microsoft Management Studio
  2. Connect to the Database
  3. Right Click on the Database and select Properties
    management studio database properties
  4. Open the Security tab
  5. Select the method you want
    SQL server properties window
  6. Restart the Database. if you don’t do this step the changes with not take effect

it helped you ? share it to help others

Leave a Reply