4 common errors and resolutions when installing SQL Server 2008 _mssql2008

It may be a problem because of the operating system, or if you installed SQL 2008 with other versions of SQL, so that our actual experience and ability to test our hands are also very important so that we can make detours less.

Issue 1: Installing SQL Server 2008 R2, prompting for errors during installation: An earlier version of Microsoft Visual Studio 2008 is installed on this computer . Please upgrade Microsoft Visual Studio 2008 to SP1 before installing SQL Server 2008.

Before my computer really installed vs2008, so I am ready to download a SP1 patch package, a look at the size of more than 800 m, originally installed the software has been very troublesome, and still have to spend time downloading, that there is no other better way? In fact, it is very simple, only need to change the registry can be, the following methods:

Workaround:

Modify your registry.

Run the registry and rename the Hkey-local-machine/software/microsoft/devdiv on the line.

After installation, then change it back.

The problem is solved by returning the SQL Server installation to the previous step and then the next point.

Issue 2: Install SQL2008, prompt to remove sql2005express tool solution

In the installation of SQL2008, prompted to delete sql2005express tools, on the Internet to find a lot of information, and finally found a more convenient way, hoping to help everyone. Modify the registry: HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\90\tools\shellsem, rename or delete shellsem items.

Unable to install SQL Server 2008 Management Studio Express

Failure phenomenon:

SQL Server 2008 Express has been installed in Windows7 and SP3 has been installed, and then the SQL Server 2008 Management Studio Express installation was downloaded from Microsoft's website and found that no man was added during the installation The Agement tool.

Workaround:

Use the maintenance features of the SQL Server2008 Installation Center (which is available in Microsoft SQL Server 2008 in the Start menu) to upgrade Express to express with advanced services. Then install SQL Server 2008 Management Studio Express, which allows you to discover the tool option. The installation was successful.

Additional tips:

A "known compatibility issue with this Program" dialog box appears when you install SQL Server 2008 Management Studio Express. If you confirm that you have installed more than SP1 files and have upgraded to express with advanced services, then ignore this dialog and press the "Run Program" button. There won't be any problems.

Problem 3, troubleshooting the inability to install SQL Server 2008 Management Studio Express

My SQL Server 2008 Express is from Visual Studio 2010, so of course it doesn't have Management studio and has its own setup, but you can't install SQL Server 2008 Management Studi o Express. Tip No feature selected.

Just find the solution from the Internet, I test through, share again:

VS2010 's SQL Server is Express-simplified, and needs to be upgraded to SQL Server Installation Center > Maintenance > Version upgrade to "Express with advanced Service" (which is soon to be completed). Run the SQL Server 2008 Management Studio Express installation package, and then eject the SQL Server Installation Center again, choosing install > New SQL Server Standalone installation or add functionality to an existing installation. Next, you can add Management Studio.

Here are some introductions to the express version with Advanced Services:

SQL Server Express with Advanced Services has all the functionality in SQL Server Express Edition and has the following features:

Easily manage SQL Server Express with the help of a new easy-to-use graphical management tool, SQL Server Management Studio Express (SSMSE).

Send a full-text query to the plain character data in the SQL Server table. Full-text queries can include words and phrases, or multiple forms of words or phrases.

Run the SQL Server Reporting Services report for local relational data.

Now, allow the Management Studio Express installation file to appear with the Administration Tools option:

Problem 4, Setup configuration check Rebootrequiredcheck failure, problem resolution

Problem Description:

Globalrules: SQL Server 2008 Installer Configuration Check for rule group "Globalrules"

Rebootrequiredcheck
Check to see if you need to suspend the computer reboot. Suspending a reboot can cause Setup to fail.
Failed
You need to restart your computer. You must restart your computer to install SQL Server.

Other checks are "passed".

Workaround:

or modify the registry method

1. Enter regedit in the beginning-> operation;
2. Find HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\Session Manager location;
3. Delete the item named PendingFileRenameOperations in the right window and confirm it;
4. Re-enable the installation or repair program, you can.

Issue 5, SQL Server 2008 installation failed: Error writing to File:Microsoft.analysisServices.AdomdClient.dll.

Problem description

==========

The SQL Server 2008 standard installation failed on Windows Server 2008 with the error:

Error writing to File:Microsoft.analysisServices.AdomdClient.dll. Verify that you have access to that directory.

Troubleshooting

==========

Depending on the error log, the following error message exists:

1. During installation to Install_sql_common_core_cpu32_action:installfiles. The following error message appears when copying new files:

Error writing to File:Microsoft.analysisServices.AdomdClient.dll. Verify that you have access to that directory.

2. When you install to install_sqlbrowser_cpu32_action, you receive the following error message:

The system cannot read from the specified device (the "system cannot read from" specified device.)

3. The following error message is present in the Detail.txt:

Copy Code code as follows:

Bootstrap/log/20110620_153155/registry_software_microsoft_mssqlserver.reg_
2011-06-20 16:07:03 SLP: The system cannot read from the specified device.
2011-06-20 16:07:03 Slp:watson Bucket for Msi based failure has been created
2011-06-20 16:07:03 Slp:InstallPackage:MsiInstallProduct returned the result code 30.
2011-06-20 16:07:03 slp:retry-able MSI return code detected:30
2011-06-20 16:07:03 slp:prompting User if they want to retry this action due to the following:
2011-06-20 16:07:03 SLP:----------------------------------------
2011-06-20 16:07:03 slp:the Following is a exception stack listing the exceptions in outermost to innermost order
2011-06-20 16:07:03 Slp:inner exceptions are being
2011-06-20 16:07:03 SLP:
2011-06-20 16:07:03 slp:exception type:Microsoft.SqlServer.Configuration.MsiExtension.MsiExtensionException
2011-06-20 16:07:03 Slp:message:
2011-06-20 16:07:03 slp:sql Server Setup encountered an error while running the Windows Installer file.
2011-06-20 16:07:03 SLP:
2011-06-20 16:07:03 slp:windows Installer error message: The system cannot read from the specified device.
2011-06-20 16:07:03 SLP:
2011-06-20 16:07:03 slp:windows Installer file: N:/x86/setup/sqlbrowser.msi
2011-06-20 16:07:03 slp:windows Installer log file: C:/Program files/microsoft SQL server/100/setup bootstrap/log/201 10620_153155/sqlbrowser_cpu32_1.log
2011-06-20 16:07:03 Slp:data:
2011-06-20 16:07:03 Slp:disableretry = True
2011-06-20 16:07:03 Slp:inner Exception type:System.ComponentModel.Win32Exception
2011-06-20 16:07:03 Slp:message:
2011-06-20 16:07:03 SLP: The system cannot read from the specified device.
2011-06-20 16:07:03 SLP:
2011-06-20 16:07:03 SLP:----------------------------------------
2011-06-20 16:23:57 slp:error Result:-2068643839
2011-06-20 16:23:57 Slp:result Facility code:1203
2011-06-20 16:23:57 Slp:result Error code:1
2011-06-20 16:23:57 Slp:Sco:Attempting to create base registry key HKEY_LOCAL_MACHINE, MACHINE
2011-06-20 16:23:57 Slp:Sco:Attempting to open registry subkey software/microsoft/pchealth/errorreporting/dw/ Installed
2011-06-20 16:23:57 Slp:Sco:Attempting to get registry value DW0200
2011-06-20 16:23:58 slp:submitted 5 of 5 failures to the Watson data repository
2011-06-20 16:24:05 slp:detected Localization Resources folder:1033
2011-06-20 16:24:05 slp:detected Localization Resources folder:2052
4. The following error message is present in the Sqlbrowser_cpu32_1.log:
MSI (s) (30:D4) [16:05:48:937]: note:1:1305 2:n:/x86/setup/sqlbrowser.msi 3:1117
MSI (s) (30:10) [16:07:03:656]: I/O on thread 2992 could is cancelled. error:1168
MSI (s) (30:10) [16:07:03:656]: I/O on thread 796 could is cancelled. error:1168
MSI (s) (30:10) [16:07:03:656]: I/O on thread 2172 could is cancelled. error:1168
MSI (s) (30:10) [16:07:03:656]: I/O on thread 3280 could is cancelled. error:1168
MSI (s) (30:10) [16:07:03:656]: I/O on thread 3796 could is cancelled. error:1168
MSI (s) (30:10) [16:07:03:656]: I/O on thread 812 could is cancelled. error:1168
MSI (s) (30:D4) [16:07:03:656]: MainEngineThread is returning 30
MSI (s) (30:10) [16:07:03:656]: No System Restore Sequence number for this installation.

The system cannot read from the specified device.

The above error may have occurred because the system was unable to read the installation files from the CD drive. There are several possible reasons for this:

1. Optical drive has been damaged

2. The files on the installation CD are damaged.

3. Install via remote path and do not have sufficient permissions

4. Installation via Remote Desktop

Solutions

==========

1. Copy and paste the files from the disc to the local (if an error occurs, retrieve the correct installation files from the Web site)

2. Install directly locally without using a remote installation