Thursday, November 24, 2011

install Sharepoint 2010 with Daneli (SQL Server 2012)

requriement: Denali CTP3
                    Sharepoint 2012 SP1

Installation:
  1. Install Dentali CTP3, without installed the sharepoint add-in. and did not configure the SSRS to run in the native mode by selecting the option of no configure the SSRS Server.
  2. Install Sharepoint SP1.
  3. installed SSRS for sharepoint by running the SQL Server Installation againt to add SSRS for shareoint feature.
  4. installed Powerpivot new standalone server.
  5. run the sharepoint 2010 server configuration wizard.
  6. installed the SSRS for sharepoint add-in.


Installation Error:
Error installing SQL Server Reporting Services
Error code: 1603
Root Cause: the Sharepoint Server is installed, but did not configure properly.
Solution: Run the Sharepoint Server Configuration Wizard First. then installed the Denali Reporting Service Add on for Sharepoint.

Error: SQL Reporting Service Application is not Shown in the Service Appliation DropDownList
Root Cause: The SSRS Service did not register properly in the sharepoint server.
Solution: run the following script in the powershell command prompt with administrative privilege ( right click on the PowerShell Icon and select Run As Administrator )
to register the SSRS Service and proxy, and instantiate the SSRS Service.
  1. Install-SPRSService
  2. Install-SPRSServiceProxy
  3. Get-SPServiceInstance -all |where {$_.TypeName -like "SQL Server Reporting*"} | Start-SPServiceInstance 
to be continue

No comments:

Post a Comment