SQL Server Reporting Services 2012 with Microsoft Dynamics GP 2010
With the Release of Microsoft SQL Server 2012, there are new considerations to be made when deploying SQL Server Reporting Services 2012 to use with Microsoft Dynamics GP 2010.
Here are a couple of the main ones.
Native Mode Deployment
1.Â If youâ€™re going to deploy the Microsoft Dynamics GP 2010 reports to a Native mode site in SQL Server Reporting Services 2012 you need to select the â€śReporting Services – Nativeâ€ť feature when installing Microsoft SQL Server 2012
2.Â You then use the Reporting Services Configuration Manager to setup your Native mode instance, just as you would have in SQL Server 2008
SharePoint Integrated Deployment
- If youâ€™re going to deploy the Microsoft Dynamics GP 2010Â reports to a SharePoint Integrated instance of SQL Server Reporting Services you need to select the â€śReporting Services â€“ SharePointâ€ť and â€śReporting Services Add-in for SharePoint Productsâ€ť features when installing Microsoft SQL Server 2012
2.Â You do not use the Reporting Services Configuration Manager to setup your SharePoint Integrated instance.Â You perform all of the setup in SharePoint using the following steps:
- Install the Reporting Services SharePoint service using the SharePoint 2010 Management Shell
- Start the Reporting Services SharePoint service in SharePoint 2010 Central Administration
- Create a Reporting Services service application in SharePoint 2010 Central Administration
- Configure the Reporting Services Integration in SharePoint 2010 Central Administration
- Activate the Claims to Windows Token Service in SharePoint 2010 Central Administration
- Create a Reports site in SharePoint
- Optional if you already have a site for the reports to reside on
- Create a Reports Library document library on your SharePoint site
- You can then proceed to deploy the reports from Dynamics GP 2010
1.Â The SQL Server 2012 installer will now create a service account called â€śNT ServiceReportServer$Instancenameâ€ť to run the service.
2.Â We have updated the “SQL Server Reporting Services Guide” for Microsoft Dynamics GP 2010Â to include all of the new information for SQL ServerÂ Reporting Services 2012.Â You can find the manual at the following URL.
3.Â For more information on SQL Server Reporting Services 2012 overall,Â refer to the following URL that has a lot of great links and information on it.
April 19, 2012
Â· Nicole Albertson Â· No Comments
Tags: dynamics, Dynamics GP, integration, Inventory, microsoft-dynamics, reporting, security, sql server, sql server 2008, srs, ssrs, upgrade Â· Posted in: Blogs I Follow Total Views: 451