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

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

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.

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. Click the Start button. Click the Microsoft SharePoint 2010 Products group. Right-click SharePoint 2010 Management Shell click Run as administrator.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 Run the following PowerShell command to install the service proxy: Install-SPRSServiceProxy 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. In SharePoint Central Administration, in the Application Management group, click Manage Service Applications.In the SharePoint ribbon, click the New button.In the New menu, click SQL Server Reporting Services Service Application.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.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.In the Database Server, you can use the current server or choose a different SQL Server.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.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.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.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. In SharePoint Central Administration, in the Application Management group, click Manage Service Applications. Find out the application name you set in the above instruction, and click it.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, EdwardEdward Zhu TechNet Community Support

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