rsExecutionNotFound

I wrote a Custom Web App using ASP.NET for reports built using SSRS 2005. The web application uses report viewer control to display the reports. The Report Viewer processing mode is set to "Remote". The session timeout for web application is 30 minutes.

Reports autorefresh property is set to 15 minutes. when the web page thats displaying the reports is running continously, I am occassionally seeing "rsExecutionNotFound" error. The error is not going away even if I refresh the page.

Thanks for u'r help.

Dear NR01,

There could be a possibility that the session of reporting services is timing out.

Try this post

HTH,

Suprotim Agarwal

|||

Hi,

I tried the post you mentioned. when I run the reports continously, still I am seeing rsExecutionNotFound error but not as frequent as before.

I set the timeout to 30 min.

rs -i sessionTimeout.rss -s http://localhost/reportserver -v timeout="1800"

I am refreshing the reports every 15min.

Thanks for u'r help.

-NR01

|||

I also did the same and set the timeout=1800.

I still get many of these failures. I didn't notice any changes going from 600 to 1800.

This is a typical error:

w3wp!ui!7!7/23/2007-04:52:49:: Unhandled exception: Microsoft.Reporting.WebForms.ReportServerException: Execution 'c14v5l45yikbbo55d5vk1jj3' cannot be found (rsExecutionNotFound)
at Microsoft.Reporting.WebForms.ServerReport.GetExecutionInfo()
at Microsoft.Reporting.WebForms.ServerReport.SetExecutionId(String executionId, Boolean fullReportLoad)
at Microsoft.Reporting.WebForms.ServerReport.LoadFromUrlQuery(NameValueCollection requestParameters, Boolean fullReportLoad)
at Microsoft.Reporting.WebForms.ReportDataOperation..ctor()
at Microsoft.Reporting.WebForms.HttpHandler.GetHandler(String operationType)
at Microsoft.Reporting.WebForms.HttpHandler.ProcessRequest(HttpContext context)
at System.Web.HttpApplication.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()
at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)

I can't imagine that people are sitting on a page for more than 30 minutes. Could there be another cause?

Neil

|||

I've solved the same issue.

I'm viewing reports with asp.net reportviewer; on production server, my aspx load correctly the report at first time, but any postback returns "rsExecutionNotFound" error.

I realized my aspx code contains hard-coded reportserverurl and reportpath values, which are different for development and production envs. So when I dynamically set up thoses settings in my page, reportviewer kill its client session since I'm changing the report path from one server to another.

So change :

<rsweb:ReportViewer ID="ReportViewer1" runat="server" ProcessingMode="Remote" Height="600px" Width="996px">

<ServerReport ReportServerUrl="http://DEVSERVER/ReportServer" ReportPath="/MyPath" />

</rsweb:ReportViewer>

To :

<rsweb:ReportViewer ID="ReportViewer1" runat="server" ProcessingMode="Remote" Height="600px" Width="996px">

<ServerReport />

</rsweb:ReportViewer>

sql

rsExecutionNotFound

I wrote a Custom Web App using ASP.NET for reports built using SSRS 2005. The web application uses report viewer control to display the reports. The Report Viewer processing mode is set to "Remote". The session timeout for web application is 30 minutes.

Reports autorefresh property is set to 15 minutes. when the web page thats displaying the reports is running continously, I am occassionally seeing "rsExecutionNotFound" error. The error is not going away even if I refresh the page.

Thanks for u'r help.

Dear NR01,

There could be a possibility that the session of reporting services is timing out.

Try this post

HTH,

Suprotim Agarwal

|||

Hi,

I tried the post you mentioned. when I run the reports continously, still I am seeing rsExecutionNotFound error but not as frequent as before.

I set the timeout to 30 min.

rs -i sessionTimeout.rss -s http://localhost/reportserver -v timeout="1800"

I am refreshing the reports every 15min.

Thanks for u'r help.

-NR01

|||

I also did the same and set the timeout=1800.

I still get many of these failures. I didn't notice any changes going from 600 to 1800.

This is a typical error:

w3wp!ui!7!7/23/2007-04:52:49:: Unhandled exception: Microsoft.Reporting.WebForms.ReportServerException: Execution 'c14v5l45yikbbo55d5vk1jj3' cannot be found (rsExecutionNotFound)
at Microsoft.Reporting.WebForms.ServerReport.GetExecutionInfo()
at Microsoft.Reporting.WebForms.ServerReport.SetExecutionId(String executionId, Boolean fullReportLoad)
at Microsoft.Reporting.WebForms.ServerReport.LoadFromUrlQuery(NameValueCollection requestParameters, Boolean fullReportLoad)
at Microsoft.Reporting.WebForms.ReportDataOperation..ctor()
at Microsoft.Reporting.WebForms.HttpHandler.GetHandler(String operationType)
at Microsoft.Reporting.WebForms.HttpHandler.ProcessRequest(HttpContext context)
at System.Web.HttpApplication.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()
at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)

I can't imagine that people are sitting on a page for more than 30 minutes. Could there be another cause?

Neil

|||

I've solved the same issue.

I'm viewing reports with asp.net reportviewer; on production server, my aspx load correctly the report at first time, but any postback returns "rsExecutionNotFound" error.

I realized my aspx code contains hard-coded reportserverurl and reportpath values, which are different for development and production envs. So when I dynamically set up thoses settings in my page, reportviewer kill its client session since I'm changing the report path from one server to another.

So change :

<rsweb:ReportViewer ID="ReportViewer1" runat="server" ProcessingMode="Remote" Height="600px" Width="996px">

<ServerReport ReportServerUrl="http://DEVSERVER/ReportServer" ReportPath="/MyPath" />

</rsweb:ReportViewer>

To :

<rsweb:ReportViewer ID="ReportViewer1" runat="server" ProcessingMode="Remote" Height="600px" Width="996px">

<ServerReport />

</rsweb:ReportViewer>

RSClientPrint.Print

I am having an issue with the RSClientPrint control. We have a .net Proxy
class (ASP.NET handler) which is being called by the RSClientPrint.Print
command, bringing the data from Reporting Services and relaying it back to
the control after regex'ing all the urls to point back to our proxy. The
main reason for this is that Reporting Services will not be available from
the client machine as it's hidden behind a firewall.
When executing the Print function, The printer dialog box is displayed,
which when accepted prints the report just as expected, however once the job
has been sent to the printer an `unknown error` is thrown by the Print
Method which is caught by the activex control, which displays an error
message in the screen stating the print failed. Even though the print
succeeds.
The before and after shot are displayed here:
= = = = = =
BEFORE: RSClientPrint.Print("http://{ourwebmachinename}/ReportServer",
"%2fFolder+1%2fFolder+2%2fReport+1&name=administrator", "Report 1")
AFTER:
RSClientPrint.Print("http://{ourwebmachinename}/{ourapp}/ReportServer.ashx",
"%2fFolder+1%2fFolder+2%2fReport+1&name=administrator", "Report 1")
= = = = = =
Removing our proxy and pointing it directly to Reporting Services works
fine, I am wondering why this message is being displayed at all, and the
really frustrating part is that it is a meaningless error.
What I am looking for is an answer to the following:
1. What exactly is the print method doing?
2. At what points could it fail?
3. Has anyone encountered a similar problem, and how have they resolved it?
Thanks for your TimeHello James,
It seems the data returned by your proxy is a little different from that of
reportserver.
You may want to use some tool to catch the HTTP data and compare with the
one from server. Once the preview mode is initiated or the report is
printed, the control instructs the Report Server to print the report using
the EMF rendering extension.
Thanks & Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
--
| From: "James Snape" <jim_snape.at.hotmail.com@.online.nospam>
| Subject: RSClientPrint.Print
| Date: Wed, 10 Aug 2005 14:58:13 +0100
| Lines: 38
| X-Priority: 3
| X-MSMail-Priority: Normal
| X-Newsreader: Microsoft Outlook Express 6.00.2900.2180
| X-RFC2646: Format=Flowed; Original
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180
| Message-ID: <e5bCOObnFHA.420@.TK2MSFTNGP09.phx.gbl>
| Newsgroups: microsoft.public.sqlserver.reportingsvcs
| NNTP-Posting-Host: exony-ltd-02.altohiway.com 213.83.66.226
| Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP09.phx.gbl
| Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.sqlserver.reportingsvcs:50071
| X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
|
| I am having an issue with the RSClientPrint control. We have a .net Proxy
| class (ASP.NET handler) which is being called by the RSClientPrint.Print
| command, bringing the data from Reporting Services and relaying it back
to
| the control after regex'ing all the urls to point back to our proxy. The
| main reason for this is that Reporting Services will not be available
from
| the client machine as it's hidden behind a firewall.
|
| When executing the Print function, The printer dialog box is displayed,
| which when accepted prints the report just as expected, however once the
job
| has been sent to the printer an `unknown error` is thrown by the Print
| Method which is caught by the activex control, which displays an error
| message in the screen stating the print failed. Even though the print
| succeeds.
|
| The before and after shot are displayed here:
| = = = = = =|
| BEFORE: RSClientPrint.Print("http://{ourwebmachinename}/ReportServer",
| "%2fFolder+1%2fFolder+2%2fReport+1&name=administrator", "Report 1")
|
| AFTER:
|
RSClientPrint.Print("http://{ourwebmachinename}/{ourapp}/ReportServer.ashx",
| "%2fFolder+1%2fFolder+2%2fReport+1&name=administrator", "Report 1")
|
| = = = = = =|
| Removing our proxy and pointing it directly to Reporting Services works
| fine, I am wondering why this message is being displayed at all, and the
| really frustrating part is that it is a meaningless error.
|
| What I am looking for is an answer to the following:
| 1. What exactly is the print method doing?
| 2. At what points could it fail?
| 3. Has anyone encountered a similar problem, and how have they resolved
it?
|
| Thanks for your Time
|
|
||||Thanks Peter I'll give that a go!
"Peter Yang [MSFT]" <petery@.online.microsoft.com> wrote in message
news:0P9fa6hnFHA.3472@.TK2MSFTNGXA01.phx.gbl...
> Hello James,
> It seems the data returned by your proxy is a little different from that
> of
> reportserver.
> You may want to use some tool to catch the HTTP data and compare with the
> one from server. Once the preview mode is initiated or the report is
> printed, the control instructs the Report Server to print the report using
> the EMF rendering extension.
> Thanks & Regards,
> Peter Yang
> MCSE2000/2003, MCSA, MCDBA
> Microsoft Online Partner Support
> When responding to posts, please "Reply to Group" via your newsreader so
> that others may learn and benefit from your issue.
> =====================================================>
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
> --
> | From: "James Snape" <jim_snape.at.hotmail.com@.online.nospam>
> | Subject: RSClientPrint.Print
> | Date: Wed, 10 Aug 2005 14:58:13 +0100
> | Lines: 38
> | X-Priority: 3
> | X-MSMail-Priority: Normal
> | X-Newsreader: Microsoft Outlook Express 6.00.2900.2180
> | X-RFC2646: Format=Flowed; Original
> | X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180
> | Message-ID: <e5bCOObnFHA.420@.TK2MSFTNGP09.phx.gbl>
> | Newsgroups: microsoft.public.sqlserver.reportingsvcs
> | NNTP-Posting-Host: exony-ltd-02.altohiway.com 213.83.66.226
> | Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP09.phx.gbl
> | Xref: TK2MSFTNGXA01.phx.gbl
> microsoft.public.sqlserver.reportingsvcs:50071
> | X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
> |
> | I am having an issue with the RSClientPrint control. We have a .net
> Proxy
> | class (ASP.NET handler) which is being called by the RSClientPrint.Print
> | command, bringing the data from Reporting Services and relaying it back
> to
> | the control after regex'ing all the urls to point back to our proxy. The
> | main reason for this is that Reporting Services will not be available
> from
> | the client machine as it's hidden behind a firewall.
> |
> | When executing the Print function, The printer dialog box is displayed,
> | which when accepted prints the report just as expected, however once the
> job
> | has been sent to the printer an `unknown error` is thrown by the Print
> | Method which is caught by the activex control, which displays an error
> | message in the screen stating the print failed. Even though the print
> | succeeds.
> |
> | The before and after shot are displayed here:
> | = = = = = => |
> | BEFORE: RSClientPrint.Print("http://{ourwebmachinename}/ReportServer",
> | "%2fFolder+1%2fFolder+2%2fReport+1&name=administrator", "Report 1")
> |
> | AFTER:
> |
> RSClientPrint.Print("http://{ourwebmachinename}/{ourapp}/ReportServer.ashx",
> | "%2fFolder+1%2fFolder+2%2fReport+1&name=administrator", "Report 1")
> |
> | = = = = = => |
> | Removing our proxy and pointing it directly to Reporting Services works
> | fine, I am wondering why this message is being displayed at all, and the
> | really frustrating part is that it is a meaningless error.
> |
> | What I am looking for is an answer to the following:
> | 1. What exactly is the print method doing?
> | 2. At what points could it fail?
> | 3. Has anyone encountered a similar problem, and how have they resolved
> it?
> |
> | Thanks for your Time
> |
> |
> |
>

RSClientPrint ActiveX causes client PC to reboot

We have a client PC trying to run a report. When they hit the print button it
first asks them to install a SQL active X control which is RSClientPrint
Class. Once installed they hit the print button on the report which then
loads the active X print dialog - when they hit print their system reboots.
I had this person delete the control and go through the same process with
the same results; they are running Windows XP SP2 with IE6.
Any ideas? Thank You.That is exactly what I am running (XP SP2 IE6).
Are they in the local administrators group on the machine (i.e. do they have
the rights to install the activeX control?)
Do they have any printers connected to their PC? This is printing locally
not at the server.
--
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Dan Zaccarine" <Dan Zaccarine@.discussions.microsoft.com> wrote in message
news:89B4C6AC-14D6-4F05-8915-2892D3AD2DA8@.microsoft.com...
> We have a client PC trying to run a report. When they hit the print button
> it
> first asks them to install a SQL active X control which is RSClientPrint
> Class. Once installed they hit the print button on the report which then
> loads the active X print dialog - when they hit print their system
> reboots.
> I had this person delete the control and go through the same process with
> the same results; they are running Windows XP SP2 with IE6.
> Any ideas? Thank You.
>|||Which version of RS do you use?
I have one computer (WinXP, DELL laptop, 2 years old) with a HP1320 printer
connected. the RS Client print alway causes "blue screen death" when try to
print report. Printing anything else is OK.
However, the printer prints RS report OK when connected to any other
computers. So, I guess it is some sort of hardware issue with that
particular computer/printer combination. The solution is by that user a
different printer. Now the reporting print with that computer is fine and
the previous computer also happily work with other computer when printing RS
report.
So, you may try to update the printer's driver first, and then try to use a
different computer.
Just an experience using RS2000 printing. RS2000 reporitn rendering/printing
horribly bad.
"Dan Zaccarine" <Dan Zaccarine@.discussions.microsoft.com> wrote in message
news:89B4C6AC-14D6-4F05-8915-2892D3AD2DA8@.microsoft.com...
> We have a client PC trying to run a report. When they hit the print button
> it
> first asks them to install a SQL active X control which is RSClientPrint
> Class. Once installed they hit the print button on the report which then
> loads the active X print dialog - when they hit print their system
> reboots.
> I had this person delete the control and go through the same process with
> the same results; they are running Windows XP SP2 with IE6.
> Any ideas? Thank You.
>|||On Nov 28, 11:20 am, "Norman Yuan" <NoAddr...@.NoEmail.fake> wrote:
> Which version of RS do you use?
> I have one computer (WinXP, DELL laptop, 2 years old) with a HP1320 printer
> connected. the RS Client print alway causes "blue screen death" when try to
> print report. Printing anything else is OK.
> However, the printer prints RS report OK when connected to any other
> computers. So, I guess it is some sort of hardware issue with that
> particular computer/printer combination. The solution is by that user a
> different printer. Now the reporting print with that computer is fine and
> the previous computer also happily work with other computer when printing RS
> report.
> So, you may try to update the printer's driver first, and then try to use a
> different computer.
> Just an experience using RS2000 printing. RS2000 reporitn rendering/printing
> horribly bad.
> "Dan Zaccarine" <Dan Zaccar...@.discussions.microsoft.com> wrote in messagenews:89B4C6AC-14D6-4F05-8915-2892D3AD2DA8@.microsoft.com...
>
> > We have a client PC trying to run a report. When they hit the print button
> > it
> > first asks them to install a SQL active X control which is RSClientPrint
> > Class. Once installed they hit the print button on the report which then
> > loads the active X print dialog - when they hit print their system
> > reboots.
> > I had this person delete the control and go through the same process with
> > the same results; they are running Windows XP SP2 with IE6.
> > Any ideas? Thank You.- Hide quoted text -
> - Show quoted text -
I have seen the same issue. However, I only get the reboot when I am
printing a matrix report. All other report types print Ok.|||I am having same problem any idea to solve this issue
"RDV" wrote:
> On Nov 28, 11:20 am, "Norman Yuan" <NoAddr...@.NoEmail.fake> wrote:
> > Which version of RS do you use?
> >
> > I have one computer (WinXP, DELL laptop, 2 years old) with a HP1320 printer
> > connected. the RS Client print alway causes "blue screen death" when try to
> > print report. Printing anything else is OK.
> >
> > However, the printer prints RS report OK when connected to any other
> > computers. So, I guess it is some sort of hardware issue with that
> > particular computer/printer combination. The solution is by that user a
> > different printer. Now the reporting print with that computer is fine and
> > the previous computer also happily work with other computer when printing RS
> > report.
> >
> > So, you may try to update the printer's driver first, and then try to use a
> > different computer.
> >
> > Just an experience using RS2000 printing. RS2000 reporitn rendering/printing
> > horribly bad.
> >
> > "Dan Zaccarine" <Dan Zaccar...@.discussions.microsoft.com> wrote in messagenews:89B4C6AC-14D6-4F05-8915-2892D3AD2DA8@.microsoft.com...
> >
> >
> >
> > > We have a client PC trying to run a report. When they hit the print button
> > > it
> > > first asks them to install a SQL active X control which is RSClientPrint
> > > Class. Once installed they hit the print button on the report which then
> > > loads the active X print dialog - when they hit print their system
> > > reboots.
> >
> > > I had this person delete the control and go through the same process with
> > > the same results; they are running Windows XP SP2 with IE6.
> >
> > > Any ideas? Thank You.- Hide quoted text -
> >
> > - Show quoted text -
> I have seen the same issue. However, I only get the reboot when I am
> printing a matrix report. All other report types print Ok.
>|||I saw this last spring:
>>>>>>>>
> > It only affects printers using the PCL 6 driver. If I print to any of
> > the others using a PCL 5e driver it works. All of our printers are HP.
> > > It doesn't appear to be a general print driver issue. As I said, only
> > > the HP 4250's have this problem.
> > > > It appears to be a print driver issue due to some recent update. If
> > > > you change your print drivers to PCL 5e it won't crash any longer.
>>>>>>>>>>>
Again, I have no real knowledge of this. Hopefully the above will help.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Irfan" <Irfan@.discussions.microsoft.com> wrote in message
news:EBD33316-B4BA-4D9D-819B-33AC540278CB@.microsoft.com...
>I am having same problem any idea to solve this issue
> "RDV" wrote:
>> On Nov 28, 11:20 am, "Norman Yuan" <NoAddr...@.NoEmail.fake> wrote:
>> > Which version of RS do you use?
>> >
>> > I have one computer (WinXP, DELL laptop, 2 years old) with a HP1320
>> > printer
>> > connected. the RS Client print alway causes "blue screen death" when
>> > try to
>> > print report. Printing anything else is OK.
>> >
>> > However, the printer prints RS report OK when connected to any other
>> > computers. So, I guess it is some sort of hardware issue with that
>> > particular computer/printer combination. The solution is by that user a
>> > different printer. Now the reporting print with that computer is fine
>> > and
>> > the previous computer also happily work with other computer when
>> > printing RS
>> > report.
>> >
>> > So, you may try to update the printer's driver first, and then try to
>> > use a
>> > different computer.
>> >
>> > Just an experience using RS2000 printing. RS2000 reporitn
>> > rendering/printing
>> > horribly bad.
>> >
>> > "Dan Zaccarine" <Dan Zaccar...@.discussions.microsoft.com> wrote in
>> > messagenews:89B4C6AC-14D6-4F05-8915-2892D3AD2DA8@.microsoft.com...
>> >
>> >
>> >
>> > > We have a client PC trying to run a report. When they hit the print
>> > > button
>> > > it
>> > > first asks them to install a SQL active X control which is
>> > > RSClientPrint
>> > > Class. Once installed they hit the print button on the report which
>> > > then
>> > > loads the active X print dialog - when they hit print their system
>> > > reboots.
>> >
>> > > I had this person delete the control and go through the same process
>> > > with
>> > > the same results; they are running Windows XP SP2 with IE6.
>> >
>> > > Any ideas? Thank You.- Hide quoted text -
>> >
>> > - Show quoted text -
>> I have seen the same issue. However, I only get the reboot when I am
>> printing a matrix report. All other report types print Ok.|||Hi all !
I found a solution for your problem. You probably installed the hotfix
925902 recently. Its a known issue for Microsoft. Some printers only (until
now : Ricoh LAN Fax Driver, Gestetner P7026n PCL, Ricoh Laser AP2600N PCL,
HP LaserJet 9050, HP LaserJet 4200, HP 4050 PCL6, HP LaserJet 4345 PCL 6 and
Canon Pixma MP170) are impacted.
This problem occurs when a printer driver makes a call that has invalid
parameters to the Win32K.sys component.
The hotfix KB935843 solved the problem on my computer.

rsAccessDenied

I have a reportViewer control on a webform. In my partial class I set the report path, server and parameters in the Page_Load. When I run the report I get this error:

The permissions granted to user 'NT AUTHORITY\NETWORK SERVICE' are insufficient for performing this operation. (rsAccessDenied)

Here is my code:

Dim u As New UriTypeConverter
Dim ReportParameters(0) As ReportParameter

ReportParameters(0) = New ReportParameter("ProjectKey", 262)
rv.ShowParameterPrompts = False
rv.ServerReport.ReportServerUrl = u.ConvertFromString("http://localhost/ReportServer/")
rv.ServerReport.ReportPath = "/Test/Duplicate_MIU_Report"
rv.ServerReport.SetParameters(ReportParameters)

Have you properly granted permission for your web user? Go to the configuration tool, and look for any red X on the left hand side. Open the "Web service identity" and make sure your web user is 'NT AUTHORITY\NETWORK SERVICE". Then go to "Database Setup" panel. I think you are using "Service Credentials". Reapply the settings may fix your problem.|||

I have NT AUTHORITY\NetworkService as the service account (it is grayed out so it is not possible to change), and I have Service Credentials as the credentials type in the database setup. There are no red X's. Still get the same error.

In addition, I get this DCOM error in the system log:

The application-specific permission settings do not grant Local Activation permission for the COM Server application with CLSID

{BA126AD1-2166-11D1-B1D0-00805FC1270E}

to the user NT AUTHORITY\NETWORK SERVICE SID (S-1-5-20). This security permission can be modified using the Component Services administrative tool.

I'm not exactly sure what and how to do in Component Services admin tool.

|||

This thread may help you with the DCOM error:

http://forums.microsoft.com/MSDN/showpost.aspx?postid=258889&siteid=1

|||Netman has both local activation AND execution|||Do you see Network Services part of RSExec role in your report server catalog db and temp db?|||Yes|||Yes, Network Services is RSExec role in report server catalog db and temp db.|||It looks like Network Service account is not allowed to set parameters. I am not sure what is the mininum permission set. Can you try adding the account as a content manager to the home folder?|||If I right-click in design view in VS2005, the report runs fine. It doesn't work when I try to run in a browser and is being served up by my dev IIS server.|||I have added the NetworkService as administrator and still no go.|||That did it. Was confused in the ReportManager. Simple fix. Seems like lots of people having same problem. Thank you for your help|||Sorry--Don't follow what the fix was. What did it?|||

Went into Report Manager and gave NT Authority\NetworkService the necessary role assignments.

|||Thanks--got past that one, now I get to deal with the database access permissions lol...

rsAccessDenied

I have a reportViewer control on a webform. In my partial class I set the report path, server and parameters in the Page_Load. When I run the report I get this error:

The permissions granted to user 'NT AUTHORITY\NETWORK SERVICE' are insufficient for performing this operation. (rsAccessDenied)

Here is my code:

Dim u As New UriTypeConverter
Dim ReportParameters(0) As ReportParameter

ReportParameters(0) = New ReportParameter("ProjectKey", 262)
rv.ShowParameterPrompts = False
rv.ServerReport.ReportServerUrl = u.ConvertFromString("http://localhost/ReportServer/")
rv.ServerReport.ReportPath = "/Test/Duplicate_MIU_Report"
rv.ServerReport.SetParameters(ReportParameters)

Have you properly granted permission for your web user? Go to the configuration tool, and look for any red X on the left hand side. Open the "Web service identity" and make sure your web user is 'NT AUTHORITY\NETWORK SERVICE". Then go to "Database Setup" panel. I think you are using "Service Credentials". Reapply the settings may fix your problem.|||

I have NT AUTHORITY\NetworkService as the service account (it is grayed out so it is not possible to change), and I have Service Credentials as the credentials type in the database setup. There are no red X's. Still get the same error.

In addition, I get this DCOM error in the system log:

The application-specific permission settings do not grant Local Activation permission for the COM Server application with CLSID

{BA126AD1-2166-11D1-B1D0-00805FC1270E}

to the user NT AUTHORITY\NETWORK SERVICE SID (S-1-5-20). This security permission can be modified using the Component Services administrative tool.

I'm not exactly sure what and how to do in Component Services admin tool.

|||

This thread may help you with the DCOM error:

http://forums.microsoft.com/MSDN/showpost.aspx?postid=258889&siteid=1

|||Netman has both local activation AND execution|||Do you see Network Services part of RSExec role in your report server catalog db and temp db?|||Yes|||Yes, Network Services is RSExec role in report server catalog db and temp db.|||It looks like Network Service account is not allowed to set parameters. I am not sure what is the mininum permission set. Can you try adding the account as a content manager to the home folder?|||If I right-click in design view in VS2005, the report runs fine. It doesn't work when I try to run in a browser and is being served up by my dev IIS server.|||I have added the NetworkService as administrator and still no go.|||That did it. Was confused in the ReportManager. Simple fix. Seems like lots of people having same problem. Thank you for your help|||Sorry--Don't follow what the fix was. What did it?|||

Went into Report Manager and gave NT Authority\NetworkService the necessary role assignments.

|||Thanks--got past that one, now I get to deal with the database access permissions lol...

rsAccessDenied

I have a reportViewer control on a webform. In my partial class I set the report path, server and parameters in the Page_Load. When I run the report I get this error:

The permissions granted to user 'NT AUTHORITY\NETWORK SERVICE' are insufficient for performing this operation. (rsAccessDenied)

Here is my code:

Dim u As New UriTypeConverter
Dim ReportParameters(0) As ReportParameter

ReportParameters(0) = New ReportParameter("ProjectKey", 262)
rv.ShowParameterPrompts = False
rv.ServerReport.ReportServerUrl = u.ConvertFromString("http://localhost/ReportServer/")
rv.ServerReport.ReportPath = "/Test/Duplicate_MIU_Report"
rv.ServerReport.SetParameters(ReportParameters)

Have you properly granted permission for your web user? Go to the configuration tool, and look for any red X on the left hand side. Open the "Web service identity" and make sure your web user is 'NT AUTHORITY\NETWORK SERVICE". Then go to "Database Setup" panel. I think you are using "Service Credentials". Reapply the settings may fix your problem.|||

I have NT AUTHORITY\NetworkService as the service account (it is grayed out so it is not possible to change), and I have Service Credentials as the credentials type in the database setup. There are no red X's. Still get the same error.

In addition, I get this DCOM error in the system log:

The application-specific permission settings do not grant Local Activation permission for the COM Server application with CLSID

{BA126AD1-2166-11D1-B1D0-00805FC1270E}

to the user NT AUTHORITY\NETWORK SERVICE SID (S-1-5-20). This security permission can be modified using the Component Services administrative tool.

I'm not exactly sure what and how to do in Component Services admin tool.

|||

This thread may help you with the DCOM error:

http://forums.microsoft.com/MSDN/showpost.aspx?postid=258889&siteid=1

|||Netman has both local activation AND execution|||Do you see Network Services part of RSExec role in your report server catalog db and temp db?|||Yes|||Yes, Network Services is RSExec role in report server catalog db and temp db.|||It looks like Network Service account is not allowed to set parameters. I am not sure what is the mininum permission set. Can you try adding the account as a content manager to the home folder?|||If I right-click in design view in VS2005, the report runs fine. It doesn't work when I try to run in a browser and is being served up by my dev IIS server.|||I have added the NetworkService as administrator and still no go.|||That did it. Was confused in the ReportManager. Simple fix. Seems like lots of people having same problem. Thank you for your help|||Sorry--Don't follow what the fix was. What did it?|||

Went into Report Manager and gave NT Authority\NetworkService the necessary role assignments.

|||Thanks--got past that one, now I get to deal with the database access permissions lol...

rsAccessDenied

I have a reportViewer control on a webform. In my partial class I set the report path, server and parameters in the Page_Load. When I run the report I get this error:

The permissions granted to user 'NT AUTHORITY\NETWORK SERVICE' are insufficient for performing this operation. (rsAccessDenied)

Here is my code:

Dim u As New UriTypeConverter
Dim ReportParameters(0) As ReportParameter

ReportParameters(0) = New ReportParameter("ProjectKey", 262)
rv.ShowParameterPrompts = False
rv.ServerReport.ReportServerUrl = u.ConvertFromString("http://localhost/ReportServer/")
rv.ServerReport.ReportPath = "/Test/Duplicate_MIU_Report"
rv.ServerReport.SetParameters(ReportParameters)

Have you properly granted permission for your web user? Go to the configuration tool, and look for any red X on the left hand side. Open the "Web service identity" and make sure your web user is 'NT AUTHORITY\NETWORK SERVICE". Then go to "Database Setup" panel. I think you are using "Service Credentials". Reapply the settings may fix your problem.|||

I have NT AUTHORITY\NetworkService as the service account (it is grayed out so it is not possible to change), and I have Service Credentials as the credentials type in the database setup. There are no red X's. Still get the same error.

In addition, I get this DCOM error in the system log:

The application-specific permission settings do not grant Local Activation permission for the COM Server application with CLSID

{BA126AD1-2166-11D1-B1D0-00805FC1270E}

to the user NT AUTHORITY\NETWORK SERVICE SID (S-1-5-20). This security permission can be modified using the Component Services administrative tool.

I'm not exactly sure what and how to do in Component Services admin tool.

|||

This thread may help you with the DCOM error:

http://forums.microsoft.com/MSDN/showpost.aspx?postid=258889&siteid=1

|||Netman has both local activation AND execution|||Do you see Network Services part of RSExec role in your report server catalog db and temp db?|||Yes|||Yes, Network Services is RSExec role in report server catalog db and temp db.|||It looks like Network Service account is not allowed to set parameters. I am not sure what is the mininum permission set. Can you try adding the account as a content manager to the home folder?|||If I right-click in design view in VS2005, the report runs fine. It doesn't work when I try to run in a browser and is being served up by my dev IIS server.|||I have added the NetworkService as administrator and still no go.|||That did it. Was confused in the ReportManager. Simple fix. Seems like lots of people having same problem. Thank you for your help|||Sorry--Don't follow what the fix was. What did it?|||

Went into Report Manager and gave NT Authority\NetworkService the necessary role assignments.

|||Thanks--got past that one, now I get to deal with the database access permissions lol...

RS2005 Web ReportViewer: Unable to set parameters and ReportServerCredentials

Hey guys,
I'm using the report viewer web control in my web application. I got it
somewhat working but now I'm stuck:
1) I can't set the parameters for the report. When I call SetParameters and
pass a ReportParameter array, it complains that this report doesn't have
parameter 'XYZ'. But in reality it does. My suspicion was that the
ServerReport object is not filled with report data yet.
So I called GetParameters beforehand to see if it would initialize the
parameters collection. Then I found out that the parameters collection is
set to read-only, which means I can't set parameter values in an initialized
parameter collection.
Last try was to call SetParameters after calling GetParameters but I got the
same exception as when calling w/o GetParameters.
2) I need to pass ReportServerCredentials to RS because of course ASPNET
does not have access rights to RS. The only property that is not read-only
underneath the ReportServerCredentials property is the
ReportServerCredentials itself, which is of type IReportServerCredentials.
So far I couldn't find any credentials object that implements this
interface.
Anybody any idea?
Thanks, ChristophI have the same problem, did anyone ever respond to you?
"Christoph Wienands" wrote:
> Hey guys,
> I'm using the report viewer web control in my web application. I got it
> somewhat working but now I'm stuck:
> 1) I can't set the parameters for the report. When I call SetParameters and
> pass a ReportParameter array, it complains that this report doesn't have
> parameter 'XYZ'. But in reality it does. My suspicion was that the
> ServerReport object is not filled with report data yet.
> So I called GetParameters beforehand to see if it would initialize the
> parameters collection. Then I found out that the parameters collection is
> set to read-only, which means I can't set parameter values in an initialized
> parameter collection.
> Last try was to call SetParameters after calling GetParameters but I got the
> same exception as when calling w/o GetParameters.
> 2) I need to pass ReportServerCredentials to RS because of course ASPNET
> does not have access rights to RS. The only property that is not read-only
> underneath the ReportServerCredentials property is the
> ReportServerCredentials itself, which is of type IReportServerCredentials.
> So far I couldn't find any credentials object that implements this
> interface.
> Anybody any idea?
> Thanks, Christoph
>
>

RS2005 viewer control connection problem.

I am using the reporting services reportviewer control from Visual Studio®
2005 Beta 2.
When I run a repmote report I get the following error:
[WebException: The request was aborted: The connection was closed
unexpectedly.]
I can access the report from my browser doing a straight url access.
I am using RS2005 (did not install anything other than that from SQLServer
2005 cd) on Windows 2003 server, and a SQLserver 2000 back end on a different
machine for RS engine.
The report data source is on the same SQL server machine as the RS database.
can anyone explain what is happening.
Thanks Fred
--
FredI'm having the same problem here.
VS 2005 Beta 2, SQL 2005 April CTP.
Have you found what was causing the problem?
Anderson
Fred escreveu:
> I am using the reporting services reportviewer control from Visual Studio==AE
> 2005 Beta 2.
> When I run a repmote report I get the following error:
> [WebException: The request was aborted: The connection was closed
> unexpectedly.]
> I can access the report from my browser doing a straight url access.
> I am using RS2005 (did not install anything other than that from SQLServer
> 2005 cd) on Windows 2003 server, and a SQLserver 2000 back end on a diffe=rent
> machine for RS engine.
> The report data source is on the same SQL server machine as the RS databa=se.
> can anyone explain what is happening.
> > Thanks Fred
> > > > > > > -- > Fred|||No,
due to other we may actually not user RS2005 anyway, so not such a burnig
issue for the moment.
I still would like to know what's going on though.
I'm using SQLServer 2000 as the RS backend, the datasource is on the same
machine as SQL2000. RS sits on its own machine.
--
Fred
"Anderson dos Santos Pimentel" wrote:
> I'm having the same problem here.
> VS 2005 Beta 2, SQL 2005 April CTP.
> Have you found what was causing the problem?
>
> Anderson
>
> Fred escreveu:
> > I am using the reporting services reportviewer control from Visual Studio®
> > 2005 Beta 2.
> >
> > When I run a repmote report I get the following error:
> >
> > [WebException: The request was aborted: The connection was closed
> > unexpectedly.]
> >
> > I can access the report from my browser doing a straight url access.
> >
> > I am using RS2005 (did not install anything other than that from SQLServer
> > 2005 cd) on Windows 2003 server, and a SQLserver 2000 back end on a different
> > machine for RS engine.
> >
> > The report data source is on the same SQL server machine as the RS database.
> >
> > can anyone explain what is happening.
> >
> > Thanks Fred
> >
> >
> >
> >
> >
> >
> > --
> > Fred
>|||I've finally found the problem.
I was dumb enough to mistype the server's name... :-)
Now, it's OK!
Andersonsql

RS2005 ReportViewer

Is it possible to use the ReportViewer user control in an ASP.NET 1.1 Web App? All the tutorials I have found integrates the reportviewer control from RS2000 and not RS2005.I don't think so. The Report Viewer Control is new to ASP.NET 2.0.

RS2005 Print Legal

Hello,
I'm trying to automate printing to legal size paper from the web
ReportViewer control.
In my Report Properties / Layout I have Page Width= 14in and Page
Height= 8.5in.
When the report renders I hit the print icon. It shows that the report
will print to landscape,
but the paper size is set to Letter.
Is there a way to programatically set the paper size to legal?
TIA,
JimNo you can not set this on the fly, and there have been bugs regarding the
portrait/landscape issue..
However you may have the settings backward... Width should be 8.5in and
height should be 14in...(myabe you just typed it backward in your post.)
--
Wayne Snyder MCDBA, SQL Server MVP
Mariner, Charlotte, NC
I support the Professional Association for SQL Server ( PASS) and it''s
community of SQL Professionals.
"jhcorey@.yahoo.com" wrote:
> Hello,
> I'm trying to automate printing to legal size paper from the web
> ReportViewer control.
> In my Report Properties / Layout I have Page Width= 14in and Page
> Height= 8.5in.
> When the report renders I hit the print icon. It shows that the report
> will print to landscape,
> but the paper size is set to Letter.
> Is there a way to programatically set the paper size to legal?
> TIA,
> Jim
>

RS2000/VS2003 RS2005 Viewer control

We have reports written using Visual Studio 2003, and deployed on a server
running Reporting services 2000. This is OK and working.
Is it possible to write a web page using Visual Studio 2005, and the new
ReportViewer control (Microsoft.Reporting.WebForms.ReportViewer
) to render these reports.
I'm setting the ReportPath and ReportServerUrl but I'm getting the following
error.
Using VS2003 and the RS2000 webservice with the same values worked...
[WebException: The request failed with HTTP status 404: Not Found.]
Microsoft.SqlServer.ReportingServices2005.Execution.RSExecutionConnection.GetSecureMethods() +242
Microsoft.SqlServer.ReportingServices2005.Execution.RSExecutionConnection.IsSecureMethod(String methodname) +86
Microsoft.SqlServer.ReportingServices2005.Execution.RSExecutionConnection.SetConnectionSSLForMethod(String methodname) +33
Microsoft.SqlServer.ReportingServices2005.Execution.RSExecutionConnection.LoadReport(String Report, String HistoryID) +68
[MissingEndpointException: The attempt to connect to the report server
failed. Check your connection information and that the report server is a
compatible version.]
Microsoft.SqlServer.ReportingServices2005.Execution.MissingEndpointException.ThrowIfEndpointMissing(WebException e) +129
Microsoft.SqlServer.ReportingServices2005.Execution.RSExecutionConnection.LoadReport(String Report, String HistoryID) +147
Microsoft.Reporting.WebForms.ServerReport.GetExecutionInfo() +249
Microsoft.Reporting.WebForms.ServerReport.GetParameters() +40
Microsoft.Reporting.WebForms.ParametersArea.GetMetaDataFromReport(Boolean
useCurrentValues) +137
Microsoft.Reporting.WebForms.ReportViewer.OnPreRender(EventArgs e) +184
System.Web.UI.Control.PreRenderRecursiveInternal() +148
System.Web.UI.Control.PreRenderRecursiveInternal() +233
System.Web.UI.Control.PreRenderRecursiveInternal() +233
System.Web.UI.Page.ProcessRequestMain(Boolean
includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +5036
Any help appreciated.
--
FredThe Report Viewer control requires running against RS2005.
There are Server side changes that RS2000 does not have.
--
| Thread-Topic: RS2000/VS2003 RS2005 Viewer control
| thread-index: AcWol1mSmeVTJhrpSOyD8QdgJNzP3g==| X-WBNR-Posting-Host: 62.188.58.81
| From: "=?Utf-8?B?RnJlZA==?=" <Fred@.discussions.microsoft.com>
| Subject: RS2000/VS2003 RS2005 Viewer control
| Date: Wed, 24 Aug 2005 03:34:04 -0700
| Lines: 50
| Message-ID: <2E7C722F-2A27-4176-816E-10517D4B25DC@.microsoft.com>
| MIME-Version: 1.0
| Content-Type: text/plain;
| charset="Utf-8"
| Content-Transfer-Encoding: 7bit
| X-Newsreader: Microsoft CDO for Windows 2000
| Content-Class: urn:content-classes:message
| Importance: normal
| Priority: normal
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
| Newsgroups: microsoft.public.sqlserver.reportingsvcs
| NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.2.250
| Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGXA03.phx.gbl
| Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.sqlserver.reportingsvcs:51025
| X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
|
| We have reports written using Visual Studio 2003, and deployed on a
server
| running Reporting services 2000. This is OK and working.
|
| Is it possible to write a web page using Visual Studio 2005, and the new
| ReportViewer control (Microsoft.Reporting.WebForms.ReportViewer
| ) to render these reports.
|
|
| I'm setting the ReportPath and ReportServerUrl but I'm getting the
following
| error.
|
| Using VS2003 and the RS2000 webservice with the same values worked...
|
|
|
| [WebException: The request failed with HTTP status 404: Not Found.]
|
|
Microsoft.SqlServer.ReportingServices2005.Execution.RSExecutionConnection.Ge
tSecureMethods() +242
|
|
Microsoft.SqlServer.ReportingServices2005.Execution.RSExecutionConnection.Is
SecureMethod(String methodname) +86
|
|
Microsoft.SqlServer.ReportingServices2005.Execution.RSExecutionConnection.Se
tConnectionSSLForMethod(String methodname) +33
|
|
Microsoft.SqlServer.ReportingServices2005.Execution.RSExecutionConnection.Lo
adReport(String Report, String HistoryID) +68
|
| [MissingEndpointException: The attempt to connect to the report server
| failed. Check your connection information and that the report server is
a
| compatible version.]
|
|
Microsoft.SqlServer.ReportingServices2005.Execution.MissingEndpointException
ThrowIfEndpointMissing(WebException e) +129
|
|
Microsoft.SqlServer.ReportingServices2005.Execution.RSExecutionConnection.Lo
adReport(String Report, String HistoryID) +147
| Microsoft.Reporting.WebForms.ServerReport.GetExecutionInfo() +249
| Microsoft.Reporting.WebForms.ServerReport.GetParameters() +40
|
Microsoft.Reporting.WebForms.ParametersArea.GetMetaDataFromReport(Boolean
| useCurrentValues) +137
| Microsoft.Reporting.WebForms.ReportViewer.OnPreRender(EventArgs e) +184
| System.Web.UI.Control.PreRenderRecursiveInternal() +148
| System.Web.UI.Control.PreRenderRecursiveInternal() +233
| System.Web.UI.Control.PreRenderRecursiveInternal() +233
| System.Web.UI.Page.ProcessRequestMain(Boolean
| includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +5036
|
|
|
|
| Any help appreciated.
|
| --
| Fred
|

rs.exe scripts

I'm a SQL Server DBA and will be playing the role of a
SQL2000 Reporting Services administrator. To tightly
control the environment and keep track of all the changes,
I'm considering to implement a policy that requires all
changes to Reporting Services and reports be released into
production via VB.NET scripts for rs.exe, and all such
scripts be submitted to me for review first.
I'd like to bounce this off you guys to see (1) whether
I'm going overboard, and (2) whether all changes can be
implemented via RS scripts.
JoeAs far as your first question, about going overboard... it's not clear to me
how this policy can be enforced. Users could just run any script, or write
their own app to talk to the server. If you really want to prevent users
from performing certain actions, I recommend using the built in security to
give users only the permissions they need for the actions you want them to
take.
As far as functionality... rs.exe has complete access to the SOAP API.
--
This posting is provided "AS IS" with no warranties, and confers no rights
"Joe Bourne" <anonymous@.discussions.microsoft.com> wrote in message
news:46ae01c4734b$5b917fa0$a401280a@.phx.gbl...
> I'm a SQL Server DBA and will be playing the role of a
> SQL2000 Reporting Services administrator. To tightly
> control the environment and keep track of all the changes,
> I'm considering to implement a policy that requires all
> changes to Reporting Services and reports be released into
> production via VB.NET scripts for rs.exe, and all such
> scripts be submitted to me for review first.
> I'd like to bounce this off you guys to see (1) whether
> I'm going overboard, and (2) whether all changes can be
> implemented via RS scripts.
> Joe|||Thanks, Brian!
I was thinking in the line of SQL Server's DDL vs DML, if
I can make such a similar distinction in SSRS. So
for 'DDL' type of changes, I'll try to enforce the rs
scripting requirement, whereas for 'DML' type of changes,
the users can make whatever changes however they want.
Just like in SQL Server, the users can
insert/delete/update their data with their permissions,
and I really don't care what they do. But when it comes to
schema changes, I make sure that thye submit scripts to me
first.
Now, can I classify SSRS tasks into 'DDL' and 'DML', and
assign security to allow DML changes only?
Joe
>--Original Message--
>As far as your first question, about going overboard...
it's not clear to me
>how this policy can be enforced. Users could just run
any script, or write
>their own app to talk to the server. If you really want
to prevent users
>from performing certain actions, I recommend using the
built in security to
>give users only the permissions they need for the actions
you want them to
>take.
>As far as functionality... rs.exe has complete access to
the SOAP API.
>--
>This posting is provided "AS IS" with no warranties, and
confers no rights
>"Joe Bourne" <anonymous@.discussions.microsoft.com> wrote
in message
>news:46ae01c4734b$5b917fa0$a401280a@.phx.gbl...
>> I'm a SQL Server DBA and will be playing the role of a
>> SQL2000 Reporting Services administrator. To tightly
>> control the environment and keep track of all the
changes,
>> I'm considering to implement a policy that requires all
>> changes to Reporting Services and reports be released
into
>> production via VB.NET scripts for rs.exe, and all such
>> scripts be submitted to me for review first.
>> I'd like to bounce this off you guys to see (1) whether
>> I'm going overboard, and (2) whether all changes can be
>> implemented via RS scripts.
>> Joe
>
>.
>

RS Data Driven Subscription is out of control...

Hi - I'm hoping someone can help me with a subscription problem (SQL 2000, Reporting SErvice SP2). Created a data driven subscription and made a mistake in the parameter list. It was really long, and now I can't get the subscription to stop. I've bounced the server, but as soon as we restart RS the job starts back up again. I tried to delete the subscription, but it gives me a timeout error. I've already changed the subscription (because I didn't realize the trouble) and I'm wondering if there is a way to get rid of it. Right now, I've left RS service stopped.

Thanks,
Mary

The subscription runs via the SQL Server Agent. You should be able to stop the agent which will stop the subscriptions from running. While stopped, you should be able to delete the subscription.

Please let me know if this helps. bradsyAtmicrosoftdotcom

|||Brad - I did try that but RS would not allow me to delete the subscription. I found another post though, that explained if I deleted from the ActiveSubscriptions and Notifications tables in ReportServer db I would be able to stop it from restarting. I tried that and it worked.

Thanks for your help.

m
|||

Please give me more details on the other post you used to find the answer.

Thanks

Chetan

RS Data Driven Subscription is out of control...

Hi - I'm hoping someone can help me with a subscription problem (SQL 2000, Reporting SErvice SP2). Created a data driven subscription and made a mistake in the parameter list. It was really long, and now I can't get the subscription to stop. I've bounced the server, but as soon as we restart RS the job starts back up again. I tried to delete the subscription, but it gives me a timeout error. I've already changed the subscription (because I didn't realize the trouble) and I'm wondering if there is a way to get rid of it. Right now, I've left RS service stopped.

Thanks,
Mary

The subscription runs via the SQL Server Agent. You should be able to stop the agent which will stop the subscriptions from running. While stopped, you should be able to delete the subscription.

Please let me know if this helps. bradsyAtmicrosoftdotcom

|||Brad - I did try that but RS would not allow me to delete the subscription. I found another post though, that explained if I deleted from the ActiveSubscriptions and Notifications tables in ReportServer db I would be able to stop it from restarting. I tried that and it worked.

Thanks for your help.

m|||

Please give me more details on the other post you used to find the answer.

Thanks

Chetan

RS asking for credentials

We have SP2 installed.
Our app uses the new viewer control.
Right now every time the app asks for a report the RS is asking to login
credentials.
Prior to today sometimes it would and sometimes it wouldn't.
We're on an intranet so anyone in the domain can run/view a report.
It seems like I've changed or missed some setting so RS doesn't as for
credentials.
Can someone point me in the rightr direction.
Thanks
Kyle!Sorry...meant SP1.
"Kyle Jedrusiak" <kjedrusiak@.princetoninformation.com> wrote in message
news:OPwU8qDbFHA.464@.TK2MSFTNGP15.phx.gbl...
> We have SP2 installed.
> Our app uses the new viewer control.
> Right now every time the app asks for a report the RS is asking to login
> credentials.
> Prior to today sometimes it would and sometimes it wouldn't.
> We're on an intranet so anyone in the domain can run/view a report.
> It seems like I've changed or missed some setting so RS doesn't as for
> credentials.
> Can someone point me in the rightr direction.
> Thanks
> Kyle!
>

RS 2005: Excessively Long String error when printing

I have a VB.NET 2003 WinForms application that contains a browser control to render reports within. I have a SQL Server 2005 Reporting Services instance - and through the RS site, the reports come up great, and print just fine. However, when pulling in the reports through the WinForms application, when trying to print - I receive an error. A message box pops up that says "An error occured trying to get the current window." The next message is:

Line: 26; Char:4; Error: Marshaler restriction: Excessively long string. Code: 0; URL: http://svr-sqlreport1/ReportServer$QA/Reserved.ReportViewerWebControl.axd?

Jon,

We are also experiencing exactly your issue described above. I read on one forum that embedded web forms using URL access to get reports is not a supported feature of RS2005 which is absolutely dumbfounding. We have invested heavily in embedding the web form in a Visual Studio application that can apparently no longer support this for 2005.

I've been told by MS that we need to use there new controls, but your assuming that our clients are willing and able to deploy the .net framework 2.0 to the desktop and that requires XP SP2 - which in the case of one of our clients is also not on the desktop.

Is there any work around to this issue?

|||We've yet to find a work around...sorry. At this point, we've decided to spend some time testing and estimating effort required to upgrade to VS.NET 2005 (.NET fx 2.0). Provided that doesn't take too long, we'll upgrade. I'm really disappointed to hear that it is not supported and MSFT's only solution is to use new controls.|||

This is a known issue and will be fixed in SP1 for RS 2005. If you cannot wait for SP1, you can contact Microsoft PSS. There is a fix in development to address this issue and should be available soon.

The workaround for now is to use the ReportViewer controls in a 2.0 .Net application instead of the Web control.

|||

Thanks Brad. Do you have a bug # / code that I can reference as I deal with support people on the Microsoft side? Much appreciated.

-Dan

|||

Sure

SQL Hotfix 319. This is the code I know it by, but PSS should be able to figure it out with a little bit of looking.

|||

Thanks so much Brad - really appreciate the help.

Jon

|||

Brad -

In speaking with product support, they are unable to provide the hotfix unless I am able to provide the actual article number associated with the hotfix - they are saying that SQL Hotfix 319 is not enough for them to go by. Do you happen to have the article number?

Thanks,

Jon

|||

I've also spoken to my contacts at MS and they are unable to help without having the Knowledge base article associatied with this issue. Problem is, i've looked on the KB and can't find a one. Brad, any assistance you can provide would be helpful - in a time crunch with our client to get a resolution on this issue.

Thanks
-Dan

|||

Dan - not sure if you've done this yet...but SQL Server 2005 Service Pack 1 appears to have fixed this issue in our environment.

Jon

|||It does indeed! Thanks for your note Jon!

RS 2005: Excessively Long String error when printing

I have a VB.NET 2003 WinForms application that contains a browser control to render reports within. I have a SQL Server 2005 Reporting Services instance - and through the RS site, the reports come up great, and print just fine. However, when pulling in the reports through the WinForms application, when trying to print - I receive an error. A message box pops up that says "An error occured trying to get the current window." The next message is:

Line: 26; Char:4; Error: Marshaler restriction: Excessively long string. Code: 0; URL: http://svr-sqlreport1/ReportServer$QA/Reserved.ReportViewerWebControl.axd?

Jon,

We are also experiencing exactly your issue described above. I read on one forum that embedded web forms using URL access to get reports is not a supported feature of RS2005 which is absolutely dumbfounding. We have invested heavily in embedding the web form in a Visual Studio application that can apparently no longer support this for 2005.

I've been told by MS that we need to use there new controls, but your assuming that our clients are willing and able to deploy the .net framework 2.0 to the desktop and that requires XP SP2 - which in the case of one of our clients is also not on the desktop.

Is there any work around to this issue?

|||We've yet to find a work around...sorry. At this point, we've decided to spend some time testing and estimating effort required to upgrade to VS.NET 2005 (.NET fx 2.0). Provided that doesn't take too long, we'll upgrade. I'm really disappointed to hear that it is not supported and MSFT's only solution is to use new controls.|||

This is a known issue and will be fixed in SP1 for RS 2005. If you cannot wait for SP1, you can contact Microsoft PSS. There is a fix in development to address this issue and should be available soon.

The workaround for now is to use the ReportViewer controls in a 2.0 .Net application instead of the Web control.

|||

Thanks Brad. Do you have a bug # / code that I can reference as I deal with support people on the Microsoft side? Much appreciated.

-Dan

|||

Sure

SQL Hotfix 319. This is the code I know it by, but PSS should be able to figure it out with a little bit of looking.

|||

Thanks so much Brad - really appreciate the help.

Jon

|||

Brad -

In speaking with product support, they are unable to provide the hotfix unless I am able to provide the actual article number associated with the hotfix - they are saying that SQL Hotfix 319 is not enough for them to go by. Do you happen to have the article number?

Thanks,

Jon

|||

I've also spoken to my contacts at MS and they are unable to help without having the Knowledge base article associatied with this issue. Problem is, i've looked on the KB and can't find a one. Brad, any assistance you can provide would be helpful - in a time crunch with our client to get a resolution on this issue.

Thanks
-Dan

|||

Dan - not sure if you've done this yet...but SQL Server 2005 Service Pack 1 appears to have fixed this issue in our environment.

Jon

|||It does indeed! Thanks for your note Jon!

RS 2005: Excessively Long String error when printing

I have a VB.NET 2003 WinForms application that contains a browser control to render reports within. I have a SQL Server 2005 Reporting Services instance - and through the RS site, the reports come up great, and print just fine. However, when pulling in the reports through the WinForms application, when trying to print - I receive an error. A message box pops up that says "An error occured trying to get the current window." The next message is:

Line: 26; Char:4; Error: Marshaler restriction: Excessively long string. Code: 0; URL: http://svr-sqlreport1/ReportServer$QA/Reserved.ReportViewerWebControl.axd?

Jon,

We are also experiencing exactly your issue described above. I read on one forum that embedded web forms using URL access to get reports is not a supported feature of RS2005 which is absolutely dumbfounding. We have invested heavily in embedding the web form in a Visual Studio application that can apparently no longer support this for 2005.

I've been told by MS that we need to use there new controls, but your assuming that our clients are willing and able to deploy the .net framework 2.0 to the desktop and that requires XP SP2 - which in the case of one of our clients is also not on the desktop.

Is there any work around to this issue?

|||We've yet to find a work around...sorry. At this point, we've decided to spend some time testing and estimating effort required to upgrade to VS.NET 2005 (.NET fx 2.0). Provided that doesn't take too long, we'll upgrade. I'm really disappointed to hear that it is not supported and MSFT's only solution is to use new controls.|||

This is a known issue and will be fixed in SP1 for RS 2005. If you cannot wait for SP1, you can contact Microsoft PSS. There is a fix in development to address this issue and should be available soon.

The workaround for now is to use the ReportViewer controls in a 2.0 .Net application instead of the Web control.

|||

Thanks Brad. Do you have a bug # / code that I can reference as I deal with support people on the Microsoft side? Much appreciated.

-Dan

|||

Sure

SQL Hotfix 319. This is the code I know it by, but PSS should be able to figure it out with a little bit of looking.

|||

Thanks so much Brad - really appreciate the help.

Jon

|||

Brad -

In speaking with product support, they are unable to provide the hotfix unless I am able to provide the actual article number associated with the hotfix - they are saying that SQL Hotfix 319 is not enough for them to go by. Do you happen to have the article number?

Thanks,

Jon

|||

I've also spoken to my contacts at MS and they are unable to help without having the Knowledge base article associatied with this issue. Problem is, i've looked on the KB and can't find a one. Brad, any assistance you can provide would be helpful - in a time crunch with our client to get a resolution on this issue.

Thanks
-Dan

|||

Dan - not sure if you've done this yet...but SQL Server 2005 Service Pack 1 appears to have fixed this issue in our environment.

Jon

|||It does indeed! Thanks for your note Jon!