Wednesday 29 April 2015

How to enable mixed authentication in SQL server?

How to enable mixed authentication in SQL server?

On the 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.


Now check it and mixed mode will be enabled.



No comments:

Post a Comment