newbie and MSDE authentication

[Dan]

I have a c# app accessing some data in a workstation via MSDE 2000; when
executing my application under systems with WinXP I can connect to my
database using integrated security (integrated security=SSPI in connection
string), but when I try to execute the same application under a WinME
machine with MSDE 2000 installed, I get the error:

"Login failed for user '(null)'. Reason: not associated with a trusted
SQL server connection"

(the WinME user logs onto the system with its user name and password, as
WinXP users do). How can I solve this configuration issue? Should I change
the MSDE configuration (how? there is no graphical UI for MSDE...), or
modify my connection string? The full connection string I'm using now looks
like:

"data source=TheServer;initial catalog=TheCatalog;integrated
security=SSPI;persist security info=False;packet size=4096"

Thanx to all!

 

[Miha Markic]

Hi Dan,

Do you have a workgroup or domain?

 

[Dan]

Thanks for your reply! All the machines in my development environment are
part of a small workgroup; anyway, for development purposes each workstation
has its "own" MSDE server and does not connect to servers of other machines
in the group; all the machines use the "(local)" server.

 

[Miha Markic]

Hi Dan,

You should have on the server machine a same local account as on the client
machine (matching user name and password) if you use integrated security.

 

[Kevin Yu [MSFT]]

Hi Dan,

I think you have to use the Mixed mode instead of Windows authentication.
Because in a workgroup, the credential in a local computer cannot be passed
to the other computer. The workaround is to use Mixed mode or put them
computers into a domain.

Kevin Yu
=======
"This posting is provided "AS IS" with no warranties, and confers no
rights."