I have been trying different approaches to install SQL Server clusters with PS using various methods like invoke-command, creating a scheduled task, running a batch file, etc. without success. I can install the primary node, but am running into problems when I am trying to do the other nodes. Regardless of whether I've copied all installation files locally or accessed them via UNC, the issue remains that when I log on interactively with the machine, I can use what I have to do a successful node installation. When I try to do it without interaction, it fails. The SQL installation method is via command line using a config. file and the Addnode installation parameter.
Rather than describe all the failed attempts, I'm hoping I can describe the need & some of the issues I've encountered and someone can suggest a solution.
1. script must run as elevated
Issues encountered so far:
batch file runs (invoke-command), returns process, but fails immediately (no log info)
Let me know if you need more information.
Have you looked into doing this with DSC? It provides specific resources for HA clusters.
You must be logged in to reply to this topic.