Completely remove SSRS instance from SharePoint farm

In this article I’ll show how to completely remove SSRS instance setup in SharePoint 2013 integrated mode. Before reading on the uninstallation procedure, you can read this article on installing and configuring SSRS

When we install SSRS in SharePoint integrated mode, there are two components we need to configure. They are,

• Reporting Services Add-In for SharePoint
• Reporting Services – SharePoint

When uninstalling, we have to remove both of those components.

1. Removing Reporting Services Add-In for SharePoint

Remember, we have to setup Reporting Services Add-In in all SharePoint servers.So we have to remove them from all SharePoint servers in the farm.

Anyway uninstallation is straight forward. First you have to navigate to Add/Remove programs and uninstall the add-in as you would do for any other program

2. Removing Reporting Services – SharePoint

To remove this we need to log-in to our SSRS server, the server where our “SQL Server Reporting Services” instance is running in our farm. Then we have to navigate to Add/Remove programs again and perform following actions

3. Remove Service Application Databases

Above actions will not remove service application databases. You have to manually remove them from your database server

SSRS - “The item '.rdl' cannot be found. ---> Microsoft.ReportingServices.Diagnostics.Utilities.ItemNotFoundException: The item '.rsds' cannot be found” in multi server SharePoint farm

I came across above exception when modifying the data source of SSRS reports using reporting services SOAP web service. Following is the detailed exception I received.

“System.ApplicationException: Failure in ActivateFeature for feature “<Feature>” on site: “<Site>” ---> System.Web.Services.Protocols.SoapException: The item 'http://sp13/Reports/TestReport.rdl' cannot be found. ---> Microsoft.ReportingServices.Diagnostics.Utilities.ItemNotFoundException: The item 'http://sp13/Reports/TestReport.rdl' ' cannot be found.   
at System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage message, WebResponse response, Stream responseStream, Boolean asyncCall)”

To resolve the issue I had to follow the steps given below

1. Check if you have installed SSRS Service and Proxy in all SharePoint Servers   

I found out above services were installed only in my application server. So I had to configure it in all WFE servers

1. Install-SPRSService
2. Install-SPRSServiceProxy

2. Recreate the SSRS Service application

above actions solved my issue :)

SSRS - System.Web.Services.Protocols.SoapException: The permissions granted to user 'NT AUTHORITY\ANONYMOUS LOGON' are insufficient for performing this operation. when using ReportingServices2010.asmx in web applications with multiple authentication providers

I came across above exception when accessing SSRS reports using reporting services SOAP web service. Following is the detailed exception I received.

“System.ApplicationException: Failure in ActivateFeature for feature "<Feature>" on site: '<Site>' ---> System.Web.Services.Protocols.SoapException: The 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.
at System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage message, WebResponse response, Stream responseStream, Boolean asyncCall)
at System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String methodName, Object[] parameters)
at Microsoft.SqlServer.ReportingServices2010.ReportingService2010.CreateCatalogItem(String ItemType, String Name, String Parent, Boolean Overwrite, Byte[] Definition, Property[] Properties,”

To resolve the issue I had to include following code segment when calling the web service

1. ReportingService2010 service = new ReportingService2010();
2. service.Credentials = CredentialCache.DefaultCredentials;
3. service.Url = "http://sp13/_vti_bin/ReportServer/ReportService2010.asmx";
4.  
5. var authCookie = HttpContext.Current.Request.Cookies["FedAuth"];
6. if (authCookie != null)
7. {
8.   var fedAuth = new Cookie(authCookie.Name, authCookie.Value, authCookie.Path, string.IsNullOrEmpty(authCookie.Domain) ? HttpContext.Current.Request.Url.Host : authCookie.Domain);
9.   service.CookieContainer = new CookieContainer();
10.   service.CookieContainer.Add(fedAuth);
11. }

Install SQL Server Reporting Services in multi server SharePoint 2013 farm with Windows 2012 R2 and SQL Server 2014 hosted in Azure VMs

Recently I installed SQL Server Reporting Services in SharePoint integrated mode in following multi server environment. I used Windows Server 2012 R2 for the operating system and SQL Server 2014 as the database server. My server farm is hosted in Azure VMs.

So following are the steps I used to install and configure SSRS

1. Installation of Reporting Services in SharePoint mode and Reporting Services add-in for SharePoint in Application server

• Download SQL Server 2014 image in application server and start the setup
• Select Reporting Services – SharePoint and Reporting Services Add-in for SharePoint
• Complete the installation

2. Installation of Reporting Reporting Services add-in for SharePoint in WFE server

• Download or copy SQL Server 2014 image in WFE server and start the setup
• Select Reporting Services Add-in for SharePoint

 

• Complete the installation

3. Register SQL Server Reporting Services service in SharePoint 2013

• We have to execute following two commands in both servers

Install-SPRSService

Install-SPRSServiceProxy

4. Start SQL Server Reporting Services service in App server


5. Create new SQL Server Reporting Services service application in Central Administration

That’s all we need to do.

Caution !!

Prior to the above successful configuration, I tried the same using Reporting Services Add-in utility downloaded from Microsoft.

Unfortunately it got the SQL Server Reporting Services Service stuck in Starting

Finally I was able to complete it after downloading the SQL Server image to my server to do the configuration as I mentioned above