INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Jobs

Sql Server 2008 Replication Agent message code 20084

Sql Server 2008 Replication Agent message code 20084

(OP)
I replaced a computer at a remote location (Computer R) and I can no longer get replication to work with my local server (computer L), computer R is running windows 7 Professional with Sql Server 2008 R2, the computer it replaced was running Windows Server 2005 and Sql Server 2008 R2. Replication worked perfectly on the old computer across a vpn connection. The server it is connecting to is running Windows Server 2008 and Sql Server 2008 R2

Both computers can connect to each other in SSMS and can configure replication with no problem, when I run the subscription I get the error "Agent Message Code 20084. Could not connect to Distributor." I know this has something to do with the VPN connection because if I connect the computers locally on a lan replication works perfectly. I also have computer L setup as a publisher and computer R as a subscriber and replication works perfectly across the vpn connection it just doesn't work the other way.

Any suggestions before I pull out all of my hair would be appreciated

RE: Sql Server 2008 Replication Agent message code 20084

I am going to assume this is a pull subscription. Have you tried configuring this as a push subscription? One other silly question: Is the distributor a different machine/instance from R and L?

RE: Sql Server 2008 Replication Agent message code 20084

(OP)
Thank you for the response, yes I have tried both pull and push subscriptions with the same result. Not sure what you mean by "Is the distributor a different machine/instance from R and L?" The distributor is computer R and the subscriber is computer L

RE: Sql Server 2008 Replication Agent message code 20084

Can this be a permissions issue? Do the SQL Agent accounts have rights to log in to the other machine? Alternatively, when you set up replication, you get prompted to supply a user to handle the replication. If this was set up, what rights does it have on either machine?

RE: Sql Server 2008 Replication Agent message code 20084

connecting through a vpn - are the 2 computers in this case on the same domain? and is the vpn connection allowing the required ports in the direction you need? e.g. it may be blocking out but allowing IN so it would fail in one case, but allow on the other

Regards

Frederico Fonseca
SysSoft Integrated Ltd
www.syssoft-int.com

FAQ219-2884: How Do I Get Great Answers To my Tek-Tips Questions?
FAQ181-2886: How can I maximize my chances of getting an answer?

RE: Sql Server 2008 Replication Agent message code 20084

(OP)
Computer L is on a Domain computer R is on a WorkGroup, Nothing has changed with the VPN connection so all necessary ports should be open, this setup worked perfectly before I replaced Computer R. There may be something on Computer R "Windows 7 Pro" that is not allowing the connection but I sure can't find it, the firewall is turned off.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Resources

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close