I'm incredibly annoyed. Everything is wonderful with my local database and a website running on Visual Web Developer 2008 Express. The identical website is also active on a production server that I own. Everything was running smoothly until I "reset" production tonight.
- A few tables were removed, then I recreated them and added data. At this point, everything was OK.
- I used the FTP to erase ALL of the files.
- I copied the website to the website via FTP using the Visual Studio "Copy Website" tool.v.
When I log on mto y website, here is the error I got:
Server Error in '/' Application.
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: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)
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: 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: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)
Regarding the SQL connection, nothing has changed; I have always used this OLD code. This has rendered my website utterly inoperable, and I feel ill inside since I believe there is nothing I can do about it.
Please, if someone can assist me?
