Groups | Blog | Home
all groups > sql server new users > may 2007 >

sql server new users : Change Windows authentication to Mixed mode


Middletree
5/24/2007 3:32:57 PM
How do I Change Windows Authentication to Mixed Mode on SQL Server 2005
(Express)?

Rick Byham, (MSFT)
5/25/2007 1:43:45 PM
The supported method is to use SQL Server Management Studio Express.
Download it from the web at
http://www.microsoft.com/downloads/details.aspx?familyid=C243A5AE-4BD1-4E3D-94B8-5A0F62BF7796&displaylang=en
1. Then connect to your server.
2. In Object Explorer, right-click the server, and then click Properties.
3. On the Security page, select SQL Server and Windows Authentication mode.
4. Restart the SQL Server service.
--
Rick Byham (MSFT)
This posting is provided "AS IS" with no warranties, and confers no rights.

[quoted text, click to view]
AddThis Social Bookmark Button