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.

Regards,
Saurav Dhyani
saurav-nav.blogspot.in

Comments

Popular posts from this blog

BC 21 and Higher - PowerShell Cmdlet (Replacement of Business Central Administration).

Hi Readers, As discussed in last article about deprecating of Business Central Administration, there are few common actions that we use in administration till Business Central 20. For our on-prem customers, we will still require doing activities. As Microsoft suggest we need to start using PowerShell cmdlet.    Let's see how to do those via PowerShell, or Administration Shell. I will be keep adding commands as you comment to this article.

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 - 

MSDYN365BC - Data Upgrade To Microsoft Dynamics 365 Business Central on premises.

Hi Readers, We have already talked about the number of steps for upgrading to Business Central on Premises from different NAV versions. After that article, I received multiple requests for an article which list down steps for Data Migration. In this article, we will discuss steps of data migration to MSDYN365BC (on-Prem) from NAV 2017. For this article, I am considering a Cronus Demo Database without any customization. For an actual upgrade project, we will have to complete object merge using compare and Merge process. After the Merge Process, the next step is data migration. Let's discuss those steps. Direct Upgrade to Microsoft Dynamics 365 Business Central (on-Prem) is from following versions - 1. NAV 2015. 2. NAV 2016. 3. NAV 2017. 4. NAV 2018.