My boss is on vacation and I'm supposed to have this installation script done by the time he returns. Unfortunately, I've realized that the script I developed won't work on the target server setup and I don't know enough about it to know how to figure it out.
The server is running SQL Server 2008 R2 standard SP1, and my installation script is PowerShell v1 and requires access to two snapins on the database server and one snapin on the webserver.
He has the webserver separated from the dataserver in such a way that the dataserver is accessible only via RDP from the webserver desktop. The script I developed on my setup works fine, but that is because my webserver and dataserver are not separated. On his setup, I can run the DB part of the installation on the dataserver successfully, and the website part on the webserver successfully, but he expects that I will have a single script for the installation.
I can't figure out how to get the two instances to talk to each other to make this happen. Is it possible to make this work as a single script? I don't even know how to start.