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.

Question

0.00/5 (No votes)

See more:

Hi,

I have Windows 2008 R2 and running SQL Server 2008 R2.
When adding a web part manager to my page and run it gives me the following 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)

Please Advise

Posted 7-Aug-11 11:48am

Moustafa Safwat

Updated 7-Aug-11 11:51am

walterhevedeich

v2

Add a Solution

3 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

walterhevedeich · Answer 1 · 2011-08-07T11:54:00

Solution 1

The error says it all. Are you sure SQL Server is running? See following solutions for troubleshooting it.

A network-related or instance-specific error occurred[^]
A network-related or instance-specific error[^]
Error in asp.net web parts[^]
how to resolve this error[^]

Posted 7-Aug-11 11:54am

walterhevedeich

Comments

Moustafa Safwat 7-Aug-11 17:59pm

Sure its running on instance MSSQLServer

walterhevedeich 7-Aug-11 18:00pm

Have you checked the links?

Moustafa Safwat 7-Aug-11 18:01pm

I have login control on anther page and connected correctly and i could access and retrieve data also. but the probleam occured when adding the web part control

Monjurul Habib 7-Aug-11 18:13pm

nice links.5+

walterhevedeich 7-Aug-11 22:22pm

Thanks Monjurul.

Moustafa Safwat · Answer 2 · 2011-08-07T13:22:00

Solution 3

Finally I found the solution :)

XML

<connectionStrings>
    <!-- Resolve Web Parts Provider Probleam with connection -->
    <remove name="LocalSqlServer" />
    <add name="LocalSqlServer" connectionString="SERVER=.;Integrated Security=true;Initial Catalog=DotStreamDB" providerName="System.Data.SqlClient" />
</connectionStrings>

Posted 7-Aug-11 13:22pm

Moustafa Safwat

Comments

Moustafa Safwat 7-Aug-11 19:24pm

The Source Article
http://daron.yondem.com/CommentView.aspx?guid=cb37f9ff-81d3-4b9c-ab97-18e9eddd9a27

walterhevedeich 7-Aug-11 21:54pm

Good. So you managed to search the net for a solution. How does it feel that you have solved it by yourself? My 5. :)

Moustafa Safwat 8-Aug-11 16:15pm

Yup we should close this community "This is lesson one" :)

Monjurul Habib · Answer 3 · 2011-08-07T12:12:00

Solution 2

The solution is here

I just pick the first link from google

Posted 7-Aug-11 12:12pm

Monjurul Habib

Comments

Moustafa Safwat 7-Aug-11 18:17pm

Thank You I read it before posting the article. I have Network service account grant all and i disabled my firewall for testing also the remote connection is enabled and sure after doing this restarted the service :)