C# SQL Connection Express

Question

0.00/5 (No votes)

See more:

Hey guys I tried my application on my friends computer and it worked, had to change the connection string. Now I am back on my own computer the following error has occured, I have looked at general help for this error and tried the help given but it hasn't worked, any idea on what could have gone wrong, thanks in advance.

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)

Posted 9-Apr-12 6:54am

Tooze

Add a Solution

Comments

wizardzz 9-Apr-12 12:57pm

Can you ping the server?

Tim Groven 9-Apr-12 13:02pm

Did it work on your computer before you tried on your friends? Have you tried changing the connection string back?

Tooze 9-Apr-12 13:07pm

Hi, yes It did work on my computer, it could connect to the database. I then opened the application on my friends, changed the string and it once again worked. When i returned on my computer the error then showed. Perhaps it was something relating to my friends computer? I did also change the string back :)

Tim Groven 9-Apr-12 13:14pm

Have you tried changing the string back to what it was before you changed it on your friends computer?

1 solution

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)

VJ Reddy · Answer 1 · 2012-04-09T07:01:00

Solution 1

The above error occurs if the instance name of the SQL Server does not match the name given in the connection string.
Run the SQL Server Management Studio, check the Server name in the connect to server form and replace the server name in the connection string with this name.

Posted 9-Apr-12 7:01am

VJ Reddy