sql server msde: My .NET application that connects to MSDE was running fine on a user's =
Win2000 PC, but now that he reinstalled he is getting the following =
error:

Error opening database connection: Login failed for user 'sa' from the =
..Net SqlClient Data Provider.



I have created a custom installation that uses the MSDE bootstrap loader =
to install MSDE and then run my database creation scripts. We've tried =
uninstalling and reinstalling this application/MSDE package, but we keep =
getting this error. I've verified the database service is starting.



My ADO.NET connection string looks like this (I turned off Integrated =
Security so users can install on Win98):



Integrated Security=3Dfalse;Persist Security Info=3DFalse;Initial =
Catalog=3DMobileMonitor;Data Source=3D(local)\PTAGIS;User =
ID=3Dsa;pwd=3D"xxxxxxx"

Any suggestions on what could be causing this authentication error on =
just this machine? The installation and application has worked fine on =

If I remember correctly, MSDE SP3A disables network support by default. =
Check to see if that's the problem (very likely if you're accessing =
remotely).

joe.
[quoted text, click to view]
My .NET application that connects to MSDE was running fine on a user's =
Win2000 PC, but now that he reinstalled he is getting the following =
error:

Error opening database connection: Login failed for user 'sa' from the =
..Net SqlClient Data Provider.



I have created a custom installation that uses the MSDE bootstrap =
loader to install MSDE and then run my database creation scripts. We've =
tried uninstalling and reinstalling this application/MSDE package, but =
we keep getting this error. I've verified the database service is =
starting.



My ADO.NET connection string looks like this (I turned off Integrated =
Security so users can install on Win98):



Integrated Security=3Dfalse;Persist Security Info=3DFalse;Initial =
Catalog=3DMobileMonitor;Data Source=3D(local)\PTAGIS;User =
ID=3Dsa;pwd=3D"xxxxxxx"

Any suggestions on what could be causing this authentication error on =
just this machine? The installation and application has worked fine on =

Thanks Joe,

I guess I'm confused...the connection to the database is local from my =
application and it was working with the previous installation (the MSDE =
wasn't upgraded just reinstalled). How is the disabling of the network =
associated with 'sa' password? Perhaps I should just use 'Integrated =
Security' and tell the people that want Win98 tough luck.

-John

[quoted text, click to view]
If I remember correctly, MSDE SP3A disables network support by default. =
Check to see if that's the problem (very likely if you're accessing =
remotely).

joe.
[quoted text, click to view]
My .NET application that connects to MSDE was running fine on a user's =
Win2000 PC, but now that he reinstalled he is getting the following =
error:

Error opening database connection: Login failed for user 'sa' from the =
..Net SqlClient Data Provider.

I have created a custom installation that uses the MSDE bootstrap loader =
to install MSDE and then run my database creation scripts. We've tried =
uninstalling and reinstalling this application/MSDE package, but we keep =
getting this error. I've verified the database service is starting.

My ADO.NET connection string looks like this (I turned off Integrated =
Security so users can install on Win98):

Integrated Security=3Dfalse;Persist Security Info=3DFalse;Initial =
Catalog=3DMobileMonitor;Data Source=3D(local)\PTAGIS;User =
ID=3Dsa;pwd=3D"xxxxxxx"
Any suggestions on what could be causing this authentication error on =
just this machine? The installation and application has worked fine on =

In message <O#AsmepGFHA.3916@TK2MSFTNGP12.phx.gbl>, John Tenney
<john@psmfc.org> writes
[quoted text, click to view]

The SP3 version of MSDE disables Network Protocols and set the Security
Mode to intergrated by default.

This sounds more like the Security Mode is not set to Mixed Mode and
hence it does not recognise the "sa" login. Its trying to login using
your Windows User ID.

--
Andrew D. Newbould E-Mail: newsgroups@NOSPAMzadsoft.com