Our test had the 2017 SQL Database and Adagio database on the same machine. Let's call it the Adagio Server, and the provider string worked for setting up the Linked Server.

You might want to give that a try.

SQL 2017 won't have any problem with a remote machine accessing the SQL database on the Adagio Server.