sqlserver集群配置(四)

2015-07-24 06:31:16 · 作者: · 浏览: 13
,也可以用此方法重新配置

?

一般性增加MSDTC资源方法:

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

“资源类型”选择“分布式事务协调器(DTC)”

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

?

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

选择仲裁盘和群集名作为其依存资源。完成

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


确定,完成MSDTC 配置。

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

?

4 注意,在安装SQL server 2005 前, 如果主机是多核心的处理器,请修改boot.ini 文件,把CPU 核心数

改为1

.可以在msconfig 选项中直接选择修改 ,这个是2005 本身的bug,等完成安装后打SP3 或更高的补丁。

补丁打完之后可修改回正常核心数量

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

?

?

?

?

5安装SQL Server 2005

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

下一步

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

?

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

下一步(步骤2处理不好,会出现com+错误)

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

?

开始安装必备组件

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

系统配置检查

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

?

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

输入注册信息

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

选择要安装的组件

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

(所提供光盘只有SQL Server Database Services组件)

输入实例名:MSSQL2005

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

输入虚拟服务器的名称:SH-sqldbc

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

输入虚拟服务器名称,下一步(区别于集群虚拟服务器IP)

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

为虚拟服务器指定IP 地址,点击“添加”

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

?

为数据文件指定安装路径,请注意这里的S 盘是数据存储盘(ClusterData),千万不要把数据文件安装到仲裁盘(QDisk)上。

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

可以在集群管理器上分一下组

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

该用户其实应该是cluster,如果用administrator,会造成不能在远程计算机安装(后面述修改方法,也可以之前在域中建好用户)

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

?

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

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

?

?

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

?

INCLUDEPICTURE \d "https://www.cppentry.com/upload_files/arti