【Vegas原创】如何配置 SQL Server 2005 以允许远程连接
微软解决方案是:
1, 从SQL Server 2005 外围应用配置器上配置本地连接和远程连接为tcp/ip方式及name Pipes;
2, 启用 SQL Server Browser 服务;
3, 在 Windows 防火墙中创建例外.
具体步骤请参见:
http://support.microsoft.com/kb/914277/zh-cn
http://support.microsoft.com/kb/914277/zh-tw
如果以上方法还不行的话,就是因为ipsec指派了之后,DB A和DB B不能相互解析到自己的主机名称,所以造成复写写不进去。
比如:在dtpcdb02中,ping dtsdb01的ip地址是通的,但是ping dtsdb01的DNS则ping不通。
终极解决方案:在两台机器的host上加上对方的ip地址和名称。
步骤:
1, 搜索hosts文件:C:\windows\system32\drivers\etc\hosts;
2, 用记事本打开,按下面进行添加。
# Copyright (c) 1993-1999 Microsoft Corp.
#
# This is a sample HOSTS file used by Microsoft TCP/IP for Windows.
#
# This file contains the mappings of IP addresses to host names. Each
# entry should be kept on an individual line. The IP address should
# be placed in the first column followed by the corresponding host name.
# The IP address and the host name should be separated by at least one
# space.
#
# Additionally, comments (such as these) may be inserted on individual
# lines or following the machine name denoted by a '#' symbol.
#
# For example:
#
# 102.54.94.97 rhino.acme.com # source server
# 38.25.63.10 x.acme.com # x client host
127.0.0.1 localhost
10.91.50.46 dtsdb01
#
# This is a sample HOSTS file used by Microsoft TCP/IP for Windows.
#
# This file contains the mappings of IP addresses to host names. Each
# entry should be kept on an individual line. The IP address should
# be placed in the first column followed by the corresponding host name.
# The IP address and the host name should be separated by at least one
# space.
#
# Additionally, comments (such as these) may be inserted on individual
# lines or following the machine name denoted by a '#' symbol.
#
# For example:
#
# 102.54.94.97 rhino.acme.com # source server
# 38.25.63.10 x.acme.com # x client host
127.0.0.1 localhost
10.91.50.46 dtsdb01
喜欢请赞赏一下啦^_^
![](https://images.cnblogs.com/cnblogs_com/amadeuslee/1997630/o_21070809243911.jpg)
【推荐】编程新体验,更懂你的AI,立即体验豆包MarsCode编程助手
【推荐】凌霞软件回馈社区,博客园 & 1Panel & Halo 联合会员上线
【推荐】抖音旗下AI助手豆包,你的智能百科全书,全免费不限次数
【推荐】博客园社区专享云产品让利特惠,阿里云新客6.5折上折
【推荐】轻量又高性能的 SSH 工具 IShell:AI 加持,快人一步