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.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment