SQL Express 2005 SP3 and SQL Authentication?

[Neil W.]

Does anyone know of a way to apply SQL Express 2005 SP3 using SQL
Authentication.

Many developers ship their Express-based applications using SQL
Authentication.

[Russell Fields]

Neil,

If I understand you, you want SQL Express 2005 to be using both Windows and
SQL Server authentication. You should be able to configure that at install
time. The command to set the mode is:

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

FWIW,
RLF

Post by Neil W.
Does anyone know of a way to apply SQL Express 2005 SP3 using SQL
Authentication.
Many developers ship their Express-based applications using SQL
Authentication.

[Russell Fields]

And the SQL Server service needs to be stopped and restarted before it takes
effect.

RLF

Post by Russell Fields
Neil,
If I understand you, you want SQL Express 2005 to be using both Windows
and SQL Server authentication. You should be able to configure that at
USE [master]
GO
EXEC xp_instance_regwrite N'HKEY_LOCAL_MACHINE',
N'Software\Microsoft\MSSQLServer\MSSQLServer', N'LoginMode', REG_DWORD, 2
GO
FWIW,
RLF

Post by Neil W.
Does anyone know of a way to apply SQL Express 2005 SP3 using SQL
Authentication.
Many developers ship their Express-based applications using SQL
Authentication.