sql connection problem

Question

0.00/5 (No votes)

See more:

VS2012

Why my visual studio show this message.
"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 the instance name is correct and that SQL server is configured to allow remote connection."
I install wamp server for my wordpress work. Is this conflict with my wamp server. please tell me a solution.

Posted 29-Nov-14 23:42pm

Durjoy39

Add a Solution

2 solutions

Solution 3

Tons of similar questions and answers you'll find here[^].

Please, refer this tooo: How to enum SQL Server instances in network[^].

Posted 30-Nov-14 7:02am

Maciej Los

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)

Afzaal Ahmad Zeeshan · Accepted Answer · 2014-11-29T23:55:00

The possible issues are the connectionstring that you're passing to connect to the server. The error would be thrown depending on any possible issues below,

First thing is to make sure that you're passing the correct name for the SQL server or the database. If not, please correct it.
Use the username and password that you used while creating the database.
You should consider understanding that the connectionString must have all of the required authentication data before enabling your application to use it. So, if you used Windows authenticaion create a string for that, otherwise if you used Database authentication then use the settings for it; username password combination.

These issues must be resolved in order to connect your database to your application. The problem generally is just because of the username/password or the authenticaion mode problem. For more on these strings, please visit: http://connectionstrings.com[^].