Tracking Forums, Newsgroups, Maling Lists
Home Scripts Tutorials Tracker Forums
  Advanced Search
  HOME    TRACKER    MS SQL Server






SuperbHosting.net & Arvixe.com have generously sponsored dedicated servers and web hosting to ensure a reliable and scalable dedicated hosting solution for BigResource.com.







Deploying To Report Manager Error


I have created a report using SSRS 2005.  It uses a stored procedure.  It executes beautifully when I'm in reporting services.  But, when I deploy it to Report Manager, this is the error I am getting.


An error has occurred during report processing.
Query execution failed for data set 'DataSource1'.
An MDX Statement was expected. An MDX expression was specified.

I have 3 parameters in this report.  Start Date, End Date & Region.  Region is a drop down that contains 2 options. This is a string field being passed into the procedure.  Start and end dates are just basic date fields. 

I am not using a cube to get my data.

I have deployed to the Report Manager before and have been successful.

 

Thanks!


View Complete Forum Thread with Replies
Sponsored Links:

Related Messages:
Reporting Services Keeping Format When Deploying To The Report Manager
Hi,

I am trying to place text boxes in the header of a matrix in order to give each row group(i.e.  each drill-down area in my matrix a header). This can be done in Reporting Services 2005.

However when I deploy this report to the corresponding url(Report Manager) it seems to be losing its formatting and not displaying correctly.  The textboxes placed in the matrix header seem to go all over the place.

I do get a warning when I deploy the report ->

 [rsOverlappingReportItems]. Some renderers do not support overlapping report items.

How can this be rectified?

View Replies !   View Related
Deploying A Report Services Application To The Local Host; Error:A Connection Could Not Be Made To The Report Server
 I installed SQL reporting services 2005 and  successfully configured reporting services.After designing the report using Bussiness Intelligence Studio, i tried to deploy my reporting services application to the localhost , I got the below mentioned error :  

TITLE: Microsoft Report Designer
------------------------------

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

------------------------------
ADDITIONAL INFORMATION:

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)

------------------------------

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

 Can anybody provide a solution for this issue....

Thanks in advance

Nirupa

View Replies !   View Related
Report Definition Error When Deploying Report To RS 2000 In VS .NET 2003
Using MS SQL 200 SP4 with Reporting Services 2000 SP2 on Win 2003 Server SP1

Visual Studio .NET 2003 on different PC (Win XP SP2)

No problem creating reports or building solutions.
Problems develop when deploying report to Report Server.

Here is the Output:

------ Build started: Project: From CD, Configuration: Debug ------

Build complete -- 0 errors, 0 warnings



------ Deploy started: Project: From CD, Configuration: Debug ------

Deploying to http://<server name>/ReportServer?%2f2nd
Deploying data source '/2nd/AdventureWorks2000'.
Deploying report 'Vendor Purchase Orders'.
The report definition is not valid.  Details: Could not find schema
information for the element
'http://schemas.microsoft.com/sqlserver/reporting/2003/10/reportdefinition:Report'.
Deploy complete -- 1 errors, 0 warnings



---------------------- Done ----------------------

    Build: 1 succeeded, 0 failed, 0 skipped
    Deploy: 0 succeeded, 1 failed, 0 skipped

These are my first attempts using report services. In a previous deployment
attempts it created the folder (named 2nd), but in another attempt (saving it
to the existing folder) I got the same result as you see above (I have also
tried with a new folder but no luck). This above output is from my last
attempt.

The Build error Task List states:

The Report Definition is not valid. Details: Could not find schema
information for the element
'http://schemas.microsoft.com/sqlserver/reporting/2003/10/reportdefinition:report'.

The shema URL as above returns HTTP 404.
If I remove :report, I receive the page for Report Definition Language
Schema May 2004

Looking at the .rdl code the schema URL is as above without :report.

As you can imagine with a limited skill set in this area I am quite
confused. I have been doing alot of research but found nothing to help (or
that I understand will help) so far.

If anyone can help me get through this I would appreciate it.

Bill

View Replies !   View Related
Error When Deploying A Report
I hope someone can help.  I'm new to reporting services 2005, and I'm currently going through Microsoft's tutorial.

 

I can build a report no problem.  But when it comes to deploying the report to a web page, the following message appears:

 

------ Build started: Project: Reporting Services Tutorial, Configuration: Production ------
Build complete -- 0 errors, 0 warnings
------ Deploy started: Project: Reporting Services Tutorial, Configuration: Production ------
Deploying to http://localhost/reportserver
Error  : Response is not well-formed XML.
Deploy complete -- 1 errors, 0 warnings
========== Build: 1 succeeded or up-to-date, 0 failed, 0 skipped ==========
========== Deploy: 0 succeeded, 1 failed, 0 skipped ==========

 

This "reponse is not well-formed XML" error also occurs when I try to expand any of the folders from a "reporting services" server type in management studio.

 

Any ideas would be greatly appreciated!

 

Cheers

 

Richard Powell

 

View Replies !   View Related
Error Deploying Report Model
I'm trying to deploy a report model and I keep getting an error. The
error is the following: "The Permissions Granted to user xxx are insufficient
for performing this operation". I'm new to this world and need someone to give me very simple instructions on how to fix this. Do I fix this in "Control Panel" or right within SQL. Please help.
thx

View Replies !   View Related
Error Deploying Report Model
I am trying to follow the step by step here

http://msdn2.microsoft.com/en-us/library/ms167048.aspx

to deploy a report model for the adventureworks DB. I get to the last step which is to right click the project and click deploy and I get these two errors.

 

Error 1 The underlying connection was closed: Could not establish trust relationship for the SSL/TLS secure channel. c:documents and settingscharles.zackmy documentssql server management studioprojectsadvworksmodeltutorialadvworksmodeltutorialAdvWorksModelTutorial.ds 0 0 


Error 2 The operation you are attempting requires a secure connection (HTTPS). c:documents and settingscharles.zackmy documentssql server management studioprojectsadvworksmodeltutorialadvworksmodeltutorialAdvWorksModelTutorial.smdl 0 0 


Any suggestions are greatly appreciated.

 

Chuck

View Replies !   View Related
Error Deploying Report With DataSource SSIS
 

Hello Everyone,
 
I make a report to consume a SSIS package, actually I use SSIS to load a datasheet on my Sql Server database, then i expose the aggregate values in a datareader destination. Every work fine in Visual Studio.  But when i deploy my report and my Shared Data Source,  and I try to run the report i get the next message:

An error has occurred during report processing.

No se puede crear una conexión al origen de datos 'ETLSource'.

The package failed to validate.
 I dont Understand why, because when i work in BIDS the work perfect,  Actually i'm using sql server authentication in my package connection to avoid the mistakes about report credentials.
 
That is the code of the ETLSource.
<?xml version="1.0" encoding="utf-8"?>
<RptDataSource xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">
  <Name>ETLSource</Name>
  <DataSourceID>c238d65d-a0f3-48da-ae23-323d6ba13bb0</DataSourceID>
  <ConnectionProperties>
    <Extension>SSIS</Extension>
    <ConnectString>-f "C:TempValidaCambioEfec.dtsx"</ConnectString>
  </ConnectionProperties>
</RptDataSource>
 
Also I have SSIS and SSRS in the same machine.  And I'm using the same domain Account to run SSIS, SSRS and Reports site.
 
 
Thank you for help me
 
 
Julian Castiblanco P
Bogotá, Colombia
 

View Replies !   View Related
Error When Deploying Report Builder Model
I get the following error when I try to deploy a report builder model. The SQL Server 2005 "Reporting Services" are installed and running on the local machine. 

TITLE: Microsoft Semantic Model Designer
------------------------------

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

------------------------------
ADDITIONAL INFORMATION:

Client found response content type of 'text/html; charset=utf-8', but expected 'text/xml'.
The request failed with the error message:
--
<html>
    <head>
        <title>
            SQL Server Reporting Services
        </title><meta name="Generator" content="Microsoft SQL Server Reporting Services 9.00.2047.00" />
<meta name="HTTP Status" content="500" />
<meta name="ProductLocaleID" content="9" />
<meta name="CountryLocaleID" content="1033" />
<meta name="StackTrace" content="   at Microsoft.ReportingServices.Diagnostics.RSConfiguration.Load()
   at Microsoft.ReportingServices.Diagnostics.RSConfiguration.Construct(String configFileName)
   at Microsoft.ReportingServices.Diagnostics.RSConfiguration..ctor(String configFileName, String location)
   at Microsoft.ReportingServices.Diagnostics.RSConfigurationManager..ctor(String configFileName, String configLocation)
   at Microsoft.ReportingServices.Library.Global.get_ConfigurationManager()
   at Microsoft.ReportingServices.WebServer.Global.StartApp()
   at Microsoft.ReportingServices.WebServer.Global.Application_BeginRequest(Object sender, EventArgs e)" />
<style>
            BODY {FONT-FAMILY:Verdana; FONT-WEIGHT:normal; FONT-SIZE: 8pt; COLOR:black}
            H1 {FONT-FAMILY:Verdana; FONT-WEIGHT:700; FONT-SIZE:15pt}
            LI {FONT-FAMILY:Verdana; FONT-WEIGHT:normal; FONT-SIZE:8pt; DISPLAY:inline}
            .ProductInfo {FONT-FAMILY:Verdana; FONT-WEIGHT:bold; FONT-SIZE: 8pt; COLOR:gray}
            A:link {FONT-SIZE: 8pt; FONT-FAMILY:Verdana; COLOR:#3366CC; TEXT-DECORATION:none}
            A:hover {FONT-SIZE: 8pt; FONT-FAMILY:Verdana; COLOR:#FF3300; TEXT-DECORATION:underline}
            A:visited {FONT-SIZE: 8pt; FONT-FAMILY:Verdana; COLOR:#3366CC; TEXT-DECORATION:none}
            A:visited:hover {FONT-SIZE: 8pt; FONT-FAMILY:Verdana; color:#FF3300; TEXT-DECORATION:underline}

        </style>
    </head><body bgcolor="white">
        <h1>
            Reporting Services Error<hr width="100%" size="1" color="silver" />
        </h1><ul>
            <li>The report server has encountered a configuration error. See the report server log files for more information. (rsServerConfigurationError) </li><ul>
                <li>Access to the path 'C:Program FilesMicrosoft SQL ServerMSSQL.4Reporting ServicesReportServerRSReportServer.config' is denied.</li>
            </ul>
        </ul><hr width="100%" size="1" color="silver" /><span class="ProductInfo">SQL Server Reporting Services</span>
    </body>
</html>
--. (Microsoft.ReportingServices.SemanticQueryDesign)

------------------------------
BUTTONS:

OK
------------------------------

View Replies !   View Related
Error Deploying Large Report Model
 


Hi ,

I am trying to deploy the report model which is more than  4 mb size. I am getting following error:

Error     2          There was an exception running the extensions specified in the config file. ---> Maximum request length exceeded.

i changed the web.config on the server side:
as following:
<!--
            <httpRuntime
                executionTimeout = "600"  [in Seconds][number]
                maxRequestLength = "102400" [number]
                requestLengthDiskThreshold = "80" [number]
                useFullyQualifiedRedirectUrl = "false" [true|false]
                minFreeThreads = "8" [number]
                minLocalRequestFreeThreads = "4" [number]
                appRequestQueueLimit = "5000" [number]
                enableKernelOutputCache = "true" [true|false]
                enableVersionHeader = "true" [true|false]
                apartmentThreading = "false" [true|false]
                requireRootedSaveAsPath = "true" [true|false]
                enable = "true" [true|false]
                sendCacheControlHeader = "true" [true|false]
                shutdownTimeout = "90"  [in Seconds][number]
                delayNotificationTimeout = "5"  [in Seconds][number]
                waitChangeNotification = "0" [number]
                maxWaitChangeNotification = "0" [number]
                enableHeaderChecking = "true" [true|false]
            />
        -->
        <httpRuntime executionTimeout="600" maxRequestLength="102400" requestLengthDiskThreshold="80" useFullyQualifiedRedirectUrl="false" minFreeThreads="8" minLocalRequestFreeThreads="4" appRequestQueueLimit="5000" enableKernelOutputCache="true" enableVersionHeader="true" requireRootedSaveAsPath="true" enable="true" shutdownTimeout="90" delayNotificationTimeout="5" waitChangeNotification="0" maxWaitChangeNotification="0" enableHeaderChecking="true" sendCacheControlHeader="true" apartmentThreading="false" />
    
But still gets same error: what else i ahve to change.

Please help!!

Thanks

View Replies !   View Related
Proxy Authentication Error While Deploying The Report On The Same Server
Hello Experts,

I have a Report Server when i try to deploy my report on the same server and if i use the Fully Qualified Domain Name in my report path i get the below Error

TargetServerURL : http://jptoclq901.corpusers.net/ReportServer

Error : The request failed with HTTP Status 407 : Proxy Authentication Required (Microsoft.ReportingServices.Designer)

 

but if i use the TargetServerURL as http://localhost/ReportServer, things do work fine. but company requirement is to use complete path.

 

Is this a limitation or some way out, any Idea???

 

Thanks in advance for the help

 

/Soni

 

 

View Replies !   View Related
Error While Loading Code Module When Deploying A Report
I have a custom assembly that I wrote.  I placed it in the GAC and the report runs fine locally.  I placed it on the server in the GAC and it kicks out the following error when deploying:

Error while loading code module: €˜SSRSReporting, Version=1.0.1.0, Culture=neutral, PublicKeyToken=de4c010eaf2f2fe8€™. Details: Could not load file or assembly 'SSRSReporting, Version=1.0.1.0, Culture=neutral, PublicKeyToken=de4c010eaf2f2fe8' or one of its dependencies. The system cannot find the file specified.   ....

If I put the file in the /bin directory on the server there is no issues and it works fine.  I need to to deploy to the GAC though.  I restarted IIS and the RS services.    I still have the same issue.

View Replies !   View Related
Deploying Report Via Visual Studio To Sharepoint - Error
Hi guys

I seem to be having a bit of trouble deploying my reports from my Reporting Services Project in Visual Studio to my Sharpoint server.

 

Both the reporting server and sharepoint are installed on the same server.

 

The settings within my reporting server are as follows (where report is the site name):

    TrargetDataSourceFolder - https://server/Report/Shared Documents/DataSources

    TrargetReportFolder - https://server/Report/Shared Documents

    TrargetServerURL - https://server/Report

 

I have not yet changed over all my reports to use fully qualified urls yet. As we have multiple domains in which the reports need to go through before they hit the production server and i haven't yet decided how i am going to handle the issues of the reports requiring fully qualified addresses (if someone has a way i would love to know).

 

I was getting the following error when i tried to deploy the projects but i delete all extensions from the blocked file types and that error went away. I can only guess that there was a file type it didn't like.

Error - "The file you are attempting to save or retrieve has been blocked from this Web site by the server administrators."

 

When i deleted all the file extensions i now get the following error.

Error - "File Not Found."

 

Just wondering if anyone has had any success with visual studio and sharepoint deployment or run into this problem.

Thanks

Anthony
 

View Replies !   View Related
.net Security Assembly Returns Results Of An MDX Query To A Report Viewed In Report Manager - EnvironmentPermissions Error
Hi,
 
I've got a Security assembly implemented in .net 2.0, which returns the results of an MDX query to a report viewed in Report Manager.
 
This is the error:
 Request for the permission of type 'System.Security.Permissions.EnvironmentPermission, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089' failed
 
If I cut out the code that asserts the need for unlimited FileIOPermissions, then the error changes to:
 
Unable to retrieve security descriptor for this frame
 
So I can't get away with just asserting less permissions. I assume that this is something to do with using MDX in this way.
 

Clearly the permissions on the assembly are inadequate, so I tried updating the rssrvpolicy.config file:
 
<configuration>
    <mscorlib>
        <security>
            <policy>
                <PolicyLevel version="1">
                    <SecurityClasses>
                        <SecurityClass Name="AllMembershipCondition" Description="System.Security.Policy.AllMembershipCondition, mscorlib, Version=1.0.5000.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"/>
                        <SecurityClass Name="AspNetHostingPermission" Description="System.Web.AspNetHostingPermission, System, Version=1.0.5000.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"/>
                        <SecurityClass Name="DnsPermission" Description="System.Net.DnsPermission, System, Version=1.0.5000.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"/>
                        <SecurityClass Name="EnvironmentPermission" Description="System.Security.Permissions.EnvironmentPermission, mscorlib, Version=1.0.5000.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"/>
                        <SecurityClass Name="FileIOPermission" Description="System.Security.Permissions.FileIOPermission, mscorlib, Version=1.0.5000.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"/>
                        <SecurityClass Name="FirstMatchCodeGroup" Description="System.Security.Policy.FirstMatchCodeGroup, mscorlib, Version=1.0.5000.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"/>
                        <SecurityClass Name="IsolatedStorageFilePermission" Description="System.Security.Permissions.IsolatedStorageFilePermission, mscorlib, Version=1.0.5000.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"/>
                        <SecurityClass Name="NamedPermissionSet" Description="System.Security.NamedPermissionSet"/>
                        <SecurityClass Name="PrintingPermission" Description="System.Drawing.Printing.PrintingPermission, System.Drawing, Version=1.0.5000.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a"/>
                        <SecurityClass Name="ReflectionPermission" Description="System.Security.Permissions.ReflectionPermission, mscorlib, Version=1.0.5000.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"/>
                        <SecurityClass Name="RegistryPermission" Description="System.Security.Permissions.RegistryPermission, mscorlib, Version=1.0.5000.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"/>
                        <SecurityClass Name="SecurityPermission" Description="System.Security.Permissions.SecurityPermission, mscorlib, Version=1.0.5000.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"/>
                        <SecurityClass Name="SocketPermission" Description="System.Net.SocketPermission, System, Version=1.0.5000.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"/>
                        <SecurityClass Name="SqlClientPermission" Description="System.Data.SqlClient.SqlClientPermission, System.Data, Version=1.0.5000.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"/>
                        <SecurityClass Name="StrongNameMembershipCondition" Description="System.Security.Policy.StrongNameMembershipCondition, mscorlib, Version=1.0.5000.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"/>
                        <SecurityClass Name="UnionCodeGroup" Description="System.Security.Policy.UnionCodeGroup, mscorlib, Version=1.0.5000.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"/>
                        <SecurityClass Name="UrlMembershipCondition" Description="System.Security.Policy.UrlMembershipCondition, mscorlib, Version=1.0.5000.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"/>
                        <SecurityClass Name="WebPermission" Description="System.Net.WebPermission, System, Version=1.0.5000.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"/>
                        <SecurityClass Name="ZoneMembershipCondition" Description="System.Security.Policy.ZoneMembershipCondition, mscorlib, Version=1.0.5000.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"/>
                    </SecurityClasses>
                    <NamedPermissionSets>
                        <PermissionSet
                                class="NamedPermissionSet"
                                version="1"
                                Unrestricted="true"
                                Name="FullTrust"
                                Description="Allows full access to all resources"
                        />
                        <PermissionSet
                                class="NamedPermissionSet"
                                version="1"
                                Name="Nothing"
                                Description="Denies all resources, including the right to execute"
                        />
                        <PermissionSet
                                class="NamedPermissionSet"
                                version="1"
                                Name="Execution">
                            <IPermission
                                    class="SecurityPermission"
                                    version="1"
                                    Flags="Execution"
                            />
                        </PermissionSet>
   <PermissionSet class="DirectoryServicesPermissionSet"
    version="1"
    Name="DSPermissionSet"
    Description="A special permission set that grants browse access to DirectoryServices">
    <IPermission class="DirectoryServicesPermission"
     version="1"
     Browse=""/>
    <IPermission class="SecurityPermission"
         version="1"
         Flags="Assertion, Execution"/>
   </PermissionSet>
                    </NamedPermissionSets>
                    <CodeGroup
                            class="FirstMatchCodeGroup"
                            version="1"
                            PermissionSetName="Nothing">
                        <IMembershipCondition
                                class="AllMembershipCondition"
                                version="1"
                        />
                        <CodeGroup
                                class="UnionCodeGroup"
                                version="1"
                                PermissionSetName="Execution"
                                Name="Report_Expressions_Default_Permissions"
                                Description="This code group grants default permissions for code in report expressions and Code element. ">
                            <IMembershipCondition
                                    class="StrongNameMembershipCondition"
                                    version="1"
                                    PublicKeyBlob="0024000004800000940000000602000000240000525341310004000001000100512C8E872E28569E733BCB123794DAB55111A0570B3B3D4DE3794153DEA5EFB7C3FEA9F2D8236CFF320C4FD0EAD5F677880BF6C181F296C751C5F6E65B04D3834C02F792FEE0FE452915D44AFE74A0C27E0D8E4B8D04EC52A8E281E01FF47E7D694E6C7275A09AFCBFD8CC82705A06B20FD6EF61EBBA6873E29C8C0F2CAEDDA2"
                            />
   </CodeGroup>
                        <CodeGroup
                                class="FirstMatchCodeGroup"
                                version="1"
                                PermissionSetName="Execution"
                                Description="This code group grants MyComputer code Execution permission. ">
                         <IMembershipCondition
                                    class="ZoneMembershipCondition"
                                    version="1"
                                    Zone="MyComputer" />
                            <CodeGroup
                                    class="UnionCodeGroup"
                                    version="1"
                                    PermissionSetName="FullTrust"
                                    Name="Microsoft_Strong_Name"
                                    Description="This code group grants code signed with the Microsoft strong name full trust. ">
                                <IMembershipCondition
                                        class="StrongNameMembershipCondition"
                                        version="1"
                                        PublicKeyBlob="002400000480000094000000060200000024000052534131000400000100010007D1FA57C4AED9F0A32E84AA0FAEFD0DE9E8FD6AEC8F87FB03766C834C99921EB23BE79AD9D5DCC1DD9AD236132102900B723CF980957FC4E177108FC607774F29E8320E92EA05ECE4E821C0A5EFE8F1645C4C0C93C1AB99285D622CAA652C1DFAD63D745D6F2DE5F17E5EAF0FC4963D261C8A12436518206DC093344D5AD293"
                                />
                            </CodeGroup>
                            <CodeGroup
                                    class="UnionCodeGroup"
                                    version="1"
                                    PermissionSetName="FullTrust"
                                    Name="Ecma_Strong_Name"
                                    Description="This code group grants code signed with the ECMA strong name full trust. ">
                                <IMembershipCondition
                                        class="StrongNameMembershipCondition"
                                        version="1"
                                        PublicKeyBlob="00000000000000000400000000000000"
                                />
                            </CodeGroup>
                            <CodeGroup
                                    class="UnionCodeGroup"
                                    version="1"
                                    PermissionSetName="FullTrust"
                                    Name="Report_Server_Strong_Name"
                                    Description="This code group grants Report Server code full trust. ">
                                <IMembershipCondition
                                        class="StrongNameMembershipCondition"
                                        version="1"
                                        PublicKeyBlob="0024000004800000940000000602000000240000525341310004000001000100272736AD6E5F9586BAC2D531EABC3ACC666C2F8EC879FA94F8F7B0327D2FF2ED523448F83C3D5C5DD2DFC7BC99C5286B2C125117BF5CBE242B9D41750732B2BDFFE649C6EFB8E5526D526FDD130095ECDB7BF210809C6CDAD8824FAA9AC0310AC3CBA2AA0523567B2DFA7FE250B30FACBD62D4EC99B94AC47C7D3B28F1F6E4C8"
                                />
                            </CodeGroup>
                            <CodeGroup
                                    class="UnionCodeGroup"
                                    version="1"
                                    PermissionSetName="FullTrust">
                                <IMembershipCondition
                                        class="UrlMembershipCondition"
                                        version="1"
                                        Url="$CodeGen$/*"
                                />
                            </CodeGroup>
                            <CodeGroup
                                    class="UnionCodeGroup"
                                    version="1"
                                    PermissionSetName="FullTrust"
                                    Name="SharePoint_Server_Strong_Name"
                                    Description="This code group grants SharePoint Server code full trust. ">
                                <IMembershipCondition
                                        class="StrongNameMembershipCondition"
                                        version="1"
                                        PublicKeyBlob="0024000004800000940000000602000000240000525341310004000001000100AFD4A0E7724151D5DD52CB23A30DED7C0091CC01CFE94B2BCD85B3F4EEE3C4D8F6417BFF763763A996D6B2DFC1E7C29BCFB8299779DF8785CDE2C168CEEE480E570725F2468E782A9C2401302CF6DC17E119118ED2011937BAE9698357AD21E8B6DFB40475D16E87EB03C744A5D32899A0DBC596A6B2CFA1E509BE5FBD09FACF"
                                />
                            </CodeGroup>
       <CodeGroup class="UnionCodeGroup"
        version="1"
                                   PermissionSetName="FullTrust"
                                   Name="MyCompany.MIS.Security"
                                   Description="A special code group for my custom assembly.">
       <IMembershipCondition class="StrongNameMembershipCondition" version="1"
        PublicKeyBlob="00240000048000009400000006020000002400005253413100040000010001003F099786BD0BDCD36FF941A6EC9E6612103F15D0D34DF124FF4792C237EF88E88C23C3BAD09A57FAD1C3364003C4C27E7EFA206520286982563134566247AFCFFFDCA1B91B9AA0EBAEA81F20A3BB6769037D882DFB38F9D7FFE2F19B8975C18CED382BC2BB911C7D4B8484B39EE3AC651530A1DDD21DCE50A24EEED613CF8DBA"
                      Name="MyCompany.MIS.Security" AssemblyVersion="3.0.0.4"/>
          </CodeGroup>
                    </CodeGroup>
                </PolicyLevel>
            </policy>
        </security>
    </mscorlib>
</configuration>
 

I've added 'Full Trust' to my specific assembly. The new clause there was generated using caspol.exe so I think it should be correct. However, this made no difference at all to the error!

 
However, if I upgrade Report_Expressions_Default_Permissions (see above) to Full Trust, the problem is 'solved'. Unfortunately giving Full Trust to any and all Report Expressions is not an option.
 
Can anyone help?
 
Dr. Bunsen
 

View Replies !   View Related
Error When Deleting Report In Report Manager And SQL Management Studio
I am getting a rsInternalError when I try to delete a report in Report Manager and SQL Management Studio.  I am able to deploy, move (as long as the report doesn't exist at the destination) and upload but not delete.
 
This is the error dump:
 
<Header>
  <Product>Microsoft SQL Server Reporting Services Version 9.00.3050.00</Product>
  <Locale>en-US</Locale>
  <TimeZone>Central Daylight Time</TimeZone>
  <Path>C:Program FilesMicrosoft SQL ServerMSSQL.10Reporting ServicesLogFilesReportServer__09_19_2007_00_02_45.log</Path>
  <SystemName>HLTHS2</SystemName>
  <OSName>Microsoft Windows NT 5.2.3790 Service Pack 1</OSName>
  <OSVersion>5.2.3790.65536</OSVersion>
</Header>
w3wp!library!5!9/19/2007-00:02:45:: i INFO: Cleaned -1 batch records, -1 policies, 0 sessions, -1 cache entries, 0 snapshots, 0 chunks, -1 running jobs, -1 persisted streams
w3wp!library!5!9/19/2007-00:12:45:: i INFO: Cleaned -1 batch records, -1 policies, 0 sessions, -1 cache entries, 0 snapshots, 0 chunks, -1 running jobs, -1 persisted streams
w3wp!library!6!9/19/2007-00:22:45:: i INFO: Cleaned -1 batch records, -1 policies, 0 sessions, -1 cache entries, 0 snapshots, 0 chunks, -1 running jobs, -1 persisted streams
w3wp!library!7!9/19/2007-00:32:45:: i INFO: Cleaned -1 batch records, -1 policies, 0 sessions, -1 cache entries, 0 snapshots, 0 chunks, -1 running jobs, -1 persisted streams
w3wp!library!6!9/19/2007-00:42:45:: i INFO: Cleaned -1 batch records, -1 policies, 0 sessions, -1 cache entries, 0 snapshots, 0 chunks, -1 running jobs, -1 persisted streams
w3wp!library!1!9/19/2007-00:52:45:: i INFO: Cleaned -1 batch records, -1 policies, 0 sessions, -1 cache entries, 0 snapshots, 0 chunks, -1 running jobs, -1 persisted streams
w3wp!library!7!9/19/2007-01:02:45:: i INFO: Cleaned -1 batch records, -1 policies, 0 sessions, -1 cache entries, 0 snapshots, 0 chunks, -1 running jobs, -1 persisted streams
w3wp!library!5!9/19/2007-01:12:45:: i INFO: Cleaned -1 batch records, -1 policies, 0 sessions, -1 cache entries, 0 snapshots, 0 chunks, -1 running jobs, -1 persisted streams
w3wp!library!7!9/19/2007-01:22:45:: i INFO: Cleaned -1 batch records, -1 policies, 0 sessions, -1 cache entries, 0 snapshots, 0 chunks, -1 running jobs, -1 persisted streams
w3wp!library!6!9/19/2007-01:32:45:: i INFO: Cleaned -1 batch records, -1 policies, 0 sessions, -1 cache entries, 0 snapshots, 0 chunks, -1 running jobs, -1 persisted streams
w3wp!library!7!9/19/2007-01:42:45:: i INFO: Cleaned -1 batch records, -1 policies, 0 sessions, -1 cache entries, 0 snapshots, 0 chunks, -1 running jobs, -1 persisted streams
w3wp!library!7!9/19/2007-01:52:45:: i INFO: Cleaned -1 batch records, -1 policies, 0 sessions, -1 cache entries, 0 snapshots, 0 chunks, -1 running jobs, -1 persisted streams
w3wp!library!5!9/19/2007-02:02:45:: i INFO: Cleaned -1 batch records, -1 policies, 0 sessions, -1 cache entries, 0 snapshots, 0 chunks, -1 running jobs, -1 persisted streams
w3wp!library!1!9/19/2007-02:12:45:: i INFO: Cleaned -1 batch records, -1 policies, 0 sessions, -1 cache entries, 0 snapshots, 0 chunks, -1 running jobs, -1 persisted streams
w3wp!library!6!9/19/2007-02:22:45:: i INFO: Cleaned -1 batch records, -1 policies, 0 sessions, -1 cache entries, 0 snapshots, 0 chunks, -1 running jobs, -1 persisted streams
w3wp!library!7!9/19/2007-02:32:45:: i INFO: Cleaned -1 batch records, -1 policies, 0 sessions, -1 cache entries, 0 snapshots, 0 chunks, -1 running jobs, -1 persisted streams
w3wp!library!1!9/19/2007-02:42:45:: i INFO: Cleaned -1 batch records, -1 policies, 0 sessions, -1 cache entries, 0 snapshots, 0 chunks, -1 running jobs, -1 persisted streams
w3wp!library!1!9/19/2007-02:52:45:: i INFO: Cleaned -1 batch records, -1 policies, 0 sessions, -1 cache entries, 0 snapshots, 0 chunks, -1 running jobs, -1 persisted streams
w3wp!library!6!9/19/2007-03:02:45:: i INFO: Cleaned -1 batch records, -1 policies, 0 sessions, -1 cache entries, 0 snapshots, 0 chunks, -1 running jobs, -1 persisted streams
w3wp!library!6!9/19/2007-03:12:45:: i INFO: Cleaned -1 batch records, -1 policies, 0 sessions, -1 cache entries, 0 snapshots, 0 chunks, -1 running jobs, -1 persisted streams
w3wp!library!7!9/19/2007-03:22:45:: i INFO: Cleaned -1 batch records, -1 policies, 0 sessions, -1 cache entries, 0 snapshots, 0 chunks, -1 running jobs, -1 persisted streams
w3wp!library!1!9/19/2007-03:32:45:: i INFO: Cleaned -1 batch records, -1 policies, 0 sessions, -1 cache entries, 0 snapshots, 0 chunks, -1 running jobs, -1 persisted streams
w3wp!library!6!9/19/2007-03:42:45:: i INFO: Cleaned -1 batch records, -1 policies, 0 sessions, -1 cache entries, 0 snapshots, 0 chunks, -1 running jobs, -1 persisted streams
w3wp!library!1!9/19/2007-03:52:45:: i INFO: Cleaned -1 batch records, -1 policies, 0 sessions, -1 cache entries, 0 snapshots, 0 chunks, -1 running jobs, -1 persisted streams
w3wp!library!1!9/19/2007-04:02:45:: i INFO: Cleaned -1 batch records, -1 policies, 0 sessions, -1 cache entries, 0 snapshots, 0 chunks, -1 running jobs, -1 persisted streams
w3wp!library!5!9/19/2007-04:12:45:: i INFO: Cleaned -1 batch records, -1 policies, 0 sessions, -1 cache entries, 0 snapshots, 0 chunks, -1 running jobs, -1 persisted streams
w3wp!library!6!9/19/2007-04:22:45:: i INFO: Cleaned -1 batch records, -1 policies, 0 sessions, -1 cache entries, 0 snapshots, 0 chunks, -1 running jobs, -1 persisted streams
w3wp!library!1!9/19/2007-04:32:45:: i INFO: Cleaned -1 batch records, -1 policies, 0 sessions, -1 cache entries, 0 snapshots, 0 chunks, -1 running jobs, -1 persisted streams
w3wp!library!1!9/19/2007-04:42:45:: i INFO: Cleaned -1 batch records, -1 policies, 0 sessions, -1 cache entries, 0 snapshots, 0 chunks, -1 running jobs, -1 persisted streams
w3wp!library!1!9/19/2007-04:52:45:: i INFO: Cleaned -1 batch records, -1 policies, 0 sessions, -1 cache entries, 0 snapshots, 0 chunks, -1 running jobs, -1 persisted streams
w3wp!library!7!9/19/2007-05:02:45:: i INFO: Cleaned -1 batch records, -1 policies, 0 sessions, -1 cache entries, 0 snapshots, 0 chunks, -1 running jobs, -1 persisted streams
w3wp!library!6!9/19/2007-05:12:45:: i INFO: Cleaned -1 batch records, -1 policies, 0 sessions, -1 cache entries, 0 snapshots, 0 chunks, -1 running jobs, -1 persisted streams
w3wp!library!6!9/19/2007-05:22:45:: i INFO: Cleaned -1 batch records, -1 policies, 0 sessions, -1 cache entries, 0 snapshots, 0 chunks, -1 running jobs, -1 persisted streams
w3wp!library!5!9/19/2007-05:32:45:: i INFO: Cleaned -1 batch records, -1 policies, 0 sessions, -1 cache entries, 0 snapshots, 0 chunks, -1 running jobs, -1 persisted streams
w3wp!library!1!9/19/2007-05:42:45:: i INFO: Cleaned -1 batch records, -1 policies, 0 sessions, -1 cache entries, 0 snapshots, 0 chunks, -1 running jobs, -1 persisted streams
w3wp!library!1!9/19/2007-05:52:45:: i INFO: Cleaned -1 batch records, -1 policies, 0 sessions, -1 cache entries, 0 snapshots, 0 chunks, -1 running jobs, -1 persisted streams
w3wp!library!1!9/19/2007-06:02:48:: i INFO: Cleaned -1 batch records, -1 policies, 0 sessions, -1 cache entries, 0 snapshots, 0 chunks, -1 running jobs, -1 persisted streams
w3wp!library!6!9/19/2007-06:12:45:: i INFO: Cleaned -1 batch records, -1 policies, 0 sessions, -1 cache entries, 0 snapshots, 0 chunks, -1 running jobs, -1 persisted streams
w3wp!library!1!9/19/2007-06:22:45:: i INFO: Cleaned -1 batch records, -1 policies, 0 sessions, -1 cache entries, 0 snapshots, 0 chunks, -1 running jobs, -1 persisted streams
w3wp!library!1!9/19/2007-06:32:45:: i INFO: Cleaned -1 batch records, -1 policies, 0 sessions, -1 cache entries, 0 snapshots, 0 chunks, -1 running jobs, -1 persisted streams
w3wp!library!1!9/19/2007-06:42:45:: i INFO: Cleaned -1 batch records, -1 policies, 0 sessions, -1 cache entries, 0 snapshots, 0 chunks, -1 running jobs, -1 persisted streams
w3wp!library!1!9/19/2007-06:52:45:: i INFO: Cleaned -1 batch records, -1 policies, 0 sessions, -1 cache entries, 0 snapshots, 0 chunks, -1 running jobs, -1 persisted streams
w3wp!library!5!9/19/2007-07:02:45:: i INFO: Cleaned -1 batch records, -1 policies, 0 sessions, -1 cache entries, 0 snapshots, 0 chunks, -1 running jobs, -1 persisted streams
w3wp!library!5!9/19/2007-07:12:45:: i INFO: Cleaned -1 batch records, -1 policies, 0 sessions, -1 cache entries, 0 snapshots, 0 chunks, -1 running jobs, -1 persisted streams
w3wp!library!7!9/19/2007-07:22:45:: i INFO: Cleaned -1 batch records, -1 policies, 0 sessions, -1 cache entries, 0 snapshots, 0 chunks, -1 running jobs, -1 persisted streams
w3wp!library!1!9/19/2007-07:32:45:: i INFO: Cleaned -1 batch records, -1 policies, 0 sessions, -1 cache entries, 0 snapshots, 0 chunks, -1 running jobs, -1 persisted streams
w3wp!library!5!9/19/2007-07:42:45:: i INFO: Cleaned -1 batch records, -1 policies, 0 sessions, -1 cache entries, 0 snapshots, 0 chunks, -1 running jobs, -1 persisted streams
w3wp!library!1!9/19/2007-07:52:45:: i INFO: Cleaned -1 batch records, -1 policies, 0 sessions, -1 cache entries, 0 snapshots, 0 chunks, -1 running jobs, -1 persisted streams
w3wp!library!1!9/19/2007-08:02:45:: i INFO: Cleaned -1 batch records, -1 policies, 0 sessions, -1 cache entries, 0 snapshots, 0 chunks, -1 running jobs, -1 persisted streams
w3wp!library!1!9/19/2007-08:12:45:: i INFO: Cleaned -1 batch records, -1 policies, 0 sessions, -1 cache entries, 0 snapshots, 0 chunks, -1 running jobs, -1 persisted streams
w3wp!library!7!9/19/2007-08:22:45:: i INFO: Cleaned -1 batch records, -1 policies, 0 sessions, -1 cache entries, 0 snapshots, 0 chunks, -1 running jobs, -1 persisted streams
w3wp!library!7!9/19/2007-08:32:45:: i INFO: Cleaned -1 batch records, -1 policies, 0 sessions, -1 cache entries, 0 snapshots, 0 chunks, -1 running jobs, -1 persisted streams
w3wp!library!7!9/19/2007-08:42:45:: i INFO: Cleaned -1 batch records, -1 policies, 0 sessions, -1 cache entries, 0 snapshots, 0 chunks, -1 running jobs, -1 persisted streams
w3wp!library!1!9/19/2007-08:52:45:: i INFO: Cleaned -1 batch records, -1 policies, 0 sessions, -1 cache entries, 0 snapshots, 0 chunks, -1 running jobs, -1 persisted streams
w3wp!library!5!9/19/2007-09:02:45:: i INFO: Cleaned -1 batch records, -1 policies, 0 sessions, -1 cache entries, 0 snapshots, 0 chunks, -1 running jobs, -1 persisted streams
w3wp!library!5!09/19/2007-09:07:20:: Call to GetItemTypeAction(/Test).
w3wp!library!1!09/19/2007-09:07:21:: Call to CreateFolderAction(Test, /).
w3wp!library!7!09/19/2007-09:07:21:: Call to GetItemTypeAction(/Data Sources).
w3wp!library!7!09/19/2007-09:07:21:: Call to GetItemTypeAction(/Data Sources/Warehouse).
w3wp!library!5!09/19/2007-09:07:22:: Call to GetItemTypeAction(/Test/Invoice Balance).
w3wp!library!6!09/19/2007-09:07:25:: Call to CreateReportAction(Invoice Balance, /Test, True).
w3wp!library!7!09/19/2007-09:07:29:: Call to SetItemDataSourcesAction(/Test/Invoice Balance).
w3wp!library!7!09/19/2007-09:08:25:: Call to GetPermissionsAction(/).
w3wp!library!7!09/19/2007-09:08:25:: Call to GetPropertiesAction(/, PathBased).
w3wp!library!7!09/19/2007-09:08:25:: Call to GetSystemPermissionsAction().
w3wp!library!5!09/19/2007-09:08:25:: Call to ListChildrenAction(/, False).
w3wp!library!5!09/19/2007-09:08:25:: Call to GetSystemPropertiesAction().
w3wp!library!5!09/19/2007-09:08:25:: Call to GetSystemPropertiesAction().
w3wp!library!5!09/19/2007-09:08:29:: Call to GetPermissionsAction(/Test).
w3wp!library!1!09/19/2007-09:08:29:: Call to GetPropertiesAction(/Test, PathBased).
w3wp!library!6!09/19/2007-09:08:29:: Call to GetSystemPermissionsAction().
w3wp!library!6!09/19/2007-09:08:29:: Call to ListChildrenAction(/Test, False).
w3wp!library!6!09/19/2007-09:08:29:: Call to GetSystemPropertiesAction().
w3wp!library!6!09/19/2007-09:08:29:: Call to GetSystemPropertiesAction().
w3wp!library!6!9/19/2007-09:12:45:: i INFO: Cleaned -1 batch records, -1 policies, 0 sessions, -1 cache entries, 0 snapshots, 0 chunks, -1 running jobs, -1 persisted streams
w3wp!library!6!09/19/2007-09:15:04:: Call to GetPermissionsAction(/Test/Invoice Balance).
w3wp!library!6!09/19/2007-09:15:04:: Call to GetSystemPropertiesAction().
w3wp!library!1!09/19/2007-09:15:04:: Call to GetPropertiesAction(/Test/Invoice Balance, PathBased).
w3wp!library!6!09/19/2007-09:15:04:: Call to GetSystemPermissionsAction().
w3wp!library!6!09/19/2007-09:15:05:: Call to GetPropertiesAction(/Test/Invoice Balance, PathBased).
w3wp!library!1!09/19/2007-09:15:05:: Call to ListEventsAction().
w3wp!library!1!09/19/2007-09:15:08:: Call to GetSystemPropertiesAction().
w3wp!library!1!09/19/2007-09:15:13:: Call to GetPermissionsAction(/Test/Invoice Balance).
w3wp!library!5!09/19/2007-09:15:14:: Call to GetSystemPropertiesAction().
w3wp!library!6!09/19/2007-09:15:14:: Call to GetPropertiesAction(/Test/Invoice Balance, PathBased).
w3wp!library!6!09/19/2007-09:15:14:: Call to GetReportParametersAction(/Test/Invoice Balance).
w3wp!library!6!09/19/2007-09:15:14:: Call to GetSystemPermissionsAction().
w3wp!library!6!09/19/2007-09:15:14:: Call to GetPropertiesAction(/Test/Invoice Balance, PathBased).
w3wp!library!6!09/19/2007-09:15:14:: Call to ListChildrenAction(/, False).
w3wp!library!6!09/19/2007-09:15:14:: Call to ListChildrenAction(/Test, False).
w3wp!library!6!09/19/2007-09:15:14:: Call to ListChildrenAction(/, False).
w3wp!library!6!09/19/2007-09:15:14:: Call to ListChildrenAction(/Test, False).
w3wp!library!5!09/19/2007-09:15:14:: Call to GetItemDataSourcesAction(/Test/Invoice Balance).
w3wp!library!6!09/19/2007-09:15:15:: Call to GetSystemPropertiesAction().
w3wp!library!1!09/19/2007-09:15:18:: Call to GetPermissionsAction(/Test/Invoice Balance).
w3wp!library!1!09/19/2007-09:15:18:: Call to GetSystemPropertiesAction().
w3wp!library!5!09/19/2007-09:15:18:: Call to GetPropertiesAction(/Test/Invoice Balance, PathBased).
w3wp!library!7!09/19/2007-09:15:18:: Call to GetReportParametersAction(/Test/Invoice Balance).
w3wp!library!5!09/19/2007-09:15:18:: Call to GetSystemPermissionsAction().
w3wp!library!5!09/19/2007-09:15:18:: Call to GetPropertiesAction(/Test/Invoice Balance, PathBased).
w3wp!library!5!09/19/2007-09:15:18:: Call to DeleteItemAction(/Test/Invoice Balance).
w3wp!library!5!09/19/2007-09:15:19:: a ASSERT: Assertion failed!   Call stack:
 Microsoft.ReportingServices.Library.DeleteItemAction.PerformActionNow() 
 Microsoft.ReportingServices.Library.RSSoapAction`1.Execute() 
 Microsoft.ReportingServices.WebServer.ReportingService2005Impl.DeleteItem(String Item) 
 Microsoft.ReportingServices.WebServer.ReportingService2005.DeleteItem(String Item) 
 System.RuntimeMethodHandle._InvokeMethodFast(Object target, Object[] arguments, SignatureStruct& sig, MethodAttributes methodAttributes, RuntimeTypeHandle typeOwner) 
 System.RuntimeMethodHandle.InvokeMethodFast(Object target, Object[] arguments, Signature sig, MethodAttributes methodAttributes, RuntimeTypeHandle typeOwner) 
 System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture, Boolean skipVisibilityChecks) 
 System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture) 
 System.Web.Services.Protocols.LogicalMethodInfo.Invoke(Object target, Object[] values) 
 System.Web.Services.Protocols.WebServiceHandler.Invoke() 
 System.Web.Services.Protocols.WebServiceHandler.CoreProcessRequest() 
 System.Web.Services.Protocols.SyncSessionlessHandler.ProcessRequest(HttpContext context) 
 System.Web.HttpApplication+CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() 
 System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) 
 System.Web.HttpApplication+ApplicationStepManager.ResumeSteps(Exception error) 
 System.Web.HttpApplication.System.Web.IHttpAsyncHandler.BeginProcessRequest(HttpContext context, AsyncCallback cb, Object extraData) 
 System.Web.HttpRuntime.ProcessRequestInternal(HttpWorkerRequest wr) 
 System.Web.HttpRuntime.ProcessRequestNoDemand(HttpWorkerRequest wr) 
 System.Web.Hosting.ISAPIRuntime.ProcessRequest(IntPtr ecb, Int32 iWRType) 
w3wp!library!5!09/19/2007-09:15:19:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details., un-named assertion fired for component library;
 Info: Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details.

 
 
The error in the event log is:
 
EventType sql90exception, P1 w3wp.exe, P2 6.0.3790.1830, P3 42435be1, P4 reportingservicesnativeclient.ni.dll, P5 2005.90.3042.0, P6 45cd6edb, P7 0, P8 00005253, P9 00000000, P10 NIL.

 
Thanks in advance!
 
Lori

View Replies !   View Related
Report Manager Error
I have seen this issue in other posts, but I've never seen a way to fix it.

When I try to access the Report Manager, I get the following:

 
Server Error in '/Reports' Application.


Could not load file or assembly 'ReportingServicesWebServer' or one of its dependencies. The system cannot find the file specified.

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

Exception Details: System.IO.FileNotFoundException: Could not load file or assembly 'ReportingServicesWebServer' or one of its dependencies. The system cannot find the file specified.

Source Error:





An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.
Assembly Load Trace: The following information can be helpful to determine why the assembly 'ReportingServicesWebServer' could not be loaded.





WRN: Assembly binding logging is turned OFF.
To enable assembly bind failure logging, set the registry value [HKLMSoftwareMicrosoftFusion!EnableLog] (DWORD) to 1.
Note: There is some performance penalty associated with assembly bind failure logging.
To turn this feature off, remove the registry value [HKLMSoftwareMicrosoftFusion!EnableLog].

Stack Trace:





[FileNotFoundException: Could not load file or assembly 'ReportingServicesWebServer' or one of its dependencies. The system cannot find the file specified.]
System.Reflection.Assembly.nLoad(AssemblyName fileName, String codeBase, Evidence assemblySecurity, Assembly locationHint, StackCrawlMark& stackMark, Boolean throwOnFileNotFound, Boolean forIntrospection) +0
System.Reflection.Assembly.InternalLoad(AssemblyName assemblyRef, Evidence assemblySecurity, StackCrawlMark& stackMark, Boolean forIntrospection) +211
System.Reflection.Assembly.InternalLoad(String assemblyString, Evidence assemblySecurity, StackCrawlMark& stackMark, Boolean forIntrospection) +141
System.Reflection.Assembly.Load(String assemblyString) +25
System.Web.Configuration.CompilationSection.LoadAssemblyHelper(String assemblyName, Boolean starDirective) +32

[ConfigurationErrorsException: Could not load file or assembly 'ReportingServicesWebServer' or one of its dependencies. The system cannot find the file specified.]
System.Web.Configuration.CompilationSection.LoadAssemblyHelper(String assemblyName, Boolean starDirective) +596
System.Web.Configuration.CompilationSection.LoadAssembly(AssemblyInfo ai) +70
System.Web.Compilation.BuildManager.GetReferencedAssemblies(CompilationSection compConfig) +177
System.Web.Compilation.BuildProvidersCompiler..ctor(VirtualPath configPath, Boolean supportLocalization, String outputAssemblyName) +180
System.Web.Compilation.ApplicationBuildProvider.GetGlobalAsaxBuildResult(Boolean isPrecompiledApp) +3446629
System.Web.Compilation.BuildManager.CompileGlobalAsax() +51
System.Web.Compilation.BuildManager.EnsureTopLevelFilesCompiled() +462

[HttpException (0x80004005): Could not load file or assembly 'ReportingServicesWebServer' or one of its dependencies. The system cannot find the file specified.]
System.Web.Compilation.BuildManager.ReportTopLevelCompilationException() +57
System.Web.Compilation.BuildManager.EnsureTopLevelFilesCompiled() +612
System.Web.Hosting.HostingEnvironment.Initialize(ApplicationManager appManager, IApplicationHost appHost, IConfigMapPathFactory configMapPathFactory, HostingEnvironmentParameters hostingParameters) +456

[HttpException (0x80004005): Could not load file or assembly 'ReportingServicesWebServer' or one of its dependencies. The system cannot find the file specified.]
System.Web.HttpRuntime.FirstRequestInit(HttpContext context) +3426855
System.Web.HttpRuntime.EnsureFirstRequestInit(HttpContext context) +88
System.Web.HttpRuntime.ProcessRequestInternal(HttpWorkerRequest wr) +149





Version Information: Microsoft .NET Framework Version:2.0.50727.42; ASP.NET Version:2.0.50727.42

I am using SSE2005 SP2

What can I do to fix this?  This is a production server that is very precisely configured, so I can't just format and reinstall everything (this would take DAYS)

Please please help!!!  : )

View Replies !   View Related
Error In Access Report Manager
I am able to access report server and view the reports on my machine but when i access

the report manager it gives error

"The attempt to connect to the report server failed.  Check your connection information and that the report server is a compatible version"

 

View Replies !   View Related
Report Manager - Subscription Error
 

Hello All,
 
I have created few reports and deployed the reports ot Report Server. When i tried to create new subscription(to schedule the report) for the report, i am getting the below error:
 
An internal error occurred on the report server. See the error log for more details. (rsInternalError) Get Online Help




For more information about this error navigate to the report server on the local server machine, or enable remote errors
 
Please let me know the solution in this regard.
 
Thanks,
SR.

View Replies !   View Related
Processing Error In Report Manager
Hi,
 
I'm trying to generate a report i'd deployed on the webserver. However, I keep getting the following error msg, even after i've created a shared data source.







An error has occurred during report processing.




Cannot create a connection to data source 'RC_Cube'.

For more information about this error navigate to the report server on the local server machine, or enable remote errors








 
Al

View Replies !   View Related
Cannot Edit Report Security In Report Manager Or SQL Server Manager!!!
Please help!  I recently installed SSRS and it has been working well for the last couple of weeks.  Now, I cannot access the security controls for any reports in either Report Manager or SQL Server Management Studio.  Right-clicking on the Home directory brings up an error window that says "Cannot show requested dialog." and gives an rsInternalError reference.
 
I've searched everything related to the error msg that I'm getting and cannot find any reference to this issue.  If anyone has any suggestions, I'd really appreciate them.
 
Thanks in advance!
 
- Mike

View Replies !   View Related
Error When Creating Schedule In Report Manager
Hello,
 
Scenario:
I am trying to set up a shared schedule in report manager after successfully deploying the reports to my server. I have set up the linked reports and AD permissions, however when I want to either set up a shared schedule, or an individual schedule I encounter the error below.  
 
System details:
Microsoft SQL Server 2005 - 9.00.2050.00 (Intel X86)   Feb 13 2007 23:02:48   Copyright (c) 1988-2005 Microsoft Corporation  Enterprise Edition on Windows NT 5.0 (Build 2195: Service Pack 4) 
 
Report Manager Error:
An internal error occurred on the report server. See the error log for more details. (rsInternalError) The specified @category_id ('100') does not exist.
 
The error log does not contain any infor regarding this error, and I've searched for this error extensively in Google as well as microsoft.com, however can't seem to find a resolution for it.
 
I have also tried to create the schedule in SQL Server Management Studio. The complete error message is as follows:
An internal error occurred on the report server. See the error log for more details. (rsInternalError) (Report Services SOAP Proxy Source)
Additional information:
An internal error occurred on the report server. See the error log for more details. (rsInternalError) (ReportingServicesLibrary)
The specified @category_id ('100') does not exist. () (.Net SqlClient Data Provider)
 
Please could you send me any further info about how to solve this problem and resolve the error.
 
Thank you
Sune de Vos

 
 
 

View Replies !   View Related
Data #ERROR In Report Manager But Not Designer
Hi,

 

I'm running a report using MDX. In preview, the report displays correctly, but after deploying to Report Manager, where there were once numbers there is now '#Error'. The string fields display correctly, its just the numeric ones that are not working.

 

Any help is much appreciated.

 

Cheers,

 

Ali

View Replies !   View Related
Error While Executing Reports From Report Manager
Hi..

I have deployed reports on to the report server. When I try to open the reports from report server, I get the error," Value does not fall within the expected range." This error message appears as soon as  I click on any report on the report manager.

I am not able to find the cause of the error.

Does anybody have any suggestions?

Thanks ,

Viva

View Replies !   View Related
Reg: Error While Browsing Report Server In IIS Manager
 
Reporting Services Error



The report server cannot open a connection to the report server database. A connection to the database is required for all requests and processing. (rsReportServerDatabaseUnavailable) Get Online Help

An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)



SQL Server Reporting Services


 
While browsing ReportServer I am getting the above error please help me on this regard.
 
 
 
Thanks in advance,
Archana Devi P

View Replies !   View Related
Login Prompt When Deploying Solution/report To Report Server
 

Hi there,
 
I've seen some similar posts to this one, however none with an answer and I'm wondering if anyone has actually figured out what causes this issue. I'm running SQL Server 2005 Reporting Services.
 
I'm attempting to implement a folder structure for the report server, therefore am creating individual solutions in Visual Studio for each folder. At the top level i.e http://servername/reportserver/ I am able to deploy reports no problem.
 
However creating a folder at the next level in the tree and then deploying to that level such as http://servername/reportserver/ManagementReports causes a Reporting Services Login prompt to appear. No matter what user credentials I enter they are not accepted. I have full administrator rights the server, the site and the folders in question.
 
Has anyone else experienced this? Does anyone have any suggestions?
 
Thanks
Matt

View Replies !   View Related
Problem Deploying Custom Report Item. Items Shows In Preview Screen In VS, But Not In Server Deployed Report
I have developed a custom report item that works fine in design and preview mode while in Visual Studio. I cannot get it to show up on my deployed reports. Here's what I have done so far:

1. Deployed the report using Visual Studio

2. updated the rsreportserver.config file with the following entry:

    <ReportItems>
      <ReportItem Name="PedigreeChart" Type="Uabr.Rap.PedigreeChart.PedigreeChartRenderer, Uabr.Rap.PedigreeChart" />
    </ReportItems>

3. Updated the rssrvpolicy.config file with the following entry.

                          <CodeGroup
                    class="UnionCodeGroup"
                    version="1"
                    PermissionSetName="FullTrust"
                    Description="This code group grants Uabr.Rap.PedigreeChart.dll FUllTrust permission. ">
                            <IMembershipCondition
                                class="UrlMembershipCondition"
                                version="1"
                                Url="C:Program FilesMicrosoft SQL ServerMSSQL.3Reporting ServicesReportServerinUabr.Rap.PedigreeChart.dll" />
                          </CodeGroup>

I've also tried using the StrongNameMembershipCondition with no better results.

4. The dll and its dependencies are copied to the bin directory of the report server.

5. When I load a report with this custom report item on it, the report loads fine with no errors or warnings in the log file (even with verbose tracing). The area where the custom item should be is just white. It's almost like Reporting Services isn't registering the item correctly.

This is particularly frustrating because the report works fine in Visual Studio - apparently I configured that correctly. Any suggestions would be greatly appreciated. I'm stumped.

View Replies !   View Related
Invalid Namespace Error While Login Report Manager
I am using Custom Security Extension DLL for implementing Forms Authentication in Reporting Service 2005. While Login I am getting an "Invalid Namespace" error. After debugging it, i found below lines in the AuthenticationUtilities.cs page of the Custom DLL which is giving error.

const string WmiNamespace = @"\localhost
ootMicrosoftSqlServerReportingServicesv8";
const string WmiRSClass = @"MSReportServerReportManager_ConfigurationSetting";

scope = new ManagementScope(WmiNamespace);

// Connect to the Reporting Services namespace.
scope.Connect(); //This is the line where the error is coming. It is trying to conenct WMI provider

Can anyone help me in figuring out What is wrong with the WmiNamespace ???????


Thanks,
Akash


 

View Replies !   View Related
Accessing SSAS Cube From Report Manager Error
Hey Forum Community

I seem to have a problem creating a model for my AS cube through Report Manager.

I have set up the data source as follows:

Name:  Gates Aust Business Intelligence

Connection Type:  MS SQL Server Analysis Services

Connection String:  Data Source=MANT4003;initial catalog="GAPL Sales Analysis"

Connect Using: Windows Interegrated Security

This part works, but when i go to generate the model, i get the following error in the browser:

"









Cannot create a connection to data source ''. (rsErrorOpeningConnection) Get Online Help




For more information about this error navigate to the report server on the local server machine, or enable remote errors

In the reporting services log file i have the following errors:

w3wp!library!7!07/03/2006-10:51:40:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.DataSourceOpenException: Cannot create a connection to data source ''., ;
 Info: Microsoft.ReportingServices.Diagnostics.Utilities.DataSourceOpenException: Cannot create a connection to data source ''. ---> Microsoft.AnalysisServices.AdomdClient.AdomdConnectionException: The connection either timed out or was lost. ---> System.IO.IOException: Unable to read data from the transport connection: An existing connection was forcibly closed by the remote host. ---> System.Net.Sockets.SocketException: An existing connection was forcibly closed by the remote host
   at System.Net.Sockets.Socket.Receive(Byte[] buffer, Int32 offset, Int32 size, SocketFlags socketFlags)
   at System.Net.Sockets.NetworkStream.Read(Byte[] buffer, Int32 offset, Int32 size)
   --- End of inner exception stack trace ---
   at System.Net.Sockets.NetworkStream.Read(Byte[] buffer, Int32 offset, Int32 size)
   at System.IO.BufferedStream.Read(Byte[] array, Int32 offset, Int32 count)
   at Microsoft.AnalysisServices.AdomdClient.DimeRecord.ForceRead(Stream stream, Byte[] buffer, Int32 length)
   at Microsoft.AnalysisServices.AdomdClient.DimeRecord.ReadHeader()
   at Microsoft.AnalysisServices.AdomdClient.DimeRecord..ctor(Stream stream)
   at Microsoft.AnalysisServices.AdomdClient.DimeReader.ReadRecord()
   at Microsoft.AnalysisServices.AdomdClient.TcpStream.GetDataType()
   --- End of inner exception stack trace ---
   at Microsoft.AnalysisServices.AdomdClient.XmlaClient.EndRequest()
   at Microsoft.AnalysisServices.AdomdClient.XmlaClient.CreateSession(ListDictionary properties, Boolean sendNamespaceCompatibility)
   at Microsoft.AnalysisServices.AdomdClient.AdomdConnection.XmlaClientProvider.Microsoft.AnalysisServices.AdomdClient.AdomdConnection.IXmlaClientProviderEx.CreateSession(Boolean sendNamespaceCompatibility)
   at Microsoft.AnalysisServices.AdomdClient.AdomdConnection.ConnectToXMLA(Boolean createSession, Boolean isHTTP)
   at Microsoft.AnalysisServices.AdomdClient.AdomdConnection.Open()
   at Microsoft.ReportingServices.Library.RSService.OpenDataSourceConnection(DataSourceInfo dataSourceInfo, CreateDataExtensionInstance createDataExtensionInstanceFunction, Boolean isUnattendedExecution, Boolean unwrapConnection, IntPtr clientToken, IDbConnection& unwrappedConnection)
   --- End of inner exception stack trace ---
w3wp!library!1!07/03/2006-10:51:59:: i INFO: Call to GetPermissions:/
w3wp!library!1!07/03/2006-10:53:02:: i INFO: Call to GetPermissions:/

 

I have tried searching the forums and cannot find anything really helpful.  I have had one cube setup and a model generated before and all was workin, but i had to delete it and i recreated the SSAS cube from scratch. 

My user account has admin rights on the cube and also on the servers.

Server is Windows 2003

Client is Windows XP.

Any one got anythoughts on this or how i can determine what is wrong.?

Many Thanks


Scotty

View Replies !   View Related
Error Message When Clicked The New Subscription In Report Manager
Hi all,


When I try above, I was shown the below:

Subscriptions cannot be created because the credentials used to run the report are not stored, the link is no longer valid.

How do I resolve this?

Regards,
Farouk Yew Abdullah

View Replies !   View Related
Reporting Services: Report Manager Does Not Load (server Error)
Hello Everyone,
 
I have installed SQL Server 2005 with Reporting Services on Windows Server 2003.  I can run through reporting services configuration and completed all the required steps to initialize it.  I can access the reports through //localhost/reportserver and I can also access the reports through Microsoft CRM.  But I cannot access the Report Manager (//localhost/reports).  I get this Error:
Server Error in '/Reports' Application.


Could not load file or assembly 'ReportingServicesWebServer' or one of its dependencies. The system cannot find the file specified. Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.IO.FileNotFoundException: Could not load file or assembly 'ReportingServicesWebServer' or one of its dependencies. The system cannot find the file specified.

Source Error:





An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.
Assembly Load Trace: The following information can be helpful to determine why the assembly 'ReportingServicesWebServer' could not be loaded.





WRN: Assembly binding logging is turned OFF.
To enable assembly bind failure logging, set the registry value [HKLMSoftwareMicrosoftFusion!EnableLog] (DWORD) to 1.
Note: There is some performance penalty associated with assembly bind failure logging.
To turn this feature off, remove the registry value [HKLMSoftwareMicrosoftFusion!EnableLog].

Stack Trace:





[FileNotFoundException: Could not load file or assembly 'ReportingServicesWebServer' or one of its dependencies. The system cannot find the file specified.]
System.Reflection.Assembly.nLoad(AssemblyName fileName, String codeBase, Evidence assemblySecurity, Assembly locationHint, StackCrawlMark& stackMark, Boolean throwOnFileNotFound, Boolean forIntrospection) +0
System.Reflection.Assembly.InternalLoad(AssemblyName assemblyRef, Evidence assemblySecurity, StackCrawlMark& stackMark, Boolean forIntrospection) +211
System.Reflection.Assembly.InternalLoad(String assemblyString, Evidence assemblySecurity, StackCrawlMark& stackMark, Boolean forIntrospection) +141
System.Reflection.Assembly.Load(String assemblyString) +25
System.Web.Configuration.CompilationSection.LoadAssemblyHelper(String assemblyName, Boolean starDirective) +32

[ConfigurationErrorsException: Could not load file or assembly 'ReportingServicesWebServer' or one of its dependencies. The system cannot find the file specified.]
System.Web.Configuration.CompilationSection.LoadAssemblyHelper(String assemblyName, Boolean starDirective) +596
System.Web.Configuration.CompilationSection.LoadAssembly(AssemblyInfo ai) +70
System.Web.Compilation.BuildManager.GetReferencedAssemblies(CompilationSection compConfig) +177
System.Web.Compilation.BuildProvidersCompiler..ctor(VirtualPath configPath, Boolean supportLocalization, String outputAssemblyName) +180
System.Web.Compilation.ApplicationBuildProvider.GetGlobalAsaxBuildResult(Boolean isPrecompiledApp) +3561465
System.Web.Compilation.BuildManager.CompileGlobalAsax() +51
System.Web.Compilation.BuildManager.EnsureTopLevelFilesCompiled() +462

[HttpException (0x80004005): Could not load file or assembly 'ReportingServicesWebServer' or one of its dependencies. The system cannot find the file specified.]
System.Web.Compilation.BuildManager.ReportTopLevelCompilationException() +57
System.Web.Compilation.BuildManager.EnsureTopLevelFilesCompiled() +612
System.Web.Hosting.HostingEnvironment.Initialize(ApplicationManager appManager, IApplicationHost appHost, IConfigMapPathFactory configMapPathFactory, HostingEnvironmentParameters hostingParameters) +521

[HttpException (0x80004005): Could not load file or assembly 'ReportingServicesWebServer' or one of its dependencies. The system cannot find the file specified.]
System.Web.HttpRuntime.FirstRequestInit(HttpContext context) +3540923
System.Web.HttpRuntime.EnsureFirstRequestInit(HttpContext context) +69
System.Web.HttpRuntime.ProcessRequestInternal(HttpWorkerRequest wr) +275











Version Information: Microsoft .NET Framework Version:2.0.50727.832; ASP.NET Version:2.0.50727.832
 
Any ideas?  I have done some searching, but could not find any viable solutions.  Please Help
 
Regards,
Ray

View Replies !   View Related
HTTP Status 401: Access Denied Error In Report Manager
This didn't use to happen but now it does.

 

When I go into Report Manager, http://localhost/reports, and try running a report it is giving me this error message:

 

The request failed with HTTP status 401: Access Denied

 

But if I go directly to the Report Server, http://localhost/reportserver, and try running a report there then everything is fine.

 

Does anyone know why it is doing this all of a sudden? I did change the Reports app in ISS to allow anonymous access but have since changed it back, and it still gives this error.

View Replies !   View Related
Error While Connecting To Reporting Services Engine &&amp; Report Manager
Hi,
 
I am getting an error:
 
1. While connecting to the Reporting Services Engine (Using SQL Server Management Server). The error message is given below. Report Server is working fine, I am able to browse the reports from the report server.
 
------------------------------------------------------------------------------------------------------------------------------------------------------------
TITLE: Connect to Server
------------------------------
Cannot connect to BTP8NMB03.
------------------------------
ADDITIONAL INFORMATION:
Client found response content type of 'text/html; charset=utf-8', but expected 'text/xml'.
The request failed with the error message:
--
<HTML dir="ltr">
<HEAD><meta name="GENERATOR" content="Microsoft SharePoint" /><meta name="progid" content="SharePoint.WebPartPage.Document" /><meta HTTP-EQUIV="Content-Type" content="text/html; charset=utf-8" /><meta HTTP-EQUIV="Expires" content="0" /><meta name="ROBOTS" content="NOHTMLINDEX" /><title>
 
 Error
</title><link rel="stylesheet" type="text/css" href="/_layouts/1033/styles/core.css?rev=5msmprmeONfN6lJ3wtbAlA%3D%3D"/>
<script type="text/javascript" language="javascript" src="/_layouts/1033/init.js?rev=VhAxGc3rkK79RM90tibDzw%3D%3D"></script>
<script type="text/javascript" language="javascript" src="/_layouts/1033/core.js?rev=F8pbQQxa4zefcW%2BW9E5g8w%3D%3D"></script>
 <meta name="Robots" content="NOINDEX " />
 <meta name="SharePointError" content=""/>
</HEAD>
<BODY scroll="yes" onload="javascript:if (typeof(_spBodyOnLoadWrapper) != 'undefined') _spBodyOnLoadWrapper();">
  <form name="aspnetForm" method="post" action="../_layouts/error.aspx" id="aspnetForm" onsubmit="return _spFormOnSubmitWrapper();">
<input type="hidden" name="__VIEWSTATE" id="__VIEWSTATE" value="/wEPDwUKLTU2NjkxODU3M2RkLuL1ujv9xB7yocvKanNE0G4cIn0=" />
  <TABLE class="ms-main" CELLPADDING=0 CELLSPACING=0 BORDER=0 WIDTH="100%" HEIGHT="100%">
 <tr><td>
    <table CELLPADDING=0 CELLSPACING=0 BORDER=0 WIDTH="100%">
  <tr>
   <td colspan=4 class="ms-globalbreadcrumb" align="right">
      <a href="javascript:TopHelpButtonClick('NavBarHelpHome')" id="ctl00_PlaceHolderGlobalNavigation_TopHelpLink" AccessKey="6" title="Help (new window)"><img src="/_layouts/images/helpicon.gif" align="absmiddle" border="0" alt="Help (new window)" /></a>
   </td>
  </tr>
    </table>
   </td></tr>
 <tr>
  <td class="ms-globalTitleArea">
   <table width=100% cellpadding=0 cellspacing=0 border=0>
    <tr>
  <td id="GlobalTitleAreaImage" class="ms-titleimagearea"><img id="onetidHeadbnnr0" src="/_layouts/images/titlegraphic.gif"  alt="" /></td>
  <td class="ms-sitetitle" width=100%>
   
   
  </td>
  <td style="padding-top:8px;" valign=top>
   
   
  </td>
    </tr>
   </table>
  </td>
 </tr>
 <TR>
  <TD id="onetIdTopNavBarContainer" WIDTH=100% class="ms-bannerContainer">
  
  
  </TD>
 </TR>
 
  

 
 
 <TR height="100%"><TD><TABLE width="100%" height="100%" cellspacing="0" cellpadding="0">
 <tr>
  <td class="ms-titlearealeft" id="TitleAreaImageCell" valign="middle" nowrap><div style="height:100%" class="ms-titleareaframe"></div></td>
  <td class="ms-titleareaframe" id="TitleAreaFrameClass">
  
  <table cellpadding=0 height=100% width=100% cellspacing=0>
   <tr><td class="ms-areaseparatorleft"><IMG SRC="/_layouts/images/blank.gif" width=1 height=1 alt=""></td></tr>
  </table>
  
  </td>
  <td valign=top  id="onetidPageTitleAreaFrame" class='ms-areaseparator' nowrap width="100%">
   <table id="onetidPageTitleAreaTable" cellpadding=0 cellspacing=0 width=100% border="0">
    <tr>
  <td valign="top" class="ms-titlearea">
  
    <a href="http://btp8nmb03" id="ctl00_PlaceHolderTitleBreadcrumb_idSimpleGoBackToHome">Go back to site</a>
  
  </td>
    </tr>
    <tr>
  <td height=100% valign=top ID=onetidPageTitle class="ms-pagetitle">
    <h2 class="ms-pagetitle">
   
 Error
    </h2>
  </td>
    </tr>
   </table>
  </td>
  <td class="ms-titlearearight">
  
  
<div class='ms-areaseparatorright'><IMG SRC="/_layouts/images/blank.gif" width=8 height=100% alt=""></div>
</td>
 </tr>
 <TR>
   <TD class="ms-leftareacell" valign=top height=100% id="LeftNavigationAreaCell">
    <table class=ms-nav width=100% height=100% cellpadding=0 cellspacing=0>
  <tr>
   <td>
    <TABLE height="100%" class=ms-navframe CELLPADDING=0 CELLSPACING=0 border="0">
     <tr valign="top">
   <td width="4px"><IMG SRC="/_layouts/images/blank.gif" width=4 height=1 alt=""></td>
   <td valign="top" width="100%">
    
    
    
    
     
    
    
   </td>
     </tr>
     <tr><td colspan=2><IMG SRC="/_layouts/images/blank.gif" width=138 height=1 alt=""></td></tr>
    </TABLE>
   </td>
   <td></td>
  </tr>
    </table>
   </TD>
   <td>
<div class='ms-areaseparatorleft'><IMG SRC="/_layouts/images/blank.gif" width=8 height=100% alt=""></div>
</td>
   <td class='ms-formareaframe' valign="top">
  <TABLE width="100%" border="0" cellspacing="0" cellpadding="0" class="ms-propertysheet">
   <TR valign="top"  >
   <TD class="ms-descriptiontext" width="100%">
    
   </TD>
      <TD ID=onetidYPadding width="10px"><IMG SRC="/_layouts/images/blank.gif" width=10 height=1 alt=""></TD>
    </TR>
    <TR >
   <TD ID=onetidMainBodyPadding height="8px"><IMG SRC="/_layouts/images/blank.gif" width=1 height=8 alt=""></TD>
    </TR>
    <tr>
    <td valign="top" height="100%">
      <A name="mainContent"></A>
    
 <table width=100% border=0 class="ms-titleareaframe" cellpadding=0>
 <TR>
 <TD valign=top width="100%" style="padding-top: 10px" class="ms-descriptiontext">
    <span id="ctl00_PlaceHolderMain_LabelMessage">The file you are attempting to save or retrieve has been blocked from this Web site by the server administrators.</span>
    <P><span class="ms-descriptiontext">
  <span id="ctl00_PlaceHolderMain_helptopic_troubleshooting"><A Title="Troubleshoot issues with Windows SharePoint Services. - Opens in new window" HREF="javascript:HelpWindowKey('troubleshooting')">Troubleshoot issues with Windows SharePoint Services.</A></span>
  
  </span>
 </TD>
 </TR>
 </table>
<script type="text/javascript" language="JavaScript">
  var gearPage = document.getElementById('GearPage');
  if(null != gearPage)
  {
   gearPage.parentNode.removeChild(gearPage);
   document.title = "Error";
  }
</script>
    </td>
    </tr>
  </table>
   </td>
   <td class="ms-rightareacell">
<div class='ms-areaseparatorright'><IMG SRC="/_layouts/images/blank.gif" width=8 height=100% alt=""></div>
</td>
 </TR>
<tr>
 <td class="ms-pagebottommarginleft"><IMG SRC="/_layouts/images/blank.gif" width=1 height=10 alt=""></td>
 <td class="ms-pagebottommargin"><IMG SRC="/_layouts/images/blank.gif" width=1 height=10 alt=""></td>
 <td class="ms-bodyareapagemargin"><IMG SRC="/_layouts/images/blank.gif" width=1 height=10 alt=""></td>
 <td class="ms-pagebottommarginright"><IMG SRC="/_layouts/images/blank.gif" width=1 height=10 alt=""></td>
</tr>
 </TABLE></TD></TR>
  </TABLE>
 
 
   <input type="text" name="__spDummyText1" style="display:none;" size=1/>
   <input type="text" name="__spDummyText2" style="display:none;" size=1/>
  </form>
 
</BODY>
</HTML>
--. (Microsoft.SqlServer.Management.UI.RSClient)
------------------------------
BUTTONS:
OK
------------------------------

-------------------------------------------------------------------------------------------------------------------------------------------------------------
 
2. When I try to connect to the Report Manager. I get the error "The request failed with HTTP status 400: Bad Request."
 
The log file contains the following information:
-------------------------------------------------------------------------------------------------------------------------------------------------------------
<Header>
  <Product>Microsoft SQL Server Reporting Services Version 9.00.3042.00</Product>
  <Locale>en-US</Locale>
  <TimeZone>India Standard Time</TimeZone>
  <Path>D:Program FilesMicrosoft SQL ServerMSSQL.3Reporting ServicesLogFilesReportServerWebApp__05_20_2008_20_12_13.log</Path>
  <SystemName>BTP8NMB03</SystemName>
  <OSName>Microsoft Windows NT 5.2.3790 Service Pack 2</OSName>
  <OSVersion>5.2.3790.131072</OSVersion>
</Header>
w3wp!library!5!5/20/2008-20:12:13:: i INFO: Initializing ReportBuilderTrustLevel to '0'  as specified in Configuration file.
w3wp!library!5!5/20/2008-20:12:13:: i INFO: Initializing MaxActiveReqForOneUser to '20' requests(s) as specified in Configuration file.
w3wp!library!5!5/20/2008-20:12:13:: i INFO: Initializing MaxScheduleWait to default value of '1' second(s) because it was not specified in Configuration file.
w3wp!library!5!5/20/2008-20:12:13:: i INFO: Initializing DatabaseQueryTimeout to default value of '30' second(s) because it was not specified in Configuration file.
w3wp!library!5!5/20/2008-20:12:13:: i INFO: Initializing ProcessRecycleOptions to default value of '0'  because it was not specified in Configuration file.
w3wp!library!5!5/20/2008-20:12:13:: i INFO: Initializing RunningRequestsScavengerCycle to default value of '30' second(s) because it was not specified in Configuration file.
w3wp!library!5!5/20/2008-20:12:13:: i INFO: Initializing RunningRequestsDbCycle to default value of '30' second(s) because it was not specified in Configuration file.
w3wp!library!5!5/20/2008-20:12:13:: i INFO: Initializing RunningRequestsAge to default value of '30' second(s) because it was not specified in Configuration file.
w3wp!library!5!5/20/2008-20:12:13:: i INFO: Initializing CleanupCycleMinutes to default value of '10' minute(s) because it was not specified in Configuration file.
w3wp!library!5!5/20/2008-20:12:13:: i INFO: Initializing DailyCleanupMinuteOfDay to default value of '120' minutes since midnight because it was not specified in Configuration file.
w3wp!library!5!5/20/2008-20:12:13:: i INFO: Initializing WatsonFlags to default value of '1064'  because it was not specified in Configuration file.
w3wp!library!5!5/20/2008-20:12:13:: i INFO: Initializing WatsonDumpOnExceptions to default value of 'Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException,Microsoft.ReportingServices.Modeling.InternalModelingException'  because it was not specified in Configuration file.
w3wp!library!5!5/20/2008-20:12:13:: i INFO: Initializing WatsonDumpExcludeIfContainsExceptions to default value of 'System.Data.SqlClient.SqlException,System.Threading.ThreadAbortException'  because it was not specified in Configuration file.
w3wp!library!5!5/20/2008-20:12:13:: i INFO: Initializing SecureConnectionLevel to default value of '1'  because it was not specified in Configuration file.
w3wp!library!5!5/20/2008-20:12:13:: i INFO: Initializing DisplayErrorLink to 'True'  as specified in Configuration file.
w3wp!library!5!5/20/2008-20:12:13:: i INFO: Initializing WebServiceUseFileShareStorage to default value of 'False'  because it was not specified in Configuration file.
w3wp!ui!5!5/20/2008-20:12:17:: e ERROR: The request failed with HTTP status 400: Bad Request.
w3wp!ui!5!5/20/2008-20:12:17:: e ERROR: HTTP status code --> 500
-------Details--------
System.Net.WebException: The request failed with HTTP status 400: Bad Request.
   at Microsoft.SqlServer.ReportingServices2005.RSConnection.GetSecureMethods()
   at Microsoft.ReportingServices.UI.Global.RSWebServiceWrapper.GetSecureMethods()
   at Microsoft.SqlServer.ReportingServices2005.RSConnection.IsSecureMethod(String methodname)
   at Microsoft.SqlServer.ReportingServices2005.RSConnection.ValidateConnection()
   at Microsoft.ReportingServices.UI.ReportingPage.EnsureHttpsLevel(HttpsLevel level)
   at Microsoft.ReportingServices.UI.ReportingPage.ReportingPage_Init(Object sender, EventArgs args)
   at System.EventHandler.Invoke(Object sender, EventArgs e)
   at System.Web.UI.Control.OnInit(EventArgs e)
   at System.Web.UI.Page.OnInit(EventArgs e)
   at System.Web.UI.Control.InitRecursive(Control namingContainer)
   at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
w3wp!ui!5!5/20/2008-20:12:18:: e ERROR: Exception in ShowErrorPage: System.Threading.ThreadAbortException: Thread was being aborted.
   at System.Threading.Thread.AbortInternal()
   at System.Threading.Thread.Abort(Object stateInfo)
   at System.Web.HttpResponse.End()
   at System.Web.HttpServerUtility.Transfer(String path, Boolean preserveForm)
   at Microsoft.ReportingServices.UI.ReportingPage.ShowErrorPage(String errMsg) at    at System.Threading.Thread.AbortInternal()
   at System.Threading.Thread.Abort(Object stateInfo)
   at System.Web.HttpResponse.End()
   at System.Web.HttpServerUtility.Transfer(String path, Boolean preserveForm)
   at Microsoft.ReportingServices.UI.ReportingPage.ShowErrorPage(String errMsg)
w3wp!ui!7!5/20/2008-20:12:26:: e ERROR: The request failed with HTTP status 400: Bad Request.
w3wp!ui!7!5/20/2008-20:12:26:: e ERROR: HTTP status code --> 500
-------Details--------
System.Net.WebException: The request failed with HTTP status 400: Bad Request.
   at Microsoft.SqlServer.ReportingServices2005.RSConnection.GetSecureMethods()
   at Microsoft.ReportingServices.UI.Global.RSWebServiceWrapper.GetSecureMethods()
   at Microsoft.SqlServer.ReportingServices2005.RSConnection.IsSecureMethod(String methodname)
   at Microsoft.SqlServer.ReportingServices2005.RSConnection.ValidateConnection()
   at Microsoft.ReportingServices.UI.ReportingPage.EnsureHttpsLevel(HttpsLevel level)
   at Microsoft.ReportingServices.UI.ReportingPage.ReportingPage_Init(Object sender, EventArgs args)
   at System.EventHandler.Invoke(Object sender, EventArgs e)
   at System.Web.UI.Control.OnInit(EventArgs e)
   at System.Web.UI.Page.OnInit(EventArgs e)
   at System.Web.UI.Control.InitRecursive(Control namingContainer)
   at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
w3wp!ui!7!5/20/2008-20:12:27:: e ERROR: Exception in ShowErrorPage: System.Threading.ThreadAbortException: Thread was being aborted.
   at System.Threading.Thread.AbortInternal()
   at System.Threading.Thread.Abort(Object stateInfo)
   at System.Web.HttpResponse.End()
   at System.Web.HttpServerUtility.Transfer(String path, Boolean preserveForm)
   at Microsoft.ReportingServices.UI.ReportingPage.ShowErrorPage(String errMsg) at    at System.Threading.Thread.AbortInternal()
   at System.Threading.Thread.Abort(Object stateInfo)
   at System.Web.HttpResponse.End()
   at System.Web.HttpServerUtility.Transfer(String path, Boolean preserveForm)
   at Microsoft.ReportingServices.UI.ReportingPage.ShowErrorPage(String errMsg)
w3wp!ui!1!5/20/2008-20:25:18:: e ERROR: The request failed with HTTP status 400: Bad Request.
w3wp!ui!1!5/20/2008-20:25:18:: e ERROR: HTTP status code --> 500
-------Details--------
System.Net.WebException: The request failed with HTTP status 400: Bad Request.
   at Microsoft.SqlServer.ReportingServices2005.RSConnection.GetSecureMethods()
   at Microsoft.ReportingServices.UI.Global.RSWebServiceWrapper.GetSecureMethods()
   at Microsoft.SqlServer.ReportingServices2005.RSConnection.IsSecureMethod(String methodname)
   at Microsoft.SqlServer.ReportingServices2005.RSConnection.ValidateConnection()
   at Microsoft.ReportingServices.UI.ReportingPage.EnsureHttpsLevel(HttpsLevel level)
   at Microsoft.ReportingServices.UI.ReportingPage.ReportingPage_Init(Object sender, EventArgs args)
   at System.EventHandler.Invoke(Object sender, EventArgs e)
   at System.Web.UI.Control.OnInit(EventArgs e)
   at System.Web.UI.Page.OnInit(EventArgs e)
   at System.Web.UI.Control.InitRecursive(Control namingContainer)
   at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
w3wp!ui!1!5/20/2008-20:25:19:: e ERROR: Exception in ShowErrorPage: System.Threading.ThreadAbortException: Thread was being aborted.
   at System.Threading.Thread.AbortInternal()
   at System.Threading.Thread.Abort(Object stateInfo)
   at System.Web.HttpResponse.End()
   at System.Web.HttpServerUtility.Transfer(String path, Boolean preserveForm)
   at Microsoft.ReportingServices.UI.ReportingPage.ShowErrorPage(String errMsg) at    at System.Threading.Thread.AbortInternal()
   at System.Threading.Thread.Abort(Object stateInfo)
   at System.Web.HttpResponse.End()
   at System.Web.HttpServerUtility.Transfer(String path, Boolean preserveForm)
   at Microsoft.ReportingServices.UI.ReportingPage.ShowErrorPage(String errMsg)

-------------------------------------------------------------------------------------------------------------------------------------------------------------
 
Any help in this regard would be appreciated.
Thanks in advance.
 
Thx,
Datta

View Replies !   View Related
CS0006 Error Accessing SSRS Report Manager Under Vista Ultimate
We receive the error below when attempting to access our newly installed reporting service under Windows Vista.  We can't seem to fix to this error.  While we can view reports deployed to my report server at http://ServerName/ReportServer, we cannot access the Report Manager that comes with SSRS via http://ServerName/Reports.  When we do we get the error below. 
 
According to the error it cannot find the 'C:WindowsassemblyGAC_32System.EnterpriseServices2.0.0.0__b03f5f7f11d50a3aSystem.EnterpriseServices.dll.  The missing dll is located in our C:$WINDOWS.~QDATAWindowsMicrosoft.NETFrameworkv2.0.50727System.EnterpriseServices.dll.  We do not have a GAC_32 directory in our Assembly directory and we cannot manually add any thing to the Assembly folder. 
 
Does anyone have any idea how to resolve this error?
 
Any assistance is greatly appreciated.
 
Server Error in '/Reports' Application.


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: CS0006: Metadata file 'C:WindowsassemblyGAC_32System.EnterpriseServices2.0.0.0__b03f5f7f11d50a3aSystem.EnterpriseServices.dll' could not be found

Source Error:







[No relevant source lines]
Source File:    Line: 0



Show Detailed Compiler Output:





c:windowssystem32inetsrv> "C:WindowsMicrosoft.NETFrameworkv2.0.50727csc.exe" /t:library /utf8output /R:"C:WindowsMicrosoft.NETFrameworkv2.0.50727Temporary ASP.NET Files
eportsaa13b3275d348ea7assemblydl350805c340086ba6_164dc701ReportingServicesNativeClient.DLL" /R:"C:WindowsMicrosoft.NETFrameworkv2.0.50727Temporary ASP.NET Files
eportsaa13b3275d348ea7assemblydl357073932092ba95_164dc701Microsoft.ReportingServices.Diagnostics.DLL" /R:"C:WindowsMicrosoft.NETFrameworkv2.0.50727Temporary ASP.NET Files
eportsaa13b3275d348ea7assemblydl34957153c0086ba6_164dc701ReportingServicesFileShareDeliveryProvider.DLL" /R:"C:WindowsassemblyGAC_32System.Data2.0.0.0__b77a5c561934e089System.Data.dll" /R:"C:WindowsassemblyGAC_MSILSystem.Runtime.Serialization3.0.0.0__b77a5c561934e089System.Runtime.Serialization.dll" /R:"C:WindowsassemblyGAC_MSILSystem.Drawing2.0.0.0__b03f5f7f11d50a3aSystem.Drawing.dll" /R:"C:WindowsassemblyGAC_MSILSystem.Web.RegularExpressions2.0.0.0__b03f5f7f11d50a3aSystem.Web.RegularExpressions.dll" /R:"C:WindowsassemblyGAC_MSILSystem.IdentityModel3.0.0.0__b77a5c561934e089System.IdentityModel.dll" /R:"C:WindowsMicrosoft.NETFrameworkv2.0.50727Temporary ASP.NET Files
eportsaa13b3275d348ea7assemblydl36a74e1360086ba6_164dc701ReportingServicesEmailDeliveryProvider.DLL" /R:"C:WindowsassemblyGAC_MSILSystem.Windows.Forms2.0.0.0__b77a5c561934e089System.Windows.Forms.dll" /R:"C:WindowsassemblyGAC_MSILSystem.ServiceModel3.0.0.0__b77a5c561934e089System.ServiceModel.dll" /R:"C:WindowsassemblyGAC_32System.EnterpriseServices2.0.0.0__b03f5f7f11d50a3aSystem.EnterpriseServices.dll" /R:"C:WindowsMicrosoft.NETFrameworkv2.0.50727Temporary ASP.NET Files
eportsaa13b3275d348ea7assemblydl39a6712b7092ba95_164dc701Microsoft.ReportingServices.Interfaces.DLL" /R:"C:WindowsassemblyGAC_MSILSystem2.0.0.0__b77a5c561934e089System.dll" /R:"C:WindowsMicrosoft.NETFrameworkv2.0.50727Temporary ASP.NET Files
eportsaa13b3275d348ea7assemblydl34c4caac70359ca7_164dc701ReportingServicesWebUserInterface.DLL" /R:"C:WindowsassemblyGAC_MSILSystem.DirectoryServices2.0.0.0__b03f5f7f11d50a3aSystem.DirectoryServices.dll" /R:"C:WindowsMicrosoft.NETFrameworkv2.0.50727Temporary ASP.NET Files
eportsaa13b3275d348ea7assemblydl326b107a10e258c3_b4d0c501ReportingServicesCDOInterop.DLL" /R:"C:WindowsassemblyGAC_MSILSystem.Web.Mobile2.0.0.0__b03f5f7f11d50a3aSystem.Web.Mobile.dll" /R:"C:WindowsassemblyGAC_MSILSystem.Configuration2.0.0.0__b03f5f7f11d50a3aSystem.Configuration.dll" /R:"C:WindowsassemblyGAC_MSILSystem.Web.Services2.0.0.0__b03f5f7f11d50a3aSystem.Web.Services.dll" /R:"C:WindowsassemblyGAC_MSILSystem.Xml2.0.0.0__b77a5c561934e089System.Xml.dll" /R:"C:WindowsassemblyGAC_MSILSystem.ServiceProcess2.0.0.0__b03f5f7f11d50a3aSystem.ServiceProcess.dll" /R:"C:WindowsassemblyGAC_MSILSystem.Design2.0.0.0__b03f5f7f11d50a3aSystem.Design.dll" /R:"C:WindowsMicrosoft.NETFrameworkv2.0.50727mscorlib.dll" /R:"C:WindowsassemblyGAC_MSILSystem.DirectoryServices.Protocols2.0.0.0__b03f5f7f11d50a3aSystem.DirectoryServices.Protocols.dll" /R:"C:WindowsassemblyGAC_32System.Web2.0.0.0__b03f5f7f11d50a3aSystem.Web.dll" /out:"C:WindowsMicrosoft.NETFrameworkv2.0.50727Temporary ASP.NET Files
eportsaa13b3275d348ea7App_global.asax.vk_hxeqb.dll" /debug- /optimize+ /w:4 /nowarn:1659;1699 "C:WindowsMicrosoft.NETFrameworkv2.0.50727Temporary ASP.NET Files
eportsaa13b3275d348ea7App_global.asax.vk_hxeqb.0.cs" "C:WindowsMicrosoft.NETFrameworkv2.0.50727Temporary ASP.NET Files
eportsaa13b3275d348ea7App_global.asax.vk_hxeqb.1.cs"


Microsoft (R) Visual C# 2005 Compiler version 8.00.50727.312
for Microsoft (R) Windows (R) 2005 Framework version 2.0.50727
Copyright (C) Microsoft Corporation 2001-2005. All rights reserved.

error CS0006: Metadata file 'C:WindowsassemblyGAC_32System.EnterpriseServices2.0.0.0__b03f5f7f11d50a3aSystem.EnterpriseServices.dll' could not be found








Version Information: Microsoft .NET Framework Version:2.0.50727.312; ASP.NET Version:2.0.50727.833

 

View Replies !   View Related
Error:no Report Server Found On The Specified Machine While Setting Up Reporting Services Configuraion Manager
Hello,

I have installed sql server 2005 along with reporting services... though i am able to design report using business intelligence studio... i am unable to access the report server.... while trying to start the reporting services configuration manager it says no report server found on the specified machine...Invalid Namespace... the installation is local ...

Due to this problem inspite of designing the entire report i am unable to deploy it on the web..since it is asking for a report server...

Can somebody please help me on this...

Thanks in advance...

Nirupa

View Replies !   View Related
Security Assembly Interrogating Database Via MDX Query Returns EnvironmentPermissions Error To Report Manager
 

Hi,
 
I've got a Security assembly implemented in .net 2.0, which returns the results of an MDX query to a report viewed in Report Manager.
 
This is the error:
 Request for the permission of type 'System.Security.Permissions.EnvironmentPermission, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089' failed
 
If I cut out the code that asserts the need for unlimited FileIOPermissions, then the error changes to:
 
Unable to retrieve security descriptor for this frame
 
So I can't get away with just asserting less permissions. I assume that this is something to do with using MDX in this way.
 

Clearly the permissions on the assembly are inadequate, so I tried updating the rssrvpolicy.config file:
 
<configuration>
    <mscorlib>
        <security>
            <policy>
                <PolicyLevel version="1">
                    <SecurityClasses>
                        <SecurityClass Name="AllMembershipCondition" Description="System.Security.Policy.AllMembershipCondition, mscorlib, Version=1.0.5000.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"/>
                        <SecurityClass Name="AspNetHostingPermission" Description="System.Web.AspNetHostingPermission, System, Version=1.0.5000.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"/>
                        <SecurityClass Name="DnsPermission" Description="System.Net.DnsPermission, System, Version=1.0.5000.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"/>
                        <SecurityClass Name="EnvironmentPermission" Description="System.Security.Permissions.EnvironmentPermission, mscorlib, Version=1.0.5000.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"/>
                        <SecurityClass Name="FileIOPermission" Description="System.Security.Permissions.FileIOPermission, mscorlib, Version=1.0.5000.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"/>
                        <SecurityClass Name="FirstMatchCodeGroup" Description="System.Security.Policy.FirstMatchCodeGroup, mscorlib, Version=1.0.5000.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"/>
                        <SecurityClass Name="IsolatedStorageFilePermission" Description="System.Security.Permissions.IsolatedStorageFilePermission, mscorlib, Version=1.0.5000.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"/>
                        <SecurityClass Name="NamedPermissionSet" Description="System.Security.NamedPermissionSet"/>
                        <SecurityClass Name="PrintingPermission" Description="System.Drawing.Printing.PrintingPermission, System.Drawing, Version=1.0.5000.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a"/>
                        <SecurityClass Name="ReflectionPermission" Description="System.Security.Permissions.ReflectionPermission, mscorlib, Version=1.0.5000.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"/>
                        <SecurityClass Name="RegistryPermission" Description="System.Security.Permissions.RegistryPermission, mscorlib, Version=1.0.5000.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"/>
                        <SecurityClass Name="SecurityPermission" Description="System.Security.Permissions.SecurityPermission, mscorlib, Version=1.0.5000.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"/>
                        <SecurityClass Name="SocketPermission" Description="System.Net.SocketPermission, System, Version=1.0.5000.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"/>
                        <SecurityClass Name="SqlClientPermission" Description="System.Data.SqlClient.SqlClientPermission, System.Data, Version=1.0.5000.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"/>
                        <SecurityClass Name="StrongNameMembershipCondition" Description="System.Security.Policy.StrongNameMembershipCondition, mscorlib, Version=1.0.5000.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"/>
                        <SecurityClass Name="UnionCodeGroup" Description="System.Security.Policy.UnionCodeGroup, mscorlib, Version=1.0.5000.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"/>
                        <SecurityClass Name="UrlMembershipCondition" Description="System.Security.Policy.UrlMembershipCondition, mscorlib, Version=1.0.5000.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"/>
                        <SecurityClass Name="WebPermission" Description="System.Net.WebPermission, System, Version=1.0.5000.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"/>
                        <SecurityClass Name="ZoneMembershipCondition" Description="System.Security.Policy.ZoneMembershipCondition, mscorlib, Version=1.0.5000.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"/>
                    </SecurityClasses>
                    <NamedPermissionSets>
                        <PermissionSet
                                class="NamedPermissionSet"
                                version="1"
                                Unrestricted="true"
                                Name="FullTrust"
                                Description="Allows full access to all resources"
                        />
                        <PermissionSet
                                class="NamedPermissionSet"
                                version="1"
                                Name="Nothing"
                                Description="Denies all resources, including the right to execute"
                        />
                        <PermissionSet
                                class="NamedPermissionSet"
                                version="1"
                                Name="Execution">
                            <IPermission
                                    class="SecurityPermission"
                                    version="1"
                                    Flags="Execution"
                            />
                        </PermissionSet>
   <PermissionSet class="DirectoryServicesPermissionSet"
    version="1"
    Name="DSPermissionSet"
    Description="A special permission set that grants browse access to DirectoryServices">
    <IPermission class="DirectoryServicesPermission"
     version="1"
     Browse=""/>
    <IPermission class="SecurityPermission"
         version="1"
         Flags="Assertion, Execution"/>
   </PermissionSet>
                    </NamedPermissionSets>
                    <CodeGroup
                            class="FirstMatchCodeGroup"
                            version="1"
                            PermissionSetName="Nothing">
                        <IMembershipCondition
                                class="AllMembershipCondition"
                                version="1"
                        />
                        <CodeGroup
                                class="UnionCodeGroup"
                                version="1"
                                PermissionSetName="Execution"
                                Name="Report_Expressions_Default_Permissions"
                                Description="This code group grants default permissions for code in report expressions and Code element. ">
                            <IMembershipCondition
                                    class="StrongNameMembershipCondition"
                                    version="1"
                                    PublicKeyBlob="0024000004800000940000000602000000240000525341310004000001000100512C8E872E28569E733BCB123794DAB55111A0570B3B3D4DE3794153DEA5EFB7C3FEA9F2D8236CFF320C4FD0EAD5F677880BF6C181F296C751C5F6E65B04D3834C02F792FEE0FE452915D44AFE74A0C27E0D8E4B8D04EC52A8E281E01FF47E7D694E6C7275A09AFCBFD8CC82705A06B20FD6EF61EBBA6873E29C8C0F2CAEDDA2"
                            />
   </CodeGroup>
                        <CodeGroup
                                class="FirstMatchCodeGroup"
                                version="1"
                                PermissionSetName="Execution"
                                Description="This code group grants MyComputer code Execution permission. ">
                         <IMembershipCondition
                                    class="ZoneMembershipCondition"
                                    version="1"
                                    Zone="MyComputer" />
                            <CodeGroup
                                    class="UnionCodeGroup"
                                    version="1"
                                    PermissionSetName="FullTrust"
                                    Name="Microsoft_Strong_Name"
                                    Description="This code group grants code signed with the Microsoft strong name full trust. ">
                                <IMembershipCondition
                                        class="StrongNameMembershipCondition"
                                        version="1"
                                        PublicKeyBlob="002400000480000094000000060200000024000052534131000400000100010007D1FA57C4AED9F0A32E84AA0FAEFD0DE9E8FD6AEC8F87FB03766C834C99921EB23BE79AD9D5DCC1DD9AD236132102900B723CF980957FC4E177108FC607774F29E8320E92EA05ECE4E821C0A5EFE8F1645C4C0C93C1AB99285D622CAA652C1DFAD63D745D6F2DE5F17E5EAF0FC4963D261C8A12436518206DC093344D5AD293"
                                />
                            </CodeGroup>
                            <CodeGroup
                                    class="UnionCodeGroup"
                                    version="1"
                                    PermissionSetName="FullTrust"
                                    Name="Ecma_Strong_Name"
                                    Description="This code group grants code signed with the ECMA strong name full trust. ">
                                <IMembershipCondition
                                        class="StrongNameMembershipCondition"
                                        version="1"
                                        PublicKeyBlob="00000000000000000400000000000000"
                                />
                            </CodeGroup>
                            <CodeGroup
                                    class="UnionCodeGroup"
                                    version="1"
                                    PermissionSetName="FullTrust"
                                    Name="Report_Server_Strong_Name"
                                    Description="This code group grants Report Server code full trust. ">
                                <IMembershipCondition
                                        class="StrongNameMembershipCondition"
                                        version="1"
                                        PublicKeyBlob="0024000004800000940000000602000000240000525341310004000001000100272736AD6E5F9586BAC2D531EABC3ACC666C2F8EC879FA94F8F7B0327D2FF2ED523448F83C3D5C5DD2DFC7BC99C5286B2C125117BF5CBE242B9D41750732B2BDFFE649C6EFB8E5526D526FDD130095ECDB7BF210809C6CDAD8824FAA9AC0310AC3CBA2AA0523567B2DFA7FE250B30FACBD62D4EC99B94AC47C7D3B28F1F6E4C8"
                                />
                            </CodeGroup>
                            <CodeGroup
                                    class="UnionCodeGroup"
                                    version="1"
                                    PermissionSetName="FullTrust">
                                <IMembershipCondition
                                        class="UrlMembershipCondition"
                                        version="1"
                                        Url="$CodeGen$/*"
                                />
                            </CodeGroup>
                            <CodeGroup
                                    class="UnionCodeGroup"
                                    version="1"
                                    PermissionSetName="FullTrust"
                                    Name="SharePoint_Server_Strong_Name"
                                    Description="This code group grants SharePoint Server code full trust. ">
                                <IMembershipCondition
                                        class="StrongNameMembershipCondition"
                                        version="1"
                                        PublicKeyBlob="0024000004800000940000000602000000240000525341310004000001000100AFD4A0E7724151D5DD52CB23A30DED7C0091CC01CFE94B2BCD85B3F4EEE3C4D8F6417BFF763763A996D6B2DFC1E7C29BCFB8299779DF8785CDE2C168CEEE480E570725F2468E782A9C2401302CF6DC17E119118ED2011937BAE9698357AD21E8B6DFB40475D16E87EB03C744A5D32899A0DBC596A6B2CFA1E509BE5FBD09FACF"
                                />
                            </CodeGroup>
       <CodeGroup class="UnionCodeGroup"
        version="1"
                                   PermissionSetName="FullTrust"
                                   Name="MyCompany.MIS.Security"
                                   Description="A special code group for my custom assembly.">
       <IMembershipCondition class="StrongNameMembershipCondition" version="1"
        PublicKeyBlob="00240000048000009400000006020000002400005253413100040000010001003F099786BD0BDCD36FF941A6EC9E6612103F15D0D34DF124FF4792C237EF88E88C23C3BAD09A57FAD1C3364003C4C27E7EFA206520286982563134566247AFCFFFDCA1B91B9AA0EBAEA81F20A3BB6769037D882DFB38F9D7FFE2F19B8975C18CED382BC2BB911C7D4B8484B39EE3AC651530A1DDD21DCE50A24EEED613CF8DBA"
                      Name="MyCompany.MIS.Security" AssemblyVersion="3.0.0.4"/>
          </CodeGroup>
                    </CodeGroup>
                </PolicyLevel>
            </policy>
        </security>
    </mscorlib>
</configuration>
 

I've added 'Full Trust' to my specific assembly. The new clause there was generated using caspol.exe so I think it should be correct. However, this made no difference at all to the error!

 
However, if I upgrade Report_Expressions_Default_Permissions (see above) to Full Trust, the problem is 'solved'. Unfortunately giving Full Trust to any and all Report Expressions is not an option.
 
Can anyone help?
 
Dr. Bunsen

View Replies !   View Related
A User Group Account Acting Like A Content Manager And Admin On The Report Manager????
 

A user was created with a limited privilege under the USERS group. Once this user loged in the Report Manager he is acting like an Admin and Content Manager, though he is not given even a browser role.
 
What do u think that this guy is acting like a Super User evenif he is restricted to a browser role on the Report Manager ????????????
 
I did all my best, but no luck so far

View Replies !   View Related
Can No Longer Access Report Manager - The Underlying Connection Was Closed: An Unexpected Error Occurred On A Receive.
 

Hi,
 
For a long time I've had SQL Server 2000 with RS on a Server2003 machine. 
When I want to publish a report from my Dev box, I remove anon. access on the Production machine, deploy the report, then go into report manager to tweak a couple of parameters.  I then re-enable anon. access so users can continue.

 
Yesterday, I removed anon. access and deployed the report but when I went into Report Manager I received the above error message... "The underlying connection was closed: An unexpected error occurred on a receive."

 
I can get into report manager with anonymous access enabled, but I don't have authority to do anything.
 
 
What's happened!!!?   More importantly, how do I fix it?

View Replies !   View Related
Deploying A Report
I'm having a little bit of trouble deploying the report project I have set up. In fact, I'm not even sure that deploying the project is what I want to do. All I want is to have something so I can view the report I've created in HTML or PDF form, something that was advertised when I downloaded the reporting services. Any help with what I would need with this would be appreciated.

View Replies !   View Related
Deploying A Report
I am new to Reporting services and have created just a layout page.

no datasets or data sources are present. This is just a cover page.

 

I need to show this page through a url. Can i deploy this on my local machine rather than showing some-one through the preview mode.

 

What would be the local host configuration settings.

Thanks.

View Replies !   View Related
Deploying A Report
 

Hi,
 
  we are working with Sql Server Reporting services for creating reports. what is my question is , how we can create a setup for deploying the reports in the report server. please advise
 
 
Thanks

View Replies !   View Related
Deploying(Publishing) The Report
Sir,

I have created reports in SQL Server reporting services(SSRS)and when i publish the report in the Localhost server it can be viewed in browser only in the INTRANET network but my intention is to generate the INTERNET URL of the report such that report published can be viewed in INTERNET outside this network..

Can u suggest any solution to do the same..

Looking Forward to an early reply..

Thank You!!!

View Replies !   View Related
Deploying A Report Model
 

First, let me freely admit I know nothing about report models or how to deploy them.  I was trying to learn by going through the tutorials.  The creating part I get, but the deployment part seems to be over my head.
 
The error message I get is "A connection cannot be made to the report server http://hqjds02/Reports."
 
I don't understand why.  Yeah...I get that it can't connect for some reason.  Probably because I have messed things up somehow.

 
This is how I've got the deployment properties set:
 
TargetDataSourceFolder: Development (DV)/Data Sources
TargetModelFolder: Development (DV)/Models
TargetServerURL: http://hqjds02/Reports

 
In searching for an answer earlier I saw where someone wrote that I should be able to go to the URL and copy and paste it from IE.  The actual URL is http://hqjds02/Reports/Pages/Folder.aspx?ItemPath=%2fDevelopment+(DV)&ViewMode=Detail .  I tried it, but it didn't work.
 
What am I doing wrong? 
 
Thanks,
Jennifer

View Replies !   View Related
Having Problems Deploying A Report.
I am working with a MS 2005 SQL Server database.  I have the following error message.  A connection could not be made to the report server http://localhost/ReportServer.  I am trying to develop these on a network server.  Is this a configuration issue, that it is expecting this on the local machine.

 

Thanks!

Terry B

View Replies !   View Related
Problems With Deploying Report Model
Hi,

 

I have a problem with deploying a Report Model.
I've build a RM in Visual Studio and by deploying mij my model, I get the next error:

 

System.Web.Services.Protocols.SoapException: There was an exception running the extensions specified in the config file. --->System.Web.HttpException: Maximum request lenght exceeded.   at System.Web.HttpRequest.GetEntireRawContent()   at System.Web.HttpRequest.get_InputStream()   at System.Web.Services.Protocols.Initialize()   --- End of inner exception stack trace ---   at System.Web. Servoces.Protocols.SoapServerProtocol.Initialize()   at System.Web.Services.Protocols.ServerProtocol.SetContext(Type type, HttpContext context, HttpRequest request, HttpResponse response)   at System.Web.Services.Protocols.ServerProtocolFactory.Create(type type, HttpContext context, HttpRequest request, HttpResponse response, Boolean& abortProcessing)

 

I've got no idea what is wrong.... anyone an idea???

View Replies !   View Related
Problem While Deploying Report On Server
Deploying to http://localhost/ReportServer
Deploying data source '/Report Project1/cnt_SDS_REQUEST'.
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.

View Replies !   View Related
SSRS 2000 Deploying Report
windows 2003 SP2 with AD, IIS with SSL, SQL 2000 SP4, RS SP2.

I am trying to deploy a report from visual studio .net 2003.  Error message: not able to connect to https://servername/reportserver
I can access the reporting website on IE https://webserver/reportserver, and I can up load reports with site interface, but can't use designer 2003 to deploy.

any suggestions?

Thanks,

Jaime B.

View Replies !   View Related
Problem In Deploying A Report To Localhost
A report runs successfully on report design and successfully complete the build process but when I clicked Deploy button
an error message came out:

Microsoft Report Designer
A connection could not made  to the report server http://localhost
Additional information:
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)
 

What is the problem and how to solve it.
 
Thanks

View Replies !   View Related
Deploying A Report To The Main Server
 

I have created several reports using SSRS which is installed  in my local machine. But source data base is in the main server. Data source connection works properly. Report manager is also configured to local machine.
 
Now I tried to deploy these reports to main server. So I changed the target URL to http://mainservername/reportsserver in the internal report property change box. But it was not succeeded. I get a error message like this.
 
 

------ Build started: Project: Partner Reports -Internal, Configuration: Production ------

Build complete -- 0 errors, 0 warnings

------ Deploy started: Project: Partner Reports -Internal, Configuration: Production ------

Deploying to http://derby/ReportServer

Error rsRPCError : The report server cannot decrypt the symmetric key used to access sensitive or encrypted data in a report server database. You must either restore a backup key or delete all encrypted content. Check the documentation for more information. (rsReportServerDisabled)

Deploy complete -- 1 errors, 0 warnings

========== Build: 1 succeeded or up-to-date, 0 failed, 0 skipped ==========

========== Deploy: 0 succeeded, 1 failed, 0 skipped ==========

 
Reporting services was already installed in main server. Do I have to change settings of report configuration manager in my local machine?

View Replies !   View Related
Deploying Report In Windows Authentication Mode
Hi,
I installed sql server express edition 2005 in my system and configured with windows authentication mode. I designed report using Business Intelligence Development Studio and i got preview of report well. But while deploying it asking for Username and Password. I tried with Domain username and password in which i logged in.

I tried in another way also. Through report manager (http://localhost/reportserver) i uploaded data connection and report. uploaded successfully and viewed report in report manager. but when i am connecting report through report viewer, i am getting error message that HTTP Status 404 : Not Found.

Could any one help me in solving this problem.

i also changed credentials to windows authentication mode, service mode in report server configuration...but no use..

View Replies !   View Related
Problem Deploying Custom Report Item
Hello,
 
I am having a problem with deploying a CRI.
On my local machine the CRI works fine, only at the development machine it doens't works.
I did the following steps:


copy the .dll to the C:Program FilesMicrosoft Visual Studio 8Common7IDEPrivateAssemblies

copy the .dll to the C:Program FilesMicrosoft SQL ServerMSSQL.4Reporting ServicesReportServerin

put this code in rsreportserver.config:
<ReportItems>
<ReportItem Name="BusinessConnectDiagram"  type="LogicaCMG.BusinessConnect.DiagrammingCRI.GenerateDiagramRenderer,LogicaCMG.BCDiagramming"/></ReportItems>

put this code in rssrvpolicy.config:
<CodeGroup
class="UnionCodeGroup"
Version="1"
 PermissionSetName="FullTrust"
                Name="BusinessConnectCodeGroup"
                Description="Code group for the Business connect diagrammer">
                <IMembershipCondition
                                class="StrongNameMembershipCondition"
                                version="1"
                PublicKeyBlob="002400000480000094000000060200000024000052534131000400000100010051C346CB2A79947C83804E550CF1561729DB2B5C7DEFF93758E419F16390A295DF4906ADD8FD9A29559D5E3C8BFA73D8D21B64724B1B0E688091C1541FD54D5290D6968C73E9ACA842B1E42AB3DE369F7B545933C8E101A737BB7D22F937921E7F02E00C5121D1DC312DBE96154E5A4E47BD7F489A655A09CF08EABCFB6AB7C1"
/></CodeGroup>

put this code in rsreportdesigner.config
<ReportItems>
<ReportItem Name="BusinessConnectDiagram"  type="LogicaCMG.BusinessConnect.DiagrammingCRI.GenerateDiagramRenderer,LogicaCMG.BCDiagramming"/>
</ReportItems>
<ReportItemDesigner>
<ReportItem Name="BusinessConnectDiagram" Type="LogicaCMG.BusinessConnect.DiagrammingCRI.GenerateDiagramDesigner,LogicaCMG.BCDiagramming" /></ReportItemDesigner
I get the following error message:
Could not load file or assembly 'ReportingServicesWebServer,
 
Also when i stop Reporting Services it won't start again. I get a timeout.

View Replies !   View Related
Problem Deploying A Report To Wss 3.0 Document Library
After configuring SSRS integration with SharePoint (MOSS 2007) I am unable to deploy a report from visual studio to a document library. The error message from visual studio is "The file you are attempting to save or retrieve has been blocked from this Web site by the server administrator." and "A connection could not be made to the report server <http://sharepoint server link>".  I have verified that .rdl, .rds and .rsds files are not blocked in SharePoint. Does anyone have ideas what this might be? Are there other file types I need to worry about?

 

 

View Replies !   View Related
Problems To Log In When Deploying Report In Remote Server
Hello.

I have a Remote Sql server running the Report Server. I create my reports and when i try to deploy them, it asks me for a Login and Password for the Report Server. I have tried every possible login, even sa sql administrator and nothing seems to be working.

Does anyone knows what i am missing here?

Thanks in advance.

Jose

View Replies !   View Related
Problem Deploying Subreports With Main Report
Hi All,

Here's my problem. I have an SSRS report with subreports on it. The main report and subreports work fine on my machine when I run the main report. However, when I deploy them to our test server and change the server name of the shared datasource, only the main report brings back data. The subreports show an error of something like "Error in displaying the subreport" for each subreport. The subreports require parameters that I believe I am supplying from the main report. What am I doing wrong? Is it really necessary to deploy the subreports with the main report to the new server. With Crystal Reports, I didn't have to do this. Any thoughts or suggestions would be appreciated.

View Replies !   View Related

Copyright © 2005-08 www.BigResource.com, All rights reserved