-
MS SQL 2005 cluster install
-
Today I had loads of fun installing the SQL on a cluster. While the installation procedure is quite simple, preparation and any kind of debugging is certainly not. If you prepare at all and if you have a windows admin handling the OS part for you there really shouldnt be any surprises right? Wrong!
I got through all prep/add and configure MSDTC/install anything thats missing/adjust permissions stuff and got to the point of the actuall installation. It failed on the passive node with 'access denied on setup.exe' or something similar in the task scheduler log. Now, I did check if the service is running and everything I did was with the same windows account (administrator offcourse). Tried some fancy stuff and went to install process again. Failed with same error. I really really wasnt happy at that point.
Third time it went through without any problems. Why? Well, I had a remote connection open on the passive node. After I logged off, the installation worked. Why? I have no idea, feel free to educate me. What does the remote connection on pasive has with installation on active (okay so its actually starting the install on pasive as well but so what)?
After that everything went fine, installed additional services, sp2 and other stuff. I just hope it still works tomorrow :).