The target service name could not be found. Server version compatibility problem? RRS feed

  • Question

  • Hi,

    I have two remote SQL Servers. One initiator another one is target. 

    Now I need to move target to new server and new database just with SAME database name.

    I have recreated all SB objects on new target machine, but once I start conversation with new target I get:

    The target service name could not be found.

    If I alter Route back to old server all works fine again.

    I am sure target names match on old and new targets, all config looks the same between servers. 

    The only difference is between server - old target is SQL 2016 and new target is SQL 2017.

    Could this cause this issue?

    Any other ideas how to detect the problem if version compatibility should not cause the issue?

    We user certificate authentication

    Many thanks

    • Edited by Natip Friday, May 10, 2019 3:36 PM
    Friday, May 10, 2019 2:49 PM

All replies

  • I have not tried moving from SQL 2016 and SQL 2017, but I find it highly unlikely that the version matter.

    I would rather look into ports, firewalls and those sorts of things.

    Exactly where in the chain do you get this error?

    Erland Sommarskog, SQL Server MVP,

    Saturday, May 11, 2019 8:08 PM
  • It looks like issue on my end as broker was still conversing with old server I had to manually clear and end all conversations.

    thanks Erland

    Monday, May 13, 2019 11:05 AM