rsFailedToDecryptConfigInformation unable to initialize

I am getting the following error: rsFailedToDecryptConfigInformation

Please help, When i am trying to initialize the RS.

Thank you very much..

OK, found it.

All i did is detached the deatabases both reportserver and also temp.

and then attached it back and gave permissions for the windows acct. under sql server database.

And then closed the sql manager.

opened the report server configuration utility and i see it got initialized by itself.

you can also check my previous post about initialization problem, under that i mentioned all the issues i had configuring rs via configuration utility.

sql

rsExecutionNotFound

I can preview a report I've written in VS (BIDS) without error. However, when I've deployed it to the report server, I'm unable to execute the report. I receive the following error:

Reporting Services Error

---

Execution 'ucv5xtu2x2uvhfjmjkfmfy45' cannot be found (rsExecutionNotFound)

---

SQL Server Reporting Services

The report contains a chart that RS is rendering. Does something need to be turned on or is the error unrelated to charting? In any event, I'm stumped. Any ideas would be greatly appreciated!

What are you using to view the report? The HTML viewer? What happens if you close IE and try to render it again?|||i have the same error and when i close IE and try to render it again it's work fine|||

I have the same problem when I attempt to run a report with a non-admin user, when the report has no parameters.

When the error appears on screen, I can refresh and the report loads find.

I am using Forms Authentication with my own report list and report parameters screens. I launch a report via URL. If I copy/paste the URL to a (logged in) browser window (ctrl-N from the report parameters screen) then the report runs fine. If I launch the report from my app (window.open(url)) then I get the error mentioned above.

Any ideas?

Thanks

|||

Can you please provide the URL that you are trying to launch?

These "execution not found" errors occur usually because your session has expired due to inactivity. If you are using the viewer controls, then you shouldn't see this happen in normal circumstances because it should automatically cause postbacks at intervals which are quick enough to keep your session alive. If you aren't using the viewer control, but directly rendering from the ReportServer virtual directory and specifying rc:toolbar=false, then you don't get any of the cool "keepalive" functionality because you have opted out of using the viewer control.

|||

Hi John. Thanks for the post.

Here is the URL I put together in my web form and pass to RS (I broke it out onto seperate lines here because it didn't seem to want to paste correctly):

http://[server name]/ReportServer/Pages/ReportViewer.aspx?

/Galactic%20Delivery%20Services/Chapter06/BusinessTypeDistribution

&rs:Format=HTML4.0

&rc:Parameters=true

&rc:Toolbar=true

I build a custom list of reports (ListChildren), each report name is a link to a custom report parameter form (GetReportParameters) with a dropdown list of extentions (HTML, PDF, etc). If the selected report has no parameters, I bypass the parameters form and launch the report in the same browser window. The parameter-less reports are the problem and the problem has been sporadic. Sometimes the report loads sometimes I get the rsExecutionNotFound error. I seem to have gotten around the problem for the most part by launching the report in a new browser window, now I rarely get the rsExecutionNotFound error. However, when I went to get the report URL (above) I got the rsExecutionNotFound error again. I closed the browser windows and tried again. The report ran fine. Session thing?

The thing I don't quite get is that I execute LogonUser and regenerate the cookie from each page (I pass a unique value that is an GUID used to validate the user in our own security database). Does this not refresh the RS session?

To test, I have a HTML form with a dropdown list of usernames (admin, limited, etc). Most of the time, the "admin" user will work directly after the "limited" user fails (meaning, I click the report link and the report fails: I click the report link again with "admin" selected and it works). Specifying rs:Format=PDF works EVERY time, even directly after a failure (meaning, I click the report link and the report fails: I click the report link again with PDF selected and it works). It appears that the error only occurs when I attempt to run an HTML version of the report.

The report list page and the report parameter page live on the RS server.

Again, thanks for your post. My app (which is still in prototype mode) seems to be working fairly well. I would like to be able to trap this (and other) error so the user doesn't get this nasty message. Better yet, I'd like to understand the error and be able to prevent it.

-- WALL

|||

I talked with a couple other folks here on the team, and we think what you are hitting is that the HTML for the report is being cached by IE, which is causing the session to not be appropriately handled.

You can workaround this issue by adding a parameter to the URL which will be ignored by RS, but will "uniqueify" the URL so that you don't run into the caching problems. Try appending rc:UniqueGuid=<newguid> to the url and see if that works around your problem.

-john

|||

Interesting. I'll try your suggestion as soon as I get a moment.

Thank you for the (very quick) response.

-- wall (I happened to log in to this forum as xguy this time)

|||

We are seeing the same problem in our environment. We have tried adding the GUID parameter and it reduced the frequency of the problem, but we are still seeing the reExecutionNotFound error 8-10 times per day.

Suggestions? A post in another forum suggested that this problem is fixed somewhere, but did not give any info on the solution.

Thanks.

|||

How are you accessing the server? SOAP? URL Access? Are you using the viewer control or a custom application? Are you getting this error when rendering the report, or when retrieving images?

If it is a custom application that is not using the viewer control, then you will need to ensure that your session is not timing out by periodically "touching" the session. The viewer controls do this by calling GetExecutionInfo() on the SOAP endpoint.

|||

Thanks for the reply, John. Here is my developer's response (I'm the DBA in charge of the server):
"We are using the ReportViewer control and accessing remote reports on the reporting server, therefore, I believe it is making SOAP calls. They should know. During rendering, we get the Out Of Memory error within the ReportViewer. I never call GetExecutionInfo() from the ReportViewer control, do we have any examples? When should I call the method, before assigning parameters, after, etc..."

Any guidance is welcome. The web server we are running this on is Windows 2003 Standard SP1, dual 2.8GHz Xeon processors with 2GB of RAM. It is running IIS 6.0 and Reporting Services 2005 (the ReportServer databases are on a different server). We are running web apps with both ASP.NET 1.1.4322 and 2.0.50727, obviously in separate application pools.

Thanks,
Kevin

|||

Out of memory is a different error than execution not found.

If you are using the viewer controls then you don't have to call GetExecutionInfo() yourself, the viewer control does this periodically to "ping" the server and keep your session alive all by itself.

Check Tudor's blog for some tips on improving performance:

http://blogs.msdn.com/tudortr/archive/2004/06/28/167969.aspx

The biggest thing you can do to reduce the amount of memory being used is to reduce the # of rows that your data sets are returning.

|||

Sorry for the confusion, John. We are actually seeing two different problems, one of which is the rsExecutionNotFound which doesn't seem to have any pattern, the other is the OutOfMemory exception that we are seeing on large reports.

Regarding the the rsExecutionNotFound error, after we added the GUID report parameter, we saw the frequency of the error decline, but not disappear completely. Do you have any other suggestions to resolve this?

Thanks again,
Kevin

|||

Hi Kevin. I have not put our reporting services apps into production yet (other projects have taken priority) but we have tested quite a bit and launching the reports in a new browser window seems to have made the rsExecutionNotFound error go away (knock on wood).

We use custom report listing forms and custom (selected) report parameter forms. We launch HTML forms in a new browser window and launch PDF (and other formats) in an iframe on the same form -- each method results in a new window opening.

Hope that helps.

Good luck.

|||

What if you get the rsExecutionNotFound error by just using your web browser to access the report? In this situation it was reporting services that generated the url and we have no way of adding anything to it.

Why can the report not be executed again when the expected execution is missing and the end user did not sepecifically request a particular execution?

Additionally, why is there a nasty exception in response to a "inappropriate handling" of a session? When you said "not be appropriately handled" did you mean that IE is allowing the session to time out and it should not be?

rsExecutionNotFound

I can preview a report I've written in VS (BIDS) without error. However, when I've deployed it to the report server, I'm unable to execute the report. I receive the following error:

Reporting Services Error

---

Execution 'ucv5xtu2x2uvhfjmjkfmfy45' cannot be found (rsExecutionNotFound)

---

SQL Server Reporting Services

The report contains a chart that RS is rendering. Does something need to be turned on or is the error unrelated to charting? In any event, I'm stumped. Any ideas would be greatly appreciated!

What are you using to view the report? The HTML viewer? What happens if you close IE and try to render it again?|||i have the same error and when i close IE and try to render it again it's work fine|||

I have the same problem when I attempt to run a report with a non-admin user, when the report has no parameters.

When the error appears on screen, I can refresh and the report loads find.

I am using Forms Authentication with my own report list and report parameters screens. I launch a report via URL. If I copy/paste the URL to a (logged in) browser window (ctrl-N from the report parameters screen) then the report runs fine. If I launch the report from my app (window.open(url)) then I get the error mentioned above.

Any ideas?

Thanks

|||

Can you please provide the URL that you are trying to launch?

These "execution not found" errors occur usually because your session has expired due to inactivity. If you are using the viewer controls, then you shouldn't see this happen in normal circumstances because it should automatically cause postbacks at intervals which are quick enough to keep your session alive. If you aren't using the viewer control, but directly rendering from the ReportServer virtual directory and specifying rc:toolbar=false, then you don't get any of the cool "keepalive" functionality because you have opted out of using the viewer control.

|||

Hi John. Thanks for the post.

Here is the URL I put together in my web form and pass to RS (I broke it out onto seperate lines here because it didn't seem to want to paste correctly):

http://[server name]/ReportServer/Pages/ReportViewer.aspx?

/Galactic%20Delivery%20Services/Chapter06/BusinessTypeDistribution

&rs:Format=HTML4.0

&rc:Parameters=true

&rc:Toolbar=true

I build a custom list of reports (ListChildren), each report name is a link to a custom report parameter form (GetReportParameters) with a dropdown list of extentions (HTML, PDF, etc). If the selected report has no parameters, I bypass the parameters form and launch the report in the same browser window. The parameter-less reports are the problem and the problem has been sporadic. Sometimes the report loads sometimes I get the rsExecutionNotFound error. I seem to have gotten around the problem for the most part by launching the report in a new browser window, now I rarely get the rsExecutionNotFound error. However, when I went to get the report URL (above) I got the rsExecutionNotFound error again. I closed the browser windows and tried again. The report ran fine. Session thing?

The thing I don't quite get is that I execute LogonUser and regenerate the cookie from each page (I pass a unique value that is an GUID used to validate the user in our own security database). Does this not refresh the RS session?

To test, I have a HTML form with a dropdown list of usernames (admin, limited, etc). Most of the time, the "admin" user will work directly after the "limited" user fails (meaning, I click the report link and the report fails: I click the report link again with "admin" selected and it works). Specifying rs:Format=PDF works EVERY time, even directly after a failure (meaning, I click the report link and the report fails: I click the report link again with PDF selected and it works). It appears that the error only occurs when I attempt to run an HTML version of the report.

The report list page and the report parameter page live on the RS server.

Again, thanks for your post. My app (which is still in prototype mode) seems to be working fairly well. I would like to be able to trap this (and other) error so the user doesn't get this nasty message. Better yet, I'd like to understand the error and be able to prevent it.

-- WALL

|||

I talked with a couple other folks here on the team, and we think what you are hitting is that the HTML for the report is being cached by IE, which is causing the session to not be appropriately handled.

You can workaround this issue by adding a parameter to the URL which will be ignored by RS, but will "uniqueify" the URL so that you don't run into the caching problems. Try appending rc:UniqueGuid=<newguid> to the url and see if that works around your problem.

-john

|||

Interesting. I'll try your suggestion as soon as I get a moment.

Thank you for the (very quick) response.

-- wall (I happened to log in to this forum as xguy this time)

|||

We are seeing the same problem in our environment. We have tried adding the GUID parameter and it reduced the frequency of the problem, but we are still seeing the reExecutionNotFound error 8-10 times per day.

Suggestions? A post in another forum suggested that this problem is fixed somewhere, but did not give any info on the solution.

Thanks.

|||

How are you accessing the server? SOAP? URL Access? Are you using the viewer control or a custom application? Are you getting this error when rendering the report, or when retrieving images?

If it is a custom application that is not using the viewer control, then you will need to ensure that your session is not timing out by periodically "touching" the session. The viewer controls do this by calling GetExecutionInfo() on the SOAP endpoint.

|||

Thanks for the reply, John. Here is my developer's response (I'm the DBA in charge of the server):
"We are using the ReportViewer control and accessing remote reports on the reporting server, therefore, I believe it is making SOAP calls. They should know. During rendering, we get the Out Of Memory error within the ReportViewer. I never call GetExecutionInfo() from the ReportViewer control, do we have any examples? When should I call the method, before assigning parameters, after, etc..."

Any guidance is welcome. The web server we are running this on is Windows 2003 Standard SP1, dual 2.8GHz Xeon processors with 2GB of RAM. It is running IIS 6.0 and Reporting Services 2005 (the ReportServer databases are on a different server). We are running web apps with both ASP.NET 1.1.4322 and 2.0.50727, obviously in separate application pools.

Thanks,
Kevin

|||

Out of memory is a different error than execution not found.

If you are using the viewer controls then you don't have to call GetExecutionInfo() yourself, the viewer control does this periodically to "ping" the server and keep your session alive all by itself.

Check Tudor's blog for some tips on improving performance:

http://blogs.msdn.com/tudortr/archive/2004/06/28/167969.aspx

The biggest thing you can do to reduce the amount of memory being used is to reduce the # of rows that your data sets are returning.

|||

Sorry for the confusion, John. We are actually seeing two different problems, one of which is the rsExecutionNotFound which doesn't seem to have any pattern, the other is the OutOfMemory exception that we are seeing on large reports.

Regarding the the rsExecutionNotFound error, after we added the GUID report parameter, we saw the frequency of the error decline, but not disappear completely. Do you have any other suggestions to resolve this?

Thanks again,
Kevin

|||

Hi Kevin. I have not put our reporting services apps into production yet (other projects have taken priority) but we have tested quite a bit and launching the reports in a new browser window seems to have made the rsExecutionNotFound error go away (knock on wood).

We use custom report listing forms and custom (selected) report parameter forms. We launch HTML forms in a new browser window and launch PDF (and other formats) in an iframe on the same form -- each method results in a new window opening.

Hope that helps.

Good luck.

|||

What if you get the rsExecutionNotFound error by just using your web browser to access the report? In this situation it was reporting services that generated the url and we have no way of adding anything to it.

Why can the report not be executed again when the expected execution is missing and the end user did not sepecifically request a particular execution?

Additionally, why is there a nasty exception in response to a "inappropriate handling" of a session? When you said "not be appropriately handled" did you mean that IE is allowing the session to time out and it should not be?

rsExecutionNotFound

I can preview a report I've written in VS (BIDS) without error. However, when I've deployed it to the report server, I'm unable to execute the report. I receive the following error:

Reporting Services Error

---

Execution 'ucv5xtu2x2uvhfjmjkfmfy45' cannot be found (rsExecutionNotFound)

---

SQL Server Reporting Services

The report contains a chart that RS is rendering. Does something need to be turned on or is the error unrelated to charting? In any event, I'm stumped. Any ideas would be greatly appreciated!

What are you using to view the report? The HTML viewer? What happens if you close IE and try to render it again?|||i have the same error and when i close IE and try to render it again it's work fine|||

I have the same problem when I attempt to run a report with a non-admin user, when the report has no parameters.

When the error appears on screen, I can refresh and the report loads find.

I am using Forms Authentication with my own report list and report parameters screens. I launch a report via URL. If I copy/paste the URL to a (logged in) browser window (ctrl-N from the report parameters screen) then the report runs fine. If I launch the report from my app (window.open(url)) then I get the error mentioned above.

Any ideas?

Thanks

|||

Can you please provide the URL that you are trying to launch?

These "execution not found" errors occur usually because your session has expired due to inactivity. If you are using the viewer controls, then you shouldn't see this happen in normal circumstances because it should automatically cause postbacks at intervals which are quick enough to keep your session alive. If you aren't using the viewer control, but directly rendering from the ReportServer virtual directory and specifying rc:toolbar=false, then you don't get any of the cool "keepalive" functionality because you have opted out of using the viewer control.

|||

Hi John. Thanks for the post.

Here is the URL I put together in my web form and pass to RS (I broke it out onto seperate lines here because it didn't seem to want to paste correctly):

http://[server name]/ReportServer/Pages/ReportViewer.aspx?

/Galactic%20Delivery%20Services/Chapter06/BusinessTypeDistribution

&rs:Format=HTML4.0

&rc:Parameters=true

&rc:Toolbar=true

I build a custom list of reports (ListChildren), each report name is a link to a custom report parameter form (GetReportParameters) with a dropdown list of extentions (HTML, PDF, etc). If the selected report has no parameters, I bypass the parameters form and launch the report in the same browser window. The parameter-less reports are the problem and the problem has been sporadic. Sometimes the report loads sometimes I get the rsExecutionNotFound error. I seem to have gotten around the problem for the most part by launching the report in a new browser window, now I rarely get the rsExecutionNotFound error. However, when I went to get the report URL (above) I got the rsExecutionNotFound error again. I closed the browser windows and tried again. The report ran fine. Session thing?

The thing I don't quite get is that I execute LogonUser and regenerate the cookie from each page (I pass a unique value that is an GUID used to validate the user in our own security database). Does this not refresh the RS session?

To test, I have a HTML form with a dropdown list of usernames (admin, limited, etc). Most of the time, the "admin" user will work directly after the "limited" user fails (meaning, I click the report link and the report fails: I click the report link again with "admin" selected and it works). Specifying rs:Format=PDF works EVERY time, even directly after a failure (meaning, I click the report link and the report fails: I click the report link again with PDF selected and it works). It appears that the error only occurs when I attempt to run an HTML version of the report.

The report list page and the report parameter page live on the RS server.

Again, thanks for your post. My app (which is still in prototype mode) seems to be working fairly well. I would like to be able to trap this (and other) error so the user doesn't get this nasty message. Better yet, I'd like to understand the error and be able to prevent it.

-- WALL

|||

I talked with a couple other folks here on the team, and we think what you are hitting is that the HTML for the report is being cached by IE, which is causing the session to not be appropriately handled.

You can workaround this issue by adding a parameter to the URL which will be ignored by RS, but will "uniqueify" the URL so that you don't run into the caching problems. Try appending rc:UniqueGuid=<newguid> to the url and see if that works around your problem.

-john

|||

Interesting. I'll try your suggestion as soon as I get a moment.

Thank you for the (very quick) response.

-- wall (I happened to log in to this forum as xguy this time)

|||

We are seeing the same problem in our environment. We have tried adding the GUID parameter and it reduced the frequency of the problem, but we are still seeing the reExecutionNotFound error 8-10 times per day.

Suggestions? A post in another forum suggested that this problem is fixed somewhere, but did not give any info on the solution.

Thanks.

|||

How are you accessing the server? SOAP? URL Access? Are you using the viewer control or a custom application? Are you getting this error when rendering the report, or when retrieving images?

If it is a custom application that is not using the viewer control, then you will need to ensure that your session is not timing out by periodically "touching" the session. The viewer controls do this by calling GetExecutionInfo() on the SOAP endpoint.

|||

Thanks for the reply, John. Here is my developer's response (I'm the DBA in charge of the server):
"We are using the ReportViewer control and accessing remote reports on the reporting server, therefore, I believe it is making SOAP calls. They should know. During rendering, we get the Out Of Memory error within the ReportViewer. I never call GetExecutionInfo() from the ReportViewer control, do we have any examples? When should I call the method, before assigning parameters, after, etc..."

Any guidance is welcome. The web server we are running this on is Windows 2003 Standard SP1, dual 2.8GHz Xeon processors with 2GB of RAM. It is running IIS 6.0 and Reporting Services 2005 (the ReportServer databases are on a different server). We are running web apps with both ASP.NET 1.1.4322 and 2.0.50727, obviously in separate application pools.

Thanks,
Kevin

|||

Out of memory is a different error than execution not found.

If you are using the viewer controls then you don't have to call GetExecutionInfo() yourself, the viewer control does this periodically to "ping" the server and keep your session alive all by itself.

Check Tudor's blog for some tips on improving performance:

http://blogs.msdn.com/tudortr/archive/2004/06/28/167969.aspx

The biggest thing you can do to reduce the amount of memory being used is to reduce the # of rows that your data sets are returning.

|||

Sorry for the confusion, John. We are actually seeing two different problems, one of which is the rsExecutionNotFound which doesn't seem to have any pattern, the other is the OutOfMemory exception that we are seeing on large reports.

Regarding the the rsExecutionNotFound error, after we added the GUID report parameter, we saw the frequency of the error decline, but not disappear completely. Do you have any other suggestions to resolve this?

Thanks again,
Kevin

|||

Hi Kevin. I have not put our reporting services apps into production yet (other projects have taken priority) but we have tested quite a bit and launching the reports in a new browser window seems to have made the rsExecutionNotFound error go away (knock on wood).

We use custom report listing forms and custom (selected) report parameter forms. We launch HTML forms in a new browser window and launch PDF (and other formats) in an iframe on the same form -- each method results in a new window opening.

Hope that helps.

Good luck.

|||

What if you get the rsExecutionNotFound error by just using your web browser to access the report? In this situation it was reporting services that generated the url and we have no way of adding anything to it.

Why can the report not be executed again when the expected execution is missing and the end user did not sepecifically request a particular execution?

Additionally, why is there a nasty exception in response to a "inappropriate handling" of a session? When you said "not be appropriately handled" did you mean that IE is allowing the session to time out and it should not be?

rsExecutionNotFound

I can preview a report I've written in VS (BIDS) without error. However, when I've deployed it to the report server, I'm unable to execute the report. I receive the following error:

Reporting Services Error

---

Execution 'ucv5xtu2x2uvhfjmjkfmfy45' cannot be found (rsExecutionNotFound)

---

SQL Server Reporting Services

The report contains a chart that RS is rendering. Does something need to be turned on or is the error unrelated to charting? In any event, I'm stumped. Any ideas would be greatly appreciated!

What are you using to view the report? The HTML viewer? What happens if you close IE and try to render it again?|||i have the same error and when i close IE and try to render it again it's work fine|||

I have the same problem when I attempt to run a report with a non-admin user, when the report has no parameters.

When the error appears on screen, I can refresh and the report loads find.

I am using Forms Authentication with my own report list and report parameters screens. I launch a report via URL. If I copy/paste the URL to a (logged in) browser window (ctrl-N from the report parameters screen) then the report runs fine. If I launch the report from my app (window.open(url)) then I get the error mentioned above.

Any ideas?

Thanks

|||

Can you please provide the URL that you are trying to launch?

These "execution not found" errors occur usually because your session has expired due to inactivity. If you are using the viewer controls, then you shouldn't see this happen in normal circumstances because it should automatically cause postbacks at intervals which are quick enough to keep your session alive. If you aren't using the viewer control, but directly rendering from the ReportServer virtual directory and specifying rc:toolbar=false, then you don't get any of the cool "keepalive" functionality because you have opted out of using the viewer control.

|||

Hi John. Thanks for the post.

Here is the URL I put together in my web form and pass to RS (I broke it out onto seperate lines here because it didn't seem to want to paste correctly):

http://[server name]/ReportServer/Pages/ReportViewer.aspx?

/Galactic%20Delivery%20Services/Chapter06/BusinessTypeDistribution

&rs:Format=HTML4.0

&rc:Parameters=true

&rc:Toolbar=true

I build a custom list of reports (ListChildren), each report name is a link to a custom report parameter form (GetReportParameters) with a dropdown list of extentions (HTML, PDF, etc). If the selected report has no parameters, I bypass the parameters form and launch the report in the same browser window. The parameter-less reports are the problem and the problem has been sporadic. Sometimes the report loads sometimes I get the rsExecutionNotFound error. I seem to have gotten around the problem for the most part by launching the report in a new browser window, now I rarely get the rsExecutionNotFound error. However, when I went to get the report URL (above) I got the rsExecutionNotFound error again. I closed the browser windows and tried again. The report ran fine. Session thing?

The thing I don't quite get is that I execute LogonUser and regenerate the cookie from each page (I pass a unique value that is an GUID used to validate the user in our own security database). Does this not refresh the RS session?

To test, I have a HTML form with a dropdown list of usernames (admin, limited, etc). Most of the time, the "admin" user will work directly after the "limited" user fails (meaning, I click the report link and the report fails: I click the report link again with "admin" selected and it works). Specifying rs:Format=PDF works EVERY time, even directly after a failure (meaning, I click the report link and the report fails: I click the report link again with PDF selected and it works). It appears that the error only occurs when I attempt to run an HTML version of the report.

The report list page and the report parameter page live on the RS server.

Again, thanks for your post. My app (which is still in prototype mode) seems to be working fairly well. I would like to be able to trap this (and other) error so the user doesn't get this nasty message. Better yet, I'd like to understand the error and be able to prevent it.

-- WALL

|||

I talked with a couple other folks here on the team, and we think what you are hitting is that the HTML for the report is being cached by IE, which is causing the session to not be appropriately handled.

You can workaround this issue by adding a parameter to the URL which will be ignored by RS, but will "uniqueify" the URL so that you don't run into the caching problems. Try appending rc:UniqueGuid=<newguid> to the url and see if that works around your problem.

-john

|||

Interesting. I'll try your suggestion as soon as I get a moment.

Thank you for the (very quick) response.

-- wall (I happened to log in to this forum as xguy this time)

|||

We are seeing the same problem in our environment. We have tried adding the GUID parameter and it reduced the frequency of the problem, but we are still seeing the reExecutionNotFound error 8-10 times per day.

Suggestions? A post in another forum suggested that this problem is fixed somewhere, but did not give any info on the solution.

Thanks.

|||

How are you accessing the server? SOAP? URL Access? Are you using the viewer control or a custom application? Are you getting this error when rendering the report, or when retrieving images?

If it is a custom application that is not using the viewer control, then you will need to ensure that your session is not timing out by periodically "touching" the session. The viewer controls do this by calling GetExecutionInfo() on the SOAP endpoint.

|||

Thanks for the reply, John. Here is my developer's response (I'm the DBA in charge of the server):
"We are using the ReportViewer control and accessing remote reports on the reporting server, therefore, I believe it is making SOAP calls. They should know. During rendering, we get the Out Of Memory error within the ReportViewer. I never call GetExecutionInfo() from the ReportViewer control, do we have any examples? When should I call the method, before assigning parameters, after, etc..."

Any guidance is welcome. The web server we are running this on is Windows 2003 Standard SP1, dual 2.8GHz Xeon processors with 2GB of RAM. It is running IIS 6.0 and Reporting Services 2005 (the ReportServer databases are on a different server). We are running web apps with both ASP.NET 1.1.4322 and 2.0.50727, obviously in separate application pools.

Thanks,
Kevin

|||

Out of memory is a different error than execution not found.

If you are using the viewer controls then you don't have to call GetExecutionInfo() yourself, the viewer control does this periodically to "ping" the server and keep your session alive all by itself.

Check Tudor's blog for some tips on improving performance:

http://blogs.msdn.com/tudortr/archive/2004/06/28/167969.aspx

The biggest thing you can do to reduce the amount of memory being used is to reduce the # of rows that your data sets are returning.

|||

Sorry for the confusion, John. We are actually seeing two different problems, one of which is the rsExecutionNotFound which doesn't seem to have any pattern, the other is the OutOfMemory exception that we are seeing on large reports.

Regarding the the rsExecutionNotFound error, after we added the GUID report parameter, we saw the frequency of the error decline, but not disappear completely. Do you have any other suggestions to resolve this?

Thanks again,
Kevin

|||

Hi Kevin. I have not put our reporting services apps into production yet (other projects have taken priority) but we have tested quite a bit and launching the reports in a new browser window seems to have made the rsExecutionNotFound error go away (knock on wood).

We use custom report listing forms and custom (selected) report parameter forms. We launch HTML forms in a new browser window and launch PDF (and other formats) in an iframe on the same form -- each method results in a new window opening.

Hope that helps.

Good luck.

|||

What if you get the rsExecutionNotFound error by just using your web browser to access the report? In this situation it was reporting services that generated the url and we have no way of adding anything to it.

Why can the report not be executed again when the expected execution is missing and the end user did not sepecifically request a particular execution?

Additionally, why is there a nasty exception in response to a "inappropriate handling" of a session? When you said "not be appropriately handled" did you mean that IE is allowing the session to time out and it should not be?

sql

rsExecutionNotFound

I can preview a report I've written in VS (BIDS) without error. However, when I've deployed it to the report server, I'm unable to execute the report. I receive the following error:

Reporting Services Error

---

Execution 'ucv5xtu2x2uvhfjmjkfmfy45' cannot be found (rsExecutionNotFound)

---

SQL Server Reporting Services

The report contains a chart that RS is rendering. Does something need to be turned on or is the error unrelated to charting? In any event, I'm stumped. Any ideas would be greatly appreciated!

What are you using to view the report? The HTML viewer? What happens if you close IE and try to render it again?|||i have the same error and when i close IE and try to render it again it's work fine|||

I have the same problem when I attempt to run a report with a non-admin user, when the report has no parameters.

When the error appears on screen, I can refresh and the report loads find.

I am using Forms Authentication with my own report list and report parameters screens. I launch a report via URL. If I copy/paste the URL to a (logged in) browser window (ctrl-N from the report parameters screen) then the report runs fine. If I launch the report from my app (window.open(url)) then I get the error mentioned above.

Any ideas?

Thanks

|||

Can you please provide the URL that you are trying to launch?

These "execution not found" errors occur usually because your session has expired due to inactivity. If you are using the viewer controls, then you shouldn't see this happen in normal circumstances because it should automatically cause postbacks at intervals which are quick enough to keep your session alive. If you aren't using the viewer control, but directly rendering from the ReportServer virtual directory and specifying rc:toolbar=false, then you don't get any of the cool "keepalive" functionality because you have opted out of using the viewer control.

|||

Hi John. Thanks for the post.

Here is the URL I put together in my web form and pass to RS (I broke it out onto seperate lines here because it didn't seem to want to paste correctly):

http://[server name]/ReportServer/Pages/ReportViewer.aspx?

/Galactic%20Delivery%20Services/Chapter06/BusinessTypeDistribution

&rs:Format=HTML4.0

&rc:Parameters=true

&rc:Toolbar=true

I build a custom list of reports (ListChildren), each report name is a link to a custom report parameter form (GetReportParameters) with a dropdown list of extentions (HTML, PDF, etc). If the selected report has no parameters, I bypass the parameters form and launch the report in the same browser window. The parameter-less reports are the problem and the problem has been sporadic. Sometimes the report loads sometimes I get the rsExecutionNotFound error. I seem to have gotten around the problem for the most part by launching the report in a new browser window, now I rarely get the rsExecutionNotFound error. However, when I went to get the report URL (above) I got the rsExecutionNotFound error again. I closed the browser windows and tried again. The report ran fine. Session thing?

The thing I don't quite get is that I execute LogonUser and regenerate the cookie from each page (I pass a unique value that is an GUID used to validate the user in our own security database). Does this not refresh the RS session?

To test, I have a HTML form with a dropdown list of usernames (admin, limited, etc). Most of the time, the "admin" user will work directly after the "limited" user fails (meaning, I click the report link and the report fails: I click the report link again with "admin" selected and it works). Specifying rs:Format=PDF works EVERY time, even directly after a failure (meaning, I click the report link and the report fails: I click the report link again with PDF selected and it works). It appears that the error only occurs when I attempt to run an HTML version of the report.

The report list page and the report parameter page live on the RS server.

Again, thanks for your post. My app (which is still in prototype mode) seems to be working fairly well. I would like to be able to trap this (and other) error so the user doesn't get this nasty message. Better yet, I'd like to understand the error and be able to prevent it.

-- WALL

|||

I talked with a couple other folks here on the team, and we think what you are hitting is that the HTML for the report is being cached by IE, which is causing the session to not be appropriately handled.

You can workaround this issue by adding a parameter to the URL which will be ignored by RS, but will "uniqueify" the URL so that you don't run into the caching problems. Try appending rc:UniqueGuid=<newguid> to the url and see if that works around your problem.

-john

|||

Interesting. I'll try your suggestion as soon as I get a moment.

Thank you for the (very quick) response.

-- wall (I happened to log in to this forum as xguy this time)

|||

We are seeing the same problem in our environment. We have tried adding the GUID parameter and it reduced the frequency of the problem, but we are still seeing the reExecutionNotFound error 8-10 times per day.

Suggestions? A post in another forum suggested that this problem is fixed somewhere, but did not give any info on the solution.

Thanks.

|||

How are you accessing the server? SOAP? URL Access? Are you using the viewer control or a custom application? Are you getting this error when rendering the report, or when retrieving images?

If it is a custom application that is not using the viewer control, then you will need to ensure that your session is not timing out by periodically "touching" the session. The viewer controls do this by calling GetExecutionInfo() on the SOAP endpoint.

|||

Thanks for the reply, John. Here is my developer's response (I'm the DBA in charge of the server):
"We are using the ReportViewer control and accessing remote reports on the reporting server, therefore, I believe it is making SOAP calls. They should know. During rendering, we get the Out Of Memory error within the ReportViewer. I never call GetExecutionInfo() from the ReportViewer control, do we have any examples? When should I call the method, before assigning parameters, after, etc..."

Any guidance is welcome. The web server we are running this on is Windows 2003 Standard SP1, dual 2.8GHz Xeon processors with 2GB of RAM. It is running IIS 6.0 and Reporting Services 2005 (the ReportServer databases are on a different server). We are running web apps with both ASP.NET 1.1.4322 and 2.0.50727, obviously in separate application pools.

Thanks,
Kevin

|||

Out of memory is a different error than execution not found.

If you are using the viewer controls then you don't have to call GetExecutionInfo() yourself, the viewer control does this periodically to "ping" the server and keep your session alive all by itself.

Check Tudor's blog for some tips on improving performance:

http://blogs.msdn.com/tudortr/archive/2004/06/28/167969.aspx

The biggest thing you can do to reduce the amount of memory being used is to reduce the # of rows that your data sets are returning.

|||

Sorry for the confusion, John. We are actually seeing two different problems, one of which is the rsExecutionNotFound which doesn't seem to have any pattern, the other is the OutOfMemory exception that we are seeing on large reports.

Regarding the the rsExecutionNotFound error, after we added the GUID report parameter, we saw the frequency of the error decline, but not disappear completely. Do you have any other suggestions to resolve this?

Thanks again,
Kevin

|||

Hi Kevin. I have not put our reporting services apps into production yet (other projects have taken priority) but we have tested quite a bit and launching the reports in a new browser window seems to have made the rsExecutionNotFound error go away (knock on wood).

We use custom report listing forms and custom (selected) report parameter forms. We launch HTML forms in a new browser window and launch PDF (and other formats) in an iframe on the same form -- each method results in a new window opening.

Hope that helps.

Good luck.

|||

What if you get the rsExecutionNotFound error by just using your web browser to access the report? In this situation it was reporting services that generated the url and we have no way of adding anything to it.

Why can the report not be executed again when the expected execution is missing and the end user did not sepecifically request a particular execution?

Additionally, why is there a nasty exception in response to a "inappropriate handling" of a session? When you said "not be appropriately handled" did you mean that IE is allowing the session to time out and it should not be?

rsclientprint Incompatible between SQL 2000 and 2005

I am unable to print a report from reporting services 2000 and then
from 2005. The rsclientprint file seems to not be compatible with
both. If I delete the file and allow it to reinstall, it will print
fine. But the other version will not.
Is there a rsclientprint.dll that will print both 2000 and 2005 reports
Thank you,
LonRS 2005 Coexisting with RS 2000
I have ran into trouble with printing reports from SQL RS 2005 and
2000. The RSClientPrint is a different version between 2005 and 2000.
The newer 2005 version may be compatible with the 2000, but the 2000
server is looking for its' rsclientprint.dll and throws an error when a
different version is found. I was hoping to maintain the old reports
and develop new reports in the new version. Any suggestion you have on
how to deal with this would be greatly appreciated.

rsactivate returns error, unable to activate error

Failure starting the web service:
Unexpected database error (-2147159548) 0x80004002Hi, possibly your configuration is bad, try runnig, rsconfig.exe with the
new parameters and then try with this again, in most cases this problem is
for bad configuration.
"hcas" wrote:
> Failure starting the web service:
> Unexpected database error (-2147159548) 0x80004002|||Hi, the problem is because the ASPNet is not reg over IIS, with this command
you can repair this.
c> "%windir%\Microsoft.NET\Framework\v1.0.375\aspnet_regiis.exe" -i
regsvr32 %windir%\Microsoft.NET\Framework\v1.0.3705\aspnet_isapi.dll
the aspnet_regiis.exe is a command of .net Framework
Best Regards
John Bocachica
Colombia|||HI John:
I have already tried quite a few different rsconfig.exe settings and users
with no luck. I also re-registered aspnet (I am using a higher version,
1.1.4322) and its dll. The same error occurs when I attempt to use the
rsactivate command. If I use the server name as opposed to the config file,
I get the following error.
Failure initializing remote NT Service:
Unexpected database error (-2147159548) 0x80004002
"John Bocachica" wrote:
> Hi, the problem is because the ASPNet is not reg over IIS, with this command
> you can repair this.
> c> "%windir%\Microsoft.NET\Framework\v1.0.375\aspnet_regiis.exe" -i
> regsvr32 %windir%\Microsoft.NET\Framework\v1.0.3705\aspnet_isapi.dll
> the aspnet_regiis.exe is a command of .net Framework
> Best Regards
> John Bocachica
> Colombia

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
>
>

RS.exe Script utility and Forms Authentication

We have successfully implemented Forms Authentication using Custom Security
Extension. It works fine except the RS Script Utility unable to deploy
reports either locally on the report server itself or remotely from
workstation.
I could not connect to the report server. The command I used:
rs -s http://reportservername/reportserver -i PublishReports.rss -u username
-p password
The error message: Could not connect to server:
http://reportservername/ReportServer/ReportService2005.asmx
I'm not sure how the authentication ticket works with the rs utility.
Thanks,
Dawit T.You need to retrieve and cache the cookie and pass it manually with each
request just like you would do with WinForm applications. With web-based
access, the browser does it for you. With other clients, you are on your
own.
You may find this sample useful (assuming that you use RS 2000).
http://www.prologika.com/downloads/FormsAuthTester/RsFormAuthTester.zip
--
HTH,
---
Teo Lachev, MVP, MCSD, MCT
"Microsoft Reporting Services in Action"
"Applied Microsoft Analysis Services 2005"
Home page and blog: http://www.prologika.com/
---
"Dawit T." <DawitT@.discussions.microsoft.com> wrote in message
news:2CB76DF1-3053-417B-8ED2-1A4A95B55862@.microsoft.com...
> We have successfully implemented Forms Authentication using Custom
> Security
> Extension. It works fine except the RS Script Utility unable to deploy
> reports either locally on the report server itself or remotely from
> workstation.
> I could not connect to the report server. The command I used:
> rs -s http://reportservername/reportserver -i PublishReports.rss -u
> username
> -p password
> The error message: Could not connect to server:
> http://reportservername/ReportServer/ReportService2005.asmx
> I'm not sure how the authentication ticket works with the rs utility.
> Thanks,
> Dawit T.|||Thanks. Actually, I'm using RS 2005. What change do I need to make the sample
work in RS 2005?
"Teo Lachev [MVP]" wrote:
> You need to retrieve and cache the cookie and pass it manually with each
> request just like you would do with WinForm applications. With web-based
> access, the browser does it for you. With other clients, you are on your
> own.
> You may find this sample useful (assuming that you use RS 2000).
> http://www.prologika.com/downloads/FormsAuthTester/RsFormAuthTester.zip
> --
> HTH,
> ---
> Teo Lachev, MVP, MCSD, MCT
> "Microsoft Reporting Services in Action"
> "Applied Microsoft Analysis Services 2005"
> Home page and blog: http://www.prologika.com/
> ---
> "Dawit T." <DawitT@.discussions.microsoft.com> wrote in message
> news:2CB76DF1-3053-417B-8ED2-1A4A95B55862@.microsoft.com...
> > We have successfully implemented Forms Authentication using Custom
> > Security
> > Extension. It works fine except the RS Script Utility unable to deploy
> > reports either locally on the report server itself or remotely from
> > workstation.
> >
> > I could not connect to the report server. The command I used:
> >
> > rs -s http://reportservername/reportserver -i PublishReports.rss -u
> > username
> > -p password
> >
> > The error message: Could not connect to server:
> > http://reportservername/ReportServer/ReportService2005.asmx
> >
> > I'm not sure how the authentication ticket works with the rs utility.
> >
> > Thanks,
> > Dawit T.
>
>|||Forms Authentication hasn't changed in RS 2005. However, the web service
APIs have been split into two web services -Management and Execution. I am
not sure if my sample will compile at all with RS 2005 once you dereference
the web service. Give it a try.
--
HTH,
---
Teo Lachev, MVP, MCSD, MCT
"Microsoft Reporting Services in Action"
"Applied Microsoft Analysis Services 2005"
Home page and blog: http://www.prologika.com/
---
"Dawit T." <DawitT@.discussions.microsoft.com> wrote in message
news:1C95ECDD-FDCE-4BE0-983C-C82A4C855B88@.microsoft.com...
> Thanks. Actually, I'm using RS 2005. What change do I need to make the
> sample
> work in RS 2005?
> "Teo Lachev [MVP]" wrote:
>> You need to retrieve and cache the cookie and pass it manually with each
>> request just like you would do with WinForm applications. With web-based
>> access, the browser does it for you. With other clients, you are on your
>> own.
>> You may find this sample useful (assuming that you use RS 2000).
>> http://www.prologika.com/downloads/FormsAuthTester/RsFormAuthTester.zip
>> --
>> HTH,
>> ---
>> Teo Lachev, MVP, MCSD, MCT
>> "Microsoft Reporting Services in Action"
>> "Applied Microsoft Analysis Services 2005"
>> Home page and blog: http://www.prologika.com/
>> ---
>> "Dawit T." <DawitT@.discussions.microsoft.com> wrote in message
>> news:2CB76DF1-3053-417B-8ED2-1A4A95B55862@.microsoft.com...
>> > We have successfully implemented Forms Authentication using Custom
>> > Security
>> > Extension. It works fine except the RS Script Utility unable to deploy
>> > reports either locally on the report server itself or remotely from
>> > workstation.
>> >
>> > I could not connect to the report server. The command I used:
>> >
>> > rs -s http://reportservername/reportserver -i PublishReports.rss -u
>> > username
>> > -p password
>> >
>> > The error message: Could not connect to server:
>> > http://reportservername/ReportServer/ReportService2005.asmx
>> >
>> > I'm not sure how the authentication ticket works with the rs utility.
>> >
>> > Thanks,
>> > Dawit T.
>>|||"Teo Lachev [MVP]" wrote:
> Forms Authentication hasn't changed in RS 2005. However, the web service
> APIs have been split into two web services -Management and Execution. I am
> not sure if my sample will compile at all with RS 2005 once you dereference
> the web service. Give it a try.
> --
> HTH,
> ---
> Teo Lachev, MVP, MCSD, MCT
> "Microsoft Reporting Services in Action"
> "Applied Microsoft Analysis Services 2005"
> Home page and blog: http://www.prologika.com/
> ---
> "Dawit T." <DawitT@.discussions.microsoft.com> wrote in message
> news:1C95ECDD-FDCE-4BE0-983C-C82A4C855B88@.microsoft.com...
> > Thanks. Actually, I'm using RS 2005. What change do I need to make the
> > sample
> > work in RS 2005?
> >
> > "Teo Lachev [MVP]" wrote:
> >
> >> You need to retrieve and cache the cookie and pass it manually with each
> >> request just like you would do with WinForm applications. With web-based
> >> access, the browser does it for you. With other clients, you are on your
> >> own.
> >>
> >> You may find this sample useful (assuming that you use RS 2000).
> >>
> >> http://www.prologika.com/downloads/FormsAuthTester/RsFormAuthTester.zip
> >>
> >> --
> >> HTH,
> >> ---
> >> Teo Lachev, MVP, MCSD, MCT
> >> "Microsoft Reporting Services in Action"
> >> "Applied Microsoft Analysis Services 2005"
> >> Home page and blog: http://www.prologika.com/
> >> ---
> >> "Dawit T." <DawitT@.discussions.microsoft.com> wrote in message
> >> news:2CB76DF1-3053-417B-8ED2-1A4A95B55862@.microsoft.com...
> >> > We have successfully implemented Forms Authentication using Custom
> >> > Security
> >> > Extension. It works fine except the RS Script Utility unable to deploy
> >> > reports either locally on the report server itself or remotely from
> >> > workstation.
> >> >
> >> > I could not connect to the report server. The command I used:
> >> >
> >> > rs -s http://reportservername/reportserver -i PublishReports.rss -u
> >> > username
> >> > -p password
> >> >
> >> > The error message: Could not connect to server:
> >> > http://reportservername/ReportServer/ReportService2005.asmx
> >> >
> >> > I'm not sure how the authentication ticket works with the rs utility.
> >> >
> >> > Thanks,
> >> > Dawit T.
> >>
> >>
> >>
>
>|||Thanks for your immediate response.
I could be able to run the sample in RS 2005 and converted it into VB.Net.
Now, I'm to run it as RS script. However, I've face some basic issues:
1. I think rs instance (ReportServiceProxy) is created by the RS Utility
and the script uses it by referencing what the environment provided (rs). How
can I intercept the rs call to another instance that implemented/overriden
the default GetWebRequest & GetWebResponse for the cookie management?
2. RS Utility runs code between Public Sub Main()...End Sub. Can I import
or reference the custom ReportServiceProxy? Can there be two
ReportServiceProxy instances, one created by RS Utility another by the
script? How do I make RS utility be aware of the custome proxy?
Thanks,
Dawit.
"Teo Lachev [MVP]" wrote:
> Forms Authentication hasn't changed in RS 2005. However, the web service
> APIs have been split into two web services -Management and Execution. I am
> not sure if my sample will compile at all with RS 2005 once you dereference
> the web service. Give it a try.
> --
> HTH,
> ---
> Teo Lachev, MVP, MCSD, MCT
> "Microsoft Reporting Services in Action"
> "Applied Microsoft Analysis Services 2005"
> Home page and blog: http://www.prologika.com/
> ---
> "Dawit T." <DawitT@.discussions.microsoft.com> wrote in message
> news:1C95ECDD-FDCE-4BE0-983C-C82A4C855B88@.microsoft.com...
> > Thanks. Actually, I'm using RS 2005. What change do I need to make the
> > sample
> > work in RS 2005?
> >
> > "Teo Lachev [MVP]" wrote:
> >
> >> You need to retrieve and cache the cookie and pass it manually with each
> >> request just like you would do with WinForm applications. With web-based
> >> access, the browser does it for you. With other clients, you are on your
> >> own.
> >>
> >> You may find this sample useful (assuming that you use RS 2000).
> >>
> >> http://www.prologika.com/downloads/FormsAuthTester/RsFormAuthTester.zip
> >>
> >> --
> >> HTH,
> >> ---
> >> Teo Lachev, MVP, MCSD, MCT
> >> "Microsoft Reporting Services in Action"
> >> "Applied Microsoft Analysis Services 2005"
> >> Home page and blog: http://www.prologika.com/
> >> ---
> >> "Dawit T." <DawitT@.discussions.microsoft.com> wrote in message
> >> news:2CB76DF1-3053-417B-8ED2-1A4A95B55862@.microsoft.com...
> >> > We have successfully implemented Forms Authentication using Custom
> >> > Security
> >> > Extension. It works fine except the RS Script Utility unable to deploy
> >> > reports either locally on the report server itself or remotely from
> >> > workstation.
> >> >
> >> > I could not connect to the report server. The command I used:
> >> >
> >> > rs -s http://reportservername/reportserver -i PublishReports.rss -u
> >> > username
> >> > -p password
> >> >
> >> > The error message: Could not connect to server:
> >> > http://reportservername/ReportServer/ReportService2005.asmx
> >> >
> >> > I'm not sure how the authentication ticket works with the rs utility.
> >> >
> >> > Thanks,
> >> > Dawit T.
> >>
> >>
> >>
>
>|||Yeah, this is too helpful, isn't it? You can't also create custom classes in
the rss script. Here is something you can try.
The rs variable should inherit from SoapHttpClientProtocol because it is a
web service proxy. As such, it exposes a CookieContainer property which
allows you to set or get cookies. In other words, instead of inheriting from
the proxy, see if you could manage the auth cookie directly. I haven't tried
it so it may not work.
--
HTH,
---
Teo Lachev, MVP, MCSD, MCT
"Microsoft Reporting Services in Action"
"Applied Microsoft Analysis Services 2005"
Home page and blog: http://www.prologika.com/
---
"Dawit T." <DawitT@.discussions.microsoft.com> wrote in message
news:C342EE4D-EC1B-43BB-97DB-2FC2B8949AE1@.microsoft.com...
> Thanks for your immediate response.
> I could be able to run the sample in RS 2005 and converted it into VB.Net.
> Now, I'm to run it as RS script. However, I've face some basic issues:
> 1. I think rs instance (ReportServiceProxy) is created by the RS Utility
> and the script uses it by referencing what the environment provided (rs).
> How
> can I intercept the rs call to another instance that implemented/overriden
> the default GetWebRequest & GetWebResponse for the cookie management?
> 2. RS Utility runs code between Public Sub Main()...End Sub. Can I import
> or reference the custom ReportServiceProxy? Can there be two
> ReportServiceProxy instances, one created by RS Utility another by the
> script? How do I make RS utility be aware of the custome proxy?
> Thanks,
> Dawit.
> "Teo Lachev [MVP]" wrote:
>> Forms Authentication hasn't changed in RS 2005. However, the web service
>> APIs have been split into two web services -Management and Execution. I
>> am
>> not sure if my sample will compile at all with RS 2005 once you
>> dereference
>> the web service. Give it a try.
>> --
>> HTH,
>> ---
>> Teo Lachev, MVP, MCSD, MCT
>> "Microsoft Reporting Services in Action"
>> "Applied Microsoft Analysis Services 2005"
>> Home page and blog: http://www.prologika.com/
>> ---
>> "Dawit T." <DawitT@.discussions.microsoft.com> wrote in message
>> news:1C95ECDD-FDCE-4BE0-983C-C82A4C855B88@.microsoft.com...
>> > Thanks. Actually, I'm using RS 2005. What change do I need to make the
>> > sample
>> > work in RS 2005?
>> >
>> > "Teo Lachev [MVP]" wrote:
>> >
>> >> You need to retrieve and cache the cookie and pass it manually with
>> >> each
>> >> request just like you would do with WinForm applications. With
>> >> web-based
>> >> access, the browser does it for you. With other clients, you are on
>> >> your
>> >> own.
>> >>
>> >> You may find this sample useful (assuming that you use RS 2000).
>> >>
>> >> http://www.prologika.com/downloads/FormsAuthTester/RsFormAuthTester.zip
>> >>
>> >> --
>> >> HTH,
>> >> ---
>> >> Teo Lachev, MVP, MCSD, MCT
>> >> "Microsoft Reporting Services in Action"
>> >> "Applied Microsoft Analysis Services 2005"
>> >> Home page and blog: http://www.prologika.com/
>> >> ---
>> >> "Dawit T." <DawitT@.discussions.microsoft.com> wrote in message
>> >> news:2CB76DF1-3053-417B-8ED2-1A4A95B55862@.microsoft.com...
>> >> > We have successfully implemented Forms Authentication using Custom
>> >> > Security
>> >> > Extension. It works fine except the RS Script Utility unable to
>> >> > deploy
>> >> > reports either locally on the report server itself or remotely from
>> >> > workstation.
>> >> >
>> >> > I could not connect to the report server. The command I used:
>> >> >
>> >> > rs -s http://reportservername/reportserver -i PublishReports.rss -u
>> >> > username
>> >> > -p password
>> >> >
>> >> > The error message: Could not connect to server:
>> >> > http://reportservername/ReportServer/ReportService2005.asmx
>> >> >
>> >> > I'm not sure how the authentication ticket works with the rs
>> >> > utility.
>> >> >
>> >> > Thanks,
>> >> > Dawit T.
>> >>
>> >>
>> >>
>>|||Yes, it is a very helpful sample! Thanks again.
RS variable exposes CookieContainer property. The problem is to catch the
auth cookie first time when rs utility gets authenticated by the web service
proxy.
Command line rs authentication occurs using:
rs -s http://reportservername/reportserver -i PublishReports.rss -u username
-p password
How do I also send the stored cookie with the request, eg during
rs.CreateFolder(parentFolder, "/", Nothing) operation?
Thanks,
Dawit.
"Teo Lachev [MVP]" wrote:
> Yeah, this is too helpful, isn't it? You can't also create custom classes in
> the rss script. Here is something you can try.
> The rs variable should inherit from SoapHttpClientProtocol because it is a
> web service proxy. As such, it exposes a CookieContainer property which
> allows you to set or get cookies. In other words, instead of inheriting from
> the proxy, see if you could manage the auth cookie directly. I haven't tried
> it so it may not work.
> --
> HTH,
> ---
> Teo Lachev, MVP, MCSD, MCT
> "Microsoft Reporting Services in Action"
> "Applied Microsoft Analysis Services 2005"
> Home page and blog: http://www.prologika.com/
> ---
> "Dawit T." <DawitT@.discussions.microsoft.com> wrote in message
> news:C342EE4D-EC1B-43BB-97DB-2FC2B8949AE1@.microsoft.com...
> > Thanks for your immediate response.
> >
> > I could be able to run the sample in RS 2005 and converted it into VB.Net.
> > Now, I'm to run it as RS script. However, I've face some basic issues:
> >
> > 1. I think rs instance (ReportServiceProxy) is created by the RS Utility
> > and the script uses it by referencing what the environment provided (rs).
> > How
> > can I intercept the rs call to another instance that implemented/overriden
> > the default GetWebRequest & GetWebResponse for the cookie management?
> >
> > 2. RS Utility runs code between Public Sub Main()...End Sub. Can I import
> > or reference the custom ReportServiceProxy? Can there be two
> > ReportServiceProxy instances, one created by RS Utility another by the
> > script? How do I make RS utility be aware of the custome proxy?
> >
> > Thanks,
> > Dawit.
> >
> > "Teo Lachev [MVP]" wrote:
> >
> >> Forms Authentication hasn't changed in RS 2005. However, the web service
> >> APIs have been split into two web services -Management and Execution. I
> >> am
> >> not sure if my sample will compile at all with RS 2005 once you
> >> dereference
> >> the web service. Give it a try.
> >> --
> >> HTH,
> >> ---
> >> Teo Lachev, MVP, MCSD, MCT
> >> "Microsoft Reporting Services in Action"
> >> "Applied Microsoft Analysis Services 2005"
> >> Home page and blog: http://www.prologika.com/
> >> ---
> >> "Dawit T." <DawitT@.discussions.microsoft.com> wrote in message
> >> news:1C95ECDD-FDCE-4BE0-983C-C82A4C855B88@.microsoft.com...
> >> > Thanks. Actually, I'm using RS 2005. What change do I need to make the
> >> > sample
> >> > work in RS 2005?
> >> >
> >> > "Teo Lachev [MVP]" wrote:
> >> >
> >> >> You need to retrieve and cache the cookie and pass it manually with
> >> >> each
> >> >> request just like you would do with WinForm applications. With
> >> >> web-based
> >> >> access, the browser does it for you. With other clients, you are on
> >> >> your
> >> >> own.
> >> >>
> >> >> You may find this sample useful (assuming that you use RS 2000).
> >> >>
> >> >> http://www.prologika.com/downloads/FormsAuthTester/RsFormAuthTester.zip
> >> >>
> >> >> --
> >> >> HTH,
> >> >> ---
> >> >> Teo Lachev, MVP, MCSD, MCT
> >> >> "Microsoft Reporting Services in Action"
> >> >> "Applied Microsoft Analysis Services 2005"
> >> >> Home page and blog: http://www.prologika.com/
> >> >> ---
> >> >> "Dawit T." <DawitT@.discussions.microsoft.com> wrote in message
> >> >> news:2CB76DF1-3053-417B-8ED2-1A4A95B55862@.microsoft.com...
> >> >> > We have successfully implemented Forms Authentication using Custom
> >> >> > Security
> >> >> > Extension. It works fine except the RS Script Utility unable to
> >> >> > deploy
> >> >> > reports either locally on the report server itself or remotely from
> >> >> > workstation.
> >> >> >
> >> >> > I could not connect to the report server. The command I used:
> >> >> >
> >> >> > rs -s http://reportservername/reportserver -i PublishReports.rss -u
> >> >> > username
> >> >> > -p password
> >> >> >
> >> >> > The error message: Could not connect to server:
> >> >> > http://reportservername/ReportServer/ReportService2005.asmx
> >> >> >
> >> >> > I'm not sure how the authentication ticket works with the rs
> >> >> > utility.
> >> >> >
> >> >> > Thanks,
> >> >> > Dawit T.
> >> >>
> >> >>
> >> >>
> >>
> >>
> >>
>
>|||But you have to call LogonUser API first. I would expect that after this
call the management proxy to return the cookie. Well, worst come to worse,
you can whip out your own console app (rsex.exe :-0).
--
HTH,
---
Teo Lachev, MVP, MCSD, MCT
"Microsoft Reporting Services in Action"
"Applied Microsoft Analysis Services 2005"
Home page and blog: http://www.prologika.com/
---
"Dawit T." <DawitT@.discussions.microsoft.com> wrote in message
news:46897D4A-0094-4154-8301-EA3158D5508E@.microsoft.com...
> Yes, it is a very helpful sample! Thanks again.
> RS variable exposes CookieContainer property. The problem is to catch the
> auth cookie first time when rs utility gets authenticated by the web
> service
> proxy.
> Command line rs authentication occurs using:
> rs -s http://reportservername/reportserver -i PublishReports.rss -u
> username
> -p password
> How do I also send the stored cookie with the request, eg during
> rs.CreateFolder(parentFolder, "/", Nothing) operation?
> Thanks,
> Dawit.
> "Teo Lachev [MVP]" wrote:
>> Yeah, this is too helpful, isn't it? You can't also create custom classes
>> in
>> the rss script. Here is something you can try.
>> The rs variable should inherit from SoapHttpClientProtocol because it is
>> a
>> web service proxy. As such, it exposes a CookieContainer property which
>> allows you to set or get cookies. In other words, instead of inheriting
>> from
>> the proxy, see if you could manage the auth cookie directly. I haven't
>> tried
>> it so it may not work.
>> --
>> HTH,
>> ---
>> Teo Lachev, MVP, MCSD, MCT
>> "Microsoft Reporting Services in Action"
>> "Applied Microsoft Analysis Services 2005"
>> Home page and blog: http://www.prologika.com/
>> ---
>> "Dawit T." <DawitT@.discussions.microsoft.com> wrote in message
>> news:C342EE4D-EC1B-43BB-97DB-2FC2B8949AE1@.microsoft.com...
>> > Thanks for your immediate response.
>> >
>> > I could be able to run the sample in RS 2005 and converted it into
>> > VB.Net.
>> > Now, I'm to run it as RS script. However, I've face some basic issues:
>> >
>> > 1. I think rs instance (ReportServiceProxy) is created by the RS
>> > Utility
>> > and the script uses it by referencing what the environment provided
>> > (rs).
>> > How
>> > can I intercept the rs call to another instance that
>> > implemented/overriden
>> > the default GetWebRequest & GetWebResponse for the cookie management?
>> >
>> > 2. RS Utility runs code between Public Sub Main()...End Sub. Can I
>> > import
>> > or reference the custom ReportServiceProxy? Can there be two
>> > ReportServiceProxy instances, one created by RS Utility another by the
>> > script? How do I make RS utility be aware of the custome proxy?
>> >
>> > Thanks,
>> > Dawit.
>> >
>> > "Teo Lachev [MVP]" wrote:
>> >
>> >> Forms Authentication hasn't changed in RS 2005. However, the web
>> >> service
>> >> APIs have been split into two web services -Management and Execution.
>> >> I
>> >> am
>> >> not sure if my sample will compile at all with RS 2005 once you
>> >> dereference
>> >> the web service. Give it a try.
>> >> --
>> >> HTH,
>> >> ---
>> >> Teo Lachev, MVP, MCSD, MCT
>> >> "Microsoft Reporting Services in Action"
>> >> "Applied Microsoft Analysis Services 2005"
>> >> Home page and blog: http://www.prologika.com/
>> >> ---
>> >> "Dawit T." <DawitT@.discussions.microsoft.com> wrote in message
>> >> news:1C95ECDD-FDCE-4BE0-983C-C82A4C855B88@.microsoft.com...
>> >> > Thanks. Actually, I'm using RS 2005. What change do I need to make
>> >> > the
>> >> > sample
>> >> > work in RS 2005?
>> >> >
>> >> > "Teo Lachev [MVP]" wrote:
>> >> >
>> >> >> You need to retrieve and cache the cookie and pass it manually with
>> >> >> each
>> >> >> request just like you would do with WinForm applications. With
>> >> >> web-based
>> >> >> access, the browser does it for you. With other clients, you are
>> >> >> on
>> >> >> your
>> >> >> own.
>> >> >>
>> >> >> You may find this sample useful (assuming that you use RS 2000).
>> >> >>
>> >> >> http://www.prologika.com/downloads/FormsAuthTester/RsFormAuthTester.zip
>> >> >>
>> >> >> --
>> >> >> HTH,
>> >> >> ---
>> >> >> Teo Lachev, MVP, MCSD, MCT
>> >> >> "Microsoft Reporting Services in Action"
>> >> >> "Applied Microsoft Analysis Services 2005"
>> >> >> Home page and blog: http://www.prologika.com/
>> >> >> ---
>> >> >> "Dawit T." <DawitT@.discussions.microsoft.com> wrote in message
>> >> >> news:2CB76DF1-3053-417B-8ED2-1A4A95B55862@.microsoft.com...
>> >> >> > We have successfully implemented Forms Authentication using
>> >> >> > Custom
>> >> >> > Security
>> >> >> > Extension. It works fine except the RS Script Utility unable to
>> >> >> > deploy
>> >> >> > reports either locally on the report server itself or remotely
>> >> >> > from
>> >> >> > workstation.
>> >> >> >
>> >> >> > I could not connect to the report server. The command I used:
>> >> >> >
>> >> >> > rs -s http://reportservername/reportserver -i
>> >> >> > PublishReports.rss -u
>> >> >> > username
>> >> >> > -p password
>> >> >> >
>> >> >> > The error message: Could not connect to server:
>> >> >> > http://reportservername/ReportServer/ReportService2005.asmx
>> >> >> >
>> >> >> > I'm not sure how the authentication ticket works with the rs
>> >> >> > utility.
>> >> >> >
>> >> >> > Thanks,
>> >> >> > Dawit T.
>> >> >>
>> >> >>
>> >> >>
>> >>
>> >>
>> >>
>>|||I apprecaite if Reporting Service team fix RS Scripting utility to make it
Forms Authentication aware. It looks like RS utility does not have that
feature or it is a bug.
Expecting to hear from RS team.
Thanks for all your help,
Dawit.
"Teo Lachev [MVP]" wrote:
> But you have to call LogonUser API first. I would expect that after this
> call the management proxy to return the cookie. Well, worst come to worse,
> you can whip out your own console app (rsex.exe :-0).
> --
> HTH,
> ---
> Teo Lachev, MVP, MCSD, MCT
> "Microsoft Reporting Services in Action"
> "Applied Microsoft Analysis Services 2005"
> Home page and blog: http://www.prologika.com/
> ---
> "Dawit T." <DawitT@.discussions.microsoft.com> wrote in message
> news:46897D4A-0094-4154-8301-EA3158D5508E@.microsoft.com...
> > Yes, it is a very helpful sample! Thanks again.
> >
> > RS variable exposes CookieContainer property. The problem is to catch the
> > auth cookie first time when rs utility gets authenticated by the web
> > service
> > proxy.
> >
> > Command line rs authentication occurs using:
> > rs -s http://reportservername/reportserver -i PublishReports.rss -u
> > username
> > -p password
> >
> > How do I also send the stored cookie with the request, eg during
> > rs.CreateFolder(parentFolder, "/", Nothing) operation?
> >
> > Thanks,
> > Dawit.
> >
> > "Teo Lachev [MVP]" wrote:
> >
> >> Yeah, this is too helpful, isn't it? You can't also create custom classes
> >> in
> >> the rss script. Here is something you can try.
> >>
> >> The rs variable should inherit from SoapHttpClientProtocol because it is
> >> a
> >> web service proxy. As such, it exposes a CookieContainer property which
> >> allows you to set or get cookies. In other words, instead of inheriting
> >> from
> >> the proxy, see if you could manage the auth cookie directly. I haven't
> >> tried
> >> it so it may not work.
> >> --
> >> HTH,
> >> ---
> >> Teo Lachev, MVP, MCSD, MCT
> >> "Microsoft Reporting Services in Action"
> >> "Applied Microsoft Analysis Services 2005"
> >> Home page and blog: http://www.prologika.com/
> >> ---
> >> "Dawit T." <DawitT@.discussions.microsoft.com> wrote in message
> >> news:C342EE4D-EC1B-43BB-97DB-2FC2B8949AE1@.microsoft.com...
> >> > Thanks for your immediate response.
> >> >
> >> > I could be able to run the sample in RS 2005 and converted it into
> >> > VB.Net.
> >> > Now, I'm to run it as RS script. However, I've face some basic issues:
> >> >
> >> > 1. I think rs instance (ReportServiceProxy) is created by the RS
> >> > Utility
> >> > and the script uses it by referencing what the environment provided
> >> > (rs).
> >> > How
> >> > can I intercept the rs call to another instance that
> >> > implemented/overriden
> >> > the default GetWebRequest & GetWebResponse for the cookie management?
> >> >
> >> > 2. RS Utility runs code between Public Sub Main()...End Sub. Can I
> >> > import
> >> > or reference the custom ReportServiceProxy? Can there be two
> >> > ReportServiceProxy instances, one created by RS Utility another by the
> >> > script? How do I make RS utility be aware of the custome proxy?
> >> >
> >> > Thanks,
> >> > Dawit.
> >> >
> >> > "Teo Lachev [MVP]" wrote:
> >> >
> >> >> Forms Authentication hasn't changed in RS 2005. However, the web
> >> >> service
> >> >> APIs have been split into two web services -Management and Execution.
> >> >> I
> >> >> am
> >> >> not sure if my sample will compile at all with RS 2005 once you
> >> >> dereference
> >> >> the web service. Give it a try.
> >> >> --
> >> >> HTH,
> >> >> ---
> >> >> Teo Lachev, MVP, MCSD, MCT
> >> >> "Microsoft Reporting Services in Action"
> >> >> "Applied Microsoft Analysis Services 2005"
> >> >> Home page and blog: http://www.prologika.com/
> >> >> ---
> >> >> "Dawit T." <DawitT@.discussions.microsoft.com> wrote in message
> >> >> news:1C95ECDD-FDCE-4BE0-983C-C82A4C855B88@.microsoft.com...
> >> >> > Thanks. Actually, I'm using RS 2005. What change do I need to make
> >> >> > the
> >> >> > sample
> >> >> > work in RS 2005?
> >> >> >
> >> >> > "Teo Lachev [MVP]" wrote:
> >> >> >
> >> >> >> You need to retrieve and cache the cookie and pass it manually with
> >> >> >> each
> >> >> >> request just like you would do with WinForm applications. With
> >> >> >> web-based
> >> >> >> access, the browser does it for you. With other clients, you are
> >> >> >> on
> >> >> >> your
> >> >> >> own.
> >> >> >>
> >> >> >> You may find this sample useful (assuming that you use RS 2000).
> >> >> >>
> >> >> >> http://www.prologika.com/downloads/FormsAuthTester/RsFormAuthTester.zip
> >> >> >>
> >> >> >> --
> >> >> >> HTH,
> >> >> >> ---
> >> >> >> Teo Lachev, MVP, MCSD, MCT
> >> >> >> "Microsoft Reporting Services in Action"
> >> >> >> "Applied Microsoft Analysis Services 2005"
> >> >> >> Home page and blog: http://www.prologika.com/
> >> >> >> ---
> >> >> >> "Dawit T." <DawitT@.discussions.microsoft.com> wrote in message
> >> >> >> news:2CB76DF1-3053-417B-8ED2-1A4A95B55862@.microsoft.com...
> >> >> >> > We have successfully implemented Forms Authentication using
> >> >> >> > Custom
> >> >> >> > Security
> >> >> >> > Extension. It works fine except the RS Script Utility unable to
> >> >> >> > deploy
> >> >> >> > reports either locally on the report server itself or remotely
> >> >> >> > from
> >> >> >> > workstation.
> >> >> >> >
> >> >> >> > I could not connect to the report server. The command I used:
> >> >> >> >
> >> >> >> > rs -s http://reportservername/reportserver -i
> >> >> >> > PublishReports.rss -u
> >> >> >> > username
> >> >> >> > -p password
> >> >> >> >
> >> >> >> > The error message: Could not connect to server:
> >> >> >> > http://reportservername/ReportServer/ReportService2005.asmx
> >> >> >> >
> >> >> >> > I'm not sure how the authentication ticket works with the rs
> >> >> >> > utility.
> >> >> >> >
> >> >> >> > Thanks,
> >> >> >> > Dawit T.
> >> >> >>
> >> >> >>
> >> >> >>
> >> >>
> >> >>
> >> >>
> >>
> >>
> >>
>
>

RS Scripting utility does not work with Forms Authentication

We have successfully implemented Forms Authentication using Custom Security
Extension. It works fine except the RS Script Utility unable to deploy
reports either locally on the report server itself or remotely from
workstation.
I could not connect to the report server. The command I used:
rs -s http://reportservername/reportserver -i PublishReports.rss -u username
-p password
The error message: Could not connect to server:
http://reportservername/ReportServer/ReportService2005.asmx
This occurs under SSRS 2005 & VS 2005.
Tried Solution: Is to cache and retrieve the cookie and pass it manually
with each
request just like WinForm applications. However, once the RS utility logs
in, it will be too late for any script to catch the authentication cookie,
even by calling rs.LogonUser API.
Question: It looks like RS utility does not support Forms Authentication or
it is a bug.
Would there be a fix by Reporting Service team to make RS Scripting utility
work with Forms Authentication?
Thanks for your help,
Dawit T.Unfortunately, it's a limitation of the RS utility, which has been the case
since SQL 2000.
--
Cheers,
'(' Jeff A. Stucker
\
Senior Consultant
www.rapidigm.com
"Dawit T." <DawitT@.discussions.microsoft.com> wrote in message
news:76EDBB9F-4B08-4BFF-A471-12C9CCA3A817@.microsoft.com...
> We have successfully implemented Forms Authentication using Custom
> Security
> Extension. It works fine except the RS Script Utility unable to deploy
> reports either locally on the report server itself or remotely from
> workstation.
> I could not connect to the report server. The command I used:
> rs -s http://reportservername/reportserver -i PublishReports.rss -u
> username
> -p password
> The error message: Could not connect to server:
> http://reportservername/ReportServer/ReportService2005.asmx
> This occurs under SSRS 2005 & VS 2005.
> Tried Solution: Is to cache and retrieve the cookie and pass it manually
> with each
> request just like WinForm applications. However, once the RS utility logs
> in, it will be too late for any script to catch the authentication cookie,
> even by calling rs.LogonUser API.
> Question: It looks like RS utility does not support Forms Authentication
> or
> it is a bug.
> Would there be a fix by Reporting Service team to make RS Scripting
> utility
> work with Forms Authentication?
>
> Thanks for your help,
> Dawit T.

RS Post installation problem

When RS completed installation a message was dispalyed saying that the
installation was successful, but that RS was unable to initialise.
Now whenever I try to access the http://servername/reports site, I get the
following error.
"
Compilation Error
Description: An error occurred during the compilation of a resource required
to service this request. Please review the following specific error details
and modify your source code appropriately.
Compiler Error Message: CS0016: Could not write to output file
'c:\WINNT\Microsoft.NET\Framework\v1.1.4322\Temporary ASP.NET
Files\reports\dc088531\5500274e\yip07jmq.dll' -- 'Access is denied. '
"
I think both problems are security/permissions related.
The sever is running Win2k3. I actually had it running fine previously, but
cannot replicate the successful installation on other servers or this one
upon reinstallation.
I have tried giving up to administrator rights to the ASPNET account with no
success.
Advice on resolving this issue would be greatly appreciated.I just tried a reinstall to get the warning message at the end of
installation. It reads:
"Setup has installed Microsoft SQL server 2000 Reporting Services
Successfully. Click Finish to exit.
Setup could not initialize the report server. You must manually initialize
the report server before using it for the first time. For more information,
see the Reporting Services setup documentation"
I have yet to find anything in the setup documentation, so help would be
greatly appreciated.
Thanks and regards,
Alex McKellar.
"TriggerFish" <apples@.oranges.com> wrote in message
news:4134102d@.info-mid...
> When RS completed installation a message was dispalyed saying that the
> installation was successful, but that RS was unable to initialise.
> Now whenever I try to access the http://servername/reports site, I get the
> following error.
> "
> Compilation Error
> Description: An error occurred during the compilation of a resource
required
> to service this request. Please review the following specific error
details
> and modify your source code appropriately.
> Compiler Error Message: CS0016: Could not write to output file
> 'c:\WINNT\Microsoft.NET\Framework\v1.1.4322\Temporary ASP.NET
> Files\reports\dc088531\5500274e\yip07jmq.dll' -- 'Access is denied. '
> "
> I think both problems are security/permissions related.
> The sever is running Win2k3. I actually had it running fine previously,
but
> cannot replicate the successful installation on other servers or this one
> upon reinstallation.
> I have tried giving up to administrator rights to the ASPNET account with
no
> success.
> Advice on resolving this issue would be greatly appreciated.
>|||For future reference and anyone who might read this later, I found the
problem.
The Network Service of the server on which RS in installed needs access to
the %systemroot%\temp directory. It also appeared to me that it needed
access to any "temp" directory environment variables that have been setup on
the server. I had two and once I gave access to both, all worked fine.
FYI for anyone that is interested.
Regards,
Alex.
"TriggerFish" <apples@.oranges.com> wrote in message
news:4134154c$1@.info-mid...
> I just tried a reinstall to get the warning message at the end of
> installation. It reads:
> "Setup has installed Microsoft SQL server 2000 Reporting Services
> Successfully. Click Finish to exit.
> Setup could not initialize the report server. You must manually
initialize
> the report server before using it for the first time. For more
information,
> see the Reporting Services setup documentation"
> I have yet to find anything in the setup documentation, so help would be
> greatly appreciated.
> Thanks and regards,
> Alex McKellar.
>
> "TriggerFish" <apples@.oranges.com> wrote in message
> news:4134102d@.info-mid...
> > When RS completed installation a message was dispalyed saying that the
> > installation was successful, but that RS was unable to initialise.
> >
> > Now whenever I try to access the http://servername/reports site, I get
the
> > following error.
> >
> > "
> > Compilation Error
> > Description: An error occurred during the compilation of a resource
> required
> > to service this request. Please review the following specific error
> details
> > and modify your source code appropriately.
> >
> > Compiler Error Message: CS0016: Could not write to output file
> > 'c:\WINNT\Microsoft.NET\Framework\v1.1.4322\Temporary ASP.NET
> > Files\reports\dc088531\5500274e\yip07jmq.dll' -- 'Access is denied. '
> > "
> >
> > I think both problems are security/permissions related.
> >
> > The sever is running Win2k3. I actually had it running fine previously,
> but
> > cannot replicate the successful installation on other servers or this
one
> > upon reinstallation.
> >
> > I have tried giving up to administrator rights to the ASPNET account
with
> no
> > success.
> >
> > Advice on resolving this issue would be greatly appreciated.
> >
> >
>