Reporting Services Configuring Default Error Messages

I have searched the web and have not had any luck on finding the issue to my problem. I'm sure it's probably simple, so here it goes.

When receiving the following error "The permissions granted to user '' are insufficient for performing this operation"

Now, I would like to add to the error message shown above an extra line below it on the web page to reflect something like "Please contact XXX @. XXX if you feel that you need to have your login issue resolved" ...or something meaningful in addition to the default error messages.

I am not getting this error normally, as I have made a typo when login in on purpose! I am just trying to find a way to add more detail to the current error message or change the message to what I want it to say. This would go for any error message received by an end user received through SQL Server 2005 Reporting Services.

Do I have to create some sort of filter to read the message coming back from within SOAP? Are these messages stored in ReportingServices database or htm file?

Thanks!

ICE

This is fairly simple using a report viewer in Visual Studio 2005. Are you only using Business Intelligence Studio?

|||

I am just wanting to add to the error message or modify the error message. Do I need to load something into VS? I am not creating a new report. I just want to modify the original message that SQL Server Reporting Services gives you during any type of error via IE.

|||

freezinice wrote:

I am just wanting to add to the error message or modify the error message. Do I need to load something into VS? I am not creating a new report. I just want to modify the original message that SQL Server Reporting Services gives you during any type of error via IE.

I'm not sure that you can do that.

Basically what I did was create my own report (just a basic SQL report) that has an error message on it.

I used it in my Visual Studio web application by handling the OnError event of the report viewer and simply displaying the error report.

However, if you haven't developed a front end for your reports then you wouldn't be able to use this approach.

|||

There has got to be a way to modify the underlying message returned from SOAP, modifying something in the reporting database messages, or modify some type of htm file. The error page is being rendered somehow.

I am going to edit this post and supply a URL to give you an example of what I found. However, this only discusses about doing something and not how to do it. Again, this discusses adding an icon and what I want to modify is the text.

http://www.ssw.com.au/ssw/Standards/BetterSoftwareSuggestions/ReportingServices.aspx#IISService

Search for Item # 61

"Make this error more friendly by making it visually consistent with the SQL Server Configuration Manager"