"Marek Powichrowski" <marekp@telbank.pl> wrote in message
news:bv81ss$hnp$1@korweta.task.gda.pl...
> Hi all,
>
> I have the the problem with logging to MSDE using SQL-DMO interface. On
the
> W2K with LoginSecure=TRUE everything is OK (connect is made without any
> parameters)
>
> But when LoginSecure=FALSE (on Win 98)
>
> connect( 'instance_name', 'sa', 'sa_password' )
>
> then it returns error message :
>
> Login failed for user 'sa'. Reason : Not associated with a trusted SQL
>
> I install MSDE on Win 98 with parameters :
>
> INSTANCENAME='instance_name'
> SECURITYMODE=SQL
> SAPWD='sa_password'
>
> Server runs with given instance name.
>
> Who knows why I can not login to MSDE ?
>
> TIA,
>
> Marek Powichrowski
>
>
>

>
> The error is slightly strange, since it suggests MSDE is running in
Windows
> authentication mode, however that isn't supported on Windows 98. Can you
> connect to the MSDE instance locally using osql, for example?
>
> osql -S instance_name -U sa -P sa_password
>
> If you can connect like this, then the issue is probably somewhere in your
> SQLDMO code, and perhaps you could post the part which makes the
connection.
> If this doesn't work, then could you post the error message? And did you
> install the latest MSDE version, ie. SP3a?