MSSQL: Enable Mixed Mode Authentication

by on March 23, 2008 · 0 comments· LAST UPDATED December 23, 2008

in , ,

Q. How do I enable mixed mode authentication under MS-SQL running on Microsoft Windows server 2003?

A. You can easily enable mixed mode authentication as follows:

First, login to your server (use Remote Desktop Connection for remote boxes)

Click on Start > Programs > Microsoft SQL Server 2005
Select "SQL Server Management Studio Express" / "SQL Server Management Studio", depending on your version of SQL Server.

Next, enter the requested information:
=> Server Type: select "Database Engine".
=> Server Name: Select default displayed values
=> Authentication: select "Windows Authentication".
Click "Connect".

Right click the server name and select "Properties".

Click "Security".

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

Click "OK".

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

TwitterFacebookGoogle+PDF versionFound an error/typo on this page? Help us!

{ 0 comments… add one now }

Leave a Comment

Tagged as: , , , , , , , , , , , , , , , , ,

Previous Faq:

Next Faq: