I recently needed to enable Mixed Mode Authentication on a SQL Server instance, so I will demonstrate how to go about setting this up. It is a pretty easy process, but I figure I'll document it nicely here. Perhaps I will come back to this later to reference this. Who knows?
First you will need to connect to the SQL Server instance using SQL Server Management Studio.
Once you've connected to the SQL Server you will need to get to the properties window for the server. To do this you can right click on the SQL Server in the Object Explorer window and it will bring up a context menu.
Now that you've got the properties window open, select the Security section and choose the SQL Server and Windows Authentication Mode radio button.
After clicking OK, you will receive a message informing you of the need to restart the Server before the changes take affect.
Now just right click on the server in the object explorer again and select restart from the context menu and the services for the server will restart.
Congratulations you're done.
Comments