locked
Linked server between SQL Express RRS feed

  • Question

  •  

    HI,

    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

Answers