SQL Server does not exist or access denied

[Guest]

I have developed a small application using ASP.NET and VB.NET on my
development machine it works great. When I copy across the files manually to
my test machine and create a Virtual Directory all of the functionality works
well except for a page with a datagrid that retrieves data from an MSDE
database (error message is detailed below). I have checked the connection
string and that looks good and MSDE is properly installed and configured on
the test box. By the way I have tried this on two separate test machines I
get the same error. At a loss to understand why. Do I need to run some exe
that lets my ASP.NET application to use MSDE, is it a permissions thing or
what?

By the way the error I get is as follows:

SQL Server does not exist or access denied.
Description: An unhandled exception occurred during the execution of the
current web request. Please review the stack trace for more information about
the error and where it originated in the code.

Exception Details: System.Data.SqlClient.SqlException: SQL Server does not
exist or access denied.

 

[Patrice]

Do you use a single machine with both the web site and SQL Server in dev and
targetting a config where the web and the SQL box are disitncts (AFAIK MSDE
allows only local access by default).

 

[Guest]

I have a single machine with both my website and db installed on it for my
dev environment and a for my test box.

I’m building a website that will run on a single machine with the db on the
box as well.

 

[Patrice]

Not that then ;-)

Apart double checking the connection string (both the server name and check
the instance name in case it would have been installed with something else
than the default name) or if the service is started I hardly see what
changed between your dev and your test box...

 

[Guest]

I'm at a loss. To give you some idea earlier today I wrote a test page that
inserted data into the database and that worked.

The funny part is that I have tried to test this application on two totally
different test boxes each with its own MSDE setup etc and i get the same
error message.

I feel lost.

 

[Patrice]

Is it solved or does it work only with this test page (running on the same
web site ???) ? Some more details would help if not solved...

SQL would work. You may have a problem with your connection string (stored
in an outdated DLL or whatever) or perhaps with permissions if it works from
a web site but not from another (authentication, impersonation ?)