Enable mixed mode authentication in MS SQL?

Enable mixed mode authentication in MS SQL?

Mixed mode authentication allows you to log into a SQL server using either your Windows VPS username and password or your SQL database username and password. When logged in using your Windows VPS username and password, you have access to all the databases on the server.

           1.       1.Log into your SQL server (Run SSMS)

           2.       Click Start, Programs, Microsoft SQL Server 2012/2008 r2 and select SQL Server  Management Studio Express or SQL Server Management Studio, depending on your version of SQL Server.

         3.      Enter the requested information:

• Server Type: select Database Engine
• Server Name: this field should be populated by default
• Authentication: select Windows Authentication

          4.       Right click the server name and select Properties.

           5.       Click Security,

         6.       Under Server authentication select SQL Server and Windows Authentication Mode.

         7.       Click OK.

         8.      Right click the server name and select Restart. Wait a few moments for the service to restart before proceeding.

Thanks & Regards

Srikanth Goud- Virtualization Administrator