I was researching the possibility to upload a WSP file remotely, without logon access to any SP servers on a farm.
This is possible with the SPFarm.Open method, as long as you have access to the database. Firewalls should also allow access.
I have created a simple solution to demonstrate this: go to this page and click Download
The code to achieve this is fairly simple:
- string connString = txtConnectionString.Text;
- SPFarm remoteFarm = SPFarm.Open(connString);
Hope this helps!