TN PT111 How to Configure SQL 2012 Reporting Services

Description

How to Configure SQL 2012 Reporting Services

• Author: Mike Viteri
• Published: 11/12/2015
• Applies to: Microsoft SQL Server 2012

Details

This technote assumes you have MSSQL 2012 installed with the reporting add in and are working local.

Click Start->Programs->Microsoft SQL Server 2012->Configuration Tools->Reporting Services Configuration Manager

It will ask you to connect to the SQL Server Instance. Click connect.

The configuration manager will open and will have a list of options that need to be configured.

Click on Service Account. It will ask the account to use. I used the default ReportServer Account. Click Apply at the bottom of the screen.

Next click on Web Service URL. In this section you can change your virtual directory and site identification. I will accept the defaults here and click apply at the bottom. 

Next click Database. Click Change Database.

Click "Create a new report server database". Then click next

Then select your security type. We will take the default. Test the connection. Then click next.

The database name should be the one you created. Click next.

Click on next. It will create the report database. Once its done configuring click on finish.

Next click on Report Manager URL. Click apply at the bottom of the page and it will configure your url.

Open your web browswer and go to http://yourservername/Reports and the page below should appear.