Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Hitesh Shah
Yak Posting Veteran
80 Posts |
 Posted - 2008-04-07 : 03:16:07
|
| We have installed SQL2k5 sP2 on node 1 successfully . Node failovers work successfully between the node . However i dont c SMO , SRS SIS etc in 2nd node . I want to install the same . I put the original dvd , it says later viersion installed and installing SP2 client tools finishes successfully but does not add SMO on 2nd machine . How do I enable all heseon 2nd node without uninstalling everything . If i have unistall , then wht all precaustions (new order of action , clearing what registries ) need to be taken care off . |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-04-07 : 23:47:57
|
| Uninstall sql support files from node 1 and reinstall from original dvd, since sp level info is stored there. |
 |
|
|
Hitesh Shah
Yak Posting Veteran
80 Posts |
Posted - 2008-04-08 : 00:06:33
|
| Just to clarify, I can re-install on 2nd node the components not installed therein after clearing the SP information . Further Do I need to install SP2 again on node 2 . And finally will there be any issue with other available services on node 2 |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-04-08 : 23:23:22
|
| Yes, need apply same sp on node 2. |
|
|
|
|
|
|
adding SMO ,SRS ,SIS etc on 2nd node of sql clus