SQL Server Performance Forum – Threads Archive

Installing SP3a on second node

I have a active/passive cluster with W2K Adv. and SQL 2000.
I was having the issue with setting up SQL on the second node. I fixed issue
by installing directly onto the second node. But their is no option with th
e sp3a to install onto the second node locally. The same issue that happened
with trying to remote install with the primary node. The install failed bec
ause of a timeout issue. Error 121. All of my settings and correct accounts
are setup. The person who told me to install directly on the second node to
install SQL stated that this was actually a known problem. What is the fix f
or the service packs if you cannot install remotely? It looks like sp3a inst
alled correctly because when I ran query analyzer the version that showed up
was sp3a. Any comments would be appreciated. Thanks,
dcaldwell

---

I had a similar problem. I first installed on node 1, and the SP is supposed to insstall on both nodes, but it doesn’t. So after installing it on node 1, I then just ran the install again for node 2. It seemed to work this way. —————————–
Brad M. McGehee, MVP
Webmaster
SQL-Server-Performance.Com

---

Did you have to move the sql resources over to install the sp on the second node? How did you setup the second node install?
Thanks
dcaldwell

---

Yes, I moved the resources to the second node, and then ran the SP3a setup program. —————————–
Brad M. McGehee, MVP
Webmaster
SQL-Server-Performance.Com

---

]]>