MSDE permissions conflict in C# app
Posted on 2004-10-18
Hello All experts,
I have developed an application in C# which uses an MSDE database as its basis. I have developed an installation routine which installs the .net framework, MSDE database and finally the application. When I install the standalone application onto a machine with Win 2k, Win XP Home or Win XP Pro as the OS and then run the application, it runs fine.
However when I install the application on a WinME or Win98 machine and run the application I get the following error:
"Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection"
I checked my connection string which was initially as follows:
"data source=local host;integrated security=SSPI;database=Jaguar;persist security info=false;packet size=4096"
Then I entered the "Trusted Connection=yes"
The connection string then evolved to:
"data source=local host;Trusted Connection=yes;integrated security=SSPI;database=Jaguar;persist security info=false;packet size=4096"
but it still pops up with the same error message.
Why does it work on Win2k, WinXP and not on WinME? Do I have to manipulate a registry setting, do I need to set some extra parameters for MSDE during installation?
Can you experts please shed light on this situation?