Linked server between SQL Express RRS feed

  • Question



    I have problem to setup linked servers between two SQL SERVER EXPRESS:

    I have two sql database sitting on SQL EXPRESS servers. I need to synchronize two tables between the two databases. For that I created triggers to update the tables mutually.

    Let say: Server C4 and C2.

    I need from the trigger in C4 to reference the table in C2, so I have to create linked servers.


    Both instances are configured to use TCP/IP and to allow remote connection. For both of them I’m using “sa” and “sapwd” to connect. I can’t connect otherwise


    From SQL server 2005 I can create linked servers to C4 andC2.

    I didn’t success to create from C4 linked server to C2 and vs. 


    How can I achieve this ? How can I setup the linked using a scripts?


    Thanks, I will appreciate a help if had deal with a similar problem


    database developper
    Friday, September 26, 2008 8:28 PM