That's a good question. Not sure how much you will be able to do through SSMS.

You might be able to set and test it programmatically. If so you can probably setup a Powershell script to do what you want.

Data Sources and Connection Methods