Rotating Header Image

Something Old, Something New

OK so I have a problem…

No not that kind of problem….

My problem was that I had replication configured (SQL 2000 – Publisher to SQL 2008 – Distributor/Subscriber) and had to change the default port number on my Distributor/Subscriber. 

Guess what happened?

Yup…. replication failed.

I tried to play around with some network settings, cleared the DNS on both machines, etc and nothing seemed to work.

I finally found a solution / workaround.

The reason I say solution / workaround is that I’m hoping there is a “better” solution so that I can call my “solution” a workaround and update this post with the REAL solution.

What I did to get this to work is that on the publisher server (my SQL Server 2000 box) I created an alias to my subscriber server (my SQL Server 2008 box).  In the alias I specified the IP address and port.

Guess what happened?

Like I said… I’m hoping one of my (much smarter than me) SQL Friends is gonna slap me upside the head with a bettter solution.

I also tested that if I publish from SQL 2005, SQL 2008, and SQL 2008 R2 that this is still the case (having to create and use an alias on the publisher to connect to the distributor/subscriber)

UPDATE:

@unclebiguns – Yes the SQL Browser Service is running on the SQL 2008 box.

Enjoy!! (Follow me on Twitter: @ColinStasiuk)

Post to Twitter Post to Delicious Post to Digg Post to StumbleUpon

2 Comments

  1. [...] Colin Stasiuk had the replication configured (SQL 2000 – Publisher to SQL 2008 – Distributor/Subscriber) and had to change the default port number on my Distributor/Subscriber. But then guess what happened? [...]

  2. [...] Colin Stasiuk had the replication configured (SQL 2000 – Publisher to SQL 2008 – Distributor/Subscriber) and had to change the default port number on my Distributor/Subscriber. But then guess what happened? [...]

Leave a Reply

Twitter links powered by Tweet This v1.6.1, a WordPress plugin for Twitter.