# SQL2008R2 Reporting Services 組態管理員 設定筆記 一般來說透過 SQL Server 2008 R2 的安裝界面在安裝的過程就能將 Reporting Services 的組態給設定好，不過也有可能在事後修改 Reporting Services 的組態設定，設定過程也算十分直覺，比較有可能出問題的地方應該就是有些專有名詞看不懂之類的，不過就算再怎麼不懂，按圖施工應該也是能成功的，以下就是設定的過程圖示。 ![](https://stwillblogassets.blob.core.windows.net/files/images/external/stwillblogassets.blob.core.windows.net/32a367ecf5f9a4b49dde-image_37.png) ![](https://stwillblogassets.blob.core.windows.net/files/images/external/stwillblogassets.blob.core.windows.net/7a6355fa5fed1c6063ba-SNAGHTML6ef7e7.png) 先確保 **報表伺服器** 與 **SQL Server 執行個體**都是**啟動**的狀態 [![](https://stwillblogassets.blob.core.windows.net/files/images/external/stwillblogassets.blob.core.windows.net/634574cd5b10c895e0ac-SNAGHTML4afd43_thumb.png)](https://stwillblogassets.blob.core.windows.net/files/images/external/stwillblogassets.blob.core.windows.net/586e987f3d8290687813-SNAGHTML4afd43.png) 執行報表伺服器的帳戶通常選取「網路服務」即可（實際名稱為 **NETWORK SERVICE** 系統帳戶） [![](https://stwillblogassets.blob.core.windows.net/files/images/external/stwillblogassets.blob.core.windows.net/bbc141f2c31941d5f5c3-SNAGHTML4d1fe0_thumb.png)](https://stwillblogassets.blob.core.windows.net/files/images/external/stwillblogassets.blob.core.windows.net/441f3ac0dbad1f683c94-SNAGHTML4d1fe0.png) **Web 服務 URL** ( Web Service URL ) 是設定 Reporting Service 對外服務的虛擬目錄為何，所有 Reporting Service 的 Web Services 都是藉由這個 Web 服務 URL  來提供，虛擬目錄名稱可以修改，我習慣改成 ReportServer 比較好記，修改完之後記得按下右下角的「套用」才行 [![](https://stwillblogassets.blob.core.windows.net/files/images/external/stwillblogassets.blob.core.windows.net/db753bc352e2ca6d1b98-SNAGHTML4db616_thumb.png)](https://stwillblogassets.blob.core.windows.net/files/images/external/stwillblogassets.blob.core.windows.net/78b0da5b8fcefac37b18-SNAGHTML4db616.png) 第一次安裝有可能連報表資料庫都沒有建立，這時就可以按下「變更資料庫」來建立預設的報表資料庫 [![](https://stwillblogassets.blob.core.windows.net/files/images/external/stwillblogassets.blob.core.windows.net/50e00076b11e577a67b4-SNAGHTML509bd3_thumb.png)](https://stwillblogassets.blob.core.windows.net/files/images/external/stwillblogassets.blob.core.windows.net/82d462ffd2b97836f74a-SNAGHTML509bd3.png) 接著我們選取「建立新的報表伺服器資料庫」 [![](https://stwillblogassets.blob.core.windows.net/files/images/external/stwillblogassets.blob.core.windows.net/5330652cbf627f496f09-SNAGHTML4fe061_thumb.png)](https://stwillblogassets.blob.core.windows.net/files/images/external/stwillblogassets.blob.core.windows.net/601b4fc1df07bd24cc67-SNAGHTML4fe061.png) 這一個步驟記得要設定「伺服器名稱」與「測試連結」，以確保資料庫連接正常 [![](https://stwillblogassets.blob.core.windows.net/files/images/external/stwillblogassets.blob.core.windows.net/36567a3abb9dd454822e-SNAGHTML52beec_thumb.png)](https://stwillblogassets.blob.core.windows.net/files/images/external/stwillblogassets.blob.core.windows.net/cabb7b53e6670321db28-SNAGHTML52beec.png) 接著輸入報表伺服器資料庫的**資料庫名稱**，預設會建立兩個資料庫，一個是暫存用的資料庫 [![](https://stwillblogassets.blob.core.windows.net/files/images/external/stwillblogassets.blob.core.windows.net/035a3a16fe534e55efde-SNAGHTML52d8b3_thumb.png)](https://stwillblogassets.blob.core.windows.net/files/images/external/stwillblogassets.blob.core.windows.net/13ec75d8a11d840f4f75-SNAGHTML52d8b3.png) 這裡的「認證」是指「連結到報表伺服器資料庫」的連接資料庫的身份為何，預設為「服務認證」，也就是你的報表伺服器用什麼身份執行就會以什麼身份連接資料庫！ [![](https://stwillblogassets.blob.core.windows.net/files/images/external/stwillblogassets.blob.core.windows.net/6471b1e595f1429ad85b-SNAGHTML52ebd6_thumb.png)](https://stwillblogassets.blob.core.windows.net/files/images/external/stwillblogassets.blob.core.windows.net/9dddca3c666c49a269c0-SNAGHTML52ebd6.png) 設定完成後可以看一下摘要 [![](https://stwillblogassets.blob.core.windows.net/files/images/external/stwillblogassets.blob.core.windows.net/50dc5540567cc0108cbf-SNAGHTML52fc78_thumb.png)](https://stwillblogassets.blob.core.windows.net/files/images/external/stwillblogassets.blob.core.windows.net/77ac7a14da32b73513c7-SNAGHTML52fc78.png) 接著就會建立報表伺服器所需的資料庫起來，並設定適當的資料庫存取權限 [![](https://stwillblogassets.blob.core.windows.net/files/images/external/stwillblogassets.blob.core.windows.net/f30c5a1058987db37533-SNAGHTML532bc2_thumb.png)](https://stwillblogassets.blob.core.windows.net/files/images/external/stwillblogassets.blob.core.windows.net/d7d3dd9c6bf78044a46b-SNAGHTML532bc2.png) 從 Management Studio 也可以看到該資料庫的使用者的確有服務帳戶在裡面，若你日後修改服務帳戶就要記得來這裡新增使用者並賦予適當的權限 ![](https://stwillblogassets.blob.core.windows.net/files/images/external/stwillblogassets.blob.core.windows.net/94147ab6fb69e21c0aa8-image_38.png) 資料庫設定完成的畫面如下 [![](https://stwillblogassets.blob.core.windows.net/files/images/external/stwillblogassets.blob.core.windows.net/42d8333ba8c7842ed335-SNAGHTML535590_thumb.png)](https://stwillblogassets.blob.core.windows.net/files/images/external/stwillblogassets.blob.core.windows.net/b150f306d0e18bf4bfc7-SNAGHTML535590.png) 接著我們設定「**報表管理員 URL**」，這個虛擬目錄就是用來做為未來報表管理者透過網頁管理報表伺服器的 URL，我個人也是習慣將虛擬目錄修改成 Reports 比較好記憶，但請記得修改完務必按下右下角的「套用」按鈕！ [![](https://stwillblogassets.blob.core.windows.net/files/images/external/stwillblogassets.blob.core.windows.net/5bee36434fada49b6f84-SNAGHTML538dfd_thumb.png)](https://stwillblogassets.blob.core.windows.net/files/images/external/stwillblogassets.blob.core.windows.net/d4ddfc92f2bb648362aa-SNAGHTML538dfd.png) 這裡要設定電子郵件的寄件者地址與 SMTP 伺服器的位址 [![](https://stwillblogassets.blob.core.windows.net/files/images/external/stwillblogassets.blob.core.windows.net/e06b352ca6733de2714e-SNAGHTML543d20_thumb.png)](https://stwillblogassets.blob.core.windows.net/files/images/external/stwillblogassets.blob.core.windows.net/7787587515301875e586-SNAGHTML543d20.png) 由於 Reporting Service 有可能會需要存取報表伺服器以外的資源（例如從外部網站取得圖片），只要需要做這些工作時可以指令另一組權限更小的執行帳戶，以保護你報表伺服器的安全。 [![](https://stwillblogassets.blob.core.windows.net/files/images/external/stwillblogassets.blob.core.windows.net/87e1eaa659a5bea14e75-SNAGHTML54621d_thumb.png)](https://stwillblogassets.blob.core.windows.net/files/images/external/stwillblogassets.blob.core.windows.net/7780294fc4735a977987-SNAGHTML54621d.png) **加密金鑰**用來將你儲存在報表伺服器中的機密資料加密編碼（例如我們在**資料來源**設定的**連接密碼**），如果報表伺服器重新安裝的話，這些密碼就無法復原，就必須要全部重新設定過一遍，這時建議您可以先備份加密金鑰，以備不時之需。 [![](https://stwillblogassets.blob.core.windows.net/files/images/external/stwillblogassets.blob.core.windows.net/f0591b5eed101db153f5-SNAGHTML5474b3_thumb.png)](https://stwillblogassets.blob.core.windows.net/files/images/external/stwillblogassets.blob.core.windows.net/dcbcd74bcb8ee7a08d5f-SNAGHTML5474b3.png) **向外延展部署**是指設定「多台報表伺服器」共用一組「報表資料庫」的情況，主要是提供給報表運算量比較大的客戶使用，要設定這種部署方式必須 SQL Server 2008 R2 企業版以上才有支援。相關資料可參考 [規劃向外延展部署](http://technet.microsoft.com/zh-tw/library/bb630407.aspx) 說明。 [![](https://stwillblogassets.blob.core.windows.net/files/images/external/stwillblogassets.blob.core.windows.net/0eb26fb02e97c200d55a-SNAGHTML548382_thumb.png)](https://stwillblogassets.blob.core.windows.net/files/images/external/stwillblogassets.blob.core.windows.net/9d609b3cb3a616f91c78-SNAGHTML548382.png) 最後我們試著連接看看**報表管理員**是否可以正常使用： ![](https://stwillblogassets.blob.core.windows.net/files/images/external/stwillblogassets.blob.core.windows.net/3edc2d0cea68e493b012-image_39.png) 如果沒問題的話就會出現以下畫面： ![](https://stwillblogassets.blob.core.windows.net/files/images/external/stwillblogassets.blob.core.windows.net/87a3eba723063692c1a7-image_40.png) **相關連結** - [SQL Server Reporting Services 產品文件](http://technet.microsoft.com/zh-tw/library/ms159106.aspx) - **Reporting Services 教學課程 ( [SQL Server 2008 R2 教學課程](http://msdn.microsoft.com/en-us/library/ms167593.aspx) )** - [教學課程：如何尋找及啟動 Reporting Services 工具](http://msdn.microsoft.com/zh-tw/library/aa337424.aspx) 您可以使用這個教學課程來了解如何使用這些工具，以便設定報表伺服器、管理報表伺服器內容和作業，以及建立並發行報表和報表模型。 - [教學課程 (Reporting Services)](http://msdn.microsoft.com/zh-tw/library/bb522859.aspx) 您可以使用這個章節的教學課程來逐步了解基本報表設計技巧。 - [設計報表模型：教學課程](http://msdn.microsoft.com/zh-tw/library/bb522684.aspx) 您可以使用這個章節的教學課程來了解建立可用於報表產生器或報表模型查詢設計工具之模型的必要技巧。 - [開發人員手冊：教學課程 (Reporting Services)](http://msdn.microsoft.com/zh-tw/library/aa337423.aspx) 您可以使用這個章節的教學課程來了解開發 Reporting Services 方案之許多不同方式的相關資訊。 - **Reporting Services Tutorial ( [SQL Server 2008 R2 Tutorial](http://msdn.microsoft.com/zh-tw/library/ms167593.aspx) )** - [Tutorial: How to Locate and Start Reporting Services Tools](http://msdn.microsoft.com/en-us/library/aa337424.aspx) Use this tutorial to learn how to use the tools to configure a report server, manage report server content and operations, and create and publish reports and report models. - [Tutorials (Reporting Services)](http://msdn.microsoft.com/en-us/library/bb522859.aspx) Use the tutorials in this section to learn basic report design skills, one step at a time. - [Designing Report Models: Tutorials](http://msdn.microsoft.com/en-us/library/bb522684.aspx) Use the tutorials in this section to learn necessary skills for creating models that you can use in Report Builder or Report Model Query Designer. - [Developer's Guide: Tutorials (Reporting Services)](http://msdn.microsoft.com/en-us/library/aa337423.aspx) Use the tutorials in this section to learn about the many different ways to develop Reporting Services solutions. - [SQL Server Reporting Services - Wikipedia, the free encyclopedia](http://en.wikipedia.org/wiki/SQL_Server_Reporting_Services) - [SSRS Tutorial: SQL Server 2008 Reporting Services Tutorial](https://web.archive.org/web/20130724091340/http://www.accelebrate.com:80/sql_training/ssrs_2008_tutorial.htm)