sql server 2005 installation/connection

Question

0.00/5 (No votes)

See more:

SQL-Server-2005

hi,
when i connect the database engine to sql server 2005 I get this error:

A network related or instance specific error occoured to Sql Server.the server was not fount or was not accessible, verify that the instance name is correct and that  sql server is configured to allow remote connections.(provider:sql Network Network Interface,error:26-Error Locating Server/Instance Specified)(Microsoft sql server)

Also I can't see the sql server in the services(admin tools).
I tried to ping my sql server like this "ping Abhishek-PC\SQlEXPRESS" but it does not found.
Is there any intallation setting error?
how to resolve this error?

Thanks.

Posted 27-Nov-12 16:25pm

Abhishek Pant

Add a Solution

4 solutions

Solution 1

in run command type services.msc and check you have sql services is on. If its not start then start it. May be this will work.

If you don't get sql server name in those Name then check your program files.

Posted 27-Nov-12 17:25pm

Patel Shailendra

Updated 27-Nov-12 17:27pm

v2

Comments

Abhishek Pant 27-Nov-12 23:57pm

I did'nt get sql server in it now what to check("those Name ")in program files

Patel Shailendra 28-Nov-12 0:06am

check that you have Microsoft SQL Server folder or not if have then go in it. then search for data file may be you don't have complete setup for sql server 2005.

if you have Microsoft SQL Server folder look open it and look for data files in side the folder if u have that then download sQL Query Analyzer.

Abhishek Pant 28-Nov-12 0:26am

Yes I do not found that.SO could you please tell whats happening a approximate answer at once.

Solution 2

Hi Abhishek,

Generally this error: 26 we get in the following scenarios.
If you are connecting from remote machine and
there was network issue, firewall or SQL
Browser service is not running.

Please Check
Go to SQL Server Configuration Manager
Select SQL server Services
In right side check any SQL Server Service is
running otherwise start the service.

If you are unable to see services then there
is problem with installation.

I want to hear more from your side.

Posted 27-Nov-12 17:25pm

Kareem.S

Comments

Abhishek Pant 28-Nov-12 0:35am

thanks for answer I cant see that.so its installation error.

Zain -Ul- Arifeen 31-Jan-13 13:02pm

Dear Sir,
my Sql Server Services and Sql Browser services is correctly running.but still give me this types of error. and the following is my connection string
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Data.SqlClient;

namespace ADMSV1
{
class ConnectionString
{
public static SqlConnection cnn = new SqlConnection("Data Source=zain\\sqlexpress;Initial Catalog=ADMSV01;Integrated Security=True");
}
}

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)

Code-Hunt · Accepted Answer · 2012-12-19T01:21:00

Solution 4

Please check the below links

http://social.msdn.microsoft.com/Forums/en-US/sqlexpress/thread/8cdc71eb-6929-4ae8-a5a8-c1f461bd61b4[^]

http://csharpektroncmssql.blogspot.in/2012/04/network-related-or-instance-specific.html[^]

http://sqlservererror-info.blogspot.in/2010/09/network-related-or-instance-specific.html[^]

check if u can locate ur problem else do tell..

Posted 19-Dec-12 1:21am

Code-Hunt

Updated 19-Dec-12 1:22am

v2

Comments

Abhishek Pant 19-Dec-12 7:52am

I tried this..ofcourse you have the good solution as far as this question. there was some problem my installations. and I installed it again and now running that succesfully from 1/2 month.

*Abhishek Pant* · Accepted Answer · 2012-12-18T21:25:00

Solution 3

SQL 2005 Express remote connection problem[^]

May have error in your installations.

also refer sql server 2005 installation/connection[Solution 4]

Posted 18-Dec-12 21:25pm

Abhishek Pant

Updated 19-Dec-12 1:54am

v3