How to activate Mixed Mode (SECURITYMODE=SQL) after installation

Hi,
is there a way to active Mixed Mode Authentication without reinstalling
MSDE?
Thanks,
mm
As in Microsoft Knowledge Base Article - 285097
To set this key to mixed-mode, follow these steps:
1.. Stop SQL Server and all related services, such as SQLAgent, from the
Services control panel.
2.. Click Start, click Run, type regedt32, and then click OK.
3.. Find the HKEY_LOCAL_MACHINE window on the local computer.
4.. Navigate to the following registry key for the default instance:
HKEY_LOCAL_MACHINE\Software\Microsoft\MSSqlserver\ MSSqlServer
5.. Navigate to the following registry key for a named instance:
HKLM\Software\Microsoft\Microsoft SQL Server\Instance
Name\MSSQLServer\LoginMode
6.. On the right-hand pane, find the value LoginMode and double-click it.
7.. In the DWORD Editor window, set the value to 0 or 2. Also, make sure
that the Hex radio button is selected.
8.. Click OK.
Regards,
Jeyakumar
"Michael Mller" <alligator081067@.yahoo.de> wrote in message
news:c4ggt0$2fca9f$1@.ID-93095.news.uni-berlin.de...
> Hi,
> is there a way to active Mixed Mode Authentication without reinstalling
> MSDE?
> Thanks,
> mm
>
|||hi Michael,
"Michael Mller" <alligator081067@.yahoo.de> ha scritto nel messaggio
news:c4ggt0$2fca9f$1@.ID-93095.news.uni-berlin.de...
> Hi,
> is there a way to active Mixed Mode Authentication without reinstalling
> MSDE?
>
please have a look at
http://support.microsoft.com/default...b;en-us;285097 , which
provides info on how to hack the window registry to change authentication
mode..
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.7.0 - DbaMgr ver 0.53.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||Hi Andrea & Jeyakumar,

> please have a look at
> http://support.microsoft.com/default...b;en-us;285097 , which
> provides info on how to hack the window registry to change authentication
> mode..
Thanks for your help. I've found that this solution helped other people, but
it sounds mad, it doesnt work for my MSDE SP3 installation.
I have changed the registry key as described, stopped and restarted the
MSSQLSERVER service, but i still can't connect with SQL Server
authentication.
I even have reinstalled MSDE with the SECURITYMODE=SQL option, but no
success. :-(
If I use MS Products like ASP.NET WebMatrix or Access with
windows-intregrated authorization, no problem.
But when I explicitly try to connect with SQL server authentication, the
following message appears:
Error -2147467259
[DBNETLIB][ConnectionOpen (Connect()).]SQL Server existiert nicht oder
Zugriff verweigert.(SQL connection does not exist or access refused.)
Provider=sqloledb;Data Source=edvserver;Network Library=dbmssocn;User
Id=sa;Password=;
Another tool with the same access problem is myLittleAdmin
(http://intranetserver/mla_sql_lite/default.asp).
I'm sure that the sa password is right.
This error appears in WebMatrix too, if i try to use SQL Authentication.
Any further idea?
Bye,
mm