After installing VS 2010, MS SQL Server 2008 is installed automatically. MS SQL Server 2008 has improved considerably over MS SQL Server 2005 and is more convenient to use. However, it was found that the SQL Server Management Studio 2005 version could not open the MS SQL Server 2008 Library and decided to download and install SQL Server Management Studio 2008 from the Web.
1. Download SQL Server Management Studio 2008 from the Web.
The download URL is as follows: Http://www.microsoft.com/downloads/zh-cn/details.aspx?familyid=08E52AC2-1D62-45F6-9A4A-4B76A8564A2B &DISPLAYLANG=ZH-CN. On this site, we can download the software, and learn about the relevant considerations.
2, the installation of the following problems occurred, and found a solution, summarized as follows.
2.1 Issues with restarting failures in SQL Server 2008 installation
When you install the first step of SQL Server 2008 (plan-to-system Configuration Checker), when you detect a rule in the Security Program support rules interface, you have the problem:
Check whether a pending computer restart is required. Suspending a restart causes Setup to fail.
You need to restart your computer. You must restart your computer to install SQL Server.
The methods and steps to solve the problem are as follows:
A, restart the machine, and then install, if you find that the error, please follow the steps below
B. Enter regedit in Start-to-run
C, to HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\Session Manager (click) location
D, right-click PendingFileRenameOperations in the right window, select Delete, then confirm
E, restart the installation, problem solving
2.2 The Mediainfo.xml file cannot be found.
Download the installer Sqlmanagementstudio_x86_chs.exe decompression, run setup.exe on it.
Installation of the SQL Server Management Studio 2008 Release