无法连接到远程数据库服务器 [英] Cannot connect to remote database server

问题描述

大家好，

我正在尝试连接到远程数据库服务器.但我收到此消息.
一次连接尝试失败，因为被连接方在一段时间后未正确响应，或者由于主机未能响应服务器而建立的连接失败."

我也尝试增加连接时间，但仍然无法正常工作.

请帮忙.

提前谢谢.

问候，
Swati

Hello All,

I am trying to connect to remote database server. But I am getting this message.
" A Connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because host has failed to respond to server".

I have tries increasing connection time also, but still its not working.

Please help.

Thanks in advance.

Regards,
Swati

推荐答案

必须在远程数据库服务器上禁用表面区域配置.

错误看起来像是表面区域配置问题.
当前在数据库服务器上禁用了远程连接.启用它.
1.打开此窗口:开始"->所有程序"->"MS SQL Server 2005"->配置工具-> SQL Server外围应用配置器
2.选择服务和连接"的外围应用配置"
3.选择"MSSQLServer"->数据库引擎"->远程连接"
4.现在选择单选按钮:本地和远程连接
5.同时选择同时使用TCP/IP和命名管道
6.选择确定按钮.您可以根据需要重新启动SQL服务.

Surface Area Configuration must be disabled on the remote database server.

Error looks like a Surface Area Configuration issue.
Remote connections are currently disabled on the database server. Enable it.
1. Open this: Start->All Programs->MS SQL Server 2005-> Configuration Tools -> SQL Server Surface Area Configuration
2. Choose Surface Area configuration for Services and Connections
3. Select MSSQLServer->Database Engines->Remote Connections
4. Now select radio button: Local and Remote Connections
5. Also select using both TCP/IP and named pipes
6. Select Ok button. You can restart the SQL Service if needed.

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