This is promising. It gives me an error though: "Missing ADSPROF". I replaced both "D:\DataFolder" entries you had with the data folders I'm using, both using drive letters and UNC path (I'm assuming I'm supposed to do that) and confirmed that ADSPROF is in the data folder.

Interestingly, I tried the DNS connection again and was able to expand the Catalogs to show a default db and under that I'm seeing the table that I'm after, APVendorMaster__ap92avms, but it says that it "contains no columns that can be selected or the current user does not have permissions on that object". Is this expected? I've confirmed that the user that SQL server is running under has full permissions to the entire drive.