建立SQL Server连接时出错 [英] Error While Making connection of SQL server

问题描述

建立与服务器的连接时发生错误.连接到SQL Server 2005时，此故障可能是由于以下事实导致的:在默认设置下，SQL Server不允许远程连接.(提供者:SQL网络接口) ，错误:26-查找指定的服务器/实例时出错)"



您能帮忙吗?...

"An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)"



Can u help....

推荐答案

首先要确保SQL Server服务正在运行.其他原因可能是错误的连接字符串或某些防火墙阻塞.

在这里，请查看此博客文章以解决问题:异常-错误26-错误定位了指定的服务器实例 [ ^ ]
提供程序:SQL网络接口，错误:26-错误定位服务器/实例... [ ^ ]
未找到指定的SQL Server" o .. [^ ]

First and foremost make sure that the SQL Server services are running. Other reasons could be, incorrect connection string or some Firewall blockage.

Here, have a look at this blog post to troubleshoot the issue : MSDN Blogs: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified[^]

If needed, look at these one:
Exception - error 26 - Error Locating Server Instance Specified[^]
provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance...[^]
"Specified SQL server not found" o..[^]

局域网中没有连接，您必须先进行局域网的联网

there is no connection in lan u have to do the networking of your lan first

这篇关于建立SQL Server连接时出错的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！