无法连接到远程数据库服务器
问题描述：
大家好，
我正在尝试连接到远程数据库服务器.但我收到此消息.
一次连接尝试失败，因为被连接方在一段时间后未正确响应，或者由于主机未能响应服务器而建立的连接失败."
我也尝试增加连接时间，但仍然无法正常工作.
请帮忙.
提前谢谢.
问候，
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.