July 9, 2019 at 9:03 pm
Update... If I add the default port number to the end of the Data source field on node A I can get the linked server to work. Port number is not needed on node B so I'm not sure yet what is allowing B to communicate properly and A not to allow it.
July 9, 2019 at 9:38 pm
Figured out the default port for the SQL Native Client was incorrectly set. Case closed.
July 9, 2019 at 9:38 pm
I would check to make sure all the servers in the mix are 2017 with CU6. And I'm not sure which port you are referencing with the port number but it could be related to how you set up the listener with the port number - just as referenced in step 4 in the example of the documentation to set this up:
Set up replication distribution database in Always On availability group
In terms of the differences with SSMS and t-sql who knows. It really depends on what version of SSMS. It's not worth trying to figure those SSMS issues out other than to try the current version of SSMS and hope it doesn't break anything else or remove functionality you were used to having available. You could try to run an extended events session or a trace to try to see how the two are done differently.
Sue
Viewing 3 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply