安裝SQL serverR問題集錦

1、No.1ProblemWhen trying to install or uninstall SQL Server, the setup process fails with the following message:Rule "Restart Computer" failed.A computer restart is required. You must restart this computer before installing SQL Server.This happens because there are pending restart operations

2、 on the machine and the setup needs a reboot before continuing. The problem is, that sometimes, even if the computer is restarted, the setup process can fail at exactly the same step. SolutionCheck if there are pending rename file operations that needs to be done after the computer is restarted

3、.To do this open a registry editor (Start -> Run -> Regedit) and navigate to the following path:HKEY_LOCAL_MACHINESYSTEMCurrentControlSetControlSession ManagerRight click on the PendingFileRenameOperations registry key from the right pane, to see the files that will be renamed after the restar

4、t.These entries are added to the registry when a program needs to rename a file that is being used. The file names are stored in this registry key until the system is restarted so they can be renamed.The best approach is to rename the PendingFileRenameOperations registry key (PendingFileRenameOperat

5、ions_OLD for example) and re-run the SQL Server Setup. This time, the setup will pass the "Restart Computer" rule. After the computer starts you can rename back the PendingFileRenameOperations_OLD to PendingFileRenameOperations registry key or add the containing entries to the newly create

6、d PendingFileRenameOperations key (if this is the case).Sometimes the PendingFileRenameOperations registry key is not present in the above path. In this situation, a solution will be to avoid the pending restart by installing / uninstalling SQL from the command line. To do this go to the SQL install

7、ation folder and from the cmd prompt execute the following:setup.exe /SkipRules=RebootRequiredCheck /ACTION=installorsetup.exe /SkipRules=RebootRequiredCheck /ACTION=uninstallBy doing this, the setup will skip the rule that verifies if there are any restart pending operations.No.2ErrorAttributes do

8、not match. Present attributes (Directory, Compressed) , included attributes (0), excluded attributes (Compressed, Encrypted)When you will see this issueYou may hit this error when you are tying to upgrade SQL Server and drive where SQL Server binaries and/or shared features are installed is compress

9、ed with NTFS windows file system compression and/or encryption is enabled.ResolutionGo to “C:Program Files” and check the properties of “Microsoft SQL Server” folder. Here in the properties window you will fins advanced option under the General tab. Now go to advanced option and look for “Compress c

10、ontents to save disk space” and “encrypt contents to secure data”. You will find these options as checked. Please uncheck these options and apply the changes. Now run the install again and it will run successfully.No.3安裝SQL server 2008 R2時遇到如下問題，在安裝到Setup Support Files 后，系統(tǒng)一閃而過下圖錯誤信息后安裝中斷。報錯：preparing SQL server 2008 R2 setup error details，please wait。如下圖：由于此次安裝的系統(tǒng)為英文版，所以要求安裝的SQL