SSRS-Security, Deployment and Configuring: SSG GP Tips

By Amy Coddington posted Sep 25, 2015 11:36 AM


SSRS – Security, Deployment and Configuring

By Eric Robert Jackson

September 25, 2015

The installation of Reporting Services can be done during the initial install of Microsoft SQL Server or it can be added on and configured later or even installed to a separate server. The installation of SSRS should be done as a domain administrator.

Once the core installation of SSRS is complete and you are able to access the main page of the website, you will need to set the maximum request length in Reporting Services configuration to be able to complete the automatic deployment of the default reports.

To deploy the default SSRS reports, you will need to log into Dynamics GP as a system administrator. Be sure to launch Dynamics GP using the Run as Administrator option. The deployment tool is located on the Administration page in the System section. Enter the path to your SSRS website and click the deploy button to begin the process.

The reports are secured in two areas, SQL Security through Logons and Role Assignments on the SSRS website.  To begin the process of assigning security you will want to add Active Directory Users or Groups to the SQL Security window using SQL Management Studio. In here, you will assign the User or Group to specific company databases and select security report roles that were previously created by the installation of Dynamics GP.

The next step in security will be to add your Active Directory Users or Groups to the SSRS website. Navigate to the website using Internet Explorer and click on the Folder Settings button to begin the process. Each company will have a corresponding folder that you can add your Users or Groups to individually. You will click on the New Role Assignment button and add the User or Group and assign them a role. One last step in setting security is to add your User or Group to the Site Settings of SSRS. This is a similar process to give them a Role Assignment.

Now that you have the base SSRS install complete and the default reports in place, users will be able to use these reports and view them in Dynamics GP, directly via the SSRS website, or in the Business Analyzer tool. It is also possible to create your own custom reports using SQL Report Builder and SQL Management Studio. The possibilities are endless. SSRS reports are fast and secure, available to anyone in your network.