rsExecutionNotFound when using ASP State Server

I'm working on an ASP.NET 2.0 project and we are using Reporting Services 2005, the web application is configured to work with a State Server. Our users are getting the following error randomly:

[ReportServerException: No se encuentra la ejecución 'bla bla bla' (rsExecutionNotFound)]

Microsoft.Reporting.WebForms.ServerReport.GetExecutionInfo() + 367

Microsoft.Reporting.WebForms.ServerReport.SetExecutionId(String executionId) + 117

Microsoft.Reporting.WebForms.ServerReport..ctor(SerializationInfo info, StreamingContext context() + 206

[TargetInvocationException: Exception has been thrown by the target invocation]

System.RuntimeMethodHandle._SerializationInvoke(Object target, SignatureStruct& declaringType, ...

...

System.Web.SessionState.SessionStateItemCollection.DeserializeAllItems() + 88

System.Web.SessionState.SessionStateItemCollection.get_Keys() + 9

System.Web.SessionState.HttpSessionStateContainer.get_Keys() + 10

System.Web.SessionState.HttpSessionState.get_Keys() + 10

...

This exception is thrown in a request when we access the session context to get a variable. After some investigation we have found that the report viewer is storing reports in the session context, we supose that when the report execution expires on server this error is thrown and the user must close Internet explorer and reenter the application.

Is there any way to avoid Report viewer storing reports on session context, if not I think that this is a bug because when using a state server this error is not recoverable and the user must close the Internet explorer. This think doesn' like them much ;-)

Any help would be appreciated

thanks in advance

I'm sorry, I'm not currently bringing a solution to your problem, although:

- I did post the issue on MSDN Labs: http://lab.msdn.microsoft.com/productfeedback/viewfeedback.aspx?feedbackid=90396e94-e868-4a33-b784-f43dcd5a7393

- There is a solution, although it's a hack: http://groups.google.fr/group/ReportingServices/browse_thread/thread/685274e5aa25310/bae5e060b65863b0?lnk=st&q=rsexecutionnotfound&rnum=3&hl=fr#bae5e060b65863b0

Trace.axd brings nothing useful session-wise.

If you did find a solution, please post it, as I too need one!

|||Microsoft says that this is solved, but I can't find where, may be in Sql Server 2005 SP1?

rsExecutionNotFound when using ASP State Server

I'm working on an ASP.NET 2.0 project and we are using Reporting Services 2005, the web application is configured to work with a State Server. Our users are getting the following error randomly:

[ReportServerException: No se encuentra la ejecución 'bla bla bla' (rsExecutionNotFound)]

Microsoft.Reporting.WebForms.ServerReport.GetExecutionInfo() + 367

Microsoft.Reporting.WebForms.ServerReport.SetExecutionId(String executionId) + 117

Microsoft.Reporting.WebForms.ServerReport..ctor(SerializationInfo info, StreamingContext context() + 206

[TargetInvocationException: Exception has been thrown by the target invocation]

System.RuntimeMethodHandle._SerializationInvoke(Object target, SignatureStruct& declaringType, ...

...

System.Web.SessionState.SessionStateItemCollection.DeserializeAllItems() + 88

System.Web.SessionState.SessionStateItemCollection.get_Keys() + 9

System.Web.SessionState.HttpSessionStateContainer.get_Keys() + 10

System.Web.SessionState.HttpSessionState.get_Keys() + 10

...

This exception is thrown in a request when we access the session context to get a variable. After some investigation we have found that the report viewer is storing reports in the session context, we supose that when the report execution expires on server this error is thrown and the user must close Internet explorer and reenter the application.

Is there any way to avoid Report viewer storing reports on session context, if not I think that this is a bug because when using a state server this error is not recoverable and the user must close the Internet explorer. This think doesn' like them much ;-)

Any help would be appreciated

thanks in advance

I'm sorry, I'm not currently bringing a solution to your problem, although:

- I did post the issue on MSDN Labs: http://lab.msdn.microsoft.com/productfeedback/viewfeedback.aspx?feedbackid=90396e94-e868-4a33-b784-f43dcd5a7393

- There is a solution, although it's a hack: http://groups.google.fr/group/ReportingServices/browse_thread/thread/685274e5aa25310/bae5e060b65863b0?lnk=st&q=rsexecutionnotfound&rnum=3&hl=fr#bae5e060b65863b0

Trace.axd brings nothing useful session-wise.

If you did find a solution, please post it, as I too need one!

|||Microsoft says that this is solved, but I can't find where, may be in Sql Server 2005 SP1?

rsExecutionNotFound when using ASP State Server

I'm working on an ASP.NET 2.0 project and we are using Reporting Services 2005, the web application is configured to work with a State Server. Our users are getting the following error randomly:

[ReportServerException: No se encuentra la ejecución 'bla bla bla' (rsExecutionNotFound)]

Microsoft.Reporting.WebForms.ServerReport.GetExecutionInfo() + 367

Microsoft.Reporting.WebForms.ServerReport.SetExecutionId(String executionId) + 117

Microsoft.Reporting.WebForms.ServerReport..ctor(SerializationInfo info, StreamingContext context() + 206

[TargetInvocationException: Exception has been thrown by the target invocation]

System.RuntimeMethodHandle._SerializationInvoke(Object target, SignatureStruct& declaringType, ...

...

System.Web.SessionState.SessionStateItemCollection.DeserializeAllItems() + 88

System.Web.SessionState.SessionStateItemCollection.get_Keys() + 9

System.Web.SessionState.HttpSessionStateContainer.get_Keys() + 10

System.Web.SessionState.HttpSessionState.get_Keys() + 10

...

This exception is thrown in a request when we access the session context to get a variable. After some investigation we have found that the report viewer is storing reports in the session context, we supose that when the report execution expires on server this error is thrown and the user must close Internet explorer and reenter the application.

Is there any way to avoid Report viewer storing reports on session context, if not I think that this is a bug because when using a state server this error is not recoverable and the user must close the Internet explorer. This think doesn' like them much ;-)

Any help would be appreciated

thanks in advance

I'm sorry, I'm not currently bringing a solution to your problem, although:

- I did post the issue on MSDN Labs: http://lab.msdn.microsoft.com/productfeedback/viewfeedback.aspx?feedbackid=90396e94-e868-4a33-b784-f43dcd5a7393

- There is a solution, although it's a hack: http://groups.google.fr/group/ReportingServices/browse_thread/thread/685274e5aa25310/bae5e060b65863b0?lnk=st&q=rsexecutionnotfound&rnum=3&hl=fr#bae5e060b65863b0

Trace.axd brings nothing useful session-wise.

If you did find a solution, please post it, as I too need one!

|||Microsoft says that this is solved, but I can't find where, may be in Sql Server 2005 SP1?sql

rsExecutionNotFound error

Hello,

I am developing a report viewer application in ASP.NEt 2.0 and in that I have a page called ReportViewer.aspx page which has a report viewer control. The processing mode is remote and it is a SQL Server 2005. There are a couple of dropdownlists one which defines the names of the different reports and the other the reporting periods. Depending on the selection made by the user, the call is made to the reporting server and reporst are displayed. Initially when the page loads, the reports show up without any problems. But if a user is inactive for a while, and the user tries to the view the report, I get the following error

"Execution 'tmf3wgqtzuasux3trzliwx25' cannot be found (rsExecutionNotFound) "

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: Microsoft.Reporting.WebForms.ReportServerException: Execution 'tmf3wgqtzuasux3trzliwx25' cannot be found (rsExecutionNotFound).

I did some research and came across this post which is the exact error which i am getting.

http://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=124525

The above link is not working for some reason but if you click on the link below, it says that the issue has been fixed. But there is no information as to how to fix this. Does anybody have any idea as to what the solution is?This is the exact same error which I am getting and any help to resolve this error would be great.

http://64.233.183.104/search?q=cache:H2UEJj42ypcJ:connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx%3FFeedbackID%3D124525+rsExecutionNotFound+%2B+2005&hl=en&ct=clnk&cd=1&gl=us

There are some posts which advise to add the a guid at the end of the url but if you are using a viewer you cannot add anything else to the .ServerReport.ReportURL property other than the path to the report or else it returns an error.

As per my knowledge, the report veiwer control should be keeping the session alive using keep alive messages. There is also the possibility of IE caching and one can disable it by going to Tools -> Options and disabling the caching. But this is not something which I can tell my customers to do.

Any help would be greatly appreciated.

Regards,

arpan

Arpan,

My team came across this error a while ago, and found that Reporting Services has it's own session that is timing out. In the ReportServer database, there is a table called ConfigurationInfo. In this table there are values for a SessionTimeout and SessionAccessTimeout. I think the default is set to '600'. This value corresponds to the number of seconds that the report session will be open.

Our solution was to bump this number way up, say to a couple of hours or more. The problem with this is then you get a lot of data in the ReportServerTempDB, which may cause headaches. It's not a perfect solution, and this property should be more easily editable.

The other way to set this property is to use some Reporting Service Scripting, .rss files, and run them using the rs.exe utility that was installed with Reporting Services. There is a Good blog about this by John Gallardo (?) I think.

Good Luck,

Mac

blog url: http://blogs.msdn.com/jgalla/archive/2006/10/11/session-timeout-during-execution.aspx

|||

Mac.

Thanks for the quick reply. I shall try it out tomorrow and see if that helps.

Regards.

arpan

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>

Rsetarting SQL server frequently

Hello All,
I have to restart SQL Server 2000 every week or it hangs
the website made in ASP. Restarting fixes the problem.
Does anyone have an idea, why it happens?
Thanks,
Tanyasounds to me like connection creep (Orphaned sessions).
GAJsql

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 problem

I'm trying to get client side printing to work in asp.net with reporting services 2005. I've got an aspx page to do printing as described here but when I try to render a report I get the following:

1. Print dialog box appears as expected

2. Press print

3. Dialog box appears saying "Print in progress"

4. After a few seconds another dialog box appears saying there was an error printing the report. Error code is 80004005.

I get the same error if I try to preview instad of print.

The (relevent) code is:

<object id="RSClientPrint" classid="CLSID:FA91DF8D-53AB-455D-AB20-F2F023E498D3" codebase="Bin/RSClientPrint.cab#Version=2005,90,1399,0"></object>

<script language="javascript" type="text/javascript">
function printIt() {
RSClientPrint.Print('http://localhost/ReportServer$SQL2005',
'/LMI Reports/GoodsIn&OrderID=1000'),
'Goodsin');
}
</script>

<body onload="printIt()">

Does anybody know what this error is and how I can get the control to work? Its not clear to me what the version on the object statement should be. This example uses the version string from the control but I've also tried 1.0 with the same result. Its also not clear if I should be using RSClientPrint.Authenticate or not. I've tried both true and false with the same result.

Many thanks

Ian

Hi Ian,

I am also getting same problem . do you have any solutions for it ?

suresh babu

|||Ian did you solve this issue?.. if you did it.. please let me know to ayoplac@.hotmail.com
|||No, sadly it was never resolved other than using a different reporting system that actually works.

RSClientPrint problem

I'm trying to get client side printing to work in asp.net with reporting services 2005. I've got an aspx page to do printing as described here but when I try to render a report I get the following:

1. Print dialog box appears as expected

2. Press print

3. Dialog box appears saying "Print in progress"

4. After a few seconds another dialog box appears saying there was an error printing the report. Error code is 80004005.

I get the same error if I try to preview instad of print.

The (relevent) code is:

<object id="RSClientPrint" classid="CLSID:FA91DF8D-53AB-455D-AB20-F2F023E498D3" codebase="Bin/RSClientPrint.cab#Version=2005,90,1399,0"></object>

<script language="javascript" type="text/javascript">
function printIt() {
RSClientPrint.Print('http://localhost/ReportServer$SQL2005',
'/LMI Reports/GoodsIn&OrderID=1000'),
'Goodsin');
}
</script>

<body onload="printIt()">

Does anybody know what this error is and how I can get the control to work? Its not clear to me what the version on the object statement should be. This example uses the version string from the control but I've also tried 1.0 with the same result. Its also not clear if I should be using RSClientPrint.Authenticate or not. I've tried both true and false with the same result.

Many thanks

Ian

Hi Ian,

I am also getting same problem . do you have any solutions for it ?

suresh babu

|||Ian did you solve this issue?.. if you did it.. please let me know to ayoplac@.hotmail.com|||No, sadly it was never resolved other than using a different reporting system that actually works.

RSClientPrint problem

I'm trying to get client side printing to work in asp.net with reporting services 2005. I've got an aspx page to do printing as described here but when I try to render a report I get the following:

1. Print dialog box appears as expected

2. Press print

3. Dialog box appears saying "Print in progress"

4. After a few seconds another dialog box appears saying there was an error printing the report. Error code is 80004005.

I get the same error if I try to preview instad of print.

The (relevent) code is:

<object id="RSClientPrint" classid="CLSID:FA91DF8D-53AB-455D-AB20-F2F023E498D3" codebase="Bin/RSClientPrint.cab#Version=2005,90,1399,0"></object>

<script language="javascript" type="text/javascript">
function printIt() {
RSClientPrint.Print('http://localhost/ReportServer$SQL2005',
'/LMI Reports/GoodsIn&OrderID=1000'),
'Goodsin');
}
</script>

<body onload="printIt()">

Does anybody know what this error is and how I can get the control to work? Its not clear to me what the version on the object statement should be. This example uses the version string from the control but I've also tried 1.0 with the same result. Its also not clear if I should be using RSClientPrint.Authenticate or not. I've tried both true and false with the same result.

Many thanks

Ian

Hi Ian,

I am also getting same problem . do you have any solutions for it ?

suresh babu

|||Ian did you solve this issue?.. if you did it.. please let me know to ayoplac@.hotmail.com
|||No, sadly it was never resolved other than using a different reporting system that actually works.

RSClientPrint Download

I have an asp.net application which is launched from our B2B site. The primary purpose of the application is to allow our external clients access to reports, along with the ability to export and print. The RS2005 report viewer component was used within the application to render the reports. The problem is when the our client users click on the print button on the report viewer's tool bar, many of them are receiving a window asking them if they want to install "SQL Server". In reality, the ActiveX viewer, RSClientPrint, is what is trying to install. Our technical support staff is being flooded with calls due to this pop up. The users are very confused and concerned about installing "SQL Server." In addition, some users do not have the ability to install the ActiveX viewer, so they are not going to be able to print. We've experienced this in the past with ActiveX for Crystal. Finally, some users receive no message or feedback when they click on the print button for several minutes. We've determined the ActiveX is being installed during this time. We've had users wait as long as 7 minutes for the Print Dialog to come up.

1. We would like to place a message along with the link on the page where the report is rendered. Is there a way for us to provide a link to a self extracting file containing RSClientPrint?

2. Also is there any way to get around the issue where the client user does not have the ability to install the ActiveX? I've seen references on the forum to using SMS, but this is not possible since the users are external?

3. Is there any setting we can turn on so the users don't think the application has gone "out to lunch" while the ActiveX viewer is installed?

Thanks

Anything that Report Manager or the ActiveX control does, you can code yourself using the Reporting Services Web Services. You don't and never did need the ActiveX to view reports. It was added to allow new developers an easy way to add reporting features to applications without needing to know about the Web Services.

What you will find is that at some point, you will need to access Reporting Services in a way that the ActiveX does not support/make easy and you will have to go via the Web Services... now it that time

Regards

Paul

|||

Paul,

Thank you for your quick response. Unfortunately, we avoided this approach on purpose for a number of reasons, one of which was to avoid passing sensitive client customer information on the query string and then having to encrypt it.

We have actually used the RS web service with a RS2000 report for our price lists. However, we liked the ease of use in VS2005 with the report viewer component and the ability to pass parameters internally from the ASP.Net application to the report viewer component which hid sensitive information from potential hackers.

I assume based on your response there is no way for us to provide a link to a self extracting RSClientPrint file or any way to speed up the download and installation time?

Thanks

Carol

|||

Not really. This is one of the 'joys' of working with ActiveX controls.

You only pass details across the query string when you are using URL access to reporting services. The web services use SOAP (XML). You could create a soap extension in .NET to encrypt the data or simply run the web services over SSL.

Cheers

Paul

|||

Paul,

You say "You don't and never did need the ActiveX to view reports".... Are you talking about RSClientPrint? If so...is there any way to print reports (other than browser, or exported) without this ActiveX?

|||

Hi to everyone, actually i have an application to external clients and they will need to be able to print some reports.

After reading some forums, blogs, MSDN KB articles, we discover a way to print automatically theese reports, but it only work if we have thath activex installed.

If you (Paul) say thah we can perform the activity to print reports on Iexplorer using the Reporting Services Web Service, could you give us some orientatio about the methods to use for this activity...

I used this Web Service form rendering reports and show it to the client, but now thath i need to print, the only way i discovered is using the activex.

Greetings !

|||From what I understand, in order to use that print button on the report toolbar, the RSClientPrint ActiveX is required. The only other options for printing are:
1. Using the browser's print functionality (file->print) - but then you get the rest of the web page, and only the part of the report that is currently visible (nothing you have to scroll to see or other pages for multipage reports)
2. Export the report and use another application to print - for instance, export to PDF and print from Adobe Reader.
Basically, the browser knows how to print web pages, Adobe knows how to print PDFs, and RSClientPrint knows how to print SQL 2005 Reports.
MSDN - SQL Server 2005 Books Online - Printing Reports from a Browser:
http://msdn2.microsoft.com/en-us/library/ms159237.aspx
MSDN - SQL Server 2005 Books Online - How to: Configure a Browser for Client-Side Printing (Report Manager)
http://msdn2.microsoft.com/en-us/library/ms159190.aspx
This was enough proof for our marketing department...
-
Mike

RSClientPrint Download

I have an asp.net application which is launched from our B2B site. The primary purpose of the application is to allow our external clients access to reports, along with the ability to export and print. The RS2005 report viewer component was used within the application to render the reports. The problem is when the our client users click on the print button on the report viewer's tool bar, many of them are receiving a window asking them if they want to install "SQL Server". In reality, the ActiveX viewer, RSClientPrint, is what is trying to install. Our technical support staff is being flooded with calls due to this pop up. The users are very confused and concerned about installing "SQL Server." In addition, some users do not have the ability to install the ActiveX viewer, so they are not going to be able to print. We've experienced this in the past with ActiveX for Crystal. Finally, some users receive no message or feedback when they click on the print button for several minutes. We've determined the ActiveX is being installed during this time. We've had users wait as long as 7 minutes for the Print Dialog to come up.

1. We would like to place a message along with the link on the page where the report is rendered. Is there a way for us to provide a link to a self extracting file containing RSClientPrint?

2. Also is there any way to get around the issue where the client user does not have the ability to install the ActiveX? I've seen references on the forum to using SMS, but this is not possible since the users are external?

3. Is there any setting we can turn on so the users don't think the application has gone "out to lunch" while the ActiveX viewer is installed?

Thanks

Anything that Report Manager or the ActiveX control does, you can code yourself using the Reporting Services Web Services. You don't and never did need the ActiveX to view reports. It was added to allow new developers an easy way to add reporting features to applications without needing to know about the Web Services.

What you will find is that at some point, you will need to access Reporting Services in a way that the ActiveX does not support/make easy and you will have to go via the Web Services... now it that time

Regards

Paul

|||

Paul,

Thank you for your quick response. Unfortunately, we avoided this approach on purpose for a number of reasons, one of which was to avoid passing sensitive client customer information on the query string and then having to encrypt it.

We have actually used the RS web service with a RS2000 report for our price lists. However, we liked the ease of use in VS2005 with the report viewer component and the ability to pass parameters internally from the ASP.Net application to the report viewer component which hid sensitive information from potential hackers.

I assume based on your response there is no way for us to provide a link to a self extracting RSClientPrint file or any way to speed up the download and installation time?

Thanks

Carol

|||

Not really. This is one of the 'joys' of working with ActiveX controls.

You only pass details across the query string when you are using URL access to reporting services. The web services use SOAP (XML). You could create a soap extension in .NET to encrypt the data or simply run the web services over SSL.

Cheers

Paul

|||

Paul,

You say "You don't and never did need the ActiveX to view reports".... Are you talking about RSClientPrint? If so...is there any way to print reports (other than browser, or exported) without this ActiveX?

|||

Hi to everyone, actually i have an application to external clients and they will need to be able to print some reports.

After reading some forums, blogs, MSDN KB articles, we discover a way to print automatically theese reports, but it only work if we have thath activex installed.

If you (Paul) say thah we can perform the activity to print reports on Iexplorer using the Reporting Services Web Service, could you give us some orientatio about the methods to use for this activity...

I used this Web Service form rendering reports and show it to the client, but now thath i need to print, the only way i discovered is using the activex.

Greetings !

|||From what I understand, in order to use that print button on the report toolbar, the RSClientPrint ActiveX is required. The only other options for printing are:
1. Using the browser's print functionality (file->print) - but then you get the rest of the web page, and only the part of the report that is currently visible (nothing you have to scroll to see or other pages for multipage reports)
2. Export the report and use another application to print - for instance, export to PDF and print from Adobe Reader.
Basically, the browser knows how to print web pages, Adobe knows how to print PDFs, and RSClientPrint knows how to print SQL 2005 Reports.
MSDN - SQL Server 2005 Books Online - Printing Reports from a Browser:
http://msdn2.microsoft.com/en-us/library/ms159237.aspx
MSDN - SQL Server 2005 Books Online - How to: Configure a Browser for Client-Side Printing (Report Manager)
http://msdn2.microsoft.com/en-us/library/ms159190.aspx
This was enough proof for our marketing department...
-
Mike

RSClientPrint Download

I have an asp.net application which is launched from our B2B site. The primary purpose of the application is to allow our external clients access to reports, along with the ability to export and print. The RS2005 report viewer component was used within the application to render the reports. The problem is when the our client users click on the print button on the report viewer's tool bar, many of them are receiving a window asking them if they want to install "SQL Server". In reality, the ActiveX viewer, RSClientPrint, is what is trying to install. Our technical support staff is being flooded with calls due to this pop up. The users are very confused and concerned about installing "SQL Server." In addition, some users do not have the ability to install the ActiveX viewer, so they are not going to be able to print. We've experienced this in the past with ActiveX for Crystal. Finally, some users receive no message or feedback when they click on the print button for several minutes. We've determined the ActiveX is being installed during this time. We've had users wait as long as 7 minutes for the Print Dialog to come up.

1. We would like to place a message along with the link on the page where the report is rendered. Is there a way for us to provide a link to a self extracting file containing RSClientPrint?

2. Also is there any way to get around the issue where the client user does not have the ability to install the ActiveX? I've seen references on the forum to using SMS, but this is not possible since the users are external?

3. Is there any setting we can turn on so the users don't think the application has gone "out to lunch" while the ActiveX viewer is installed?

Thanks

Anything that Report Manager or the ActiveX control does, you can code yourself using the Reporting Services Web Services. You don't and never did need the ActiveX to view reports. It was added to allow new developers an easy way to add reporting features to applications without needing to know about the Web Services.

What you will find is that at some point, you will need to access Reporting Services in a way that the ActiveX does not support/make easy and you will have to go via the Web Services... now it that time

Regards

Paul

|||

Paul,

Thank you for your quick response. Unfortunately, we avoided this approach on purpose for a number of reasons, one of which was to avoid passing sensitive client customer information on the query string and then having to encrypt it.

We have actually used the RS web service with a RS2000 report for our price lists. However, we liked the ease of use in VS2005 with the report viewer component and the ability to pass parameters internally from the ASP.Net application to the report viewer component which hid sensitive information from potential hackers.

I assume based on your response there is no way for us to provide a link to a self extracting RSClientPrint file or any way to speed up the download and installation time?

Thanks

Carol

|||

Not really. This is one of the 'joys' of working with ActiveX controls.

You only pass details across the query string when you are using URL access to reporting services. The web services use SOAP (XML). You could create a soap extension in .NET to encrypt the data or simply run the web services over SSL.

Cheers

Paul

|||

Paul,

You say "You don't and never did need the ActiveX to view reports".... Are you talking about RSClientPrint? If so...is there any way to print reports (other than browser, or exported) without this ActiveX?

|||

Hi to everyone, actually i have an application to external clients and they will need to be able to print some reports.

After reading some forums, blogs, MSDN KB articles, we discover a way to print automatically theese reports, but it only work if we have thath activex installed.

If you (Paul) say thah we can perform the activity to print reports on Iexplorer using the Reporting Services Web Service, could you give us some orientatio about the methods to use for this activity...

I used this Web Service form rendering reports and show it to the client, but now thath i need to print, the only way i discovered is using the activex.

Greetings !

|||From what I understand, in order to use that print button on the report toolbar, the RSClientPrint ActiveX is required. The only other options for printing are:
1. Using the browser's print functionality (file->print) - but then you get the rest of the web page, and only the part of the report that is currently visible (nothing you have to scroll to see or other pages for multipage reports)
2. Export the report and use another application to print - for instance, export to PDF and print from Adobe Reader.
Basically, the browser knows how to print web pages, Adobe knows how to print PDFs, and RSClientPrint knows how to print SQL 2005 Reports.
MSDN - SQL Server 2005 Books Online - Printing Reports from a Browser:
http://msdn2.microsoft.com/en-us/library/ms159237.aspx
MSDN - SQL Server 2005 Books Online - How to: Configure a Browser for Client-Side Printing (Report Manager)
http://msdn2.microsoft.com/en-us/library/ms159190.aspx
This was enough proof for our marketing department...
-
Mike

RSClientPrint - Error on some clients

I have several new PCs that I am setting up to run an RS ASP.net application. The Dells work fine. The Gateway gives a print error message 'An error occurred during printing (0x80070006)' and then a script error 'the handle is invalid'. I have tried various things, such as, disabling popup blockers, tool bars and changing IE settings. Nothing makes it work. The only difference between the machines is that the Gateway has Norton Anti-Virus loaded. Tried disabling it but still got the error. I have searched the internet and cannot find a similar error. Need help fast, deploying in 2 weeks.

Hi mark,

I've had the same problem at a client. Did you do an upgrade to SQL Server 2005 or installed a service pack for reporting services ?

The problem is that when the user tries to print a reporting services report, an ActiveX is installed on the user's pc (C:\Windows\Downloaded Program Files\RsClientPrint Class).

When upgrading to a new version or installing a service pack, the component needs to be upgraded. Apparently this doesn't always work that well.

When you remove the component (by right clicking it in c:\windows\...) and try to print a page, you will see that a new version will be installed and that you can print again.

I didn't figured out a good way to deploy this yet because user's don't have sufficient rights to install ActiveX components. It might work if you put the site in the Trusted Sites.

Hope this helps !

Geert Verhoeven

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 and ASP.net 1.x

I'm wondering if RS2005 and ASP.net 1.x are compatible...
Thanks in advance.
ChiekoRS2005 use the framework 2.0.
RS2005 is compatible with the .Net 1.1 in the way that the IIS virtual
directory for RS2005 will use ASP.Net 2.0 and another virtual directory will
use the .Net 1.1
So on the same box you can run both .Net1.1 and 2.0 web applications.
"chieko" <chieko@.discussions.microsoft.com> wrote in message
news:01CE6C4B-EBBA-4584-AB60-303DF02C8BC5@.microsoft.com...
> I'm wondering if RS2005 and ASP.net 1.x are compatible...
> Thanks in advance.
> Chieko
>|||Hi Jeje,
Thank you for your response.
Yes, the reports in .Net 1.1 are running fine under RS2005.
Chieko
"Jeje" wrote:
> RS2005 use the framework 2.0.
> RS2005 is compatible with the .Net 1.1 in the way that the IIS virtual
> directory for RS2005 will use ASP.Net 2.0 and another virtual directory will
> use the .Net 1.1
> So on the same box you can run both .Net1.1 and 2.0 web applications.
>
> "chieko" <chieko@.discussions.microsoft.com> wrote in message
> news:01CE6C4B-EBBA-4584-AB60-303DF02C8BC5@.microsoft.com...
> > I'm wondering if RS2005 and ASP.net 1.x are compatible...
> >
> > Thanks in advance.
> > Chieko
> >
>

RS2005 and 401 - Unauthorized.

After a long time, I finally got my asp.net application to authenticate
with RS 2005..
I have a server with Windows 2003 Server and SQL 2005/RS 2005. I created
a user in the domain just for ReportViewer, and granted access in RS 2005.
In my project, I implemented IReportServerCredentials like this:
public bool GetFormsCredentials(out Cookie authCookie, out string
userName, out string password, out string authority)
{
authCookie = null;
userName = null;
password = null;
authority = null;
return false;
}
public WindowsIdentity ImpersonationUser
{
get
{
return null;
}
}
public ICredentials NetworkCredentials
{
get
{
return new NetworkCredential(_user, _pass, _domain);
}
}
It works perfectly running the ASP.NET application in my computer,
winXP/IIS 5.1, but when I deploy the exact same site in the win2003
server (the same from RS), I get this error:
The request failed with HTTP status 401: Unauthorized.
I checked the EventViewer, and when running from my computer, I get this:
Successful Network Logon:
User Name: USER
Domain: DOMAIN
but when running from the server, I get this:
Logon attempt using explicit credentials:
Logged on user:
User Name: NETWORK SERVICE
Domain: NT AUTHORITY
Logon ID: (0x0,0x3E4)
Logon GUID: -
User whose credentials were used:
Target User Name: MYUSER
Target Domain: DOMAIN
Target Logon GUID: -
And nothing more.
I tried the help, it didn't help much.
Anyone know what is the problem here?
Thanks in advance.I just enabled auditing failure events, and I get this from windows 2003
server:
Logon Failure:
Reason: An error occurred during logon
User Name: USER
Domain: DOMAIN
Logon Type: 3
Logon Process: Ðùë
Authentication Package: NTLM
Workstation Name: SERVER
Status code: 0xC000006D
Substatus code: 0x0
I have no idea what is happening. The username and password are right,
since they work in my computer and is a domain user, and the web server
is a domain computer...
help please!
Natan Vivo wrote:
> After a long time, I finally got my asp.net application to authenticate
> with RS 2005..
> I have a server with Windows 2003 Server and SQL 2005/RS 2005. I created
> a user in the domain just for ReportViewer, and granted access in RS 2005.
> In my project, I implemented IReportServerCredentials like this:
> public bool GetFormsCredentials(out Cookie authCookie, out string
> userName, out string password, out string authority)
> {
> authCookie = null;
> userName = null;
> password = null;
> authority = null;
> return false;
> }
> public WindowsIdentity ImpersonationUser
> {
> get
> {
> return null;
> }
> }
> public ICredentials NetworkCredentials
> {
> get
> {
> return new NetworkCredential(_user, _pass, _domain);
> }
> }
> It works perfectly running the ASP.NET application in my computer,
> winXP/IIS 5.1, but when I deploy the exact same site in the win2003
> server (the same from RS), I get this error:
> The request failed with HTTP status 401: Unauthorized.
> I checked the EventViewer, and when running from my computer, I get this:
> Successful Network Logon:
> User Name: USER
> Domain: DOMAIN
> but when running from the server, I get this:
> Logon attempt using explicit credentials:
> Logged on user:
> User Name: NETWORK SERVICE
> Domain: NT AUTHORITY
> Logon ID: (0x0,0x3E4)
> Logon GUID: -
> User whose credentials were used:
> Target User Name: MYUSER
> Target Domain: DOMAIN
> Target Logon GUID: -
>
> And nothing more.
> I tried the help, it didn't help much.
> Anyone know what is the problem here?
> Thanks in advance.|||Hi,
try Changing the your web application app pool identity to run under local
system, it may work. but this is not a correct solution. I have the same
problem, and i am waiting for the solution too
--
Regards
Raja Annamalai
"Natan Vivo" wrote:
> I just enabled auditing failure events, and I get this from windows 2003
> server:
> Logon Failure:
> Reason: An error occurred during logon
> User Name: USER
> Domain: DOMAIN
> Logon Type: 3
> Logon Process: �ùë
> Authentication Package: NTLM
> Workstation Name: SERVER
> Status code: 0xC000006D
> Substatus code: 0x0
> I have no idea what is happening. The username and password are right,
> since they work in my computer and is a domain user, and the web server
> is a domain computer...
> help please!
> Natan Vivo wrote:
> > After a long time, I finally got my asp.net application to authenticate
> > with RS 2005..
> >
> > I have a server with Windows 2003 Server and SQL 2005/RS 2005. I created
> > a user in the domain just for ReportViewer, and granted access in RS 2005.
> >
> > In my project, I implemented IReportServerCredentials like this:
> >
> > public bool GetFormsCredentials(out Cookie authCookie, out string
> > userName, out string password, out string authority)
> > {
> > authCookie = null;
> > userName = null;
> > password = null;
> > authority = null;
> >
> > return false;
> > }
> >
> > public WindowsIdentity ImpersonationUser
> > {
> > get
> > {
> > return null;
> > }
> > }
> >
> > public ICredentials NetworkCredentials
> > {
> > get
> > {
> > return new NetworkCredential(_user, _pass, _domain);
> > }
> > }
> >
> > It works perfectly running the ASP.NET application in my computer,
> > winXP/IIS 5.1, but when I deploy the exact same site in the win2003
> > server (the same from RS), I get this error:
> >
> > The request failed with HTTP status 401: Unauthorized.
> >
> > I checked the EventViewer, and when running from my computer, I get this:
> >
> > Successful Network Logon:
> > User Name: USER
> > Domain: DOMAIN
> >
> > but when running from the server, I get this:
> >
> > Logon attempt using explicit credentials:
> > Logged on user:
> > User Name: NETWORK SERVICE
> > Domain: NT AUTHORITY
> > Logon ID: (0x0,0x3E4)
> > Logon GUID: -
> > User whose credentials were used:
> > Target User Name: MYUSER
> > Target Domain: DOMAIN
> > Target Logon GUID: -
> >
> >
> > And nothing more.
> >
> > I tried the help, it didn't help much.
> >
> > Anyone know what is the problem here?
> >
> > Thanks in advance.
>

rs.getrows equivalent

Hi

Is there and equivalent of rs.getrows in asp.net? I want to fill an array quickly from a datareader?

ta
LbobIf you're using a DataReader you can add the items to an ArrayList so you don't need to know the number of records. This can be useful in some cases. Furthermore, if you're in the presentation code itself you can just set the DataReader as the DataSource of a control and do a DataBind on the control to display the contents on the control. There is a RecordsAffected property as well which may be helpful if you still want to determine the number of affected records by the query.|||I think it became depreciated when the DataTable object came out with ado.net

// first loop is the first dimension array similarity
for (int i=0;i<DataTable.Rows.Count;i++) {
 // second loop is the second dimension array similarity
 for (int j=0;j<DataTable.Columns.Count;j++) {
 // output the contents to the output window.
 System.Diagnostics.Debug.WriteLine(DataTable.Rows[i][j].ToString());
 }
}

RS on SQL Server 2005 Express

I have a ASP.NET web app on a dedicated Eindows Server 2003 with SQL Server
2000 and RS.
I need to move it to a new dedicated server that will have Windows Server
2003 Web Edition with SQL Server 2005 Express with RS.
The scaled down version of RS is fine for the application except -
http://msdn2.microsoft.com/en-us/library/ms365166.aspx indicates
"Report data sources must be SQL Server relational databases that run
locally in SQL Server Express."
All of the data for my reports come from a remote server via stored
procedures. Is there any way that I can still use the data from the remote
server?
Maybe a VPN connection so that RS sees a local IP address'
TIA
--
AG
Email: discuss at adhdata dot comYou are asking how to cheat the system. The reporting services is free with
a free database if you are getting the data from that database. Otherwise,
you are essentially asking how to break your license. Even if possible
no-one should be telling how to do this.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"AG" <NOSPAMa-giam@.newsgroups.nospam> wrote in message
news:%23eh68wvuGHA.4952@.TK2MSFTNGP02.phx.gbl...
>I have a ASP.NET web app on a dedicated Eindows Server 2003 with SQL Server
>2000 and RS.
> I need to move it to a new dedicated server that will have Windows Server
> 2003 Web Edition with SQL Server 2005 Express with RS.
> The scaled down version of RS is fine for the application except -
> http://msdn2.microsoft.com/en-us/library/ms365166.aspx indicates
> "Report data sources must be SQL Server relational databases that run
> locally in SQL Server Express."
> All of the data for my reports come from a remote server via stored
> procedures. Is there any way that I can still use the data from the remote
> server?
> Maybe a VPN connection so that RS sees a local IP address'
> TIA
> --
> AG
> Email: discuss at adhdata dot com
>
>|||Bruce,
Thanks for the quick reply.
I am not looking to 'cheat' or 'break' anything. I want to make sure I
understand it correctly and keep it legal. I maintain an MSDN Premium
subscription (not cheap) and always make sure I have valid software
licenses. Sometimes there are different ways of looking at things and
something may be allowed under some circumstances and not others. I haven't
used 2005 yet and there is so much info out there, it saves a lot of time to
ask in this forum.
So, don't take issue if my explanation was less than eloquent. I was trying
to be concise.
It seems like an unusual restriction to not allow any connection to another
database for something that comes with a web server.
Also, in this case, the amount of data, number of users, other features
needed, etc. does not warrant full SQL Server - except for this one item.
Would it be ok to copy the data from the remote server to Express? Assuming,
of course, that Express itself allows linked servers.
--
AG
Email: discuss at adhdata dot com
"Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
news:uGYmnCwuGHA.1272@.TK2MSFTNGP05.phx.gbl...
> You are asking how to cheat the system. The reporting services is free
> with a free database if you are getting the data from that database.
> Otherwise, you are essentially asking how to break your license. Even if
> possible no-one should be telling how to do this.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "AG" <NOSPAMa-giam@.newsgroups.nospam> wrote in message
> news:%23eh68wvuGHA.4952@.TK2MSFTNGP02.phx.gbl...
>>I have a ASP.NET web app on a dedicated Eindows Server 2003 with SQL
>>Server 2000 and RS.
>> I need to move it to a new dedicated server that will have Windows Server
>> 2003 Web Edition with SQL Server 2005 Express with RS.
>> The scaled down version of RS is fine for the application except -
>> http://msdn2.microsoft.com/en-us/library/ms365166.aspx indicates
>> "Report data sources must be SQL Server relational databases that run
>> locally in SQL Server Express."
>> All of the data for my reports come from a remote server via stored
>> procedures. Is there any way that I can still use the data from the
>> remote server?
>> Maybe a VPN connection so that RS sees a local IP address'
>> TIA
>> --
>> AG
>> Email: discuss at adhdata dot com
>>
>>
>|||OK.
I'm afraid I don't know about linked servers being available or not (which
is different from copying the data).
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"AG" <NOSPAMa-giam@.newsgroups.nospam> wrote in message
news:%23lCz$5xuGHA.976@.TK2MSFTNGP05.phx.gbl...
> Bruce,
> Thanks for the quick reply.
> I am not looking to 'cheat' or 'break' anything. I want to make sure I
> understand it correctly and keep it legal. I maintain an MSDN Premium
> subscription (not cheap) and always make sure I have valid software
> licenses. Sometimes there are different ways of looking at things and
> something may be allowed under some circumstances and not others. I
> haven't used 2005 yet and there is so much info out there, it saves a lot
> of time to ask in this forum.
> So, don't take issue if my explanation was less than eloquent. I was
> trying to be concise.
> It seems like an unusual restriction to not allow any connection to
> another database for something that comes with a web server.
> Also, in this case, the amount of data, number of users, other features
> needed, etc. does not warrant full SQL Server - except for this one item.
> Would it be ok to copy the data from the remote server to Express?
> Assuming, of course, that Express itself allows linked servers.
> --
> AG
> Email: discuss at adhdata dot com
>
> "Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
> news:uGYmnCwuGHA.1272@.TK2MSFTNGP05.phx.gbl...
>> You are asking how to cheat the system. The reporting services is free
>> with a free database if you are getting the data from that database.
>> Otherwise, you are essentially asking how to break your license. Even if
>> possible no-one should be telling how to do this.
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "AG" <NOSPAMa-giam@.newsgroups.nospam> wrote in message
>> news:%23eh68wvuGHA.4952@.TK2MSFTNGP02.phx.gbl...
>>I have a ASP.NET web app on a dedicated Eindows Server 2003 with SQL
>>Server 2000 and RS.
>> I need to move it to a new dedicated server that will have Windows
>> Server 2003 Web Edition with SQL Server 2005 Express with RS.
>> The scaled down version of RS is fine for the application except -
>> http://msdn2.microsoft.com/en-us/library/ms365166.aspx indicates
>> "Report data sources must be SQL Server relational databases that run
>> locally in SQL Server Express."
>> All of the data for my reports come from a remote server via stored
>> procedures. Is there any way that I can still use the data from the
>> remote server?
>> Maybe a VPN connection so that RS sees a local IP address'
>> TIA
>> --
>> AG
>> Email: discuss at adhdata dot com
>>
>>
>>
>|||AG,
The SQL Express support Linked server.
Althought it support Linked Server, I strongly recommend you to copy the
data to the SQL Express. If you wants to use the linked server in the
reporting services as your data source, you need to configure to use a
specified account to connect to the linked server.
Hope this will be helpful!
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
ications.
Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
http://msdn.microsoft.com/subscriptions/support/default.aspx.
==================================================(This posting is provided "AS IS", with no warranties, and confers no
rights.)|||Sounds good, thank you!
--
AG
Email: discuss at adhdata dot com
"Wei Lu [MSFT]" <weilu@.online.microsoft.com> wrote in message
news:sOfQPn3uGHA.492@.TK2MSFTNGXA01.phx.gbl...
> AG,
> The SQL Express support Linked server.
> Althought it support Linked Server, I strongly recommend you to copy the
> data to the SQL Express. If you wants to use the linked server in the
> reporting services as your data source, you need to configure to use a
> specified account to connect to the linked server.
> Hope this will be helpful!
> Sincerely,
> Wei Lu
> Microsoft Online Community Support
> ==================================================> Get notification to my posts through email? Please refer to
> http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
> ications.
> Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
> where an initial response from the community or a Microsoft Support
> Engineer within 1 business day is acceptable. Please note that each follow
> up response may take approximately 2 business days as the support
> professional working with you may need further investigation to reach the
> most efficient resolution. The offering is not appropriate for situations
> that require urgent, real-time or phone-based interactions or complex
> project analysis and dump analysis issues. Issues of this nature are best
> handled working with a dedicated Microsoft Support Engineer by contacting
> Microsoft Customer Support Services (CSS) at
> http://msdn.microsoft.com/subscriptions/support/default.aspx.
> ==================================================> (This posting is provided "AS IS", with no warranties, and confers no
> rights.)
>