===========================================================
===========================================================
How to configure SQL Server 2005 to allow remote connections
SQL SERVER2005安装完后默认是拒绝CLIENT连接的。如果没有配置在CLIENT会出现如下错误提示:
Sqlcmd: Error: Microsoft SQL Native Client: An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections.
本篇介绍如何配置SQL SERVER2005允许remote connections.
测试环境: Windows2003 STD SERVER + SQL SERVER 2005 STD
分3步:
| • | Enable remote connections on the instance of SQL Server that you want to connect to from a remote computer. |
| • | Turn on the SQL Server Browser service. |
| • | Configure the firewall to allow network traffic that is related to SQL Server and to the SQL Server Browser service. |
bbobb
发表于:2007.09.12 22:27
::分类:
( MS SQL Server
)
::阅读:(427次)
:: Permanent link
