I'm trying to setup transaction replication using a static IP.
I have 2 servers: one has a static IP but other one does not. In this case can I do replication. I am able to connect to the static IP SQL Server from the other server. I also created an alias for the static IP.
I set most of it up, but at the end I got an error on the subscriber:
And if I click on Start then this error appears:
Best Answer
This means this job is already runing. You might want to stop it and start it again, if you really need to re-run it.
Instead:
for a basic quick verification
I check the log reader on the publication, see if the log reader agent is reading the transactions and passing them to the distributor.
second thing
I go to the publication database and find out who is the distributor
sp_helpdistributor
then I connect to the distributor you got above and run the following query to find out what is going on.
hope this helps