SEO

#1 (**permalink**) 02-28-2008, 07:44 PM

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

#2 (**permalink**) 02-28-2008, 07:45 PM

"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?

Simon

#3 (**permalink**) 02-28-2008, 07:45 PM

>
> 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?

Cause of error was setting LoginSecure to TRUE for the connection made on
the Win 98. When I change LoginSecure to FALSE then connection ends
succesfully (for proper server name user name and password) . So I can
create database using script generated by Enterprise Manager from my
computer and can atatch existing database to MSDE without Enterprise Manager
in the easy way (few lines of code).

Thanks for your support.

Marek Powichrowski

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SEO

Login to MSDE on Win 98