Brendan Enrick's Blog

Daily Software Development.


Enabling Mixed Mode Authentication in SQL Server

by Brendan Enrick Thursday, April 3 2008 16:52

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.

SQLServerConnectWindow

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.

SQLServerContextMenu

Now that you've got the properties window open, select the Security section and choose the SQL Server and Windows Authentication Mode radio button.

SQLServerMixedModeAuth

After clicking OK, you will receive a message informing you of the need to restart the Server before the changes take affect.

SQLServerConfigMessage

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.

SQLServerRestartContext

Congratulations you're done.

Tagged as:
Comments are closed