0

I'm trying to replicate from SQL Server 2008 to a remote SQL Server 2005. I can't add subscribers with SQL Login, and I'm getting this error.

enter image description here

I tried adding aliases, editing hosts file, adding the subscriber directly form T-SQL with no success.

Ahmed Khalaf
  • 1,401
  • 2
  • 15
  • 29
  • The error message is extremely clear. You cannot do it like this. It clearly states in the error message that what you are trying to do is not possible. What part of it are you not understanding? – Sean Lange Dec 02 '15 at 19:32
  • What the error message implies is that remote replication is not supported altogether in sql server. If it's true, it's really surprising. So, I'm looking for workarounds or alternate solutions. – Ahmed Khalaf Dec 02 '15 at 19:37
  • Try this article as a great starting place. https://msdn.microsoft.com/en-us/library/ms151319.aspx – Sean Lange Dec 02 '15 at 20:04
  • 1
    Possible duplicate of [Sql Server replication requires the actual server name to make a connection to the server](http://stackoverflow.com/questions/8212032/sql-server-replication-requires-the-actual-server-name-to-make-a-connection-to-t) – Matt Gibson Dec 02 '15 at 21:47

0 Answers0