TN PT110 Enable SQL Server Mixed Mode After Install

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.

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