You can set server properties on a report server to return additional information about error conditions that occur on remote servers. If an error message contains the text "For more information about this error, navigate to the report server on the local server machine, or enable remote errors", you can set the EnableRemoteErrors property to access additional information that can help you troubleshoot the problem.
Start Management Studio and connect to a report server instance.
Right-click the report server node, and select Properties.
Click Advanced to open the properties page.
In EnableRemoteErrors, select True.
Click OK.
Create a text file and copy the following script into the file.
Public Sub Main() Dim P As New [Property]() P.Name = "EnableRemoteErrors" P.Value = True Dim Properties(0) As [Property] Properties(0) = P Try rs.SetSystemProperties(Properties) Console.WriteLine("Remote errors enabled.") Catch SE As SoapException Console.WriteLine(SE.Detail.OuterXml) End Try End Sub
Save the file as EnableRemoteErrors.rss.
Click Start, point to Run, type cmd, and click OK to open a command prompt window.
Navigate to the directory that contains the .rss file you just created.
Type the following command line, replacing servername with the actual name of your server:
rs -i EnableRemoteErrors.rss -s http://servername/ReportServer
Does the top process work? I don't see it in my ssms. SQL 2005, 9.00.3073.00. Maybe becuase my report server is a named instance (something I will never do again as it causes many issues in SSIS too).rs -i EnableRemoteErrors.rss -s http://servername/Reportserver$instance
[Tai Yee - MSFT] Hi, the best way to get questions answered is to post in the Microsoft Community Forum. The SQL Server Forums are located here: http://forums.microsoft.com/MSDN/default.aspx?ForumGroupID=19&SiteID=1. You may want to post this to the Reporting Services forum.
Phil is right, this doc seems to be wrong. There is no EnableRemoteErrors option in SQL Server Management Studio, either on the server level or the database level.
Here is the proper way to do it in sql:
use reportservergo
begin tran
update dbo.ConfigurationInfoset Value = 'True'where Name = 'EnableRemoteErrors'
commit tran
Hi All,This is the page for Sql Server 2008. There is a link for the 2005 documentation at the top of this page under the following lable.Other versions are also available for the following:Or you can just use this link.
http://technet.microsoft.com/en-us/library/aa337165(SQL.90).aspx There is no mention of the Management Studio feature there so I take it that the feature was introduced with 2008.I used the following solution to solve the problem on my 2005 server...1. Execute the following T-SQL statements on the Sql Server that is hosting your ReportServer database.
Use ReportServer;update ConfigurationInfo set Value = 'True' where Name = 'EnableRemoteErrors';
2. Restart IISNote that this solution simply consolidates the information provided by boyongoo and Andreas_Apptus. I did however leave out the redundant transation.