Skip to main content

How to Configure SQL Server Reporting Services

Hi all,

In this post we will see how we can configure SQL Server Reporting Services.

1. Open Reporting Services Configuration Manager from -
Start Menu -> Microsoft SQL Server -> Configuration Services as shown below.

* If you don't see the Reporting Services Configuration here, you need to install it first from SQL Server DVD.

2. You need to specify the server name for which you want to configure the Reporting Services.
* By Default it shows the Local SQL Server Name.

3. Click Connect after specifying the Server Name. Hit Apply in the Next window as shown below.
By Configuration Web Service URL you will get the Base URL for All the Report that you publish.

4. Next is Database.
SSRS Creates Two Database, these databases are used to store the URL and Report Defination Uploaded by you on server.

5. Click Next on New Database and provide a name of the database.
* Default Name SQL Reporting Database.

6. Once you click Finish the Database is created on SQL Server Selected in step 1.

7. Next you need to set the Report Manager URL, where you can upload, modify and delete SSRS Reports.
This URL will also provide you access to the Security sections of the SSRS Report, where you can specify rights to users.

8. If you want to configure the Auto Email part, then u can setup that on E-mail settings.

Once done the SSRS Reporting server is deployed.

In Next post in this series we will see how to check the Deployed Reporting Server and conman issues.

Saurav Dhyani


Popular posts from this blog

Welcome - Microsoft Dynamics 365!

Hi All, In this article we will discuss the new introduced member of Dynamics Family. Yes you heard it correctly, one more new member with Name "Microsoft Dynamics 365" . #ProjectMadeira   #Dynamics365

Send Mail with Attachment From Navision.

Hi all, We have seen how to save a report into PDF and how to send mail to a customer. Let's link these two post in one i.e. Mailing statement to a customer into PDF Format. This article is part of the Series. Please Refer  Table of Content here . If you have the old objects set let me brief you what I will be changing - 

NAV 2013 Credential Type - How to Use?

Hi all, Please do these activities when you have time, its a long activity and i would suggest do all activities in one go. So be clam and lets start. For NAV 2013 R2 Refer Here. For NAV 2016 Steps have been Reduced Please Refer Here. I have installed NAV 2013 and its work great with my windows credentials. I was checking the service console (Microsoft Dynamics NAV Administration) in NAV 2013 and found out that Credentials Type have multiple Options.