SQL Server administration and T-SQL development, Web Programming with ASP.NET, HTML5 and Javascript, Windows Phone 8 app development, SAP Smartforms and ABAP Programming, Windows 7, Visual Studio and MS Office software
Development resources, articles, tutorials, code samples, tools and downloads for ASP.Net, SQL Server, Reporting Services, T-SQL, Windows, AWS, SAP HANA and ABAP


SQL Server Reporting Services Error : Server is not configured for RPC


When I ran a SQL Server 2000 Reporting Services report on a server I got the following Reporting Services error message:

Reporting Services Error

An error has occured during report processing. (rsProcessingAborted)

Query execution failed for data set '...'. (rsErrorExecutingCommand)

Server '...' is not configured for RPC.

 

reporting-services-RPC-error

I later noticed that the server which is causing this error is defined as a linked server on the SQL Server that the Reporting Services is installed on.

When I checked the Linked Server properties of the related SQL Server, I see that the RPC is disabled. After I have enabled the RPC option the error that the server is not configured for RPC has dissappeared.





An interesting thing about the linked servers when compared between SQL Server 2000 and SQL Server 2005 is that the default linked server properties differ in options tab. For example RPC and RPC Out are both enabled in SQL Server 2000 but these features are now disabled by default for SQL Server 2005.

You see below a linked server options tag defined in a Microsoft SQL Server 2000

Linked-Server-Properties

And below is a linked server options tab that is defined in MS SQL Server 2005.

Linked-Server-Properties



SQL Server

SQL Server 2019 Installation
download SQL Server 2019
download SQL Server 2017
download SQL Server 2016
download SQL Server 2014
download SQL Server 2012
MacOS ve SQL Server 2019


Copyright © 2004 - 2021 Eralper YILMAZ. All rights reserved.