Category Archives: Reporting Services

SSRS Cluster, How to Install and Configure SQL Server Reporting Service Cluster Configuration for High Availability VIDEO

How to Configure SQL Server Reporting Service on Cluster (SSRS Cluster) for High Availability ? We can configure SQL Server Database Engine, Analysis Services and Integration Services  for High availability but how to Configure Reporting Services on Cluster (SSRS Cluster) for High Availability that too without using a any third party Load Balancing component. The [...]

User does not have required permissions. Verify that sufficient permissions have been granted and Windows User Account Control (UAC) restrictions have been addressed – SQL Server Reporting Services Error

User ‘DBATAG-DEMO\cluadmin’ does not have required permissions. Verify that sufficient permissions have been granted and Windows User Account Control (UAC) restrictions have been addressed. I received this error, when I was trying to configure SQL Server Reporting Services for “Scale-OUT Deployment” for NLB configuration. I was logged in as Domain / Enterprise Administration account still [...]

101 SQL Server Reporting Services Interview Questions with Answers

In this post, I am going to walk you thru SQL Server Reporting Services Interview Questions from GENERAL | BASICS | Introduction DBA (Production Support) Prospective DBA + Developer Common Questions Developer (Report Designer) Prospective Solution Architect prospective IT Manager prospective GENERAL Questions – SSRS Interview Questions What is SQL Server Reporting Services? Reporting Services [...]

SQL Server Express with Reporting Services

Can we run Reporting Services with SQL Server Express Edition, which is a free version of SQL Server ? Yes, SQL Server 2005 Express Edition with Advanced Services support Reporting Services. we can use SQL Server Express Edition for deploying reporting Services. What are the limitations in Reporting Services on SQL Server Express Edition ? [...]

Installing & Configuring SQL Server Reporting Services on Cluster Environment for High Availability

I was working on project, where there is only a one cluster box which is being used for Database Services to meet high availability requirements. Customer, understood some reporting Services feature so asked developers to build some required reports, which was being done. Now things need to be pushed to production so a requirement for [...]

SQL Server Reporting Service – Find out a report schedule job name

Currently I was working with one of my developer and he asked me to run a report once again so that subscribers to that reports will get the updated report. I said, if I execute a report, I mean to say, if I open a report Server url and click on required report, I will [...]

How to Integrate Map with SQL Server Reporting Services – Video

This video explains how to insert a map into a report using SQL Server 2008 R2 Reporting Services. The map utilizes spatial data within a SQL Server database This video demonstrates the following: Create a report using Business Intelligence Design Studio Add a map to the report Define spatial to visual within the report The [...]