Support Center
Knowledgebase Contact Support
Search our knowledgebase

How to enable mixed authentication in sql server

Last updated on December 02 2014
  1. On the SQL Server start SQL Server Management Studio


     
  2. Enter the Server name and select Windows authentication.
    Make sure you are logged in with administrator credentials.


     
  3. Right click on the server name and select properties


     
  4. Go to Security and select SQL Server and Windows Authentication Mode.


     
  5. Right click on the server name and select Restart to restart the SQL services.