Friday, February 24, 2012

enable reomte error

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.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...
> 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.
>|||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:
> 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 =3D "EnableRemoteErrors"
> P.Value =3D True
> Dim Properties(0) As [Property]
> Properties(0) =3D 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...
> > 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.
> >|||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 ?:
> 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...
> > 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.
> >|||Thanks,
I'll try to find this elusive ReportServer.ConfigurationInfo database
Take care,
Roy.
Radoslaw Lebkowski =D7=9B=D7=AA=D7=91:
> 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=C2=BFytkownik "nicknack" <roezohar@.gmail.com> napisa=C2=B3 w wiadomo=C2==B6ci
> 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 ?:
> > 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 =3D "EnableRemoteErrors"
> > P.Value =3D True
> > Dim Properties(0) As [Property]
> > Properties(0) =3D 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 pro=mpt
> > window.
> > Navigate to the directory that contains the .rss file you just created.
> > Type the following command line, replacing servername with the actual n=ame
> > 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...
> > > 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.
> > >

No comments:

Post a Comment