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

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 - 

Dynamics 365 Business Central 2021 release wave 2 (BC19) Released.

Hi Readers, As we all were expecting Microsoft have Released Business Central 2021 Release Wave 2 Today a.k.a BC19. In this article we will see what all is announced with the General Availability.  Starting Today Customers & Partners can start using Business Central 19. #msdyn365bc #bc19

Error After Restore SQL Backup of NAV 2013 Database

Hi all, we are facing a conman issue during restoring a SQL Database backup restored for NAV 2013. While Trying to run object from Object Designer we get below listed error (even the service is configured properly) - --------------------------- Microsoft Dynamics NAV Development Environment --------------------------- There are no NAV Server instances available for this database. You must ensure that a NAV Server instance is running and is configured to use the database before you perform this activity. --------------------------- OK    ---------------------------