MSDE on win98 / WinME

I have a lot of problems installing MSDE on a Win98 and WinME computer.
Most of the time SQL Server will not start.
If I am lucky and SQL Server will start I can not create a Database.
It will pop up a message 42000 18452.
Any ideas how to solve this?
hi Peter,
Peter Herijgers wrote:
> I have a lot of problems installing MSDE on a Win98 and WinME
> computer. Most of the time SQL Server will not start.
> If I am lucky and SQL Server will start I can not create a Database.
> It will pop up a message 42000 18452.
> Any ideas how to solve this?
as per
http://msdn.microsoft.com/library/de...rview_74vn.asp ,
MSDE should be supported on Win98/ME, but actually I never installed it on
that platform...
what is the "verbose" message you got along with the 42000 exception?
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.15.0 - DbaMgr ver 0.60.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||If have installed WinME on a brand new computer with all the latest updates.
Installing MSDE is going well but if I want to access the database the
following error appears:
SQL Server Error: SQL State: 42000, SQL Error Code: 18452
Login failed for user '(null)'. Reason: Not associated with a trusted SQL
Server connection.
MSDTC and SQL Server Agent are turned off.
SQL Server is turned on.
I installed MSDE with the following parameters:
[OPTIONS]
INSTANCENAME="TEST" SECURITYMODE=SQL SAPWD="QEW624gHHF6" /L*v C:/MSDELog.log
Thanks
"Andrea Montanari" wrote:

> hi Peter,
> Peter Herijgers wrote:
> as per
> http://msdn.microsoft.com/library/de...rview_74vn.asp ,
> MSDE should be supported on Win98/ME, but actually I never installed it on
> that platform...
> what is the "verbose" message you got along with the 42000 exception?
> --
> Andrea Montanari (Microsoft MVP - SQL Server)
> http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
> DbaMgr2k ver 0.15.0 - DbaMgr ver 0.60.0
> (my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
> interface)
> -- remove DMO to reply
>
>
|||BTW
The password for login on ME is different then the MSDE password.
I don't know if this would cause any problems.
"Peter Herijgers" wrote:
[vbcol=seagreen]
> If have installed WinME on a brand new computer with all the latest updates.
> Installing MSDE is going well but if I want to access the database the
> following error appears:
> SQL Server Error: SQL State: 42000, SQL Error Code: 18452
> Login failed for user '(null)'. Reason: Not associated with a trusted SQL
> Server connection.
> MSDTC and SQL Server Agent are turned off.
> SQL Server is turned on.
> I installed MSDE with the following parameters:
> [OPTIONS]
> INSTANCENAME="TEST" SECURITYMODE=SQL SAPWD="QEW624gHHF6" /L*v C:/MSDELog.log
> Thanks
>
> "Andrea Montanari" wrote:
|||hi Peter,
Peter Herijgers wrote:
> If have installed WinME on a brand new computer with all the latest
> updates. Installing MSDE is going well but if I want to access the
> database the following error appears:
> SQL Server Error: SQL State: 42000, SQL Error Code: 18452
> Login failed for user '(null)'. Reason: Not associated with a trusted
> SQL Server connection.
are you mixing up trusted connection with user defined credentials for
login?
how and with what tool are you trying to connect to the MSDE instance?
if you use oSql.exe, the command line tool provided with MSDE, you have 2
different ways to connect..
specifying a trusted WinNT connection,
c:\...\>osql.exe -E -S(Local)
or with a standard SQL Server authenticated connection,
c:\..\>osql.exe -Usa -Pyourpwd -S(Local)
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.15.0 - DbaMgr ver 0.60.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||hi Again,
BTW, can you please verify the mixed mode authentication is enabled?..
run regsvr32.exe, locate the registry "LoginMode" key as indicated in
http://support.microsoft.com/default...b;en-us;285097 and verify
it's value is 2
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.15.0 - DbaMgr ver 0.60.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||I recently installed quite a few MSDE (SP3) on laptops for one of my apps
(Win2K and WinXP SP2). I found that the SQL Security was not enabled in
spite if including "SECURITYMODE=SQL" in setup command. I did not spend time
to figure it out why. I simply went to Windows Registry to manually enable
SQL Security mode:
HKEY_LocalMachine->Software->Microsoft->MSSQLServer-MSSQLServer->LoginMode,
set it to 2.
This will enable SQL Security mode, which is used for Win9x & ME.
"Peter Herijgers" <PeterHerijgers@.discussions.microsoft.com> wrote in
message news:C9EFFF51-4EA8-4F58-9625-812852BAE099@.microsoft.com...[vbcol=seagreen]
> If have installed WinME on a brand new computer with all the latest
> updates.
> Installing MSDE is going well but if I want to access the database the
> following error appears:
> SQL Server Error: SQL State: 42000, SQL Error Code: 18452
> Login failed for user '(null)'. Reason: Not associated with a trusted SQL
> Server connection.
> MSDTC and SQL Server Agent are turned off.
> SQL Server is turned on.
> I installed MSDE with the following parameters:
> [OPTIONS]
> INSTANCENAME="TEST" SECURITYMODE=SQL SAPWD="QEW624gHHF6" /L*v
> C:/MSDELog.log
> Thanks
>
> "Andrea Montanari" wrote:
|||Maybe I have made a big mistake but it is running now.
On a WinXP machine I code the following (Delphi):
SQLConnection.Close;
SQLConnection.Params.Clear;
SQLConnection.Params.Add('DriverName=MSSQL');
SQLConnection.Params.Add('HostName=MachineName\TES T');
SQLConnection.Params.Add('DataBase=Test');
SQLConnection.Params.Add('User_Name=MyName');
SQLConnection.Params.Add('Password=WhatEver');
SQLConnection.Params.Add('BlobSize=-1');
SQLConnection.Params.Add('ErrorResourceFile=');
SQLConnection.Params.Add('LocaleCode=0000');
SQLConnection.Params.Add('MSSQL TransIsolation=ReadCommited');
SQLConnection.Params.Add('OS Authentication=True');
I have changed this into:
SQLConnection.Close;
SQLConnection.Params.Clear;
SQLConnection.Params.Add('DriverName=MSSQL');
SQLConnection.Params.Add('HostName=MachineName\TES T');
SQLConnection.Params.Add('DataBase=Test');
SQLConnection.Params.Add('User_Name=sa');
SQLConnection.Params.Add('Password=WhatEver');
SQLConnection.Params.Add('BlobSize=-1');
SQLConnection.Params.Add('ErrorResourceFile=');
SQLConnection.Params.Add('LocaleCode=0000');
SQLConnection.Params.Add('MSSQL TransIsolation=ReadCommited');
SQLConnection.Params.Add('OS Authentication=False');
Now it works very find.
It runs on both Win98 and WinXP.
Thanks.
"Norman Yuan" wrote:

> I recently installed quite a few MSDE (SP3) on laptops for one of my apps
> (Win2K and WinXP SP2). I found that the SQL Security was not enabled in
> spite if including "SECURITYMODE=SQL" in setup command. I did not spend time
> to figure it out why. I simply went to Windows Registry to manually enable
> SQL Security mode:
> HKEY_LocalMachine->Software->Microsoft->MSSQLServer-MSSQLServer->LoginMode,
> set it to 2.
> This will enable SQL Security mode, which is used for Win9x & ME.
> "Peter Herijgers" <PeterHerijgers@.discussions.microsoft.com> wrote in
> message news:C9EFFF51-4EA8-4F58-9625-812852BAE099@.microsoft.com...
>
>
sql