MSDE Error 18456

Hi,
Read a lot about the above mentioned error.
But I don't understand the solutions.
About the operating system I an a novice too.
Installed MSDE a few times before the server Icon with the green errow apered.
Deinstalled MSDE 2000 a few times and removed also the directories.
Some in this newsgroup mentioned that there are entries in the registry that
should be deleted. But about the registry I am a novice.
Is there another solution to make a clean install.
Henk
hi Henk,
Henk wrote:
> Hi,
> Read a lot about the above mentioned error.
> But I don't understand the solutions.
> About the operating system I an a novice too.
> Installed MSDE a few times before the server Icon with the green
> errow apered. Deinstalled MSDE 2000 a few times and removed also the
> directories.
> Some in this newsgroup mentioned that there are entries in the
> registry that should be deleted. But about the registry I am a novice.
> Is there another solution to make a clean install.
about the folders and registry entries to be deleted, you can have a look at
http://support.microsoft.com/default...EN-US;Q290991, which
completely remove an MSDE instance from a pc but for the presence orphaned
Windows Installer registry entries.. for the latter you have to use
MsiZap.exe, part of the Windows Installer SDK, as indicated in
http://support.microsoft.com/default...b;en-us;320873
unfortunately there's no other "manual" method to clean a system..
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.12.0 - DbaMgr ver 0.58.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||"Andrea Montanari" schreef:
Knip
Thank you Andrea,
Your suggestion helped me a lot.
But I can't connect to the database.
I like to connect a database with Visual basic.net (standard) trhough a
sql data adaptor,wich invokes a wizard.
I choose New. connection.
Servername=PC_name
Login = Username
Passw = Userlogin passw
The next error appeared.
Login Failed for user.
What I am doing wrong.
Sorry but I am a novice and a little bit slow in understanding.
Henk.
|||hi Henk,
Henk wrote:
> But I can't connect to the database.
> I like to connect a database with Visual basic.net (standard) trhough
> a sql data adaptor,wich invokes a wizard.
> I choose New. connection.
> Servername=PC_name
> Login = Username
> Passw = Userlogin passw
> The next error appeared.
> Login Failed for user.
> What I am doing wrong.
> Sorry but I am a novice and a little bit slow in understanding.
i hope the exception raised continue with " .. not associated with a trusted
SQL Server connection"
if this is the case you have to understand that MSDE installs by default on
WinNT platform enabling only trusted authenticated connections..
you can modify this behaviour both at install time, providing the
SECURITYMODE=SQL parameter to the setup.exe MSDE boostrap installer, or
later, at run-time, accessing the Windows registry and modifying the
HKLM\SOFTWARE\Microsoft\MSSQLServer\MSSQLServer
LoginMode=2
for a default MSDE instance, or
HKLM\SOFTWARE\Microsoft\Microsoft SQL Server\InstanceName\MSSQLServer
LoginMode=2
for a named instance...
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.12.0 - DbaMgr ver 0.58.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||"Andrea Montanari" schreef:

> hi Henk,
> Henk wrote:
> i hope the exception raised continue with " .. not associated with a trusted
> SQL Server connection"
> if this is the case you have to understand that MSDE installs by default on
> WinNT platform enabling only trusted authenticated connections..
> you can modify this behaviour both at install time, providing the
> SECURITYMODE=SQL parameter to the setup.exe MSDE boostrap installer, or
> later, at run-time, accessing the Windows registry and modifying the
> HKLM\SOFTWARE\Microsoft\MSSQLServer\MSSQLServer
> LoginMode=2
> for a default MSDE instance, or
> HKLM\SOFTWARE\Microsoft\Microsoft SQL Server\InstanceName\MSSQLServer
> LoginMode=2
> for a named instance...
> --
> Andrea Montanari (Microsoft MVP - SQL Server)
> http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
> DbaMgr2k ver 0.12.0 - DbaMgr ver 0.58.0
> (my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
> interface)
> -- remove DMO to reply
>
>Thanks for your quick reply.
I am not used to change any thing in the registry.
I found the next entrys.
Defaultlogin Reg_SZ guest
Loginmode Reg_Dword 0X00000000(0)
Should I Change 0X00000000(0) into 2
But during setup I gave the next parameter in: SecurityMode=SQL
Henk.
|||"Henk" schreef:

>
> "Andrea Montanari" schreef:
>
> I am not used to change any thing in the registry.
> I found the next entrys.
> Defaultlogin Reg_SZ guest
> Loginmode Reg_Dword 0X00000000(0)
> Should I Change 0X00000000(0) into 2
> But during setup I gave the next parameter in: SecurityMode=SQL
> Henk.
>
I tried the above mentioned settings.
But nothing worked.
Tried the next thing.
Removed MSDE2000 through
Start-Config-Software-MicrosoftSQLMSDe
Removed
Restart
Manually removed Map Microsoft SQL Server
within map MSSQl
Map-Log
New install MSDE200
Installed MSDERelA
setup SAPWD=Sapassword SecurityMode=SQL
Restart
Server Runs
Registery check
Loginmode=0
DefaultLogin = guest.
Manually Loginmode=2 changed
Tried again in VB.net
Login failed for user.
I tried everything but nothing works.
Henk
|||hi,
Henk wrote:
> I tried the above mentioned settings.
> But nothing worked.
> Tried the next thing.
> Removed MSDE2000 through
> Start-Config-Software-MicrosoftSQLMSDe
> Removed
> Restart
> Manually removed Map Microsoft SQL Server
> within map MSSQl
> Map-Log
> New install MSDE200
> Installed MSDERelA
> setup SAPWD=Sapassword SecurityMode=SQL
> Restart
> Server Runs
> Registery check
> Loginmode=0
> DefaultLogin = guest.
> Manually Loginmode=2 changed
> Tried again in VB.net
> Login failed for user.
> I tried everything but nothing works.
first... try SECURITYMODE=SQL ... perhaps it's case sensitive.. never
tried mixed case...
then... if you modify the registry try stopping and restarting the server...
then.. can you please repeat the exception you are prompted with?
thank you
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.12.0 - DbaMgr ver 0.58.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||"Andrea Montanari" schreef:

> hi,
> Henk wrote:
> first... try SECURITYMODE=SQL ... perhaps it's case sensitive.. never
> tried mixed case...
> then... if you modify the registry try stopping and restarting the server...
> then.. can you please repeat the exception you are prompted with?
> thank you
> --
> Andrea Montanari (Microsoft MVP - SQL Server)
> http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
> DbaMgr2k ver 0.12.0 - DbaMgr ver 0.58.0
> (my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
> interface)
> -- remove DMO to reply
>
Many thanks again for answering my questions.
But none of the answers solved the question.
But after all it works.
What I have done is the following.
Deinstalled MSDE.
Removed everything with SQL from program files and from the registery.
Dit a registery cleanup, with RegClean.
And after all defragmented my harddisk.
After that I installed MSDE and started to ad a sqladapter and everything
works.
I scrolled through the started services and there was one thing that seemed
to be different, the SQLServerAgent was automaticly started.
Till now I don't know what i dit wrong and that is a shame, but it works.
Thanks again for answering.
Henk

>