sql数据库连接 [英] sql database connection

问题描述

你好，

如何解决我的问题?

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


谢谢，

Hello,

How to resolve my quesiton ?

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)


Thanks,

推荐答案

研究此链接以解决您的错误.
可能是外围区域配置错误或sql服务配置问题.请查看此线程的潜在原因和解决方案:解决建立与SQL Server的连接时发生与网络相关或特定于实例的错误[^]

如果需要，请参阅此处的设置表面积配置的步骤..

如果这不能解决您的问题，请查看以下线程:
http: //forums.asp.net/t/1334649.aspx
[ ^ ]
SQL SERVER FIX ERROR(提供程序:命名管道[^]
这里也提出了很多可能的原因和解决方案.
快乐编码
:)

Study this link to Resolve your Error.
It might be surface area configuration error or sql service configuration issue. Have a look at this thread for potential reasons and resolutions: Resolving A network-related or instance-specific error occurred while establishing a connection to SQL Server[^]

If needed, See steps for setting up Surface area configuration here..

If this does not resolve your issue, have a look at these thread:
http://forums.asp.net/t/1334649.aspx
[^]
SQL SERVER FIX ERROR (provider: Named Pipes [^]
Quite few possible reasons and resolutions are proposed here too.
Happy Coding
:)

检查此链接 http://www.connectionstrings.com/ [

Hi ,
Check this link http://www.connectionstrings.com/[^]


If you can''t connect to your Database through management studio Then go sql server configuration manager and restart the service

Best Regards
M.Mitwalli

您的连接字符串不正确.

尝试使用这些凭据(从web.config文件或IIS管理器获取它们)，SQL Server Management Studio(如果使用SQL Server)或数据库服务器附带的任何控制台进行连接.您会发现您将无法连接.您需要更新到连接字符串并提供正确的凭据才能解决此问题.

You connection string is incorrect.

Try connecting using these credentials (get them from you web.config file or IIS Manager) SQL Server Management Studio (if you are using SQL Server) or any console that comes which you database server. You will find that you won''t be able to connect. You need to update to connection string and provide with correct credentials to resolve this.

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