CODEWITHSUNDEEP
sql-serverreplicationdatabase-replicationtransactional-replication
plasteezy
plasteezy

Reputation: 317

How do I add a subscriber to a SQL Server Replication Publisher

In entering the credentials for the remote server, I get an error asking for the actual server name. What I usually provide is [IP Address] as the server name but I get an error asking for the actual server name so I provide [IP Address]\[ServerName] but it still does not work. Any help?

Upvotes: 0

Views: 634

Answers (1)

Ben Thul
Ben Thul

Reputation: 32707

Replication requires that you use the actual server names in all parts of the setup. In order to find the server name you should be using, do select @@servername on each server involved (publisher, distributor, and subscriber).

Upvotes: 1

Related Questions