SQL SERVER – Installing SQL Server Data Tools and SSRS

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.

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.

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.

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.

Select Create a new report server database and click Next.

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.

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.

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 (http://blog.sqlauthority.com)

About these ads

3 thoughts on “SQL SERVER – Installing SQL Server Data Tools and SSRS

  1. Pingback: SQLAuthority News – 5 days of SQL Server Reporting Service (SSRS) Summary | Journey to SQL Authority with Pinal Dave

  2. 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

    Like

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s