Deployment problems

[Tom Hoogeboom]

I have written a .Net web application to deliver data contained on a SQL
server to web pages requested by a client. The .aspx page generates an SQL
statement pointing to a stored procedure on the SQL server, and connection
is made via a connect string containg server name, user id, pwd, and initial
page, stored in the web.config file.

The application works perfectly on the development machine under Visual
Studio, but refuses to work on the client web server (different from the SQL
server). I made certain that MDAV v2.8 was installed on the web server, but
a test page says the SQL server could not be found.

Are there any special requirements for deploying a web application that uses
a SQL database?

Help!

Tom Hoogeboom

 

[Guest]

Does the identity that your web site is running as (possibly ASPNET or
NETWORK SERVICE) have permissions to access the production database?

Scott Swigart
blog.swigartconsulting.com
www.swigartconsulting.com