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 "http://blog.itpub.net/attachment/201408/11/29500582_1407739037lWe2.png" \* MERGEFORMATINET
2 在DC中使用DCPROMO命令创建域
(后面的步骤中须要更新windows组件,必须先挂载安装盘)
INCLUDEPICTURE \d "http://blog.itpub.net/attachment/201408/11/29500582_14077391708Ti6.jpg" \* MERGEFORMATINET
3 下一步
INCLUDEPICTURE \d "http://blog.itpub.net/attachment/201408/11/29500582_1407739247Oq09.jpg" \* MERGEFORMATINET
4 下一步
INCLUDEPICTURE \d "http://blog.itpub.net/attachment/201408/11/29500582_1407739274XN5X.jpg" \* MERGEFORMATINET
5 下一步
INCLUDEPICTURE \d "http://blog.itpub.net/attachment/201408/11/29500582_14077393012nbo.png" \* MERGEFORMATINET
6 选择新林中的域
INCLUDEPICTURE \d "http://blog.itpub.net/attachment/201408/11/29500582_1407739354rKwn.png" \* MERGEFORMATINET
7 填入所要创建域的完整的域名
INCLUDEPICTURE \d "http://blog.itpub.net/attachment/201408/11/29500582_1407739377CMKf.png" \* MERGEFORMATINET
8 下一步
INCLUDEPICTURE \d "http://blog.itpub.net/attachment/201408/11/29500582_1407739509vRI0.png" \* MERGEFORMATINET
9 选择AD数据库和日志文件的存放位置
INCLUDEPICTURE \d "http://blog.itpub.net/attachment/201408/11/29500582_1407739565AxuX.png" \* MERGEFORMATINET
10 存放SYSVOL的存放位置(注意:一定要放在NTFS的分区中)
INCLUDEPICTURE \d "http://blog.itpub.net/attachment/201408/11/29500582_1407739603KBsU.png" \* MERGEFORMATINET
11 注意:AD是离不开DNS服务的,由于客户机增加域和登录域都须要把域名解析为IP地址,由于此时DC没有DNSserver,所以选择第二项让系统在创建DC的同一时候把DNS服务随之中的一个起安装上.当然你也能够安装DC后自己手动再安装和配置DNSserver(当时是您给会正确配置DNSserver),建议和DC一起让系统帮我们创建,由于省事
INCLUDEPICTURE \d "http://blog.itpub.net/attachment/201408/11/29500582_1407739851kpky.png" \* MERGEFORMATINET
12 选择兼容的模式。为了以后能够方便windows2000和2003兼容
INCLUDEPICTURE \d "http://blog.itpub.net/attachment/201408/11/29500582_1407739883TU02.jpg" \* MERGEFORMATINET
13 设置AD的还原password(为了以后对AD数据库做完备份,开机按F8进入AD还原模式须要的还原password,假设在此设置了password,一定切记):
INCLUDEPICTURE \d "http://blog.itpub.net/attachment/201408/11/29500582_14077399565Eoz.jpg" \* MERGEFORMATINET
14 下一步
INCLUDEPICTURE \d "http://blog.itpub.net/attachment/201408/11/29500582_1407740932ypMd.jpg" \* MERGEFORMATINET
15 下一步
INCLUDEPICTURE \d "http://blog.itpub.net/attachment/201408/11/29500582_1407741371FFnB.jpg" \* MERGEFORMATINET
16 须要挂载有关盘,才会自己主动安装DNS
INCLUDEPICTURE \d "http://blog.itpub.net/attachment/201408/11/29500582_1407741434D07d.jpg" \* MERGEFORMATINET
17 完毕
INCLUDEPICTURE \d "http://blog.itpub.net/attachment/201408/11/29500582_14077425689rnx.jpg" \* MERGEFORMATINET
18 重新启动
INCLUDEPICTURE \d "http://blog.itpub.net/attachment/201408/11/29500582_1407742596D44S.jpg" \* MERGEFORMATINET
19 安装完重起系统后登录界面为使用域中的管理员和password登录到域
INCLUDEPICTURE \d "http://blog.itpub.net/attachment/201408/11/29500582_14077426257kHs.png" \* MERGEFORMATINET
20 进入系统后查看计算机的状态
INCLUDEPICTURE \d "http://blog.itpub.net/attachment/201408/11/29500582_1407742652R7uD.png" \* MERGEFORMATINET
21查看管理工具会添加DNS和有关AD的工具,以及安全策略
INCLUDEPICTURE \d "http://blog.itpub.net/attachment/201408/11/29500582_1407742694MvtT.png" \* MERGEFORMATINET
22 点开用户和计算机域控管理界面
(创建域test.com完毕)
INCLUDEPICTURE \d "http://blog.itpub.net/attachment/201408/11/29500582_1407742729f3b0.png" \* MERGEFORMATINET
三:配置节点win1 和
节点win2的网络,并加入到域中
1 网络配置
win1 网络配置
网卡1:
DNS须要配置DC的IP
INCLUDEPICTURE \d "http://blog.itpub.net/attachment/201408/11/29500582_1407742769IgEN.jpg" \* MERGEFORMATINET
网卡2
INCLUDEPICTURE \d "http://blog.itpub.net/attachment/201408/11/29500582_1407742840A6l3.jpg" \* MERGEFORMATINET
“高级”里面配置一下禁用NetBIOS 不勾选前面两项
INCLUDEPICTURE \d "http://blog.itpub.net/attachment/201408/11/29500582_1407742943Fy03.jpg" \* MERGEFORMATINET
Win2网络设置
网卡1:
INCLUDEPICTURE \d "http://blog.itpub.net/attachment/201408/11/29500582_1407743537GJ7l.jpg" \* MERGEFORMATINET
网卡2
INCLUDEPICTURE \d "http://blog.itpub.net/attachment/201408/11/29500582_14077435693D38.png" \* MERGEFORMATINET
Win1 win2 进行同样的操作
2 更改计算机名。以及增加域test.com
INCLUDEPICTURE \d "http://blog.itpub.net/attachment/201408/11/29500582_1407743633bYBe.png" \* MERGEFORMATINET
3 属于域控制账号password
INCLUDEPICTURE \d "http://blog.itpub.net/attachment/201408/11/29500582_1407743676gbuo.jpg" \* MERGEFORMATINET
4 完毕后重新启动
INCLUDEPICTURE \d "http://blog.itpub.net/attachment/201408/11/29500582_1407743709vOFZ.jpg" \* MERGEFORMATINET
5 域登录
INCLUDEPICTURE \d "http://blog.itpub.net/attachment/201408/11/29500582_1407743759G5G5.png" \* MERGEFORMATINET
6 增加域后的计算机属性
INCLUDEPICTURE \d "http://blog.itpub.net/attachment/201408/11/29500582_1407743787p33j.png" \* MERGEFORMATINET
Win2 也是一样的步骤增加到域中
6 在域控主机192.168.9.176中能够看到新加入的成员
INCLUDEPICTURE \d "http://blog.itpub.net/attachment/201408/11/29500582_1407743817WsaU.png" \* MERGEFORMATINET
在步骤五中可能会提示报错指定域的名称或安全标识(SID)与该域的信任信息不一致
(由于指定域的名称或安全标识(SID)与该域的信任信息不一致)须要改动
改动方法:
1 .从安装盘中 support\tools\deploy.cab中提取sysprep.exe和setuppcl.exe 到桌面
INCLUDEPICTURE \d "http://blog.itpub.net/attachment/201408/11/29500582_1407743850SDwD.png" \* MERGEFORMATINET
INCLUDEPICTURE \d "http://blog.itpub.net/attachment/201408/11/29500582_1407743871Py6C.png" \* MERGEFORMATINET
INCLUDEPICTURE \d "http://blog.itpub.net/attachment/201408/11/29500582_1407743888vP01.png" \* MERGEFORMATINET
2 执行sysprep.exe"确定"開始又一次封装
往下就是下一步下一步安装就可以 (不能远程操作。封装一次就可以,不作详述了)
四:安装win server2003集群
Win1节点上进行操作,关闭其它节点
1 依次单击“開始”、“全部程序”和“管理工具”,然后单击“群集管理器”
INCLUDEPICTURE \d "http://blog.itpub.net/attachment/201408/11/29500582_14077439293FFp.png" \* MERGEFORMATINET
2 下一步
INCLUDEPICTURE \d "http://blog.itpub.net/attachment/201408/11/29500582_14077440578D3X.png" \* MERGEFORMATINET
3 选择域(test.com),键入群集名win2003cluster。下一步
INCLUDEPICTURE \d "http://blog.itpub.net/attachment/201408/11/29500582_1407744070JRQx.png" \* MERGEFORMATINET
4 机器名输入 win1。下一步
INCLUDEPICTURE \d "http://blog.itpub.net/attachment/201408/11/29500582_1407744154ehw0.png" \* MERGEFORMATINET
5 这一步是检測硬件环境是否符合群集要求。
假设这一步出现错误提示,能够点击“查看日志”。依照提示检查网络设置和磁盘阵列连接是否正确
INCLUDEPICTURE \d "http://blog.itpub.net/attachment/201408/11/29500582_1407744230SSkp.gif" \* MERGEFORMATINET
1 通过下一步,输入集群的IP地址。操作系统虚拟server的IP 地址
INCLUDEPICTURE \d "http://blog.itpub.net/attachment/201408/11/29500582_1407744249x6HR.gif" \* MERGEFORMATINET
6 输入域username和password。这里使用的是域管理员administrator
INCLUDEPICTURE \d "http://blog.itpub.net/attachment/201408/11/29500582_1407744263857b.gif" \* MERGEFORMATINET
说明:在项目实施时一定不能用域的管理员administrator。应该要求用户网络管理员提供一个专门管理
群集的新用户。这个新用户在各个群集节点中应该在本地管理员组(local administrator group)中。
7 点击“仲裁”button,在弹出的窗体中选择仲裁资源。
我们选择磁盘Q(QDisk)作为仲裁盘
INCLUDEPICTURE \d "http://blog.itpub.net/attachment/201408/11/29500582_1407744272ks9Q.gif" \* MERGEFORMATINET
8
INCLUDEPICTURE \d "http://blog.itpub.net/attachment/201408/11/29500582_1407744294mA7n.gif" \* MERGEFORMATINET
9 完毕
INCLUDEPICTURE \d "http://blog.itpub.net/attachment/201408/11/29500582_1407744319FJ6n.gif" \* MERGEFORMATINET
10 群集 win2003cluster 已经配置成功。可是眼下仅仅有win1。我们须要将第二个节点增加。构建出容灾群集。
INCLUDEPICTURE \d "http://blog.itpub.net/attachment/201408/11/29500582_1407744358n8K5.gif" \* MERGEFORMATINET
11 新建节点
INCLUDEPICTURE \d "http://blog.itpub.net/attachment/201408/11/29500582_1407744371gd4L.gif" \* MERGEFORMATINET
12 下一步
INCLUDEPICTURE \d "http://blog.itpub.net/attachment/201408/11/29500582_1407744385peeG.gif" \* MERGEFORMATINET
13 输入“win2”
INCLUDEPICTURE \d "http://blog.itpub.net/attachment/201408/11/29500582_1407744396zcBj.png" \* MERGEFORMATINET
14 下一步
INCLUDEPICTURE \d "http://blog.itpub.net/attachment/201408/11/29500582_1407744468rsZ5.gif" \* MERGEFORMATINET
15 下一步
INCLUDEPICTURE \d "http://blog.itpub.net/attachment/201408/11/29500582_1407744481R038.gif" \* MERGEFORMATINET
16 下一步
INCLUDEPICTURE \d "http://blog.itpub.net/attachment/201408/11/29500582_1407744502HRQ7.gif" \* MERGEFORMATINET
17 下一步
INCLUDEPICTURE \d "http://blog.itpub.net/attachment/201408/11/29500582_1407744520a8xd.gif" \* MERGEFORMATINET
Win2上的共享磁盘QDisk 和ClusterData 已经被win1 所独占。这个警告不用理会
18 下一步,完毕win2节点加入
INCLUDEPICTURE \d "http://blog.itpub.net/attachment/201408/11/29500582_1407744536ppLl.gif" \* MERGEFORMATINET
19 操作系统容灾群集已经安装完成。
INCLUDEPICTURE \d "http://blog.itpub.net/attachment/201408/11/29500582_1407744552ya8d.gif" \* MERGEFORMATINET
20 配置群集网络通信
右键选择群集“属性”
INCLUDEPICTURE \d "http://blog.itpub.net/attachment/201408/11/29500582_1407744587KWB4.gif" \* MERGEFORMATINET
21 本地连接2 -à属性
INCLUDEPICTURE \d "http://blog.itpub.net/attachment/201408/11/29500582_1407744602x808.png" \* MERGEFORMATINET
22 专门用于群集节点内部通讯使用的
INCLUDEPICTURE \d "http://blog.itpub.net/attachment/201408/11/29500582_14077446226FNs.png" \* MERGEFORMATINET
23确保private 在public 上面(private 优先级更高)。确定完毕网络设置。
INCLUDEPICTURE \d "http://blog.itpub.net/attachment/201408/11/29500582_1407744651WcyM.jpg" \* MERGEFORMATINET
24 測试操作系统群集
INCLUDEPICTURE \d "http://blog.itpub.net/attachment/201408/11/29500582_1407744660XhOo.gif" \* MERGEFORMATINET
25 点击移动组能够相互切换资源
INCLUDEPICTURE \d "http://blog.itpub.net/attachment/201408/11/29500582_1407744686wgRC.png" \* MERGEFORMATINET
26为了測试群集的可用性,在win1 上右键选择“停止群集服务”
INCLUDEPICTURE \d "http://blog.itpub.net/attachment/201408/11/29500582_1407744699WCOe.png" \* MERGEFORMATINET
27 Win2 接管了资源。成为眼下群集的工作节点
INCLUDEPICTURE \d "http://blog.itpub.net/attachment/201408/11/29500582_1407744712kFdi.png" \* MERGEFORMATINET
INCLUDEPICTURE \d "http://blog.itpub.net/attachment/201408/11/29500582_1407744730Lazx.png" \* MERGEFORMATINET
28 又一次启动win1
INCLUDEPICTURE \d "http://blog.itpub.net/attachment/201408/11/29500582_1407744745g883.jpg" \* MERGEFORMATINET
Windowns server2003集群完毕配置
五 :配置SQL Server 2005 群集
1说明:假设群集环境不须要安装报表服务(SQL Server Reporting Services),能够忽略此步骤。
安装IIS
2 打开组件服务---计算机---我的电脑---属性—安全配置,选择administrator 用户登陆,输入administrator
的password。
这一步是必须的,否则在安装SQL server 2005 的时候会出现COM+错误。
INCLUDEPICTURE \d "http://blog.itpub.net/attachment/201408/11/29500582_14077447844cHJ.gif" \* MERGEFORMATINET
INCLUDEPICTURE \d "http://blog.itpub.net/attachment/201408/11/29500582_14077447977j94.gif" \* MERGEFORMATINET
3 配置MSDTC 到资源组中
进入 CMD 执行
net stop msdtc
msdtc –uninstall
msdtc –install
net start msdtc
此操作之后在群集组直接出现 MSDTC 资源
假设出现msdtc无法正常使用,也能够用此方法又一次配置
一般性添加MSDTC资源方法:
INCLUDEPICTURE \d "http://blog.itpub.net/attachment/201408/11/29500582_140774481409IC.png" \* MERGEFORMATINET
“资源类型”选择“分布式事务协调器(DTC)”
INCLUDEPICTURE \d "http://blog.itpub.net/attachment/201408/11/29500582_14077448256dP6.gif" \* MERGEFORMATINET
INCLUDEPICTURE \d "http://blog.itpub.net/attachment/201408/11/29500582_1407744854jfNM.gif" \* MERGEFORMATINET
选择仲裁盘和群集名作为其依存资源。完毕
INCLUDEPICTURE \d "http://blog.itpub.net/attachment/201408/11/29500582_1407744867nQMJ.gif" \* MERGEFORMATINET
确定,完毕MSDTC 配置。
INCLUDEPICTURE \d "http://blog.itpub.net/attachment/201408/11/29500582_1407744885M46X.gif" \* MERGEFORMATINET
4 注意,在安装SQL server 2005 前, 假设主机是多核心的处理器。请改动boot.ini 文件。把CPU 核心数
改为1
.能够在msconfig 选项中直接选择改动 ,这个是2005 本身的bug,等完毕安装后打SP3 或更高的补丁。
补丁打完之后可改动回正常核心数量
INCLUDEPICTURE \d "http://blog.itpub.net/attachment/201408/11/29500582_1407744896HzT9.gif" \* MERGEFORMATINET
5安装SQL Server 2005
INCLUDEPICTURE \d "http://blog.itpub.net/attachment/201408/11/29500582_1407744939QYbK.png" \* MERGEFORMATINET
下一步
INCLUDEPICTURE \d "http://blog.itpub.net/attachment/201408/11/29500582_14077449503Df3.png" \* MERGEFORMATINET
INCLUDEPICTURE \d "http://blog.itpub.net/attachment/201408/11/29500582_1407744968I81t.png" \* MERGEFORMATINET
下一步(步骤2处理不好,会出现com+错误)
INCLUDEPICTURE \d "http://blog.itpub.net/attachment/201408/11/29500582_14077449795J34.png" \* MERGEFORMATINET
開始安装必备组件
INCLUDEPICTURE \d "http://blog.itpub.net/attachment/201408/11/29500582_1407744989AIgW.png" \* MERGEFORMATINET
系统配置检查
INCLUDEPICTURE \d "http://blog.itpub.net/attachment/201408/11/29500582_1407745003rYzQ.png" \* MERGEFORMATINET
INCLUDEPICTURE \d "http://blog.itpub.net/attachment/201408/11/29500582_14077450180cuh.gif" \* MERGEFORMATINET
输入注冊信息
INCLUDEPICTURE \d "http://blog.itpub.net/attachment/201408/11/29500582_1407745031baoA.png" \* MERGEFORMATINET
选择要安装的组件
INCLUDEPICTURE \d "http://blog.itpub.net/attachment/201408/11/29500582_1407745057vz41.png" \* MERGEFORMATINET
(所提供光盘仅仅有SQL Server Database Services组件)
输入实例名:MSSQL2005
INCLUDEPICTURE \d "http://blog.itpub.net/attachment/201408/11/29500582_1407745072podT.png" \* MERGEFORMATINET
输入虚拟server的名称:SH-sqldbc
INCLUDEPICTURE \d "http://blog.itpub.net/attachment/201408/11/29500582_1407745107ArP0.png" \* MERGEFORMATINET
输入虚拟server名称。下一步(差别于集群虚拟serverIP)
INCLUDEPICTURE \d "http://blog.itpub.net/attachment/201408/11/29500582_1407745121U1uU.gif" \* MERGEFORMATINET
为虚拟server指定IP 地址,点击“加入”
INCLUDEPICTURE \d "http://blog.itpub.net/attachment/201408/11/29500582_1407745126XcS5.gif" \* MERGEFORMATINET
为数据文件指定安装路径,请注意这里的S
盘是数据存储盘(ClusterData),千万不要把数据文件安装到仲裁盘(QDisk)上。
INCLUDEPICTURE \d "http://blog.itpub.net/attachment/201408/11/29500582_1407745139mnRW.gif" \* MERGEFORMATINET
能够在集群管理器上分一下组
INCLUDEPICTURE \d "http://blog.itpub.net/attachment/201408/11/29500582_1407745149zX6d.gif" \* MERGEFORMATINET
该用户事实上应该是cluster,假设用administrator,会造成不能在远程计算机安装(后面述改动方法,也能够之前在域中建好用户)
INCLUDEPICTURE \d "http://blog.itpub.net/attachment/201408/11/29500582_1407745155lTGS.png" \* MERGEFORMATINET
INCLUDEPICTURE \d "http://blog.itpub.net/attachment/201408/11/29500582_1407745190BL3x.gif" \* MERGEFORMATINET
INCLUDEPICTURE \d "http://blog.itpub.net/attachment/201408/11/29500582_14077451973Bma.png" \* MERGEFORMATINET
INCLUDEPICTURE \d "http://blog.itpub.net/attachment/201408/11/29500582_1407745210d8k8.png" \* MERGEFORMATINET
INCLUDEPICTURE \d "http://blog.itpub.net/attachment/201408/11/29500582_14077452234KZ9.png" \* MERGEFORMATINET
选择混合模式验证
INCLUDEPICTURE \d "http://blog.itpub.net/attachment/201408/11/29500582_1407745234SblE.png" \* MERGEFORMATINET
INCLUDEPICTURE \d "http://blog.itpub.net/attachment/201408/11/29500582_1407745246Aqpq.png" \* MERGEFORMATINET
INCLUDEPICTURE \d "http://blog.itpub.net/attachment/201408/11/29500582_1407745262pPPB.png" \* MERGEFORMATINET
INCLUDEPICTURE \d "http://blog.itpub.net/attachment/201408/11/29500582_1407745273LV55.png" \* MERGEFORMATINET
開始安装
INCLUDEPICTURE \d "http://blog.itpub.net/attachment/201408/11/29500582_1407745288YFsc.png" \* MERGEFORMATINET
INCLUDEPICTURE \d "http://blog.itpub.net/attachment/201408/11/29500582_1407745350t0Wp.png" \* MERGEFORMATINET
安装程序。
INCLUDEPICTURE \d "http://blog.itpub.net/attachment/201408/11/29500582_1407745365spAH.png" \* MERGEFORMATINET
完毕后在还有一个节点安装。
六:解决远程不能安装问题,创建swg域用户,托付管理
1 打开域控制管理
INCLUDEPICTURE \d "http://blog.itpub.net/attachment/201408/11/29500582_14077453825h6y.png" \* MERGEFORMATINET
2 新建用户
INCLUDEPICTURE \d "http://blog.itpub.net/attachment/201408/11/29500582_1407745628BIXb.png" \* MERGEFORMATINET
3 加入到组
INCLUDEPICTURE \d "http://blog.itpub.net/attachment/201408/11/29500582_1407745724heZa.png" \* MERGEFORMATINET
4 加入到administrator组中
INCLUDEPICTURE \d "http://blog.itpub.net/attachment/201408/11/29500582_1407745737U5xo.png" \* MERGEFORMATINET
5 查看属性
INCLUDEPICTURE \d "http://blog.itpub.net/attachment/201408/11/29500582_1407745745VMv1.jpg" \* MERGEFORMATINET
6 win1 win2 节点上加用户权限
INCLUDEPICTURE \d "http://blog.itpub.net/attachment/201408/11/29500582_1407745754s7Nj.jpg" \* MERGEFORMATINET
7 加入到swg组
INCLUDEPICTURE \d "http://blog.itpub.net/attachment/201408/11/29500582_1407745762t1Z5.jpg" \* MERGEFORMATINET
8 最后所实用swg用户等test.com域上的主机win1,win2
INCLUDEPICTURE \d "http://blog.itpub.net/attachment/201408/11/29500582_1407745778Klvg.jpg" \* MERGEFORMATINET
七:安装完毕后測试
1 win1上查看添加的资源
INCLUDEPICTURE \d "http://blog.itpub.net/attachment/201408/11/29500582_1407745798o54e.jpg" \* MERGEFORMATINET
2 停止当中win1节点,服务自己主动转移
INCLUDEPICTURE \d "http://blog.itpub.net/attachment/201408/11/29500582_1407745807BB77.jpg" \* MERGEFORMATINET
INCLUDEPICTURE \d "http://blog.itpub.net/attachment/201408/11/29500582_1407745813HCSC.jpg" \* MERGEFORMATINET
八:訪问数据库。导入数据
1 右键“数据库” “附加”
INCLUDEPICTURE \d "http://blog.itpub.net/attachment/201408/11/29500582_1407745821o56o.jpg" \* MERGEFORMATINET
2 导入整个数据库
INCLUDEPICTURE \d "http://blog.itpub.net/attachment/201408/11/29500582_1407745830HtaT.jpg" \* MERGEFORMATINET
3 导入完毕后。显示数据
INCLUDEPICTURE \d "http://blog.itpub.net/attachment/201408/11/29500582_1407745846B7dG.jpg" \* MERGEFORMATINET
4 做故障转移时,数据库能够正常被訪问
INCLUDEPICTURE \d "http://blog.itpub.net/attachment/201408/11/29500582_1407745935DEw2.jpg" \* MERGEFORMATINET