再裝一次 CTP3

參照 Getting up and running with SQL Server Denali for Business Intelligence (Crescent and PowerPivot in CTP3)

中文版的 Crescent 存取始終有權限問題,不知是設定錯誤還是本身有問題,用英文版再試一次…

因為對 SharePoint、Hyper-V、AD、Denali 不夠熟悉,重裝 3 次仍有問題,這次留下些紀錄好檢討😦

 

待安裝的 WIndows 加入 Windows AD

裝 SharePoint 前須先裝 Prerequistes

image

安裝 SharePoint "Farm" 選擇 "完整" 但不要設定,讓 SQL Server 設定與 BI 整合

安裝 SharePoint 2010 SP1

找不到安裝前檢查所需的 Update

image

先完整安裝 Denali 所有的功能

image

自動建立相關服務的帳號

image

需要研究一下實際的授權狀況😦

image

可能因為還沒有設定 SharePoint

image

應先裝 SQL Server PowerPivot for SharePoint

image

不須選任何元件

image

服務帳戶似乎一定要 AD 帳號,非要加入 AD 不可 傷心,但奇怪的是要到 Server Configuration 才被迫放棄,為何不在選擇 SQL Server PowerPivot for SahrePoint 的步驟提醒…

image

裝完 AS,執行 PowerPivot Configuration Tool

image

SharePoint 的 Service Application 尚沒有 Reporting Service,再裝一次

image

AS 改裝 Tabular Mode

image

安裝完畢,SharePoint 還是沒有 SQL Server Reporting Services Service Application

參照 Configuring SQL Server Denali Reporting Services SharePoint 2010 Integration,透過 SharePoint 2010 Management Shell 執行

  1. Type the following PowerShell command> Install-SPRSService
  2. Type the following PowerShell command> Install-SPRSServiceProxy
  3. Now to start the service type the following PowerShell Command> get-spserviceinstance -all |where {$_.TypeName -like “SQL Server Reporting*”} | Start-SPServiceInstance

image

這才有

image

建立 SQL Server Reporting Services Service Application

image

建立完畢後的訊息

image

點選 Provision Subscriptions and Alters 後, Download Script 在 SQL Server 執行

image

還是一樣的錯誤…

image

還是沒有 Report Library

image

參照 Configuring SQL Server Denali Reporting Services SharePoint 2010 Integration:If you do not see the Reports Library option you will want to make sure that the Enterprise Features are enabled not only at the Site Collection Level, but also at the Site level.

image

image

啟動完 Site 的 SharePoint Server Enterprise Site features 就可以有 Report Library

image

若沒看到上述畫面,需要先安裝 SilverLight

image

而後就可以照 Configuring SQL Server Denali Reporting Services SharePoint 2010 Integration 做完練習了🙂

裝完英文版,才知是漏設定,非語言版本…

One Trackback

  1. By 再次安裝 SQL Server 2012 « 偶有所得 on 2012 年 03 月 09 日 at 14:54:52

    […] CTP3 和 RC0 的差異不大,可以參考前兩篇 […]

發表迴響

在下方填入你的資料或按右方圖示以社群網站登入:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / 變更 )

Twitter picture

You are commenting using your Twitter account. Log Out / 變更 )

Facebook照片

You are commenting using your Facebook account. Log Out / 變更 )

Google+ photo

You are commenting using your Google+ account. Log Out / 變更 )

連結到 %s

%d 位部落客按了讚: