Shulou(Shulou.com)05/31 Report--

This article will explain in detail the common errors and solutions related to the installation of sql server 2008. The content of the article is of high quality, so the editor will share it with you for reference. I hope you will have a certain understanding of the relevant knowledge after reading this article.

You often encounter the following common errors when installing sql server 2008:

1. Install SQL2008 and prompt the solution to delete the SQL2005Express tool.

When installing SQL2008, you are prompted to remove the SQL2005EXPRESS tool, which is relatively simple. Modify the registry: HKEY_LOCAL_MACHINE\ Software\ Microsoft\ Microsoft SQL Server\ 90\ Tools\ ShellSEM, rename or delete the ShellSEM key.

2. Install SQL Server 2008 Management Studio Express

First use the maintenance function of the sql server2008 installation center, which is available in the microsoft sql server2008 of the start menu, to upgrade express to Express with advanced services. Install SQL Server 2008 Management Studio Express again, and you can find the tool option. Installation succeeded.

If the dialog box "this program has a known compatibility problem" appears during installation. If you confirm that you have upgraded to express with advanced services, ignore the dialog box and press the "run programs" button.

3. Unable to install SQL Server 2008 Management Studio Express

The SQL Server that comes with Visual Studio2010 is a simplified version of Express, which needs to be upgraded to "Express with advanced services" from "SQL Server installation Center > maintenance > version upgrade". This process can be completed quickly. Then run the SQL Server 2008 Management Studio Express installation package, then pop up the SQL Server installation Center again, select install > New SQL Server stand-alone installation or add features to the existing installation, and you can add Management Studio.

4. Error writing to file:Microsoft.analysisServices.AdomdClient.dll,SQL Server 2008 installation failure prompt.

This error may be caused by the system's inability to read some installation files from the optical drive. Downloading the SQL2008 installation package directly from the website is rarely a failure, so it is recommended to download and install to avoid this failure. The causes of this failure are

1) the files in the installation CD are damaged

2) the optical drive reading is damaged.

3) install via a remote path and do not have sufficient permissions

4) remote installation

SQL2008 fault handling method:

1) install directly locally instead of using remote installation

2) copy and paste the files in the CD locally, or re-download the SQL2008 installation package from the Internet.

On the installation of sql server 2008 common mistakes and solutions to share here, I hope the above can be of some help to you, can learn more knowledge. If you think the article is good, you can share it for more people to see.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.