Skip to main content
InSource KnowledgeCenter

TN PT110 Enable SQL Server Mixed Mode After Install

insource logo large.jpg



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 




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.





  •  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.





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