Let me begin by saying I am not familiar with ASP, IIS, or SQL Server. However, I am working on a redesign for a client who's current site was designed in ASP, on a Windows System, running IIS6 and SQL Server 2005.
The redesign is being done in PHP, and I was told the only way to run PHP in this environment is to upgrade to IIS7, so I gave GoDaddy the go-ahead to do the upgrade. I was told the upgrade would take 24 hours, but it ended up taking a week (not sure what happened).
Immediately after the upgrade went into effect, the current website (ASP) ceased functioning. The website generates an error message, which can be seen at the primary homepage (www.luckyladypecans.com).
A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)
I realize this is somewhat of a general connectivity error, but I've done some research, and this seems to be related to a firewall issue that commonly occurs when upgrading to IIS7. If anyone has any advice or experience with this type of issue, I would love to hear some opinions on what I can do.
I have already tried re-creating the database, with Remote Access enabled. That proved unsuccesful. As I said, I'm not experienced with IIS or SQL Server; I work with MySQL, Apache, and PHP, so try to keep things in lamens terms for me!
Thank you!
