Click here to Skip to main content
15,568,804 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
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

 
Share this answer
 
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.
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.
 
Share this answer
 
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.
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.
 
Share this answer
 
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");
}
}
 
Share this answer
 
v3

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



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900