Skip to main content
InSource Solutions

TN PT110 Enable SQL Server Mixed Mode After Install

  1. Last updated
  2. Save as PDF

insource logo large.jpg

 

Description

This article from InSource shows how to enable SQL Server Mixed Mode if it was not selected during installation.

 

  • Author: Mike Viteri
  • Published: 9/21/2015
  • Applies to: Microsoft SQL Server 

 

 

Details

Mixed Mode will have to be enabled in two places.

 

  • Enable the SA Account

 

Inside SQL Server Management Studio. Go Under Security->logins then SA Account. Right click on this account and go to properties. Click on status make sure login is set to enable. You should reset your SA password.

 

sql1.JPG

 

 

  •  Enable SQL Server Authentication

 

Next you will have to right click on your SQL Server in Management Studio. Select properties then choose security. Make sure SQL Server and Windows Authentication is selected.

 

 

sql2.JPG

 

Now restart your SQL Server instance or restart the computer and you can now login with your SA account.