Post reply

SQL Server replication

  • August 31, 2009 at 11:36 am

    #225560

    Let me explain the environment.

    primary server has SQL Server 2005

    secondary server has SQL server 2005.

    Now i am trying to replicate data from primary server to secondary server.Both the servers are on a different domain, so i have to set a TCP/IP connection both the SQL Servers. (We although have a VPN connection). so my only question is how do i set a TCP/IP connection both the SQL Servers.

    Please reply.

    Thank you.

  • August 31, 2009 at 2:03 pm

    #1047124

    any clues friends?

  • September 3, 2009 at 6:22 am

    #1048672

    Read http://support.microsoft.com/kb/321822 as stated in http://sqlserver-qa.net/blogs/replication/archive/2007/12/18/2974.aspx

    HTH!

    MJ

  • September 3, 2009 at 7:45 am

    #1048731

    You need to check out a few different things.

    1. Make sure your SQL Servers can connect to each other through the firewall. You should be able to telnet to each server on the port SQL is running on.

    You will need to create an alias on each of the servers so you can resolve with the server name and instance name.

    2. What kind of replication are you setting up?

    Snapshot

    Snapshot with Transactional

    3. Are you using a distribution server?

    Are you setting up Push or Pull Subscriptions?

    If you have an alias and firewall settings are correct you should be able to connect to the servers through management studio with a TCP/IP connection.

  • September 3, 2009 at 7:58 am

    #1048744

    "...Both the servers are on a different domain..."

    As I recall, you'll also need an administrative level SQL Login on both servers with the same name & password.

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply