Configure the Reporting Services Configuration Manager >> SQL Server 2012

To do the initial configuration of SSRS, or to change the configuration of an existing installation, you need to start the Reporting Services Configuration Manager (Start menu >> Programs >> Microsoft SQL Server 2012 >> Configuration Tools >> Reporting Services Configuration Manager);

The Configuration Manager can largely be treated as a wizard as you move down the tabs on the left side of the window. The first step is to set the Service Account. Once you’ve made you selection and entered logon details click the Apply button;

 

Move to the Web Service URL and either accept the default or change the Virtual Directory and Web Service Site identification details (make sure you make a note of the Report Server Web Service URL as you will need this when configuring SSRS within Microsoft SharePoint);

After you’ve clicked Apply, the Results section will confirm the Virtual Directory has been created and the URL reserved.

Click the Database Tab to select, or create a new, database for use with SSRS;

 Click the Change Database to open the Report Server Database Configuration Wizard. I’m leaving the default option of Create a new report server database and click Next;

Enter the Server Name and connection details for the SQL server which will hold the SSRS database and click Next;

Enter the Database and Temp Database Names, pick your language (unfortunately we’re restricted to only English (United States) without an option for English and pick whether SSRS should be in Native or SharePoint Integration Mode. For simplicity I have chosen Native Mode;

 Enter the log on credentials. Again I have chosen Service Credentials but would recommend a Domain User account for a production environment;

Click Next and you’ll be presented with a summary of your selections. Review them and click Previous to make any changes or click Next to proceed;

The Wizard will verify the configuration and present confirmation where you need to click Next;

The Database tab of the main Reporting Services Configuration Manager window will be updated with the database details. Review them and click Apply;
 

Move to the Report Manager URL tab and enter the Virtual Directory you want to use (I left this at the default option but in hindsight I’d rather have changed this to ReportManager_SQL2012);

After clicking Apply, as with the Web Service URL tab, you’ll be presented with confirmation that the virtual directory has been created and the URL reserved;

Click E-mail Settings and configure the SMTP settings if you want to use Report Server e-mail and click Apply;

On the Execution Account tab enter the details for accessing remote servers that store external images (make sure you use a domain user account with minimal read-only permissions) and click Apply;

Click onto the Encryption Keys tab. Whenever I see a Backup button I feel the need to do so. In the case of a demo system this isn’t especially important, but on a production environment I’d recommend you back up the Encryption Key in case of a need to recover or move the SSRS database;

 


The final step is to scale out the Deployment should you wish;
 

When done click close and SSRS will be available for use within SharePoint.



Hope you enjoyed reading this. Your comments, votes and suggestions motivates us for writing more stuffs like this.