Database connectivity for SQL server 2008 and c# 2008

Question

0.00/5 (No votes)

See more:

Hi,
I have one project in C# and my data base is in SQl-Server2008. When I try to connect my database i have one error. Kindly help me to slow this error.
Error: " A Network-related or Instance-Specification error occurred while establishing a connection to SQL Server. The server was not found or was not accessible verify that the instance name is configured to allow remote configured to allow remote connection provider. SQL network interface, Error:26.Error locating Server/Instance specified
:sigh:

Posted 9-Nov-10 21:51pm

purvi hope

Add a Solution

Comments

AmitChoudhary10 10-Nov-10 3:59am

Run to services.msc and check whether services for SQL are started.May be the problem....

purvi hope 20-Jan-11 7:43am

Hi all Thanks for replay...
Now I use...
<add name="ConnectionString" providerName="System.Data.SqlClient" connectionString="Persist Security Info=false;Data Source=ADMIN-PC;Initial Catalog=Database;Integrated Security=true" />
It's work very good...
Thanks agen...

2 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)

Abhinav S · Answer 1 · 2010-11-09T21:54:00

Solution 1

Nice little article here[^]. Use this as a checklist.

Posted 9-Nov-10 21:54pm

Abhinav S

Comments

purvi hope 10-Nov-10 3:57am

Thank you dear. But kindly explain it.

purvi hope 10-Nov-10 4:00am

Sorry i got it...
Thanks...

purvi hope 10-Nov-10 5:58am

Dear Abhinav! I read all your content but it is for SQL Server 2005 I need solution for SQL server 2008..
Kindly help me.

purvi hope · Answer 2 · 2010-11-10T01:42:00

Hi! All :),
I try to solve this error by connection string.
<connectionstring>
<add name="ConectionString" provider="" connectionstring="Persist Security Info=false; Data source=MyComputer;Initial catalog=globe;Integrated Sequrity=true" />
</connectionstring>
But now I get Errors : Database schema could not be retrieved for this connection. Please make sure the connection setting are correct and that the database is online. This server version is not supported Only servers up to MicroSoft SQL Server 2005 are supported.
And yes I use SQL server 2008 and Visual Studio 2008.