IIS 7提供程序SQL网络接口上的错误消息错误26定位服务器/...时出现错误 [英] error message on the IIS 7 Provider SQL Network Interfaces error 26 Error locating server/...

问题描述

嗨
我设计了一个在线注册Web应用程序，该应用程序可以很好地在我的开发人员机器上运行.在IIS 7上部署并打开数据库页面或打开登录名后，将出现以下错误:
建立与SQL Server的连接时发生与网络相关或特定于实例的错误.服务器未找到或无法访问.验证实例名称正确，并且已将SQL Server配置为允许远程连接. (提供者:SQL网络接口，错误:26-错误指定了服务器/实例的位置)请问我以不同的方式厌倦了什么问题，但我找不到解决办法

感谢

Hi
I have designed an online registration web application that works on my developer machine well. after deployed on the IIS 7 and to open data base page or to open login it gives this error:
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 that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified) please what is the problem i tire in different way but i can''t get the solution

Thanks

推荐答案

首先要确保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..[^]

这篇关于IIS 7提供程序SQL网络接口上的错误消息错误26定位服务器/...时出现错误的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！