SQL 2005 Change Authentication Mode?

[CatchTwentyTwo]

Hello all,

We have SQL 2005 Developer Edition installed on a computer. When we initially installed it, we set it up for Windows Authentication. We now found that we need it to be Mixed Mode Authentication. Is there a way to change it without reinstalling?

Thanks!

 

[bborissov]

USE [master]
GO
EXEC xp_instance_regwrite N'HKEY_LOCAL_MACHINE', N'Software\Microsoft\MSSQLServer\MSSQLServer', N'LoginMode', REG_DWORD, 2
GO

The server should restart.

Borislav Borissov
VFP9 SP2, SQL Server 2000/2005.
Microsoft MVP VFP