Stuck at Error : A network-related or instance-specific error occurred while establishing a connection to SQL Server

0
votes

I am getting this error not in all pages of website but in only one page. I can't found any solution,

Error

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)

I have referred to this link

Similar Question from stackoverflow

But problem still persists.

Thanks in advance.

2
asp.netsql-server
Well, then please show us your connection string that is being used on those "one page" in your web site! – marc_s

2 Answers

0
votes

So you are saying that there's a problem with only one web page? maybe some other class is used to retrieve the backing data? Maybe you should compare it to the other pages? Basically if the problem doesn't appear on other pages, then SQL Server is configured properly.

It's really hard to help you if you don't share anything from your code. It surely touches your connection string, so maybe you should first compare the one used on this faulty web page to the other ones (from the pages where you don't get any error).

0
votes

Actually, I have used web part in my page which causing problem, so problem was with web part. It was a web part Personalization problem. For now, I have keep Personalization-Enabled="false".

Similar Question from stackoverflow