I'm trying to set up translactional replication from our local server to our host sql database and need a little help getting there.
So far I have successfuly set up a local public replication and now need to set up a push subscription to the remote database. When I go through the new subscription wizard in management studio I do not see the remote database in the window where you choose a subscriber.
I have already registered the remote server and am connected to it..I can see it in the object explorer.
How to I connect to it?