Friday 16 January 2015

How to enable mixed authentication in sql server

Login to SQL Server
Start SQL Server Management Studio
Enter the Server name and select Windows authentication.
Make sure you are logged in with administrator credentials.
Right click on the server name and select properties.
Go to Security and select SQL Server and Windows Authentication Mode.
Right click on the server name and select Restart to restart the SQL services.