如何在asp.net中解决erorr:26? [英] How to solve erorr:26 in asp.net?

问题描述

你好朋友，

我在Visual Studio 2008中使用本地数据库，但是当我单击数据库时创建了问题，它返回下面给出的错误

异常详细信息:System.Data.SqlClient.SqlException:建立与SQL Server的连接时发生与网络相关或特定于实例的错误.服务器未找到或无法访问.验证实例名称正确，并且已将SQL Server配置为允许远程连接. (提供者:SQL网络接口，错误:26-指定服务器/实例时出错)

我该如何解决?

Hello friends,

I using local data base in visual studio 2008 but issue created when i click on my database it returns the error which given below

Exception Details: 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 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)

how can i solve this?

推荐答案

您的服务器存在通信问题.这是一篇很棒的文章，解释了如何诊断和修复它(并且不要错过有助于诊断过程的末尾工具):

http://blogs.msdn.com/b/sql_protocols/archive/2007/05/13/sql-network-interfaces-error-26-error-locating-server-instance-specified.aspx [

You have a communication issue with your server. Here is a great posting that explains how to diagnose and fix it (and don''t miss the tool near the end that helps in the diagnosis process):

http://blogs.msdn.com/b/sql_protocols/archive/2007/05/13/sql-network-interfaces-error-26-error-locating-server-instance-specified.aspx[^]

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

这篇关于如何在asp.net中解决erorr:26?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！