Sign in
 
Home20122008 R2200820052000LibraryForums
SQL Server >
> 
> 
SSRS 2012 & SharePoint Foundation 2010 Configuration

Answered SSRS 2012 & SharePoint Foundation 2010 Configuration

  • Friday, June 22, 2012 6:59 PM
     
     
    Sign In to Vote
    0

    I have 2 servers.  Server 1 = SQL 2012 with SSRS in SharePoint Integrated Mode installed.  Server 2 = WFE with SharePoint Foundation 2010 Installed.

    I ran the configuration wizard to create the SharePoint farm.  However on the next step on the General Application Settings I see SQL Server Reporting Services (2008 and 2008 R2).  I am guessing this shows because a pre-requisite to install SharePoint Foundation was SQL 2008 Native Client.

    My question is I want to use SQL 2012.  I installed the SQL 2012 Native Client, which SharePoint Foundation didn't seem to recognize because it still wanted the SQL 2008 Native Client.

    So on the Central Adminstration do I go ahead and finish my configurations with SQL Server Reporting Services (2008 and 2008 R2) or how do I get SQL 2012 to show as an option.

    Thanks

     

All Replies

  • Monday, June 25, 2012 10:01 AM
    Moderator
     
     
    Sign In to Vote
    0

    Hello rlbcas,

    From your description, the problem is that SharePoint 2010 cannot recognize the SQL 2012 native client. Based on my knowledge, SharePoint 2010 does not support the SQL 2012. You need install SharePoint 2010 SP1 first. For more information, please review the KB article of SharePoint 2010 SP1.

    http://support.microsoft.com/kb/2460045
    http://www.microsoft.com/en-us/download/details.aspx?id=26623 (You can download the SP1 from this link.)

    If you have installed the SP1 for SharePoint 2010, and still encounter this issue, please share the error screenshot for further troubleshooting. If you have any questions, please post it out.

    Regards,

    Edward

    TechNet Subscriber Support

    If you are TechNet Subscription user and have any feedback on our support quality, please send your feedback here.

    Edward Zhu

    TechNet Community Support

     
  • Monday, June 25, 2012 3:21 PM
     
     
    Sign In to Vote
    0

    I did install sp1 for SharePoint 2010 on both the SQL and WFE servers.

    I don't get an error message.  The issue is I don't see on the Central Administration General Application Settings an option for SSRS 2012.  The only option I see if SSRS 2008 and 2008 R2.

    Just not sure if I go ahead and configure SSRS using 2008 or if there is way to get SSRS 2012 to show up as an option since by SQL Server is 2012.

     
  • Wednesday, June 27, 2012 5:22 AM
    Moderator
     
     Answered Has Code
    Sign In to Vote
    0

    Hello rlbcas,

    SSRS 2012 is totally different with previous SSRS version. It is implemented into a SharePoint shared service, and all configuration is in the SharePoint Central Administrator site instead of the entry SQL Server Reporting Services (2008 and 2008 R2). 

    First, please open the SharePoint Central Administrator in IE browser and click Application Management > Manage services on server to check whether the service SQL Server Reporting Services service does exist and is started. If you cannot find out the service, it seems that you are not enabled the service on the SharePoint service. Please follow the next steps to enable the Reporting Server in SharePoint.

    1. Click the Start button. Click the Microsoft SharePoint 2010 Products group. Right-click SharePoint 2010 Management Shell click Run as administrator.
    2. Run the following PowerShell command to install the SharePoint service. A successful completion of the command displays a new line in the management shell. No message is returned to the management shell when the command completes successfully:
      Install-SPRSService
    3. Run the following PowerShell command to install the service proxy:
      Install-SPRSServiceProxy
    4. Run the following PowerShell command to start the service or see the following notes for instructions to start the service from SharePoint Central administration: 
      get-spserviceinstance -all |where {$_.TypeName -like "SQL Server Reporting*"} | Start-SPServiceInstance

    After a while, go to the Manage Service on Server page to review whether the service is available.

    After the service is installed properly, please Create the Reporting service application on the SharePoint. This step is to create a new SharePoint reporting service database and configure it.

    1. In SharePoint Central Administration, in the Application Management group, click Manage Service Applications.
    2. In the SharePoint ribbon, click the New button.
    3. In the New menu, click SQL Server Reporting Services Service Application.
    4. In the Create SQL Server Reporting Services Service Application page, enter a name for the application. If you are creating multiple Reporting Services service applications, a descriptive name or naming convention helps you organize your administration and management operations.
    5. In Application Pool section, create a new application pool for the application (recommended). Using the same name for the new application pool as the service application, makes ongoing administration easier.
      Select or create a managed account for the application pool. Be sure to specify a domain user account. A domain user account enables the use of the SharePoint managed account feature, which lets you update passwords and account information in one place. Domain accounts are also required if you plan to scale out the deployment to include additional service instances that run under the same identity.
    6. In the Database Server, you can use the current server or choose a different SQL Server.
    7. In Database Name the default value is ReportingService_<guid>, which is a unique database name. If you type a new value, type a unique value.
    8. In Database Authentication, the default is Windows Authentication. If you choose SQL Authentication, refer to the SharePoint administrator guide for best practices on how to use this authentication type in a SharePoint deployment.
    9. In the Web Application Association section, select the Web Application to be provisioned for access by the current Reporting Services Service Application. You can associate one Reporting Services service application to one web application. If all of the current web applications are already associated with a Reporting Services service application, you see a warning message.
    10. Click OK.

    For more information about the above steps, please review the following article on MSDN.

    http://msdn.microsoft.com/en-us/library/gg492276.aspx

    If you want to have further configuration on the reporting service, please follow the next steps.

    1. In SharePoint Central Administration, in the Application Management group, click Manage Service Applications. 
    2. Find out the application name you set in the above instruction, and click it.
    3. Then you will go to the configuration page. In the configuration page, you can set the Email settings, SharePoint subscription and alerts, and etc. Here is the screenshot of the settings page.

    If you have any questions about this issue, please let me know.

    Regards,

    Edward

    Edward Zhu

    TechNet Community Support

     
  • Wednesday, June 27, 2012 7:13 PM
     
     
    Sign In to Vote
    0

    Edward,

    I have the same issue as rlbacs.  I tried your solution with no luck.  I don't get any errors, it just doesn't show up anywhere. I have a 2 WFE & 4 SVC farm and I'm installing this on a SVC server that IS NOT hosting CA.  I am running SSRS 2008R2 on another SVC server but MSFT insured me that I can run them in parallel.  Any more help or guidence would be awesome!

    Thanks,

    Mike

    
    
     
  • Monday, July 02, 2012 3:19 AM
    Moderator
     
     
    Sign In to Vote
    0

    Hello Mike,

    I am sorry for my delay.

    The above instruction is only for SQL Server 2012 on SharePoint 2010 SP1 integration. If your SSRS version is 2008 R2 or prior, please set it in the entry SQL Server Reporting Services (2008 and 2008 R2).

    I hope my information is helpful to you. If you have questions, please provide us more detail information.

    Regards,

    Edward

    Edward Zhu

    TechNet Community Support