无法远程连接sql server [英] can not connect sql server remotly
问题描述
大家好,
我已经在远程服务器上安装了SQL Server 2005.我还安装了管理工作室.现在,每当我尝试从本地PC连接sql server时,都会出现类似
的错误
此故障可能是由于在默认设置下sql server不允许远程连接这一事实引起的"
我已经完成了所有设置,例如允许在Management Studio中进行远程连接.在表面积上也是允许的.我不知道该怎么办.
有什么建议吗?
在此先感谢您.
Hello All,
I have installed SQL Server 2005 on my remote server. I also have installed management studio. Now whenever I am trying to connect sql server from my local pc it gives me error like
"this faiure may be caused by the fact that under the default settings sql server does not allow remote connections"
I have done all the settings like in management studio remote connection is allowed. In surface area also it is allowed. I don''t know what to do.
Any suggestions??
Thanks in advance.
推荐答案
阅读以下内容:
SQL SERVER-修复:错误:40-无法打开与SQL Server的连接. [远程连接sql服务器 [
Read these:
SQL SERVER – Fix : Error : 40 – could not open a connection to SQL server.[^]
connect sql server remotly[^]
hope it helps :)
在这里,请看下面的博客条目,它们应该对您有所帮助:
在默认设置下,SQL Server不允许远程连接 [ ^ ]
它说:
I.确保在外围应用配置器"工具中启用了远程连接"
二.检查是否在SQL Server配置管理器中启用了TCP/IP协议
三,确保SQL Server浏览器服务正在运行
还要看这个:
^ ]
它说:
I. SQL Server应该已启动并正在运行.
二.在SQL Server配置中启用TCP/IP
三, Windows防火墙中的打开端口
IV.启用远程连接
V.启用SQL Server浏览器服务
六.在防火墙中创建sqlbrowser.exe的例外
七.重新创建别名
Here, look at the following blog entries, that should help you:
Under the default settings SQL Server does not allow remote connections[^]
It says:
I. Make sure that Remote Connections are enabled in Surface Area Configuration tool
II. Check Whether TCP/IP protocol is enabled in the SQL Server Configuration Manager
III. Make sure that SQL server Browser service is running
Also look at this:
SQL SERVER – FIX : ERROR : (provider: Named Pipes Provider, error: 40...[^]
It says:
I. SQL Server should be up and running.
II. Enable TCP/IP in SQL Server Configuration
III. Open Port in Windows Firewall
IV. Enable Remote Connection
V. Enable SQL Server Browser Service
VI. Create exception of sqlbrowser.exe in Firewall
VII. Recreate Alias
这篇关于无法远程连接sql server的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!