How to connect SQL Server 2008 with SQL Server 2005

Originally using the SQL Server 2005 database, and later because the job needs to be upgraded to the SQL Server 2008 development version, the upgrade process is simple, basically no problem

The main point here is how to connect SQL Server 2008 with SQL Server, the process is actually very simple, the main focus is two

1 SQL Server The SP4 patch needs to be patched

See Management Studio version 9.00.50000, if not patched, prompts "only SQL Server 2000 and 2005 databases can be managed"

2 SQL Server 2008 if installed on Windows 2008, add the running program through the firewall.

3 The SQL Server 2008 Configuration tool to configure the TCP/IP protocol needs to be started.

Main 1.2 Two point OK, basic can connect successfully. The 3rd is for reminders only;

As shown in the following illustration: