Showing posts with label deployment. Show all posts
Showing posts with label deployment. Show all posts

Wednesday, March 28, 2012

Report deployment without VS

Hi!
I created several reports and I want to give them to several persons for the installation on

their SQL Server 2005. Is it possible to create something like an

installation package (similar to the deployment manifest in SSIS)?
Thanks for any help!

Check out the PublishSampleReports.rss script in the C:\Program Files\Microsoft SQL Server\90\Samples\Reporting Services\Script Samples folder.

You can use it with the rs.exe tool to automatically publish an RDL definition to a server. To use it, your user will have to type a command, however.

If you *totally* want to automate deployment of reports you could do so by creating an MSI which uses a custom action: That custom action would essentially call the same commands as in the script above...It seems like a lot of work to me, though.

|||You can use Reporting Services Scripter to do this. Simply select the reports + datasource you want to distribute (and probably the folder too) and generate the scripts. You can then supply the generated scripts/rdl + batch file to them and all they have to do is change the servername and run the batchfile.|||

...and Jasper's reply reminds me that you can also now script this stuff right from SQL Managment Studio just like you could script tables, views, etc. back in 2000.

Launch SSMS, connect to your Report Server, then right-click the object you want to distribute and click Script.

Report deployment with RS2k, SP1

Hello,
I have a problem with report's deployment (SQL 2k, RS SP1). All my reports
have only hidden parameters (parameters with a prompt blank).
When I deploy from VS. NET 2003 to an empty folder on my RS server, the
prompts reappear and the checkbox "prompt user" is unchecked. That means
read only parameters and my reports return an error. The only way to correct
that is to manualy change the checkbox.
After the first deployment, each time I deploy the same reports (I replace
the existing), the checks stay but the prompt reappear. I have 15 reports
with 5-10 parameters on 3 environments (dev, qa, prod) and after each
deployment, I have to manualy remove the prompt..... I get crazy....
If someone have some experience with that problem or a workaround, don't
hesitate...
Thanks in adavance
LaurentHi,
have you tried rs.CreateReport with overwrite properties so that you can
overwrite all the parameter and report properties..
when i do upgrade i use this property to overwrite report in the script..
Bava
"Laurent" wrote:
> Hello,
> I have a problem with report's deployment (SQL 2k, RS SP1). All my reports
> have only hidden parameters (parameters with a prompt blank).
> When I deploy from VS. NET 2003 to an empty folder on my RS server, the
> prompts reappear and the checkbox "prompt user" is unchecked. That means
> read only parameters and my reports return an error. The only way to correct
> that is to manualy change the checkbox.
> After the first deployment, each time I deploy the same reports (I replace
> the existing), the checks stay but the prompt reappear. I have 15 reports
> with 5-10 parameters on 3 environments (dev, qa, prod) and after each
> deployment, I have to manualy remove the prompt..... I get crazy....
> If someone have some experience with that problem or a workaround, don't
> hesitate...
> Thanks in adavance
> Laurent
>
>sql

Report Deployment Problem on SQL 2005

Hi everyone,
I'm trying to deploy my Report Project on SQL 2005 on my machine from Visual Studio itself, but I keep getting this error:
"The Report Server Web Service is unable to access secure information in the report server. Please verify that the WebServiceAccount is specified correctly in the report server config file."
Although I specified the WebServiceAccount in the rsreportserver.config file, using an administrative account, but still facing the same problem :s.
Any idea what so ever?
ThanksI was hoping someone would reply to you on this problem. I am having a very similar problem of not being able to deploy reports to the Report Server, using the June SQL Server CTP.

When trying to deploy Company Sales.rdl or any of the other sample reports to the Report Server, from Visual Studio 2005, this error message appears (see below). Where should I start to troubleshoot the problem? Thank you.

A connection could not be made to the report server http://localhost/reportserver. (Microsoft Report Designer)

===================================

The attempt to connect to the report server failed. Check your connection information and that the report server is a compatible version. (Microsoft.ReportingServices.Designer)


Program Location:

at Microsoft.SqlServer.ReportingServices2005.RSConnection.MissingEndpointException.ThrowIfEndpointMissing(WebException e)
at Microsoft.SqlServer.ReportingServices2005.RSConnection.GetItemType(String Item)
at Microsoft.ReportDesigner.Project.ReportServiceClient.GetItemType(String item)
at Microsoft.ReportDesigner.Project.ReportServiceClient.CheckAuthorized()
at Microsoft.ReportDesigner.Project.ReportClientManager.GetCredentials(String url)
at Microsoft.ReportDesigner.Project.ReportProjectDeployer.PrepareDeploy()

===================================

The request failed with HTTP status 404: Not Found. (Microsoft.ReportingServices.Designer)


|||Hi everyone,

I managed to solve the problem at my side, this post was very helpfull:
http://forums.microsoft.com/msdn/ShowPost.aspx?PostID=58665

For my case, the easiest way was to reinstall SQL 2005 CTP again in one shot, as installing it in multiple phases caused the problem that I faced.
In addition, I had to give write authority to the (Network Services) to the ASP.NET Temporary files directory.

Hope this will be helpfull.|||I also had the same problem and it was resolved by reinstalling all components of SQL 2005 CTP in one go.|||
Solution to this problem is

1) Open Configure Report Server Tool
2) Update 'Web Service Identity' tab to reflect Asp .Net account on the machine.
For Eg. machineName\ASPNET
3) Click Apply Button, This will update WebServiceAccount tag in your report server configuration file 'rsreportserver.config'.

Hope this helps.

Thanks,

Report Deployment Problem on SQL 2005

Hi everyone,
I'm trying to deploy my Report Project on SQL 2005 on my machine from Visual Studio itself, but I keep getting this error:
"The Report Server Web Service is unable to access secure information in the report server. Please verify that the WebServiceAccount is specified correctly in the report server config file."
Although I specified the WebServiceAccount in the rsreportserver.config file, using an administrative account, but still facing the same problem :s.
Any idea what so ever?
ThanksI was hoping someone would reply to you on this problem. I am having a very similar problem of not being able to deploy reports to the Report Server, using the June SQL Server CTP.

When trying to deploy Company Sales.rdl or any of the other sample reports to the Report Server, from Visual Studio 2005, this error message appears (see below). Where should I start to troubleshoot the problem? Thank you.

A connection could not be made to the report server http://localhost/reportserver. (Microsoft Report Designer)

===================================

The attempt to connect to the report server failed. Check your connection information and that the report server is a compatible version. (Microsoft.ReportingServices.Designer)


Program Location:

at Microsoft.SqlServer.ReportingServices2005.RSConnection.MissingEndpointException.ThrowIfEndpointMissing(WebException e)
at Microsoft.SqlServer.ReportingServices2005.RSConnection.GetItemType(String Item)
at Microsoft.ReportDesigner.Project.ReportServiceClient.GetItemType(String item)
at Microsoft.ReportDesigner.Project.ReportServiceClient.CheckAuthorized()
at Microsoft.ReportDesigner.Project.ReportClientManager.GetCredentials(String url)
at Microsoft.ReportDesigner.Project.ReportProjectDeployer.PrepareDeploy()

===================================

The request failed with HTTP status 404: Not Found. (Microsoft.ReportingServices.Designer)


|||Hi everyone,

I managed to solve the problem at my side, this post was very helpfull:
http://forums.microsoft.com/msdn/ShowPost.aspx?PostID=58665

For my case, the easiest way was to reinstall SQL 2005 CTP again in one shot, as installing it in multiple phases caused the problem that I faced.
In addition, I had to give write authority to the (Network Services) to the ASP.NET Temporary files directory.

Hope this will be helpfull.|||I also had the same problem and it was resolved by reinstalling all components of SQL 2005 CTP in one go.|||
Solution to this problem is

1) Open Configure Report Server Tool
2) Update 'Web Service Identity' tab to reflect Asp .Net account on the machine.
For Eg. machineName\ASPNET
3) Click Apply Button, This will update WebServiceAccount tag in your report server configuration file 'rsreportserver.config'.

Hope this helps.

Thanks,

Monday, March 26, 2012

Report Deployment Problem

* Running SQL Server 2005 Enterprise on XP Pro *
After dealing with and solving some problems with the local ASPNET user and
it's rights to the report server config file and the database server I ran
into a report deployment problem:
I can preview the report in Developer Studio, but when I try to deploy it,
the operation ends with an error. The error indicates that the deployment
process is trying to use the guest IIS account to perform the operation...
Error 1 The permissions granted to user 'EDN-SCOTTT\IUSR_EDN-SCOTTT' are
insufficient for performing this operation. 0 0
1. Why is it trying to do a deployment using this account?
2. Where do I correct this problem by supplying the correct account
information?
Thank you,
ScottOn the report server, make sure that your Reportserver web site Anonymous
Access disabled, and Authentication Access set to Integrated WIndows
Authentication.
In Internet Explorer on your computer, put the Report server web site in
Trusted Sites, and turn on "Always prompt for username and password" under
the security settings.
Then make sure that your account is allowed to view and add reports to the
server, by going to the report server URL and try to log in and generally do
stuff. (If you get the Upload file-button, you should be allowed to add
reports.)
Try deploying the report again.
Kaisa M. Lindahl
"ScottT" <ScottT@.discussions.microsoft.com> wrote in message
news:C4B0237D-79CB-4585-9B2C-DA7ED256AF50@.microsoft.com...
>* Running SQL Server 2005 Enterprise on XP Pro *
> After dealing with and solving some problems with the local ASPNET user
> and
> it's rights to the report server config file and the database server I ran
> into a report deployment problem:
> I can preview the report in Developer Studio, but when I try to deploy it,
> the operation ends with an error. The error indicates that the deployment
> process is trying to use the guest IIS account to perform the operation...
> Error 1 The permissions granted to user 'EDN-SCOTTT\IUSR_EDN-SCOTTT' are
> insufficient for performing this operation. 0 0
> 1. Why is it trying to do a deployment using this account?
> 2. Where do I correct this problem by supplying the correct account
> information?
> Thank you,
> Scott
>

Report Deployment Error:

Hi while deploying the reports to the server I get the following error.
Server did not recognize the value of HTTP Header SOAPAction:
http://schemas.microsoft.com/sqlserver/reporting/2003/10/reportingservices/ListSecureMethods.
Could anyone help me to overcome this?
Please mention if any configuration changes are to be made.
Thanks.Looks like a version mismatch between your client (VS.NET) and your
server... open http://<servername>/reportserver and in VS.NET open Help |
About Microsoft Development Environment and select "Microsoft SQL Server
Report Designer"... compare the version numbers
--
Douglas McDowell douglas@.nospam.solidqualitylearning.com
"Thyagu" <Thyagu@.discussions.microsoft.com> wrote in message
news:A10C3285-CAB6-4A19-93A3-6DD7365F49B7@.microsoft.com...
> Hi while deploying the reports to the server I get the following error.
> Server did not recognize the value of HTTP Header SOAPAction:
> http://schemas.microsoft.com/sqlserver/reporting/2003/10/reportingservices/ListSecureMethods.
> Could anyone help me to overcome this?
> Please mention if any configuration changes are to be made.
> Thanks.|||Douglas,
Thanks very much. The problem got solved once I upgraded the package to a
newer version.
Regards,
Thyagu
"Douglas McDowell" wrote:
> Looks like a version mismatch between your client (VS.NET) and your
> server... open http://<servername>/reportserver and in VS.NET open Help |
> About Microsoft Development Environment and select "Microsoft SQL Server
> Report Designer"... compare the version numbers
> --
> Douglas McDowell douglas@.nospam.solidqualitylearning.com
>
> "Thyagu" <Thyagu@.discussions.microsoft.com> wrote in message
> news:A10C3285-CAB6-4A19-93A3-6DD7365F49B7@.microsoft.com...
> > Hi while deploying the reports to the server I get the following error.
> >
> > Server did not recognize the value of HTTP Header SOAPAction:
> > http://schemas.microsoft.com/sqlserver/reporting/2003/10/reportingservices/ListSecureMethods.
> >
> > Could anyone help me to overcome this?
> > Please mention if any configuration changes are to be made.
> >
> > Thanks.
>
>

Report Deployment Error on --http://localhost/reportserver

I am getting the following ERROR!! below when I try to DEPLOY my report. The output generated from - Debug --> Start
-- Deploy started: Project: Report Project1, Configuration: DebugLocal --
Deploying to http://localhost/reportserver/?%2fReport+Project1
Error rsReportServerDatabaseUnavailable : The report server cannot opena connection to the report server database. A connection to thedatabase is required for all requests and processing.
Deploy complete -- 1 errors, 0 warnings
=====================================================

When I try to go tohttp://<server>/reportserver a PROMT window pop up "Enter username and password for "" at http://localhost. Atthis point I'm pretty desperate to get it to work., I have been tryingfor couple of days. I reinstalled reporting services couple of timeswith no success. Any help would be greatly appreciated. Thanks!

-lalon

Hi it sounds to me the AspNet user or the user used in your dataset don't have access to your SRS database( "ReportServer" DB) . Check the permissions of the SQL Reporting Services database. Also you can't deploy to a server not running the SRS Server, unless you are on a SQL reporting server as localhost . I assume you clicked 'play' in VS.Net ? You need to deploy to a SRS Server.

Report deployment error in SharePoint Integration mode

Hi,

I get the following error when I am trying to deploy Report from Visual Studio Report Designer.

SRSS is configured in SharePoint integration mode. Configuration is mentioned below.

TITLE: Microsoft Report Designer

A connection could not be made to the report server http://rbddspsdev2:44887/.

ADDITIONAL INFORMATION:

Server was unable to process request. > The request failed with HTTP status 401: Unauthorized. (System.Web.Services)

BUTTONS:

OK

Configuration is as follows.

Web front end server.

MOSS 2007 Standard edition 64 bit.

SQL Reporting Service Add in 64 bit.

SQL Server

MS SQL server 2005 32 bit with sp2.

Reporting Services configured.

WSS 3.0 32 bit required for configuration, of SRSS in integrated mode.

Windows service and web service are both running under a domain account. The account is a SharePoint Admininstrator. The account is also in Administrators, Reporting Server user and Web service group and also has a dbo rights on database.

Hi

To publish a report to a SharePoint site configured for SharePoint integration, you must verify that the report project properties in Report Designer point to the SharePoint site. All references to servers, reports, shared data sources, and resources must be fully qualified URLs. The TargetServerURL property must be a URL to a SharePoint site. The TargetDataSourceFolder and TargetReportFolder properties must be URLs to a SharePoint library or library folder. You must have Member or Owner permission on the SharePoint site to set the properties on the project.

To publish a report to a SharePoint site

1. In SQL Server Development Studio, open an existing or new Report Server project.

2. From the Project menu, click Properties. The <project> Property Pages dialog box opens.

3. Choose the Configuration you use to publish to a SharePoint site. For example, Active(Debug) or Production.

4. In the Deployment section, for the optional TargetDataSourceFolder, type a URL to a library or library folder. For example, http://TestServer/TestSite/Documents/DataSources.

5. For TargetReportFolder, type a fully qualified URL to a library or library folder. For example, http://TestServer/TestSite/Documents.

6. For TargetServerURL, type a URL to a SharePoint top-level site or sub-site. If you do not specify a site, the default top-level site is used. For example, http://servername, http://servername/site or http://servername/site/subsite..

7. Click OK.

8. In Solution Explorer, right-click on the report you want to publish, and click Deploy. The report is published to the location specified in TargetReportFolder.

|||

Please post back if you have resolved this issue, as I have the same issue.

I have SQL 2005 sp2 as a seperate server from my sharepoint server. I was running reports in native mode and converted to integrated. I am using domain accounts for windows and web services. I have all green checks in reports configuration. If I browse to http://sqlserver/reportserver/ I get the following error:

The report server has encountered a configuration error. See the report server log files for more information. (rsServerConfigurationError) Get Online Help

I don't see anything in the log - but would be happy to post entries if someone can spot my error in them.

From VS 2005 when I attempt to upload a report, I get "a connection could not be made to the report server Get Online Help

I don't see anything in the log - but would be happy to post entries if someone can spot my error in them.

From VS 2005 when I attempt to upload a report, I get "a connection could not be made to the report server https://sharepointserver/

In Sharepoint configuration, when I attempt to set server defaults I get: "

An unexpected error occurred while connecting to the report server. Verify that the report server is available and configured for SharePoint integrated mode. --> Server was unable to process request. > The request failed with HTTP status 401: Unauthorized.

Troubleshoot issues with Windows SharePoint Services. "

I would really love to get this working.

|||I get the same error in the same place.

|||

Please check rs_log# file in ...:\Documents and Settings\[USER]\Local Settings\Temp

It should contain more details about your problem.

Are you using "Windows Integrated" or "Trusted Accounts" Authentication Mode?

|||

Hi all,

My issue i guess was because of the double hop between my Reporting Server and SharePoint server. Anyways now i have Reporting Server and MOSS both on same machine and the problem seem to go away on its own.

Hope this helps other too.

Thanks,

|||Anyone an answer to this? I've seen many blogs w/ this issue but no answers.

Report deployment connection error

Hi,

I'm using the reports designer in Visual Studio 2005 Professional and have successfully been deploying reports to my client's server for several months. Now I can't deploy any reports, when I try Visual Studio almost hangs, tries for about 5 minutes to deploy a single report and then fails with an error message:

TITLE: Microsoft Report Designer

A connection could not be made to the report server http://winserver/ReportServer.


ADDITIONAL INFORMATION:

The operation has timed out (System.Web.Services)


BUTTONS:

OK

It used to ask me for username/password for the server (credentials), now it doesn't do that. I can go to the reports server and reports interface pages in my browser OK. The reports build without any errors.

Has anyone experienced this? Any ideas on how to get it working again?

Regards,

Greg

Check for your IE settings. I think that must have changed.

In the client machine, IE Options -> Connection -> LAN settings that - check if both these 2
options were checked/enabled -
1. Automatically detect settings
2. Use Automatic Configuration Script
The option #2 was causing HTTP request from VS go through the proxy server and
passing anonymous request (401)

Or any other Security settings from a machine where deployment works fine.


|||

Hi,

Thanks for your response. I checked the settings in IE and all LAN Settings options are unchecked. Is this correct?

I am connecting through a VPN so that might be causing a problem (all options unchecked for VPN connection settings in IE). I will try directly connecting to the client's LAN and see if it works.

Regards,

Greg

Report deployment connection error

Hi,

I'm using the reports designer in Visual Studio 2005 Professional and have successfully been deploying reports to my client's server for several months. Now I can't deploy any reports, when I try Visual Studio almost hangs, tries for about 5 minutes to deploy a single report and then fails with an error message:

TITLE: Microsoft Report Designer

A connection could not be made to the report server http://winserver/ReportServer.


ADDITIONAL INFORMATION:

The operation has timed out (System.Web.Services)


BUTTONS:

OK

It used to ask me for username/password for the server (credentials), now it doesn't do that. I can go to the reports server and reports interface pages in my browser OK. The reports build without any errors.

Has anyone experienced this? Any ideas on how to get it working again?

Regards,

Greg

Check for your IE settings. I think that must have changed.

In the client machine, IE Options -> Connection -> LAN settings that - check if both these 2
options were checked/enabled -
1. Automatically detect settings
2. Use Automatic Configuration Script
The option #2 was causing HTTP request from VS go through the proxy server and
passing anonymous request (401)

Or any other Security settings from a machine where deployment works fine.


|||

Hi,

Thanks for your response. I checked the settings in IE and all LAN Settings options are unchecked. Is this correct?

I am connecting through a VPN so that might be causing a problem (all options unchecked for VPN connection settings in IE). I will try directly connecting to the client's LAN and see if it works.

Regards,

Greg

sql

Report deployment

Hello,

I have two questions:

  1. When I debug my application it seems it deploys reports to report manager, how can I prevent that from happening, I would like to deploy when I chose deploy command only?
  2. I have a report which has many sub-report, when I deploy sub-reports are deployed to report manager to and they become visible in the report manager screen., so user my chose and try to run them, I would like to make only my main report be visible on the report manager, is there anyway to accomplish this?

Thanks,

Disable the deploy of your project in the configuration for the solution in debug mode.

Report Deployment

We have a "Change Management" Dept that MUST deploy all reports into
Production. I have the same ability from my machine and I can deploy the
solution (or each individual project) without problems (but they don't like
it since I am just a developer).
When CM deploys (they take my solution file and hit "Deploy") the
credentials to all of the data sources is removed so that we have to go into
Report Viewer and add back in the credentials.
So basically, why do I NOT have any problems deploying the solution and data
sources (credentials = a service account), yet CM takes a copy of my solution
and they cannot deploy the data sources with credentials?
Any thoughs appreciated.It is how it is configured in VS. They have it to overwrite data sources and
you do not. They should not be configured this way and they can change it.
Right mouse click on each project, properties, set the overwritedatasources
property to false (if you look for yours it is set to false). That is the
default so they must have changed it.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Rob" <Rob@.discussions.microsoft.com> wrote in message
news:42674178-04C7-444B-B010-DFB59FD59373@.microsoft.com...
> We have a "Change Management" Dept that MUST deploy all reports into
> Production. I have the same ability from my machine and I can deploy the
> solution (or each individual project) without problems (but they don't
> like
> it since I am just a developer).
> When CM deploys (they take my solution file and hit "Deploy") the
> credentials to all of the data sources is removed so that we have to go
> into
> Report Viewer and add back in the credentials.
> So basically, why do I NOT have any problems deploying the solution and
> data
> sources (credentials = a service account), yet CM takes a copy of my
> solution
> and they cannot deploy the data sources with credentials?
> Any thoughs appreciated.

Report Deployment

Hi,
Two Things:
1a) I was wondering if there is the odd issue with redeploying a report in
that some changes do not seem to be propagated. For instance, In one case I
set default parameter values for a report - this would cause the report to
automatically execute when browsing to it - I did not want this behaviour so
I removed the default values and redeployed the report. The defaults were
still there when refreshing the browser window - (even with closing and
reopening the browser the paramter values have not been removed).
1b) As an aside, can you turn this behaviour off so the report does not run
automatically if all parameters are preset?
2) Consequently, to ensure the report definition gets fully updated, I
remove the report and redeploy. A side-effect of this is all the
subscriptions are removed - and rightly so. However, the datasources for
the subscription remain. Is there any reason why this is?
thanks
regards
Matt1a) Server properties will always win when the rdl is republished. Because
the original RDL had defaults the server extracted this and stores them.
When a new RDL is uploaded we do not update the server parameters.
1b) No, you can not turn of this behavior.
2) Are the data sources shared? If so then they don't belong to the report
so they will not be deleted. If they are not shared, how are you still
seeing them?
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"Matt" <NoSpam:Matthew.Moran@.Computercorp.com.au> wrote in message
news:ewy2iFoeEHA.644@.tk2msftngp13.phx.gbl...
> Hi,
> Two Things:
> 1a) I was wondering if there is the odd issue with redeploying a report in
> that some changes do not seem to be propagated. For instance, In one case
I
> set default parameter values for a report - this would cause the report to
> automatically execute when browsing to it - I did not want this behaviour
so
> I removed the default values and redeployed the report. The defaults were
> still there when refreshing the browser window - (even with closing and
> reopening the browser the paramter values have not been removed).
> 1b) As an aside, can you turn this behaviour off so the report does not
run
> automatically if all parameters are preset?
> 2) Consequently, to ensure the report definition gets fully updated, I
> remove the report and redeploy. A side-effect of this is all the
> subscriptions are removed - and rightly so. However, the datasources for
> the subscription remain. Is there any reason why this is?
> thanks
> regards
> Matt
>
>

Friday, March 23, 2012

Report Catalog Database

Hi All,

In a scale out deployment, which component sends the query to the database, the report catalog or the Report Manager?

Report Manager is just a report portal. Running a report in report manager will send a request to the RS scale out deployment. If you are using a load balancer, it will send the request to one of the server nodes in the scale out deployments. This server node (a RS web service) will then execute the report which includes running queries, retrieving data, processing data, and rendering the result and sending it back to the client (which is report manager in this case).

-- Robert

Wednesday, March 7, 2012

Report Automation

hi

i have created a rss script for report deployment which i working pretty good but icheckout my all reports on report server and from another machine i mapped that drive from command line and run rss script then i got following error

================================================================

:\Automation>rs -i PromotionAutomation.rss -s http://fsaleem/reportserver -v en
v=Dev -v DBServer=fsaleem

Unhandled Exception: System.TypeInitializationException: The type initializer fo
r "Microsoft.ReportingServices.ScriptHost.ScriptHost" threw an exception. > S
ystem.Security.SecurityException: Request for the permission of type System.Secu
rity.Permissions.FileIOPermission, mscorlib, Version=1.0.5000.0, Culture=neutral
, PublicKeyToken=b77a5c561934e089 failed.
at System.Security.CodeAccessSecurityEngine.CheckHelper(PermissionSet granted
Set, PermissionSet deniedSet, CodeAccessPermission demand, PermissionToken permT
oken)
at System.Security.CodeAccessSecurityEngine.Check(PermissionToken permToken,
CodeAccessPermission demand, StackCrawlMark& stackMark, Int32 checkFrames, Int32
unrestrictedOverride)
at System.Security.CodeAccessSecurityEngine.Check(CodeAccessPermission cap, S
tackCrawlMark& stackMark)
at System.Security.CodeAccessPermission.Demand()
at System.Reflection.Assembly.VerifyCodeBaseDiscovery(String codeBase)
at System.Reflection.Assembly.GetName(Boolean copiedName)
at System.Reflection.Assembly.GetName()
at Microsoft.ReportingServices.ScriptHost.ScriptHost..cctor()

The state of the failed permission was:
<IPermission class="System.Security.Permissions.FileIOPermission, mscorlib, Vers
ion=1.0.5000.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"
version="1"
PathDiscovery="Z:\Automation\RS.exe"/>

End of inner exception stack trace
at Microsoft.ReportingServices.ScriptHost.ScriptHost.Main(String[] args)

================================================================

I think what's happening here is that the CAS security in .NET reduces the security privileges because you mapped the drive. If you add the mapped location to the trusted sites in IE does it work? It should work if you copy the files locally.