Rob Bamforth's Blog
Java, SQL, MySQL, Networking, SQL Server, PHP, COM, DBA + ODBC

Posts Tagged ‘connect server’

SQL Server 2005 Linked Server

October 21, 2008

 
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 [...]