PowerShell script to configure SQL Server Reporting Services in SharePoint mode

Originally posted on Vignesh's SharePoint Thoughts:
The below mentioned script will take care of the steps listed below : Installs Reporting Services service and service proxy, and starts the service.2 Creates a service proxy named “Reporting Services”. Creates a Reporting Services service application named “Reporting Services Application”. Enables the Power View feature for a…

Report Bulider 3.0 ‘NT AUTHORITY\ANONYMOUS LOGON’ Error

I was trying to edit some of rdl resports on one server and get this kind of error : ​he permissions granted to user ‘NT AUTHORITY\ANONYMOUS LOGON’ are insufficient for performing this operation. —> Microsoft.ReportingServices.Diagnostics.Utilities.AccessDeniedException: The permissions granted to user ‘NT AUTHORITY\ANONYMOUS LOGON’ are insufficient for performing this operation.​ when I googled this error it… Continue reading Report Bulider 3.0 ‘NT AUTHORITY\ANONYMOUS LOGON’ Error

Unable to install this application because an application with the same identity is already installed.

This kind of error I get trying to edit rdl file by Report Bulider 3.0. After while I figured out that I need do this two steps : 1. Open a command prompt. Enter the following:  rundll32 dfshim CleanOnlineAppCache Press Enter. 2.  Go to the C:\Users\[User Name]\AppData\Local\Apps\2.0 Delete the all temporay files. *You may want… Continue reading Unable to install this application because an application with the same identity is already installed.

Conditionally Setting Column Visibility in SSRS

In this article I will show you real example of the usage of Column Visibility property in SSRS. Column visibility property is used to show or hide the column in the report. Now in this article, we can use this property to allow the users to select columns what they want to see in a… Continue reading Conditionally Setting Column Visibility in SSRS

SSRS in SharePoint Integration mode with custom rendering extention ( export files )

Problem I can modify the rendering format of a Reporting Services report by making changes to the RSReportServer.config file. However, this does not work when Reporting Services is running in SharePoint-integrated mode. How can we accomplish this? Since Reporting Services in both native and SharePoint-integrated mode have the RSReportServer.config file, we have gotten used to the… Continue reading SSRS in SharePoint Integration mode with custom rendering extention ( export files )