Sunday, March 11, 2012

Change Windows Authentication to Mixed Mode

How do I Change Windows Authentication to Mixed Mode on SQL Server 2005
(Express)?On May 24, 9:09 pm, "Middletree" <middlet...@.hottttttttmail.com>
wrote:
> How do I Change Windows Authentication to Mixed Mode on SQL Server 2005
> (Express)?
I don't know express
In SSMS , go to SERVER , Right Click Properties ,
-> Security-> Server Authentication Select SQL Server and Windows
authentication
OR
USE [master]
GO
EXEC xp_instance_regwrite N'HKEY_LOCAL_MACHINE', N'Software\Microsoft
\MSSQLServer\MSSQLServer', N'LoginMode', REG_DWORD, 2
GO|||The first method worked. Thanks.

No comments:

Post a Comment