Deployment problem connecting to database

Hi,

Here’s my scenario. I have two machines:

DevBox

Windows 2000

IIS version 5

Desktop

WindowsXP Pro

IIS version 5.1

I open Visual Web Developer 2008 express on desktop and Select File>open Website, and browse to a folder on DevBox. Once opened I run the project using F5 and it does as it should (I click a button and it connects to a database and displays information on a page).

The trouble starts when I open IE6 on desktop and type in http://devbox/websitename/default.aspx. It finds the website and displays exactly the same screen, but when I click the button it times out and throws up an error message:

An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)

The website uses AJAX controls, namely an UpdatePanel and Timer, and I populate various controls in the code behind file. I have Microsoft ASP.NET 2.0 AJAX Extensions 1.0 installed on both machines.

It seems very strange that I can open the website using VWD 2008 and see it working, but not if I browse to the website through IE6.

Can anyone suggest a possible cause?

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Scott Lysle17y ago
Run the surface area configuration tool, use the connections option, and check the settings:

Try setting the option for local and remote connections and the sub option for tcp/ip and named pipes.

If that fails, make sure that you have setup the security on the database to allow the aspnet account access.