Groups | Blog | Home
all groups > sql server reporting services > february 2007 >

sql server reporting services : enable reomte error


nicknack
2/5/2007 11:30:19 PM
Hello,
I got the error:
______________________
Reporting Services Error

* For more information about this error navigate to the report
server on the local server machine, or enable remote errors SQL Server
Reporting Services
______________________


I saw the answer:
"You could set the "EnableRemoteErrors" configuration value to True in
the ReportServer.ConfigurationInfo database table."

How can I get to the ReportServer.ConfigurationInfo database table?

I am on the reportservice server and I run "reporting services
configuration manager" and the "sql server managment". I didn't saw
that option :(

Where is this configuration?

Any help?
Thanks.
nicknack
2/6/2007 5:31:12 AM
Hi Radoslaw,

Thanks for the replay.
Is that the only way?
Isn't there any simple way to change this with one of the
configuration tools?

If not, I'll use the script you sent me.

Thanks again.

Radoslaw Lebkowski =D7=9B=D7=AA=D7=91:
[quoted text, click to view]
nicknack
2/6/2007 7:14:32 AM
Thanks,
I'll try to find this elusive ReportServer.ConfigurationInfo database

Take care,
Roy.

Radoslaw Lebkowski =D7=9B=D7=AA=D7=91:
[quoted text, click to view]
Radoslaw Lebkowski
2/6/2007 1:09:20 PM

Hello,

Follow the steps below.

Enable remote errors through script
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

Best regards,
Radoslaw Lebkowski


Uzytkownik "nicknack" <roezohar@gmail.com> napisal w wiadomosci
news:1170747019.500396.131190@v45g2000cwv.googlegroups.com...
[quoted text, click to view]

Radoslaw Lebkowski
2/6/2007 3:06:24 PM

I think you can also use Enterprise Manager (for SQL 2000 database) or SQL
2005 Management Studio (for SQL 2005 server)
to change this value in ReportServer.ConfigurationInfo database table.
You have to connect to database server and ReportServer database and then
change value in ConfigurationInfo table.


Radoslaw Lebkowski





U¿ytkownik "nicknack" <roezohar@gmail.com> napisa³ w wiadomo¶ci
news:1170768672.373595.150750@k78g2000cwa.googlegroups.com...
Hi Radoslaw,

Thanks for the replay.
Is that the only way?
Isn't there any simple way to change this with one of the
configuration tools?

If not, I'll use the script you sent me.

Thanks again.

Radoslaw Lebkowski ???:
[quoted text, click to view]

AddThis Social Bookmark Button