关闭

关闭

关闭

封号提示

内容

首页 A Step by Step guide to installing SQL Server 20…

A Step by Step guide to installing SQL Server 2008.pdf

A Step by Step guide to installi…

larrylam1987 2012-06-28 评分 0 浏览量 0 0 0 0 暂无简介 简介 举报

简介:本文档为《A Step by Step guide to installing SQL Server 2008pdf》,可适用于IT/计算机领域,主题内容包含AAAAStepStepStepStepbybybybyStepStepStepStepguideguideguideguidetotototoin符等。

AAAAStepStepStepStepbybybybyStepStepStepStepguideguideguideguidetotototoinstallinginstallinginstallinginstallingSQLSQLSQLSQLServerServerServerServersimplysimplysimplysimplyandandandandsuccessfullysuccessfullysuccessfullysuccessfullywithwithwithwithnonononopriorpriorpriorpriorknowledgeknowledgeknowledgeknowledgeDevelopersandsystemadministratorswillfindthisinstallationguideuseful,aswillseasonedDBAsItwillteachyouthebasicsrequiredforatypical,problemfreeinstallationofSQLServer,allowingyoutoaddothercomponentslaterifyouwishRememberRememberRememberRemembertotototoinstallinstallinstallinstallthethethetheNetNetNetNetFrameworkFrameworkFrameworkFrameworkBeforeyoustarttheinstallation,you’llneedtoinstalltheNetFrameworkThiscomespreinstalledonWindowsServer,butforearlierversionsofWindows,you’llneedtoinstallitfirstThisisastraightforwardprerequisiteandisusuallyincludedaspartoftheSQLServerinstallationHowever,ifyoudon’tknowhowtodothis,orforsomereasonyouneedtodownloadit,checkouttheguideInstallingNetFrameworkforSQLServerOncethisFrameworkininstalledyoucancommencetheinstallationofSQLServerSTEPSTEPSTEPSTEP::::CopyCopyCopyCopythethethetheinstallationinstallationinstallationinstallationfilesfilesfilesfilesFirstoffI’drecommendyoucopytheentiredirectorystructurefromtheSQLServerinstallationdisctotheC:driveofthemachineyouaregoingtoinstallitonAlthoughthismeansyouneedtograbacupofcoffeewhilstit’scopying,thishasthreeadvantages:•ItmakestheinstallationprocessmuchfasterthanrunningitfromCDDVDonceitgetsstarted•Itallowsyoutoeasilyaddorremovecomponentslater,withouthavingtohuntaroundfortheCDDVD•Ifyourmediaisdamagedandafilewon’tcopy,yougettofindoutnow,ratherthanhalfwaythroughtheinstallationHere’swhatmysystemlookslikeafterthecopy:STEPSTEPSTEPSTEP::::SetupexeSetupexeSetupexeSetupexeDoubleclickonthesetupexefileAfterafewsecondsadialogboxappears:Thiswilldisappearfromthescreenandthenthemaininstallationpageappears:STEPSTEPSTEPSTEP::::SQLSQLSQLSQLServerServerServerServerInstallationInstallationInstallationInstallationCenterCenterCenterCenterClickontheInstallationhyperlinkonthelefthandsideofthescreen:STEPSTEPSTEPSTEP::::SQLSQLSQLSQLServerServerServerServerInstallationInstallationInstallationInstallationCenterCenterCenterCenterClickonthe"New"New"New"NewServerServerServerServerstandalonestandalonestandalonestandaloneinstallation"installation"installation"installation"linkontherightsideofthescreen:Thefollowingdialogappearsonthescreenwhilsttheinstallprogrampreparesforinstallation:Afteraminuteorso(thetimingwillvaryaccordingtoyoursystem),thefollowingscreenappears:STEPSTEPSTEPSTEP(optional)(optional)(optional)(optional)::::Ifanycheckshavefailed,clickontheShowdetailsbuttonor"Viewdetailedreportlink"tofindoutthecause,correctit,thenclickontheRerunbuttontoperformthechecksagainSTEPSTEPSTEPSTEP::::ProductProductProductProductkeykeykeykeyIfallcheckshavepassed,clickontheOKbuttonAfterafewmoments,theoptiontoselecttheeditionandtoenterthelicensekey(or“productkey”)willappearNotethattheproductkeyboxmayalreadybepopulated,dependingonwhicheditionyouhaveDon’tentertheproductkeywe’veshownhere,itwon’tworkonyoursystem!:STEPSTEPSTEPSTEP::::LicenseLicenseLicenseLicenseTermsTermsTermsTermsEntertheproductkeyintothebox,orchoosethefreeeditionifyou'reevaluatingSQLServer,andclickontheNextbutton:Clickinthe"I"I"I"Iacceptacceptacceptacceptthethethethelicenselicenselicenselicenseterms"terms"terms"terms"checkbox,thenclickontheNextNextNextNextbuttonagainSTEPSTEPSTEPSTEP::::SetupSetupSetupSetupSupportSupportSupportSupportFilesFilesFilesFilesThefollowingscreenappearsclickontheInstallbutton:ThefollowingscreenwillappearwhilstWindowsInstallerpreparesitselffortheinstallationThiswilltakeashortwhile:Aftersecondsorsothedialogappearsagain:STEPSTEPSTEPSTEP::::SetupSetupSetupSetupSupportSupportSupportSupportRulesRulesRulesRulesIfalliswell,thefollowingscreenappears:ClickontheNextNextNextNextbuttonagainSTEPSTEPSTEPSTEP::::FeatureFeatureFeatureFeatureSelectionSelectionSelectionSelectionSelectSelectSelectSelectthethethethefeaturesfeaturesfeaturesfeaturesyouyouyouyouwantwantwantwanttotototoinstallinstallinstallinstallAtaminimum,thefollowingareuseful(I'dargueessential),butwhatyouneedwilldependonyourneeds:ClickontheNextNextNextNextbuttonSTEPSTEPSTEPSTEP::::InstanceInstanceInstanceInstanceConfigurationConfigurationConfigurationConfigurationAfterashortwhilethefollowingscreenappears:Formostinstallations,keepthedefaultsettingsClickontheNextNextNextNextbuttonSTEPSTEPSTEPSTEP::::DiskDiskDiskDiskSpaceSpaceSpaceSpaceRequirementsRequirementsRequirementsRequirementsThisscreenjusttellsyouifyouhavesufficientdiskspaceonthedriveyou’reinstallingto,andwhat’sgoingtobeinstalledwhereClickonNextNextNextNextSTEPSTEPSTEPSTEP::::ServerServerServerServerConfigurationConfigurationConfigurationConfigurationThisstepallowsyoutosetuptheserviceaccountsthatwillbeusedtorunSQLServerIfyouhavecreatedWindowsNTorActiveDirectoryaccountsforusewithservices,usetheseIfnot,thenjusttogettheinstallationupandworking,usethebuiltinNetworkServiceaccountforallthreeserviceslisted(thisaccountdoesnotrequireapassword)ThisallowsSQLServertostartupafterinstallationHowever,itcanbeeasilychangedlatertoanotheraccountthroughtheServicesapplet(ControlPanel>AdministratorTools>Services):Inaddition,remembertochangetheStartupStartupStartupStartupTypeTypeTypeTypetoAutomaticAutomaticAutomaticAutomatic,forallthreeservicesThisautomaticallystartstheSQLServerdatabaseengine,SQLAgentandSQLBrowserserviceswhentheserverisrebootedThefirstservicerunstheSQLServerdatabaseenginesexecutableprocessTheothertwoservicesallowscheduledjobstorunafterinstallation(andafterareboot),andallowtheSQLServertobefoundbyclientsonthenetworkDonotworryaboutchangingthecollationtab,unlessthereisaspecificrequirementforanythingotherthanthedefaultcollationsequenceFinally,clickonNextNextNextNextSTEPSTEPSTEPSTEP::::DatabaseDatabaseDatabaseDatabaseEngineEngineEngineEngineConfigurationConfigurationConfigurationConfiguration––––AccountAccountAccountAccountProvisionProvisionProvisionProvisionThisscreenallowsyoutosetupdatabaseenginesecurityChangetheAuthenticationAuthenticationAuthenticationAuthenticationModeModeModeModetoMixedMixedMixedMixedModeModeModeModeunlessyouarecertaincertaincertaincertainyouonlyneedWindowsonlyauthentication•ManyManyManyManythirdthirdthirdthirdpartypartypartypartyapplicationsapplicationsapplicationsapplicationsrelyrelyrelyrelyononononSQLSQLSQLSQLServerServerServerServerloginsloginsloginsloginstotototooperateoperateoperateoperatecorrectly,correctly,correctly,correctly,sosososoififififyouyouyouyouarearearearesettingsettingsettingsettingupupupupaaaaserverserverserverserverforforforforaaaathirdthirdthirdthirdpartypartypartypartyapplication,application,application,application,ratherratherratherratherthanthanthanthanoneoneoneonedevelopeddevelopeddevelopeddevelopedinhouse,inhouse,inhouse,inhouse,enablingenablingenablingenablingMixedMixedMixedMixedModeModeModeModeauthenticationauthenticationauthenticationauthenticationisisisisaaaagoodgoodgoodgoodideaideaideaideaIfyoupickMixedModesecurity,youmustalsoenterapasswordforthesysadminaccount(sa)EnterandconfirmasecurepasswordforthesaaccountandkeepitsomewheresafeDonotgiveittoanyoneyoudonotwanttohaveaccesstotheSQLServerNotethatyouMUSTalsoprovideaWindowsNTaccountonthelocalmachineasaSQLServeradministratorIfyoudonotwantWindowssystemadministratorstobeablewalkuptotheboxandlogintoSQLServer,createanew,local,dummyWindowsuserandaddthisaccountinsteadOtherwise,addinthelocaladministratoraccount,oryourownWindowsaccountonthedomaininwhichtheSQLServerwillresideSTEPSTEPSTEPSTEP::::DatabaseDatabaseDatabaseDatabaseEngineEngineEngineEngineConfigurationConfigurationConfigurationConfiguration––––DataDataDataDataDirectoriesDirectoriesDirectoriesDirectoriesClickontheDataDataDataDataDirectoriesDirectoriesDirectoriesDirectoriestabChangethedirectoriestospecifywhichdrivesinyoursystemwillbeusedforthevarioustypesofdatabasefilesGenerallyit’sadvisabletoputtheUserdatabasedirectoryandUserlogdirectoryonseparatephysicaldrivesforperformance,butitwilldependonhowWindowshasbeenconfiguredandhowmanydiskdrivesyouhaveavailableIfyouareinstallingonasingledrivelaptopordesktop,thensimplyspecify:DataDataDataDatarootrootrootrootdirectorydirectorydirectorydirectoryC:ProgramFilesMicrosoftSQLServerUserUserUserUserdatabasedatabasedatabasedatabasedirectorydirectorydirectorydirectoryC:DataUserUserUserUserloglogloglogdirectorydirectorydirectorydirectoryC:LogsTempTempTempTempDBDBDBDBdirectorydirectorydirectorydirectoryC:TempDBTempTempTempTempLogLogLogLogdirectorydirectorydirectorydirectoryC:TempDBBackupBackupBackupBackupdirectorydirectorydirectorydirectoryC:BackupsDonotclickontheFILESTREAMFILESTREAMFILESTREAMFILESTREAMtabunlessyouknowyouneedtochangetheseoptions,asitisnotgenerallyrequiredformostinstallations,butcaneasilybechangedbyusingspconfigure'filestreamaccesslevel',''afterSQLServerhasbeeninstalledClickonNextNextNextNextSTEPSTEPSTEPSTEP::::ErrorErrorErrorErrorUsageUsageUsageUsageReportingReportingReportingReportingThisscreensimplyasksifyouwanttosenderrorinformationtoMicrosoftandcansafelybeskippedifyoudonotwanttoshareanyinformationClickboxesifyouwanttohelpMicrosofthelpyouClickonNextNextNextNextagain…STEPSTEPSTEPSTEP::::InstallationInstallationInstallationInstallationRulesRulesRulesRulesThisscreensimplychecksifthereareanyprocessesorotherinstallationsrunningwhichwillstoptheinstallationofSQLServerClickonNextNextNextNextagain–you’realmostreadytoinstall:STEPSTEPSTEPSTEP::::ReadyReadyReadyReadytotototoInstallInstallInstallInstallThisscreensummariseswhatyouareabouttoinstallandgivesyoualastchancetocancelorchangeanythingthat’swronglyconfigured:Checkthatwhat’sbeinginstallediswhatyouwantandthenclickonInstallInstallInstallInstallwhenyou’resureyouwanttostarttheinstallationprocess:InstallationInstallationInstallationInstallationProgressProgressProgressProgressSQLServerwillnowinstallHowlongittakesdependsonthespeedofyourmachine,whatloadit’sunder,theinstallationmedia(CDisslower)andwhatyou’vechosentoinstall…………MoreMoreMoreMoreInstallationInstallationInstallationInstallationProgressProgressProgressProgressandandandandFinallyFinallyFinallyFinallyFinally,theinstallationwillcomplete:andthefollowingdialogboxwillappear:ClickClickClickClickononononOK,OK,OK,OK,thethethethemachinemachinemachinemachinewillwillwillwillNOTNOTNOTNOTrebootrebootrebootrebootThefollowingwillappear:…followedby:ClickClickClickClickononononthethethetheNextNextNextNextbuttonbuttonbuttonbuttonagainSTEPagainSTEPagainSTEPagainSTEP::::InstallationInstallationInstallationInstallationCompleteCompleteCompleteCompleteThefollowingscreenappears:Itmaybeworthclickingontheinstallationlogatthetopofthescreentocheckeverything’sgoneasexpectedNotthatthisisMUCHsmallerthantheusualSQLServerinstallationlogfilesofoldFinally,clickclickclickclickononononthethethetheCloseCloseCloseClosebuttonbuttonbuttonbuttonThefollowingdialogwillappear:ClickClickClickClickononononOKOKOKOK––––youryouryouryourserverserverserverserverwillwillwillwillNOTNOTNOTNOTrebootrebootrebootrebootatatatatthisthisthisthispointpointpointpointThedialogboxwilldisappearandyouwillbereturnedtotheInstallationCenter:ClickClickClickClickononononthethethetheCloseCloseCloseClosebuttonbuttonbuttonbutton(the“x”)inthetoprightofthescreenFinally,manuallyrebootyourmachinetocompletetheSQLServerinstallationTopTopTopTopTipsTipsTipsTips::::HowHowHowHowtotototocheckcheckcheckcheckthatthatthatthatSQLSQLSQLSQLServerServerServerServerhashashashasinstalledinstalledinstalledinstalledcorrectlycorrectlycorrectlycorrectlyHereareashortnumberofpostinstallationcheckswhichareusefultoperformafterrebootingyournewSQLServerYoudon’thavetorunthese,andthereareotherwaystocheck,buttheyareveryusefulfornonDBAstobesurethattheinstallationisbasicallysoundandaconnectioncanbemadetothenewSQLServerbeforehandingitovertosomeoneelseCheckCheckCheckCheck::::HasHasHasHasthethethetheSQLSQLSQLSQLServerServerServerServerServiceServiceServiceServiceStartedStartedStartedStartedCheckSQLServerhasstartedCheckCheckCheckCheck::::DoesDoesDoesDoesManagementManagementManagementManagementStudioStudioStudioStudioWorkWorkWorkWorkCheckManagementStudioworksbyfiringitupClickClickClickClickononononNONONONOwhenyouseethisdialogbox:CheckCheckCheckCheck::::CanCanCanCanyouyouyouyourunrunrunrunaaaabasicbasicbasicbasicqueryqueryqueryqueryagainstagainstagainstagainstthethethethenewnewnewnewSQLSQLSQLSQLServerServerServerServerCheckSQLServerworksbyrunningasimplequeryfromManagementStudio:EnterthequeryshownbelowandhitFtorunit:CheCheCheCheckckckck::::IsIsIsIsSQLSQLSQLSQLServerServerServerServerAgentAgentAgentAgentRunningRunningRunningRunningCheckSQLServerAgentisrunningforscheduledjobsThereshouldbeagreenarrownexttotheSQLServerAgentdatabasesymbol(it’ssmall,youmighthavetolookhard):CheckCheckCheckCheck::::CanCanCanCanSQLSQLSQLSQLServerServerServerServerbebebebeseenseenseenseenfromfromfromfromthethethetheNetworkNetworkNetworkNetworkCheckthatthenewSQLServercanbeseenfromanotherSQLServeronthesamedomainbyrunningisql–L(orosql–L):Ifyoucan’tseethenewSQLServerinthislist,checkthattheSQLServerBrowserserviceisstartedonthemachinewhereyouhavejustinstalledSQLServerCheckCheckCheckCheck::::HasHasHasHasthethethetheTCPIPTCPIPTCPIPTCPIPnetworknetworknetworknetworkprotocolprotocolprotocolprotocollibrarylibrarylibrarylibrarybeenbeenbeenbeenenabledenabledenabledenabledononononthethethetheserverserverserverserverIfthebrowserserviceisstartedbutyoustillcannotconnecttotheserver,clickonStartStartStartStart>Programs>Programs>Programs>Programs>>>>SQLSQLSQLSQLServerServerServerServer>>>>SQLSQLSQLSQLServerServerServerServerConfigurationConfigurationConfigurationConfigurationManagerManagerManagerManager(ontheserverwhereSQLServer’sjustbeeninstalled)TheSQLServerConfigurationManagerwindowopensClickontheSQLSQLSQLSQLServerServerServerServerNetworkNetworkNetworkNetworkConfigurationConfigurationConfigurationConfigurationnodeandexpanditIntheexamplebelow,wehaveMSSQLSERVER(abaseinstanceofSQLServer),andSQLEXPRESSshowingasinstalledIfindoubt,clickonProtocolsProtocolsProtocolsProtocolsforforforforMSSQLSERVERMSSQLSERVERMSSQLSERVERMSSQLSERVERIntheabovescreenshot,theTCPIPnetworkprotocollibraryisdisabledWeneedtoenableitinorderthatremoteserverscantalktothenewlyinstalledSQLServer•AAAAwordwordwordwordofofofofexplanationexplanationexplanationexplanation::::Inmostinstallations,NamedPipescanbeignored,unlessthereisarequirementforitInvirtuallyallenvironments,VIAcanalsobeignoredasthisprotocolrequiresaspecialnetworkcardSharedmemoryisthe“local”protocolthatSQLServeruseswhentalkingtoaclientapplicationonthesameserverasitself,forexamplewhenSQLServerManagementStudioconnectstoitItisusuallybesttoleavethisenabledYouwillneedtheTCPIPprotocolenabledifyouneedtoconnecttoyournewSQLServerfromaremoteclientoranotherserverviaTCPIP,whichiswhatmostnetworksuseIfitshowsasDISABLEDDISABLEDDISABLEDDISABLED(above),doubledoubledoubledoubleclickclickclickclickononononthethethetheTCPIPTCPIPTCPIPTCPIPprotocolprotocolprotocolprotocollinelinelineline,andthefollowingwindowwillappear:EnsureEnsureEnsureEnsurethatEnabledEnabledEnabledEnabledisisisissetsetsetsettotototoYesYesYesYes,andclickonOKThefollowingwarningwillappear:ClickonOK,andyouwillbereturnedtotheConfigurationManagerwindow,whereTCPIPwillnowbeshownasenabled:GobacktotheServicesapplet,andrestarttheMSSQLSERVERservicesothattheTCPIPprotocolcanbeusedtoconnecttoyournewSQLServerThentrytoconnecttoitagainfromaremotemachineIfyouhaveexperiencedproblemswiththepreviousconnectivitytests,youshouldnowbeabletorepeatatleastsomeofthemsuccessfully

用户评论(0)

0/200

精彩专题

上传我的资料

每篇奖励 +1积分

资料评分:

/29
0下载券 下载 加入VIP, 送下载券

意见
反馈

立即扫码关注

爱问共享资料微信公众号

返回
顶部

举报
资料