MSSQLServer2008r2安裝+reportingservice配置教程

1、SQL Server 2008 R2 安裝教程11/23/2011目錄1.1 MS SQL Server 2008 R酒 MS SQL Server 2008 R2 Reporting Service31.1.1 下載31.1.2 安裝與配置 31.2 MS SQL Server 2008 R2 Reporting Service 231.2.1配置231.3 安裝數(shù)據(jù)庫411.1 MS SQL Server 2008 R2 和 MS SQL Server 2008 R2 Reporting Service該章節(jié)介紹如何下載、安裝 MS SQL Server 2008 R酒 MS SQL Se

2、rver Reporting Serviced且介紹如 何配置 MS SQL Server 2008 R2 1.1.1 下載MS SQL Server 2008 R2可從微軟官網(wǎng) 上下載, 也可從國內(nèi)軟件網(wǎng)站上下載，或者購買其安裝光盤。下載完成后即可進(jìn)入安裝。1.1.2安裝與配置打開Microsoft SQL Server 2008 R2安裝程序，按照提示安裝。單擊 "New installation or add features to an existing installation ”，開始安裝 MS SQL Server2008 R2七 SQL 3 y MOB 腔鐸tup-一

3、 I = | 回Setup Support RulesS?tup Support 23弁普 identify probHem-5 tFt Eqht occur .vhen /exj install SQL Server Setup support files Failures nrust be corrected before Setup can contmue.Setup Support RulesQperstioni ccmpletsd. Passsd: 7- Failed 3. Warning Q. Sk pped 0.甘ig details >>Vi-ew dr tail

4、ed rsportOK | CancelI一 - 正式安裝前，安裝程序會(huì)檢測(cè)目標(biāo)計(jì)算機(jī)是否符合安裝條件，沒有錯(cuò)誤才可進(jìn)行安裝。一切無誤后，點(diǎn)擊“OK"斧 SQL Server 200E R2 SetupProduct KeySpecify the edition of SQL Server 2008 R2 to install.Product KeyLicense TermsSutup Support Film/alidate this intanct oi QL Server 200# RW by entering tie 25-chararter <ey tronr the

5、 Vlicrasoi cetmcate S gjthenticity Qr product psckaqinq Vqu can also specir/ a edition : SQL Ser/er, such es Evaluation or Express，Evaljation has the largest et of SQL Server :G3turs£., docLFYicfiited in SQL Server Book? Qnine. ond is flctivited with o ISO cay xpirationH To upgrade wm one editi

6、on to another, run tne Edition Upgrade Wizard.Speciiy a Vee edition;Evaluation/J Enter the arodriet key：TDJSM-B6HKB-M934-QX4PB-Q49MB、BdikNext mCdrKfl輸入產(chǎn)品密鑰后，點(diǎn)擊"nextb SQL Server 2DCh3 R2 Setup -= I 叵License TermsTt install SQL Server 2308 R2. you mmist acrept thre Mirrcsoft Scfrwar? License Teir

7、ns.Product KeyLken» TtrnifiSetup Support Fil-esMICROSOFT SOFTWARE iLKfMSE IT RMSMICROSOfT SQL SERVER 2000 R2 DATACCHITRnese 1 cenie terms a-e an eEr&±nrent beiw±en M icrosoft Corporation (or Mied vun改e you live ma- of its atfiI ate=;| and cu. POeaseEzd thsnn-Tbev applyiz>Em Eof

8、tvimre nam&d abce, Which inc udes the medic on whic.1 ycu received t. if any. The terms dhe spdy io any M crosaft iupdste supplennenita Intsmet-bM&ed servic&s, aid support services一a hCcpy PrintP 1 the Btenae tsg，j Send feature u:ogeto M icr? !. Feature u»ge data includes inforrnati

9、on abcut youirbdrd'ditt coriifigurdtian dnd h舊 you use SQL Seivei dnd its compqmerits.喝e the hlicroEoft &OL &wirveir 2008： RN Piuaiy tmtwEwnt io匚rnerm irrhjmmiium< BickNext >Cancel在 "I accept the license terms” 之前的框中打鉤，并點(diǎn)擊 " next”。點(diǎn)擊 a Install,開始安裝七 SQL Ser i/er 2303 R2 S

10、etjpSetup Support Rulesletup Support Ruw普 identify problems tnat mght orcur .%ben pd<j install SQL Server Setup support files Failures nruEt be correctec? before £tup can continue.Setup Support RulesInstallation TypeProdizct KeyUcerw TermsSetup R.cleFraturc SdcdbcrDisk Space RequiremertsErro

11、r R印cmirgInstallllaticsr C-onFfiguratJCir Ru esReady s InsldlJnttaHlatiC'n ProgressComplete< BackNewt >Cjtnce再次檢測(cè)目標(biāo)計(jì)算機(jī)，一切無誤后，點(diǎn)擊“ nextSetup SupportSrtup RaleFeatuire Se-ect-crInsitallatioin Rules)Dik Space SlequiFementg.Error Rrpurtir-qInstallation Lcnfigijr.aticri Rul#£Reiad' to I

12、nstalllEalleff加 PrngressCompleteSQLSet i/ei 2303 R2 SetupSetup RoleC irk tne SQ Server Fectue m£il ton cipTion tc rdr/iduslfy select which feature cornpDnenf% to or click a feature rolle ta install a specifiz ccnfguraton.9 SQL Scrvrr Feature Imt卻I砒iemn$t 由 II iQLDat-sba- Engird £#rvu土電烏 Ai

13、alySE5Re porting Serviee-s.Inicrgrfliiipiii ScrvitE, and ot li? i fralum,SQL Servef RpyrerPivot For SharePointInst a IerPivct *or Gbure Point on a re村 nr existing £ ha rePai nt 2010 scirxer to supportPoivsrPivot dal日 access in the faiTm. To use the New Ser option. ShaiePoint rnu&T be I dial

14、led but mot congured.Add PowtsrPivQl far SFidrtPaint id. N-cw Server-口II F”TurT Whh iQefault?1 ns>tdII 41 fraLurc using default vdllue (ot thre icrvite azcouint.< LackNe.st >CareclHelp選擇 SQL Server Feature Installation 并點(diǎn)擊 next。選擇 Select All 即已包括 reporting service，并點(diǎn)擊 Next。安裝規(guī)則檢測(cè)，若無誤，點(diǎn)擊next

15、選擇 Default instance ,點(diǎn)擊 next。°；X9U早覃節(jié) SQL Saver 20DS R2 SetupServer ConfigurationSper-fy sFnir? ic-oijnt5；日nd rolafimn configurationiSetup Supporl Ru C5Setup RoieFeature SelecticnInmllMbi Rju 書H&tarce LcxitigurationDi>k Space FlTOuircimentiSrwr Co ntlgu rationDatabase- Engine1 Confiqurat

16、ionAnalysh Services ConfigurationFporbrrg Services Config "at! 0*1Error Reportingifictallaticn Lotrfigurarticn Rjuiws.Ready H InistallImstallatim ProgressCompleteSenrice Accounts Co larioAccount NoPasswordStartup TypeSQL Server AyrrlitNT AUTHORJTVXSr.,.MdriualSQL SePb-er Databiae Enginehr JlUTH

17、QRlTYXS'fST.AirtomarlDicTSQL Sfvet Anasishir AUTHOR1WT .AutomciicrMQL Ssruer Reporting Snruic#®NF AUTHORJT¥4¥Sr.AutomMicVSQL ter'er Jrtegration S>eirvi.Nr AUTHORJTVSV£F.Auicmaticw 二SQL Ful -test Filtar Dseimn L.BNT AUTHORJTVXLOG.SQL Server BrcwierNT AUTHORITYM.DG .D &g

18、t;dbl cdMcroicft r圳onMwds thdt you L&e d dtr uount for fdd SL Sf vtrUse the 5anw account for all SQL Server services< BackCanednext。將Account Name這列按上圖配置，配置完畢，點(diǎn)擊選擇 "windows authentication mode，點(diǎn)擊 Add Current User。用戶添加完畢后，在同一頁面選擇“FILESTREAMte項(xiàng)卡，全選后，點(diǎn)擊 next點(diǎn)擊Add Current User,添加完畢后點(diǎn)擊 Next。選擇

19、 install but do not configure the report server。點(diǎn)擊 next。Setup Support Ry C3Setup RoleFeatu re S-decticrIm 汩偵icn Raj esIn &tarcs C&ntiguirationDkk Space RcoufrcimcrtsS#r/#r Conf gurat onDatabase Engine CanfiquristicnUylyqk ServirM C onfigurfinnF.eportirg Services ConligjationError ReportingIn

20、ctallaticn Lonfiguraticn RulecEeady to Install iwllatien rogres?CompleteSQL 2MS 限 Setuo. = I 01Error ReportingHelp M crosoft improve SQL Server features and services.Specrfy the in+Drmstion that ycu woijIdl like to sutcmaticaDly send to Microsoft: to impress future relra5« of SQL Server, These

21、sAttingarc optiorel. Mkrosoft treats th?s informaticn s confiderTticL Mictqso may provide updates thro ugh f/kroscift. Update to me di勺 ctdtLire usag? data. Th&'se updatFs might be dD'AinloadiEd arvd installed dn pour rrnarh ns air：omaticallyB de pend ing on your Auto-natic Update settin

22、gs,th。SQL W00& R2 Privacy Saxrrcrticr rriDra曰m4gadH口fu 訝盤GLlUmtlmte1 我rd AuturrbaM。Send Window! oho SQL Server Error Reports tc Microsoft ar your corporate report server Tlis seuing only applies la services (hat run without user interaction.< 蟲;wkiNeid aCancdihelp點(diǎn)擊nexto檢測(cè)符合安裝配置規(guī)則后，點(diǎn)擊next。恪 S

23、QLSer/er 20&3 R2 SetujReady to InstallTM SQ Server 7008 =?2 feat 115 to be intlled.Setup SuppprI Ru C3Setup RoleFsstu re SrlecticrMeady to in stall SQL S-erwr 200S R2:Iriilaltetion RulesIn &tance C&ntigiuratioriDisk Spiscc RcQUircimcrM-sS#r/*r Confgurat onDatabase Enqine CorrfiquraticnUm

24、lyqis ServirM C DrrfigurrionReport9 Services Confiigjratio*i Error Reportingluctallaticn Conffiaurafticn RjuI«£Ready Installiwllatien rogrescComplete5" SummaryEdfdm; I匚CenterAdie m： Tnistdll- G*h*r*l Conti gm rati o n臼 Fmtuivs.i r- Dara baEngine Se rvicesSQL Server Replication- IFuH-T

25、cjct SrarchiAnatysia ScnrlccsRop&rtingi Arviwt!Bucin#£ lnft«l igenc#- D>v#lepmerit Studio Clie-nit T ook Ce-nr-stfrurty- integration ServicesClient Tcxals Bckuvrds Conipatib lity-Clknt Tooh SDKConfigur-CT or Tie pctLCf.Pncgrain Filesf/icrooft SQL Server、100Seip EllooTra plcg20111102

26、_124452rjDnfiQuratii< OsckInHullCancelLei 點(diǎn)擊 install oUnlyqk Wrvirpq CorrfiQurflrinnF.eporting Services CongjationError ReportingInctallafticn Lorrfigurafticn RulesF.eady to InstallI riia Hatton ProgrestComplete安裝完畢后，點(diǎn)擊nextProdjcirg mtcmncdliatD 壬tiltm尊 log).Next >CnnceiHelpInstallation Progre

27、ssSetup Support Ru C3Setup RoleFeature SlecticrIn 汩II航icn Raj esIfl ttarce C&ntigurationDisk Space RcisufrcimcrtiS#r*r Confgurat&on土 SQL Serwr 2008 R2 SetupComplete/ur £Q_ §mrve寸 2038 2 instjllst ar completed succesJuly-Setbp Support RufesPiaduct KeyLrzen se 7 e r Fin'sSetUL? R

28、cikFrafjrc SrletticnIrtdlMon Ruleslr5*£.ricc Ccnfig jrctianDk Space R號(hào)irn耳ntsServer ConfigurationiDstebss? Engine CdrfijrationAnalysis Services CcmfigjrationReporting Servizee ConfigLrationEnra R>po rt flgIr-Esilaition Configuration RulesR*ady tc InstallIrslladon ProgresscompleteSijrnrnary I

29、cq file hes been M¥?d! to the Rjllovrinqi locsticm;. 5。9對(duì) h心WfbOEQft -eTELlPOAetupi BcotHjapLop JLLL；SLW 13工心 iLmma*空 JL：U%22 呂12衛(wèi)4上:<nfarmati&n about the Setup epeatio- or posibh nn<t 或pqYour SQL Se'er 2003 R2 installation com pined successfulSupphrnErtfil InforrniitioniThe follo

30、wing notes apply to this release of SQL Server only.Micro soft UpdoteFot irfonTiaticn about how to use Micro-sofr Update tc identify updates for SQL Server 2008 R2 see the Microscft Update Web site st hmp 7ao.-Tiitfm Iir </?Linklc10840?.安裝成功，點(diǎn)擊close,關(guān)閉安裝界面1.2 MS SQL Server 2008 R2 Reporting Servi

31、ce此軟件已與 MS SQL Server 2008 R和套安裝，在此章節(jié)介紹如何配置1.2.1 配置HicrtOfficeNicrogaftMicrosoftNierosoft-Importo Import 螳 SQL ServerSQL S er verSilver light 3 SDK -中文簡(jiǎn)臼5匹 SQL ait!Server2008andServerEicp or£Eicp ort200STataDataR2級(jí)-Mt)似4 一bi t)Bum in色££ IntelligenceManent.4Analysis Servi cesConfigurit

32、ion Tool知 Rmpnir七 tnw Eetwicww CKFifi s?Jir m+.，口e, Mar, arMh 3QL Server: SQL Server” S9L ServerC onfi cur ati on M an ager Error iul Um垃薩 Eep&r Iiks all&ti oil C«nt ar (D'o cum ent a.t ionIntegration ServiC4E P «rEorfflince ToolsMicrosoft.and TutorialsNicrSQL Server 2000E2 Cci

33、rnimi ty >S;rnc Yfsimw心rkVi sual Stulio 2003WicrQsoft7isual Studio SOLOFC Eitm殘，ti Mi dT i m e5ubv*rsi anTartfiissSVN點(diǎn)擊開始 所有程序 Microsoft SQL Server 2008 R2 Configuration Tools Reporting ServicesConfiguration Manager 進(jìn)入配置界面。點(diǎn)擊connect,進(jìn)入配置服務(wù)器并連接到報(bào)表服務(wù)器實(shí)例，如下圖所示:點(diǎn)擊start，啟動(dòng)報(bào)表服務(wù)器，使各選項(xiàng)卡處于可用狀態(tài)，如下圖所示:/ SQL

34、Server2008R2Reporting Services Configurabor Manager,§Coanec<ZfAN8rSSQlSERYER電 Server Acooint/ 7/eb Ser vice LRL. Dabcfie Report Manascr URLi EF Settngsn Execucon AcciMitA bncvT>»r %”. ScA-ojt DeploytnentReport Server SmtmUselh«Repotting Se.IceiConfioi>r«tloniotctoo to Ce

35、f trodlfystCDngsforthe R-tpcSctve (irdRepartMraacr. fYCjitai edResomno s«r.Kec in* c: orr fwodtvcu fiuotconftoiretf*e Aeb sen ce JRL,th d«:abesef anc the Report Maragsr URL.Curre-it Aepcr ServerSQ- server Irsoce:Instance ID:Edhi o«:Produa ver 引on:Report Server Dm base Sore:Report Server Mode:R“ort Strvict SUliM：MS&2L5ER/眼MSR510.5C.MSSQLS»V»D&nCShTHR ecriON ：0).2SDC.ORcpfTSer.cr代St viedSrartResults.flooly=Xft點(diǎn)擊“Service Account”，進(jìn)入服務(wù)賬號(hào)配置，這里初始的用戶即為安裝時(shí)選擇的用戶，所以這 里為local System。我們就選擇這個(gè)賬戶。進(jìn)入 Web Service URL項(xiàng)卡，默認(rèn)設(shè)置即可s>Dafabase 濟(jì)aKinrechang