安装SQL server 2008 R2问题集锦.doc

《安装SQL server 2008 R2问题集锦.doc》由会员上传分享，免费在线阅读，更多相关内容在工程资料-天天文库。

1、No.1ProblemWhentryingtoinstalloruninstallSQLServer,thesetupprocessfailswiththefollowingmessage:Rule"RestartComputer"failed.Acomputerrestartisrequired.YoumustrestartthiscomputerbeforeinstallingSQLServer.Thishappensbecausetherearependingrestartoperationso

2、nthemachineandthesetupneedsarebootbeforecontinuing.Theproblemis,thatsometimes,evenifthecomputerisrestarted,thesetupprocesscanfailatexactlythesamestep. SolutionCheckiftherearependingrenamefileoperationsthatneedstobedoneafterthecomputerisrestarted.Todothi

3、sopenaregistryeditor(Start->Run->Regedit)andnavigatetothefollowingpath:HKEY_LOCAL_MACHINESYSTEMCurrentControlSetControlSessionManagerRightclickonthePendingFileRenameOperationsregistrykeyfromtherightpane,toseethefilesthatwillberenamedaftertherestart

4、.Theseentriesareaddedtotheregistrywhenaprogramneedstorenameafilethatisbeingused.Thefilenamesarestoredinthisregistrykeyuntilthesystemisrestartedsotheycanberenamed.ThebestapproachistorenamethePendingFileRenameOperationsregistrykey(PendingFileRenameOperati

5、ons_OLDforexample)andre-runtheSQLServerSetup.Thistime,thesetupwillpassthe"RestartComputer"rule.AfterthecomputerstartsyoucanrenamebackthePendingFileRenameOperations_OLDtoPendingFileRenameOperationsregistrykeyoraddthecontainingentriestothenewlycreatedPend

6、ingFileRenameOperationskey(ifthisisthecase).SometimesthePendingFileRenameOperationsregistrykeyisnotpresentintheabovepath.Inthissituation,asolutionwillbetoavoidthependingrestartbyinstalling/uninstallingSQLfromthecommandline.TodothisgototheSQLinstallation

7、folderandfromthecmdpromptexecutethefollowing:setup.exe/SkipRules=RebootRequiredCheck/ACTION=installorsetup.exe/SkipRules=RebootRequiredCheck/ACTION=uninstallBydoingthis,thesetupwillskiptherulethatverifiesifthereareanyrestartpendingoperations.No.2ErrorAt

8、tributesdonotmatch.Presentattributes(Directory,Compressed),includedattributes(0),excludedattributes(Compressed,Encrypted)WhenyouwillseethisissueYoumayhitthiserrorwhenyouaretyingtoupgradeSQLServeranddrivewhereSQLServerbinariesand/