Showing posts with label underlying. Show all posts
Showing posts with label underlying. Show all posts

Friday, March 23, 2012

ReportServer Problem

Hi!
I get suddenly the following error when accessing the error:
"The underlying connection was closed: Unable to connect to the remote
server."
The configuration has not been changed.....!?!
Greets
ChrisHello'
Noone knows an answer?
greetz
chris
"Christian Weber" <avbc.def@.ghi.de> wrote in message
news:cdqjei$1a7$1@.papyrus.erlm.siemens.de...
> Hi!
> I get suddenly the following error when accessing the error:
> "The underlying connection was closed: Unable to connect to the remote
> server."
> The configuration has not been changed.....!?!
> Greets
> Chris
>|||Sorry, I will be no help here. I have the same problem. It just magically
happened when I came to work this Monday. Everything was working normally
when I left Friday. No configuration changes have been done.
The only good thing is I can still render reports through the web service.
So this is an annoyance but thankfully my application is still working for
now.
If I go to:
http://reportserver/reports/
I get the exact same error you got.
If I go to:
http://reportserver/reportserver/
everything works fine and I see folders and links to previously uploaded
reports. I can also run reports from here.
My reporting services app runs on Windows 2003 Server. It is on a separate
server from SQL Server 2000 Standard which is also a Windows 2003 Server. I
have been running Reporting Services SP1 for a few weeks now. I do not think
that Windows XP SP2 has been applied to the servers by the sysadmins yet.
If you solve this yourself or find the solution could you please reply to
this thread. I will do that same for you.
Jeff
"Christian Weber" wrote:
> Hello'
> Noone knows an answer?
> greetz
> chris
> "Christian Weber" <avbc.def@.ghi.de> wrote in message
> news:cdqjei$1a7$1@.papyrus.erlm.siemens.de...
> > Hi!
> >
> > I get suddenly the following error when accessing the error:
> >
> > "The underlying connection was closed: Unable to connect to the remote
> > server."
> >
> > The configuration has not been changed.....!?!
> >
> > Greets
> >
> > Chris
> >
> >
>
>sql

Tuesday, March 20, 2012

Reports in Report Manager-drilldown

When runing a report in Report Manager I can click on an item and SQL Server provides the logic to drill down into the underlying tables. I can find no button to go back. The only way I've found to go back is to click a different tab at the top of the screen (History or something) then click View again and you get the original report. In designer there's a back button. Is there not such a button when running a saved report?

Thanks.

Never mind....D'OH

Wednesday, March 7, 2012

ReportingService.CancelJob method and sql connection

If we use the CancelJob method anbd cancel a new/running report, is the
underlying sql connection and process also cancelled/killed/released. I have
not found any documentation on this and am in the process of setting up a
test that will help me determine this.
===================== Thanks!
Keith
p.s. Get off the couch and exercise!This is correct, CancelJob will initiate releasing resources such as
database connections etc.
-- Robert
This posting is provided "AS IS" with no warranties, and confers no rights.
"Keith" <Keith@.discussions.microsoft.com> wrote in message
news:16B983BC-AD60-42AB-8393-2FC43A2CEA40@.microsoft.com...
> If we use the CancelJob method anbd cancel a new/running report, is the
> underlying sql connection and process also cancelled/killed/released. I
> have
> not found any documentation on this and am in the process of setting up a
> test that will help me determine this.
> =====================> Thanks!
> Keith
> p.s. Get off the couch and exercise!|||That's great news, but while researching the help documentation for SRS 2005,
I found this:
Canceling a job only cancels the processes that are running on the report
server. Because the report server does not manage processes on other
computers, you must manually cancel query processes that are subsequently
orphaned on other systems. Consider specifying query time-out values to
automatically shut down queries that are taking too long to execute. For more
information, see Setting Time-out Values for Report Execution. For more
information about temporarily pausing a report, see Pausing Report and
Subscription Processing.
I found this under the topic, "canceling jobs".
Can you shed some light on this discrepancy or explain to me what I am
missing.
Thank you,
Keith
"Robert Bruckner [MSFT]" wrote:
> This is correct, CancelJob will initiate releasing resources such as
> database connections etc.
> -- Robert
> This posting is provided "AS IS" with no warranties, and confers no rights.
> "Keith" <Keith@.discussions.microsoft.com> wrote in message
> news:16B983BC-AD60-42AB-8393-2FC43A2CEA40@.microsoft.com...
> > If we use the CancelJob method anbd cancel a new/running report, is the
> > underlying sql connection and process also cancelled/killed/released. I
> > have
> > not found any documentation on this and am in the process of setting up a
> > test that will help me determine this.
> >
> > =====================> > Thanks!
> > Keith
> > p.s. Get off the couch and exercise!
>
>