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
Showing posts with label mode. Show all posts
Showing posts with label mode. Show all posts
Friday, February 24, 2012
Subscribe to:
Posts (Atom)