Why did a network-related or instance-specific error occur while establishing a connection to SQL Server

0 votes

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.

  1. A few tables were removed, then I recreated them and added data. At this point, everything was OK.
  2. I used the FTP to erase ALL of the files.
  3. 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?

Sep 5, 2022 in Database by narikkadan
• 63,420 points
1,368 views

No answer to this question. Be the first to respond.

Your answer

Your name to display (optional):
Privacy: Your email address will only be used for sending these notifications.

Related Questions In Database

0 votes
0 answers
0 votes
0 answers
0 votes
0 answers

SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified

I've been attempting to solve a significant ...READ MORE

Aug 22, 2022 in Database by Kithuzzz
• 38,010 points
1,466 views
0 votes
1 answer

Login failed for user 'sa'. The user is not associated with a trusted SQL Server connection. (Microsoft SQL Server, Error: 18452) in sql 2008

Solution Go to Start > Programs > Microsoft SQL Server > Enterprise Manager. Right-click the SQL ...READ MORE

answered Sep 12, 2022 in Database by narikkadan
• 63,420 points
834 views
0 votes
1 answer
0 votes
1 answer

powerbi embeded in .net core 1.1

See if it helps: https://www.nuget.org/packages/PowerBI.NetStandar ...READ MORE

answered Nov 28, 2018 in Power BI by Upasana
• 8,620 points
1,219 views
0 votes
1 answer

Power BI Embedded : Importing Packages

This should help you out. https://www.nuget.org/packages/PowerBI.N ...READ MORE

answered Apr 3, 2019 in Power BI by Shubham
• 13,490 points
465 views
0 votes
1 answer

What are the correct version numbers for C#?

On Wikipedia, you may find the most ...READ MORE

answered May 31, 2022 in C# by rajiv
• 1,620 points
217 views
0 votes
0 answers

How to get the connection String from a database

I want to use the database I ...READ MORE

Aug 20, 2022 in Database by Kithuzzz
• 38,010 points
236 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP