In this example SERVER 1 is the server bieng linked to.
SERVER 2 is the server bieng linked from.
STEP 1:
The first thing to set up is the SQL SERVER 1 to allow incoming connections from a non Windows Authenticated account – if not already done so.
In SQL server 2005 Management Studio, right click on the database at the top [...]