sql server远程连接 [英] sql server remote connection

问题描述

你好朋友
我使用sqlserver Management Studio和
创建了一个sql server数据库 通过远程连接但通过运行
在c#项目中使用它 出现以下应用程序错误

建立时发生与网络相关或特定于实例的错误
与sql server的连接

解决方案是什么?

解决方案

基本上，这意味着SQL Server没有响应.有很多可能的原因，例如不亮，防火墙阻止等.

例如查看以下内容: target ="_ blank" title ="New Window"> ^ ]

阅读来自那里的线程[建立与SQL Server的连接时发生相关或特定于实例的错误] [ link- [与SQL Server建立连接时发生与网络相关或特定于实例的错误] [

解决SQL连接问题的步骤 [ ^ ]
SQL Server 2005连接性问题疑难解答-第一部分 [对SQL Server 2005中的连接问题进行故障排除-第二部分 [ ^ ]
对SQL Server 2005中的连接问题进行故障排除-第III部分 [ ^ ]

顺便说一句，也检查这堆是否有未来的错误

Hi friends
I create a sql server databse with sqlserver management studio and
use it in c# project by remote connection but by running
application following error appear

A network-related or instance-specific error occured while establishing
a connection to sql server

what''s solution?

解决方案

Basically it means that the SQL Server is not responding. There are lots of possible reasons like, its not on, firewall blocking etc.

Have a look at for example this: http://www.sqlmusings.com/2009/03/11/resolving-a-network-related-or-instance-specific-error-occurred-while-establishing-a-connection-to-sql-server/[^]

Read thread from there-[A network-related or instance-specific error occurred while establishing a connection to SQL Server][^]
and this link-[A network-related or instance-specific error occurred while establishing a connection to SQL Server][^] might help you.

From link[^]:

Basically, when you failed to connect to your SQL Server, the issue could be:
1) Network issue,
2) SQL Server configuration issue.
3) Firewall issue,
4) Client driver issue,
5) Application configuration issue.
6) Authentication and logon issue.

Check these
Steps to troubleshoot SQL connectivity issues[^]
SQL Server 2005 Connectivity Issue Troubleshoot - Part I[^]
Troubleshoot Connectivity Issue in SQL Server 2005 - Part II[^]
Troubleshoot Connectivity Issue in SQL Server 2005 - Part III[^]

BTW check this bunch also for future errors

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