sql server 2005安装/连接 [英] sql server 2005 installation/connection

问题描述

当我将数据库引擎连接到sql server 2005时出现此错误：

发生网络相关或实例特定错误到Sql Server。服务器不是fount或无法访问，验证实例名称是否正确，并且sql server配置为允许远程连接。（提供程序：sql网络网络接口，错误：26-错误查找指定的服务器/实例）（微软sql server）



我也看不到服务中的sql server（管理工具）。

我试图ping我的sql server这样的ping Abhishek-PC\SQlEXPRESS但是没找到。

是否有任何安装设置错误？

如何解决这个错误？



谢谢。

解决方案

请查看以下链接



HTTP：//social.msdn.m icrosoft.com/Forums/en-US/sqlexpress/thread/8cdc71eb-6929-4ae8-a5a8-c1f461bd61b4 [ ^ ]



< a href =http://csharpektroncmssql.blogspot.in/2012/04/network-related-or-instance-specific.html> 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 [ ^ ]



检查你是否可以找到你的问题em else告诉..

在运行命令中键入services.msc并检查是否已启用sql服务。如果它没有启动然后启动它。可能会这样。



如果你没有在这些名字中获得sql server名称，那么检查你的程序文件。

< blockquote>嗨Abhishek，



一般来说这个错误：26我们遇到以下情况。

如果你从远程机器和

有网络问题，防火墙或SQL

浏览器服务没有运行。



请检查
转到SQL Server配置管理器

选择SQL服务器服务

在右侧检查任何SQL Server服务是

否则运行开始服务。



如果您无法看到服务那么

是安装问题。



我希望从你这边听到更多。

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.

解决方案

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..

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.

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.

这篇关于sql server 2005安装/连接的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！