sqlserver集群配置(五)

2015-07-24 06:31:16 · 作者: · 浏览: 13
cle/57/1_n9sz0__.png" \* MERGEFORMATINET

选择混合模式验证

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

?

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

?

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

?

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

开始安装

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

?

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

安装程序。

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

?

完成后在另一个节点安装。

?

六:解决远程不能安装问题,创建swg域用户,委托管理

1 打开域控制管理

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

2 新建用户

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

?

3 添加到组

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

?

?

4 添加到administrator组中

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

?

5 查看属性

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

?

6 win1 win2 节点上加用户权限

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

?

?

7 添加到swg组

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

?

8 最后全部用swg用户等test.com域上的主机win1,win2

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

?

?

?

?

?

七:安装完成后测试

1 win1上查看增加的资源

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

?

?

?

2 停止其中win1节点,服务自动转移

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

?

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

八:访问数据库,导入数据

1 右键“数据库” “附加”
INCLUDEPICTURE \d "https://www.cppentry.com/upload_files/article/57/1_oi9v3__.jpg" \* MERGEFORMATINET

?

2 导入整个数据库

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

?

3 导入完成后,显示数据

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

?

4 做故障转移时,数据库可以正常被访问

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

?