Thank you, Andy, for the article and thank you, ehancen, for the pointing out the bug in the BIML.

My local instance of SQL Server is a named instance, so I had to change from (local) server name to SERVER\INSTANCE, but it didn't work. Then I realized that I needed to double up on the slashes: SERVER\\INSTANCE, however it still didn't work (this time with a different error). I eventually connected to a server with a default instance and everything worked, but it would be interesting to know how to connect to named instances.

Thank you!