sqlserver集群配置(一)

2015-07-24 06:31:16 · 作者: · 浏览: 17

?

Windows server2003 + sql server2005 集群配置安装

一:环境

软硬件环境

?

虚拟3台windows server 2003主机。其中一台做域控DC,另外两台作为节点win1 win2.

域控DC网络设置:

Hostname

Private网卡

Public网卡

?

adtest

?

192.168.9.176

?

?

节点主机网络设置

Hostname

Private网卡

Public网卡

?

Win1

10.0.0.173

192.168.9.173

?

Win2

10.0.0.174

192.168.9.174

?

?

二:建域test.com

在域控主机192.168.9.176上安装域

1 设置DC的ip 192.168.9.176
INCLUDEPICTURE \d "https://www.cppentry.com/upload_files/article/57/1_8s9ve__.png" \* MERGEFORMATINET

2 在DC中使用DCPROMO命令创建域 (后面的步骤中需要更新windows组件,必须先挂载安装盘)
INCLUDEPICTURE \d "https://www.cppentry.com/upload_files/article/57/1_4wejh__.jpg" \* MERGEFORMATINET

3 下一步

INCLUDEPICTURE \d "https://www.cppentry.com/upload_files/article/57/1_bzfeq__.jpg" \* MERGEFORMATINET

4 下一步

INCLUDEPICTURE \d "https://www.cppentry.com/upload_files/article/57/1_i5dq6__.jpg" \* MERGEFORMATINET

5 下一步

INCLUDEPICTURE \d "https://www.cppentry.com/upload_files/article/57/1_1uziu__.png" \* MERGEFORMATINET

6 选择新林中的域

INCLUDEPICTURE \d "https://www.cppentry.com/upload_files/article/57/1_nh0dw__.png" \* MERGEFORMATINET

7 填入所要创建域的完整的域名
INCLUDEPICTURE \d "https://www.cppentry.com/upload_files/article/57/1_2bqgr__.png" \* MERGEFORMATINET

8 下一步

INCLUDEPICTURE \d "https://www.cppentry.com/upload_files/article/57/1_bb08r__.png" \* MERGEFORMATINET

9 选择AD数据库和日志文件的存放位置

INCLUDEPICTURE \d "https://www.cppentry.com/upload_files/article/57/1_owte5__.png" \* MERGEFORMATINET

10 存放SYSVOL的存放位置(注意:一定要放在NTFS的分区中)

INCLUDEPICTURE \d "https://www.cppentry.com/upload_files/article/57/1_fisp4__.png" \* MERGEFORMATINET

11 注意:AD是离不开DNS服务的,因为客户机加入域和登录域都需要把域名解析为IP地址,因为此时DC没有DNS服务器,所以选择第二项让系统在创建DC的同时把DNS服务随之一起安装上.当然你也可以安装DC后自己手动再安装和配置DNS服务器(当时是您给会正确配置DNS服务器),建议和DC一起让系统帮我们创建,因为省事

INCLUDEPICTURE \d "https://www.cppentry.com/upload_files/article/57/1_obqjd__.png" \* MERGEFORMATINET

12 选择兼容的模式,为了以后可以方便windows2000和2003兼容

INCLUDEPICTURE \d "https://www.cppentry.com/upload_files/article/57/1_9yazc__.jpg" \* MERGEFORMATINET

13 设置AD的还原密码(为了以后对AD数据库做完备份,开机按F8进入AD还原模式需要的还原密码,如果在此设置了密码,一定切记):

INCLUDEPICTURE \d "https://www.cppentry.com/upload_files/article/57/1_gylwt__.jpg" \* MERGEFORMATINET

14 下一步

INCLUDEPICTURE \d "https://www.cppentry.com/upload_files/article/57/1_xtlkg__.jpg" \* MERGEFORMATINET

15 下一步

INCLUDEPICTURE \d "https://www.cppentry.com/upload_files/article/57/1_p45bu__.jpg" \* MERGEFORMATINET

16 需要挂载有关盘,才会自动安装DNS

INCLUDEPICTURE \d "https://www.cppentry.com/upload_files/article/57/1_bm02r__.jpg" \* MERGEFORMATINET

17 完成

INCLUDEPICTURE \d "https://www.cppentry.com/upload_files/article/57/1_hht4j__.jpg" \* MERGEFORMATINET

18 重启

INCLUDEPICTURE \d "https://www.cppentry.com/upload_files/article/57/1_fbypi__.jpg" \* MERGEFORMATINET

19 安装完重起系统后登录界面为使用域中的管理员和密码登录到域

INCLUDEPICTURE \d "https://www.cppentry.com/upload_files/article/57/1_ebui6__.png" \* MERGEFORMATINET

20 进入系统后查看计算机的状态

INCLUDEPICTURE \d "https://www.cppentry.com/upload_files/article/57/1_lu21u__.png" \* MERGEFORMATINET

21查看管理工具会增加DNS和有关AD的工具,以及安全策略


INCLUDEPICTURE \d "https://www.cppentry.com/upload_files/article/57/1_nqzpg__.png" \* MERGEFORMATINET

22 点开用户和计算机域控管理界面 (创建域test.com完成)

INCLUDEPICTURE \d "https://www.cppentry.com/upload_files/article/57/1_wdrns__.png" \* MERGEFORMATINET

三:配置节点win1 和 节点win2的网络,并添加