How to connect SQL Server 2008 with SQL Server 2005

Source: Internet
Author: User
Tags management studio

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:

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.