SQL SERVER – Installing SQL Server Data Tools and SSRS

SQL SERVER - Installing SQL Server Data Tools and SSRS SSRS2012cover This example is from the Beginning SSRS by Kathi Kellenberger. Supporting files are available with a free download from the www.Joes2Pros.com web site.

If you have installed SQL Server, but are missing the Data Tools or Reporting Services

Double-click the SQL Server 2012 installation media. Click the Installation link on the left to view the Installation options. Click the top link New SQL Server stand-alone installation or add features to an existing installation.

SQL SERVER - Installing SQL Server Data Tools and SSRS ssrs3-1

Follow the SQL Server Setup wizard until you get to the Installation Type screen. At that screen, select Add features to an existing instance of SQL Server 2012. Click Next to move to the Feature Selection page. Select Reporting Services – Native and SQL Server Data Tools. If the Management Tools have not been installed, go ahead and choose them as well.

SQL SERVER - Installing SQL Server Data Tools and SSRS ssrs3-2

Continue through the wizard and reboot the computer at the end of the installation if instructed to do so.

Configure Reporting Services

If you installed Reporting Services during the installation of the SQL Server instance, SSRS will be configured automatically for you. If you install SSRS later, then you will have to go back and configure it as a subsequent step.

Click Start > All Programs > Microsoft SQL Server 2012 > Configuration Tools > Reporting Services Configuration Manager > Connect on the Reporting Services Configuration Connection dialog box.

SQL SERVER - Installing SQL Server Data Tools and SSRS ssrs3-3

On the left-hand side of the Reporting Services Configuration Manager, click Database. Click the Change Database button on the right side of the screen.

SQL SERVER - Installing SQL Server Data Tools and SSRS ssrs3-4

Select Create a new report server database and click Next.

SQL SERVER - Installing SQL Server Data Tools and SSRS ssrs3-5

Click through the rest of the wizard accepting the defaults. This wizard creates two databases: ReportServer, used to store report definitions and security, and ReportServerTempDB which is used as scratch space when preparing reports for user requests.

Now click Web Service URL on the left-hand side of the Reporting Services Configuration Manager. Click the Apply button to accept the defaults. If the Apply button has been grayed out, move on to the next step. This step sets up the SSRS web service. The web service is the program that runs in the background that communicates between the web page, which you will set up next, and the databases.

SQL SERVER - Installing SQL Server Data Tools and SSRS ssrs3-6

The final configuration step is to select the Report Manager URL link on the left. Accept the default settings and click Apply. If the Apply button was already grayed out, this means the SSRS was already configured. This step sets up the Report Manager web site where you will publish reports. You may be wondering if you also must install a web server on your computer. SQL Server does not require that the Internet Information Server (IIS), the Microsoft web server, be installed to run Report Manager.

SQL SERVER - Installing SQL Server Data Tools and SSRS ssrs3-7

Click Exit to dismiss the Reporting Services Configuration Manager dialog box.

Tomorrow’s Post

Tomorrow’s blog post will show how to create your first report using the Report Wizard.

If you want to learn SSRS in easy to simple words – I strongly recommend you to get Beginning SSRS book from Joes 2 Pros.

Reference: Pinal Dave (https://blog.sqlauthority.com)

,
Previous Post
SQL SERVER – Determine if SSRS 2012 is Installed on your SQL Server
Next Post
SQL SERVER – Create a Very First Report with the Report Wizard

Related Posts

13 Comments. Leave new

  • varaprasad M
    July 24, 2013 8:20 pm

    Thanks its very use full for me.

    Reply
  • when i install like start.—->all prgrams—->Microsoft Sql Server 2008 R2—–>Configuration Tools——->Sql Server Installation Center then i select New SQL Server stand-alone installation or add features to an existing installation but when i choose and select any folder or disk like program files or Disk C then it shows me error Invalid Folder ,…how i solve this issue? please reply

    Reply
  • Thanks for the guide, very helpful

    Reply
  • Thanks for your nice post … It was very helpful for me.

    Reply
  • Very good article. I was really struggling until I read this.
    Thank you

    Reply
  • It helps me.

    Reply
  • Can I add Reporting Services to an existing SQL Server instance while it is in use? Or do I need to do this during a maintenance window when there are no users connecting?

    Reply
  • Thanks.
    I have an issue. When I open Reporting Services Configuration Manager a pop up opens with Server name and Report Server Instance. Server Name is displaying but Report Server Instance is blank and disabled, also connect button is disabled. please give me solution.

    Reply
    • That might be due to version mismatch between of Reporting Service Configuration manager tool and SSRS Engine.
      OR
      It would be a WMI issue.

      Reply
  • Hello Sir,

    I have install Sql server 2017 Custom mode, It comes with the database engine only i unable to see reporting service from service configuration section. After that i downloaded reporting service exe file but i’m not be able to understand how can i configure. please help me on that.

    Thanks in advance

    Reply

Leave a Reply

Menu