.NET Client connecting to MSDE for the first time

Our app's connection string at most (currently all) client sites points to
Sql Server 7 or 2000 on a seperate machine.
We have one small client who is running MSDE. We tried to bring them up
today.
I cannot get a connection to the MSDE. I keep getting
"System.Data.SqlClient.SqlException: SQL Server does not exist or access
denied."
I removed user id and password and set Integrated Security to True in the
connection string.
Our existing FoxPro app has no problems seeing and using MSDE, the .Net
Client cannot. The MSDE is running on the same machine as the .NET client
and the existing FoxPro application.
The FoxPro app uses an ODBC connection which works.
I googled this and I am not coming up with anything.
Any suggestions?
hi Greg,
Greg Robinson wrote:
> "System.Data.SqlClient.SqlException: SQL Server does not exist or
> access denied."
>
this kind of exception is a generic MDAC raised exception
please have a look at
http://support.microsoft.com/default...06&Product=sql
to see further suggestions..
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.14.0 - DbaMgr ver 0.59.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply