错误：26 - 错误定位sql server 2008中指定的服务器/实例 [英] error: 26 - error locating server/instance specified in sql server 2008

问题描述

大家好，



这是来自Chennai的Arun。我用VS 2008开发了我在WPF（C＃）中的第一个应用程序。 SQL Server 2008.它在我的系统中运行良好。部署后，它不会在其他系统中工作。它显示以下错误消息。



system.data.sqlclient.sqlexception - 建立与sql server的连接时发生网络相关或实例特定错误。服务器未找到或无法访问。验证实例名称是正确的，并且sql server配置为允许远程连接。（提供者：sql网络接口，错误：26 - 指定错误定位服务器/实例）。



我已经通过谷歌并完成了以下步骤但没有用。



服务器名称：ECARE432 \SQLEXPRESS

实例名称：SQLEXPRESS

App.Config有：

< connectionStrings>

< add name =" TimeTracker.Properties.Settings.myecareConnectionString" connectionString =" Data Source = ECARE432\SQLEXPRESS; Initial Catalog = myecare; Persist Security Info = True; User ID = sa; Password = ecare123 @" providerName =" System.Data.SqlClient" />

< / connectionStrings>





1. Visual Studio - >工具 - >选项 - >数据库工具 - >数据连接 - >

已更改SQL Server实例名称来自sqlexpress空白。



2.配置工具 - > SQL Server配置管理器 - > SQL Native Client配置

别名 - >

别名 - > ECARE432 \ SQLEXPRESS，1433

端口号 - > 1433

协议 - > TCP / IP

服务器名称 - > ECARE432 \ SQLEXPRESS



3. SQL Server Browser在我的系统中运行。



4.服务器名字是对的。没有拼写错误。



5.客户机可以ping我的机器。



6. TCP 1433和UDP 1434异常添加到防火墙。同时在我的系统和客户端系统中关闭防火墙。



请指导我如何解决此问题。

解决方案

检查以下链接...它可以帮助你。

SQL网络接口，错误：26 - 找到指定的服务器/实例时出错 [ ^ ]

SQL SERVER - FIX：ERROR [ ^ ]

SQL 2008 R2错误：SQL网络接口，错误：26 - 找到指定的服务器/实例时出错 [ ^ ]

问候，

GVPrabu

< blockquote>已将connectionString =Data Source = ECARE432 \ SQLEXPRESS更改为Data Source = ECARE432。我刚刚删除了实例名称及其工作。

Hi All,

This is Arun from Chennai. I have developed my first application in WPF (C#) with VS 2008 & SQL Server 2008. It works fine in my system. After deployment, it wont works in other systems. It shows the following error message.

system.data.sqlclient.sqlexception - 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 instance name is correct and sql server is configured to allow remote connections.(provider: sql network interfaces, error: 26 - error locating server/instance specified).

I have gone through the google and done the following steps but no use.

Server Name : ECARE432\SQLEXPRESS
Instance Name : SQLEXPRESS
App.Config have:
<connectionStrings>
<add name="TimeTracker.Properties.Settings.myecareConnectionString" connectionString="Data Source=ECARE432\SQLEXPRESS;Initial Catalog=myecare;Persist Security Info=True;User ID=sa;Password=ecare123@" providerName="System.Data.SqlClient"/>
</connectionStrings>


1. Visual Studio-->Tools-->Options-->Database Tools-->Data Connections-->
Changed "SQL Server Instance Name" from "sqlexpress" to blank.

2. Configuration Tools->SQL Server Configuration Manager->SQL Native Client Configration
Aliases->
Alias Name -> ECARE432\SQLEXPRESS,1433
Port Number -> 1433
Protocol -> TCP/IP
Server Name -> ECARE432\SQLEXPRESS

3. SQL Server Browser is running in my system.

4. Server Name is correct. No typo mismatch.

5. Client machine is able to ping my machine.

6. TCP 1433 and UDP 1434 Exception added to Firewall. Also Turned off the Firewall in both my system and the client system.

Please guide me how to fix this issue.

解决方案

Hi,

Check the following links... Its helps u.
SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified[^]
SQL SERVER – FIX : ERROR [^]
SQL 2008 R2 error: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified[^]
Regards,
GVPrabu

changed connectionString="Data Source=ECARE432\SQLEXPRESS" as "Data Source=ECARE432". Just I have removed the instance name and its working now.

这篇关于错误：26 - 错误定位sql server 2008中指定的服务器/实例的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！