Wednesday, March 23, 2016

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

image

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

image

clip_image001

clip_image003

clip_image005

clip_image007

3. Remove Service Application Databases

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

Thursday, March 3, 2016

Resolving Power Query error “Specified value has invalid CRLF characters.Parameter name: value” when connecting with SharePoint on-premises site

In Microsoft Office Excel Power Query, we have an option to connect with SharePoint lists. When I tried to test the functionality with on-premises SharePoint sites it was always giving me the error “Specified value has invalid CRLF characters.Parameter name: value”.

Following were the steps I used to connect with my SharePoint site

image_thumb34

image_thumb53

image_thumb42

image_thumb40

Unfortunately this was the error I got for all my on-premises environments

image_thumb3

I changed web application settings and enable anonymous authentication for that web application, but nothing worked for me. Then I tried with a SharePoint online environment. It worked perfectly!! So was that due to a SharePoint build difference?

I checked my on-premise SharePoint patch level. they were all patched with November 2014 CU. Ok, that was pretty old !!

Then I updated one of my SharePoint environments with the latest CU, which is the March 2016. You can download the CU from this location. You can read the relevant KB article from following location

After the update I was able to successfully connect to my SharePoint environments.

image_thumb25

image_thumb28