I created a report in another project and it is loading through the web server. Now I want to access that report through a
web project that is using the reportviewer control. Now how do I setup the reportviewer to access that existing report on web server? I don't think you would have to have the report actually added to the web project do you? When I hit this page no report comes up.
Here is MicroSofts ReportViewer Control defined in my web form:
I'm very new new at this. I'm try to deploy a report model and got this message. I have no idea what its going on about.
Can anyone help me?
Aku
------------------------------
System.Web.Services.Protocols.SoapException: 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) ---> Microsoft.ReportingServices.Diagnostics.Utilities.RPCException: 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) ---> System.Exception: 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) ---> System.Exception: 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) ---> System.Exception: 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) ---> System.Exception: 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) ---> System.Exception: Bad Data. (Exception from HRESULT: 0x80090005) --- End of inner exception stack trace --- --- End of inner exception stack trace --- --- End of inner exception stack trace --- --- End of inner exception stack trace --- --- End of inner exception stack trace --- at Microsoft.ReportingServices.Diagnostics.DataProtection.ProtectData(Byte[] unprotectedData, String tag) at Microsoft.ReportingServices.Library.ConnectionManager.ConnectStorage() at Microsoft.ReportingServices.Library.Storage.NewStandardSqlCommand(String storedProcedureName) at Microsoft.ReportingServices.Library.DBInterface.GetAllConfigurationInfo() at Microsoft.ReportingServices.Library.RSService.GetSystemProperties(Property[] requestedProperties) at Microsoft.ReportingServices.WebServer.ReportingService.GetSystemProperties(Property[] Properties, Property[]& Values) --- End of inner exception stack trace --- at Microsoft.ReportingServices.WebServer.ReportingService.GetSystemProperties(Property[] Properties, Property[]& Values) (System.Web.Services)
I'm using SQL Express with Advance Services & I get this error when I try to deploy my reports. Why do I get this error
An error has occurred during report processing. (rsProcessingAborted)
Cannot create a connection to data source 'EDPSYS'. (rsErrorOpeningConnection)
The feature: "Remote access to report data sources and/or the report server database" is not supported in this edition of Reporting Services. (rsOperationNotSupported)
I have a problem that I'm hoping someone can give me some advice with: I have created a website that uses .Net 2.0, SQL 2005, and ASP.NET Membership to manage users. Everything works fine until it comes to calling reports, in particular setting report parameters:
Exception Details: Microsoft.Reporting.WebForms.ReportServerException: The permissions granted to user 'NT AUTHORITYNETWORK SERVICE' are insufficient for performing this operation. (rsAccessDenied)
Source Error:
Line 30: End If Line 31: Line 32: Me.rvInvoice.ServerReport.SetParameters(p) Line 33: Me.rvInvoice.Visible = True Line 34:
The report worked fine before the security model was changed to use the Membership classes which leads me to conclude that I have not configured the Report Server to deal with the network account that the ASP pages are now using.
I have looked at the example project for configuring extensions with no success. Any help would be greatly appreciated.
Ive finally gotten my report server setup to run. I can access the reports via IIS from a remote computer if I login as the server administrator. Ive given certain users permissions to the /Program Files/sql server/Reporting Services/ folder, however, when I try to enter their login info, from the IIS login prompt when i visit http://servername/ReportServer/ I am unable to login. How do I grant users permission to login to report server?
Hi, I'm a beginner on SQL Server Reporting Services field. I perform a full installation of SQL Server 2008 CTP6 Developer Editon on a clean Windows Server 2008 Enterprise machine. I log on to the machine using the built-in Administrator account so there is no UAC stuff. The Enhanced Security Configuration of IE is disabled. When I want to have a look at the Report Manager by typing http://localhost/Reports, it pops up an error says "The underlying connection was closed. Could not establish trust relationship for the SSL/TLS secure channel." It makes me confused so any help or suggestion is highly appreciated.
The following is a fraction of log file from Reporting Services: ... ReportingServicesService!resourceutilities!b5c!03/08/2008-14:25:57:: i INFO: Reporting Services starting SKU: Developer
ReportingServicesService!resourceutilities!b5c!03/08/2008-14:25:57:: i INFO: Evaluation copy: 165 days left
ReportingServicesService!appdomainmanager!4e4!03/08/2008-14:28:15:: i INFO: Appdomain:3 ReportManager_0-1-128494312954554272 started.
ReportingServicesService!appdomainmanager!4e4!03/08/2008-14:28:18:: i INFO: RS authentication mode is 5; effective ASP.NET authentication mode is Windows. vdir=/Reports.
ReportingServicesService!appdomainmanager!4e4!03/08/2008-14:28:18:: i INFO: Appdomain:3 ReportManager_0-1-128494312954554272 initialized (#1).
ReportingServicesService!appdomainmanager!e10!03/08/2008-14:28:26:: e ERROR: Remote certificate error RemoteCertificateNameMismatch encountered for url https://localhost/ReportServer/ReportService2005.asmx.
ReportingServicesService!ui!e10!03/08/2008-14:28:27:: e ERROR: The underlying connection was closed: Could not establish trust relationship for the SSL/TLS secure channel.
ReportingServicesService!ui!e10!03/08/2008-14:28:27:: e ERROR: HTTP status code --> 500
-------Details-------- System.Net.WebException: The underlying connection was closed: Could not establish trust relationship for the SSL/TLS secure channel. ---> System.Security.Authentication.AuthenticationException: The remote certificate is invalid according to the validation procedure. at System.Net.Security.SslState.StartSendAuthResetSignal(ProtocolToken message, AsyncProtocolRequest asyncRequest, Exception exception) at System.Net.Security.SslState.CheckCompletionBeforeNextReceive(ProtocolToken message, AsyncProtocolRequest asyncRequest)
Can someone provide me some hints or useful links on user access throguh a report server? Here is the situation:
MachineA: (My Machine) running Windows XP professional with full SQL Server 2005 installed
MachineB: running Windows 2003 Server with full SQL Server 2005 installed
MachineC: a user machine running Windows XP professional .
All the machines are connected within the same LAN.
I created a report - on MachineA with a data source called 'DataSource1' that points to an analysis database located in MachineB. I deployed the report to the reporting service on MachineA. I have no problem to view the report on my web browser on MachineA through http://localhost/reportserver. Now I let a user to view the report on on MachineC through http://MachineA/reportserver. She can see my report. However, when she clicks the report, she got the following error: An error has occurred during report processing. (rsProcessingAborted) Cannot create a connection to data source 'DataSource1'. (rsErrorOpeningConnection) For more information about this error navigate to the report server on the local server machine, or enable remote errors
I tried many ways to fix the problem, and got no solution. She sees my report so she can access my report server. She has enough access right to the analysis database and cubes and dimensions. She can use her Management Studio to connect to it and browse the cube. She just can not open 'DataSource1'. I would really appreciate if someone can share some knowledge or recommend me some useful resources that explains the access/security control via Web Service -> Report Server -> Analysis Cubes. There are so many places to configure the access/security: IIS, Report Manager (Roles), the OLTP server that hosts Report Server databases (ReportServer and ReportServerTempDB), and the Analysis database (also called roles). I really get confused: how do they work together?
I'm trying to conncet to Report Server with Non-Administrator user through WMI in compliance with this document: http://msdn2.microsoft.com/en-us/library/ms365170.aspx
When I try to get Instances from MSReportServer_Instance class I get an exception:
In my C# project i have an exception:
System.Runtime.InteropServices.COMException (0x8000000A) at System.Runtime.InteropServices.Marshal.ThrowExceptionForHRInternal(Int32 errorCode, IntPtr errorInfo) at System.Management.ManagementObjectCollection.ManagementObjectEnumerator.MoveNext()
But, when I give the account Domain Administrators rights all works ok.
What additional rights must I give to the account?
I've been unsuccessful getting Reporting Services 2005 to work after reinstalling SQL 2005. The RS service cannot connect to its database, as reported in the Event Log. If I visit http://localhost/Reports, I get the error "Key not valid for use in specified state. (Exception from HRESULT: 0x8009000B) (rsRPCError)"
I've used the RS Config Mgr to create a fresh database for it named SSRS (and SSRSTembDB), and it is set to use Service Credentials in the db connection. The RS service is running using the same admin account as MSSQL, .SQLExec. I have confirmed that .SQLExec is in the RSExecRole role in the SSRS database.
When I created the SSRS database, the Config Mgr had a green check for every step except the last. For "Setting Connection Info for the Reporting Server" there was a yellow '!', with the explanation, "Although saving the database connection succeeded, the report server cannot access internal information about this deployment to determine if the current configuration is valid for this edition. ..."
I examined rsreportserver.config to look for any issues. The <dsn> element has an encrypted string, the <ConnectionType> element says "Default", and the logon elements are empty. I could not find the db names, SSRS and SSRSTempDB, anywhere in the file. Where are these kept? I don't know what else to look for.
Also, in RS Config Mgr, the 'Encryption Keys' page has a blue '!', and only the 'Restore' and 'Delete' buttons are enabled. The 'Initialization' page has a red 'X'. The local RS is not listed (the grid is empty), and clicking the 'Initialize' button does nothing.
I receive the following error when i call report server web service from an asp.net application:
"The request failed with HTTP status 401: Unauthorized."
Here are the IIS logs on the reporting services server. When i open IE and browse to the web service i provide my user credentials and i can access the web service just fine. However when i call the web service via my asp.net application it looks like my credentials are not being passed??
I just changed my Access 2002 database to a SQL Server ADP project. Ihad a form where the user entered a value into a text box and when acommand button on the form was clicked a Report was opened. The reportsrecord source is a query. The query uses the value from the form textbox to restrict the query.Table name = EggsTableone of the columns in the table is named: EggColorForm name = EggColorFormForm text box name = ColorTextBoxThis sql worked for the query before I converted to SQL:SELECT EggsTable.EggColorFROM EggsTableWHERE (((EggsTable.EggColor)=[Forms]![EggColorForm]![ColorTextBox]));This no longer works. Can I change the syntax somehow to get this towork? I tried dropping the brackets around the word "Forms", I trieddropping all the square brackets, etc., nothing worked.I also tried just opening the report with the report's Server Filterproperty set to:EggColor=N'Forms.EggColorForm.ColorTextBox'I tried using the Report's open event to pass the form value directlyto the report. I tried setting a variable from the text box value onthe form. So far, nothing works. Any ideas?
what is MS's strategy for having two off the shelf ways of getting at reports? In a typical company, is the average non administrator type user getting at his reports via one, the other, both?
I've set up a report server on IIS on my local machine using SSRS 2005. All is well in the world--it shows up, and I can publish reports and have them display successfully.
However, I'm trying to publish a couple of reports based on an Access database--and this is where the problem lies. The reports run perfectly in Visual Studio, which is on the same machine as the report server. Thus, I can deduce that the ODBC connection to the Access database is set up properly. There are no errors on the report, which means that the reports are set up correctly. I've spent the last day researching the problem, but nothing I've tried thus far (from putting the Access database in a shared folder to changing security on the file and report server to rebuilding the reports from scratch) works. The exact error is given below, with the data source name changed:
An error has occurred during report processing.
Cannot create a connection to data source 'MyODBCDataSource.
ERROR [HY024] [Microsoft][ODBC Microsoft Access Driver] '(unknown)' is not a valid path. Make sure that the path name is spelled correctly and that you are connected to the server on which the file resides. ERROR [IM006] [Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failed ERROR [HY024] [Microsoft][ODBC Microsoft Access Driver] '(unknown)' is not a valid path. Make sure that the path name is spelled correctly and that you are connected to the server on which the file resides. Can anyone suggest something I missed? I'm stumped on this one.
Edit: Just to clarify, EVERYTHING is on my local machine--the web browser I'm viewing from, IIS, SSRS 2005, the Access database, the ODBC connection (in the System DSN), everything.
SQL Server Reporting Services 2005 (SSRS) is installed on Vista Ultimate. I cannot access to the http://localhost/ReportServer page. IE posts an internal error HTTP 500.0 (after IE required a Windows account). All the configurations of Reporting Services are OK. In the Log file, there is nothing: the Web Services does not seem to be launched.
By continuing the investigations in IIS 7 (activation of the €śRules of follow-up of the requests having failed€?, I found the error following:
Translation of the french sentence: ErrorCode="Incorrect syntax of the file name, the directory or the volume."
I made a full research on Internet and in the documentation at my disposal and I did not find anything which can advance me towards a beginning of solution€¦
Thank you with all for the assistance which you will be able to bring to me.
Is there any way to get more information for when IAuthorizationExtension::CheckAccess fails to grant access to a report item for the current user? Specifically, it would be useful to know:
1. URL of attempted report 2. IP address of user agent 3. Identity of current user 4. Date/Time of the failed attempt
I need to prevent domain and local administrators from having full control over our report manager. (I want them to be assigned permissions just like everyone else, some reports they can see other reports they can not.)
How can I accomplish this? I tried going into Report Manager -> Site Settings -> Configure Site Wide Security and re-assigning BUILTINAdministrators to the System User role instead of the System Administrator role. (A different set of report manager admins was given the system administrator role).
However, it appears that members of the BUILTINAdministrators group still have full control in Report Manager.
Hello, I'm using Reporting Services to render a text (stored in sql as varchar(max)). The text is all plain text, with some lines having trailing spaces.
Source text file i've imported to SQL via SSIS: CLIENT: 10055 STATEMENT 2007 DATE:1002993 THIS IS THE OTHER STATEMENT COLUMN1 COLUMN2 COLUMN 3 TRY THIS
*Note the trailing spaces on the line before 'STATEMENT 2007'.
I've designed a report using the Report Project in VS2005 to retrieve this text via a stored procedure. When I test the report using the 'Preview' tab in the IDE, it looks good CLIENT: 10055 STATEMENT 2007 DATE:1002993 THIS IS THE OTHER STATEMENT COLUMN1 COLUMN2 COLUMN 3 TRY THIS
But when I deploy the report and run it using URL Access:
CLIENT: 10055 STATEMENT 2007 DATE:1002993
THIS IS THE OTHER STATEMENT
COLUMN1 COLUMN2 COLUMN 3 TRY THIS
On all lines with trailing spaces, they (the trailing spaces) have been removed. This is affecting my formatting of some reports and statements. We really want to use the report viewer as it has built in paging, print and export capabilities.
Why does it look okay in VS2005 but different in Report Viewer via URL Access and Report Manager?
Note: When I export as PDF, it looks okay.
The stored procedure I use to return the data is a CLR Hosted assembly as below:
Code Snippet Partial Public Class StoredProcedures <Microsoft.SqlServer.Server.SqlProcedure()> _
Public Shared Sub GetPagedDocument(ByVal inText As SqlString) Dim dr As SqlDataReader Dim row As New SqlDataRecord(New SqlMetaData("RowText", SqlDbType.Text)) Dim cmd As New SqlCommand("select cast(doc as varchar(max)) as 'DOCTEXT' from testdoc WHERE id='" + inText + "'") Dim cn As New SqlConnection("context connection=true") cn.Open() cmd.Connection = cn SqlContext.Pipe.SendResultsStart(row) 'initialise the resultset to be returned dr = cmd.ExecuteReader 'If no records in result set, return. If Not dr.HasRows Then
row.SetString(0, "There is no document to display or you do not have permission to view the document.") SqlContext.Pipe.SendResultsRow(row) SqlContext.Pipe.SendResultsEnd() ' SqlContext.Pipe.Send("There is no document to display.") Return End If 'Read rows in the result set dr.Read()
'Get the entire text Dim docText As String = dr.Item("DOCTEXT") 'debug row.SetString(0, docText) SqlContext.Pipe.SendResultsRow(row) SqlContext.Pipe.SendResultsEnd() Return 'end debug
I am setting up the SQL2005 reporting service to let users build their own reports on the web. I'll provide them with pre-built report models. We have concern with SQL database performance by allowing users to execute huge reports. The problem that I have is: If I give the users permissions to build report they'll have access to the report's Properties | Execution page, which allows them to disable the report execution timeout. Is there a way for me to allow them build reports while restrict them to access the report execution timeout settings?
I have search all around the net, trying to get a solution for my application under MS Access 2003, I developed a database that generates a report, this report will need to be accessed trough the internal network, perhaps we don't want any user to have direct access to the database itself, and also we don't want to have to manually posted the report in the shared folder, we want to set up this to be done automatically and the end user won't need to have MS access in their pc, perhaps exporting the report as an spreadsheet instead. I try by using Macros within Access but this will only work manually from the .mdb file. I also check what options do I have if I use Javascript but I don't think it will work either, since I'm not using Crystal Reports. Can you please provide me with some guidance, if this is actually possible from a database/report under MS Access 2003.
I have report that in access 97. When i run that report every morning, it's update technician time, mileage and money. I want that report to be update every min like real time report in sql reporting service. can u tell how i can do that?
I have one table used to maintain information on Service Events.Each record contains a Repair, Maint, and Battery checkbox(bound/boolean). Any one of these fields may be checked or left empty.Ex. REPAIR=True, MAINT=False, BATTERY=TrueI want to generate ONE report that lists all the REPAIRS, then listsall the MAINT, and then lists all the BATTERY events. One group afterthe other in the same report. Because (ex. REPAIR and BATTERY) mayboth be true in the same record, the record will appear 2 times in thereport, once in the REPAIR group and once in the BATTERY group.I am not sure how to approach this. I'm new to SQL. I' m using MSAccessSQL.I Tried the following code, but the results are not sorting properlyand not grouped.SELECT * FROM [TABLE1] WHERE [REPAIR]UNION ALLSELECT * FROM [TABLE1] WHERE [MAINT]UNION ALLSELECT * FROM [TABLE1] WHERE [BATTERY]
We are planning on using 2005 report services. Im wondering how I can feed reports to my asp.net web application that resides on a different machine.
The scenario is: user -> IIS web app -> report on sql
I guess the real question at this point for me, is if I have reports - can I have them cached in pdf format and then how are they accessed with a url ?
The main thing i want to know is how to import report from access 97 to sql reporting service. I am not really familiar with reporting services in sql, can you be little more specific where to set up time? The report only update when i run query every morning. Queries and Tables are in access 97. When i tried to migrate tables with ssma, i wan not able to convert all of the query.
We recently upgraded to SQL Server 2005, we've added SSRS to same server. This server is an internal SQL server. I can access to the reports from http://localhost and http://servername/ but how do I access reports I've created from outside of the domain? Does SSRS needed to be installed on an server with IIS and SQL Server 2005 that we can get to from outside? Please help! Thanks.
I am running SQLExpress 2005 with Advanced Services SP2 I used the Reporting Services Configuration Tool to manually instal Report Manager to its default virtual directory. Got no error message. So far so good, but when I tried to start the manager by writing the URL (http://localhost/reports) in the address bar of my browser (iexplorer 7.0), I got the following error message:
XML-siden kan ikke vises Kan ikke vise XML-inndata ved hjelp av XSL-stilark. Rett opp feilen og velg deretter Oppdater eller prøv på nytt senere. Et navn ble startet med et ugyldig tegn. Feil under behandling av ressursen http://localhost/reports. Linje 1, Posisjon 2 <%@ Page language="c#" Codebehind="Home.aspx.cs" AutoEventWireup="false" Inherits="Microsoft.ReportingServices.UI.HomePag...
It is in norwegian so I try to translate it to the best of my ability: XML can't be translated by means of XSL style sheet. Invalid charater. Error occurred handling the resource http://localhost/reports Line 1 Posistion 2 <%@ Page language="c#" Codebehind="Home.aspx.cs" AutoEventWireup="false" Inherits="Microsoft.ReportingServices.UI.HomePag... There is a squiggly line under "c#" and "codebehind" as well.
I know very little of XML and XSL. What amends can I do to access the Manager? Please help somebody. Is it possible to use the Reporting Services Configuration once again to instal the Manager to another location?
I have just installed Reporting Services on a 2 server web farm. I can access http://virtualserver/reportserver but when I try to access http://virtualserver/reports, I get the following: The page cannot be found
The page you are looking for might have been removed, had its name changed, or is temporarily unavailable.
Please try the following:
Make sure that the Web site address displayed in the address bar of your browser is spelled and formatted correctly. If you reached this page by clicking a link, contact the Web site administrator to alert them that the link is incorrectly formatted. Click the Back button to try another link. HTTP Error 404 - File or directory not found. Internet Information Services (IIS)
Technical Information (for support personnel)
Go to Microsoft Product Support Services and perform a title search for the words HTTP and 404. Open IIS Help, which is accessible in IIS Manager (inetmgr), and search for topics titled Web Site Setup, Common Administrative Tasks, and About Custom Error Messages.
Hi My project is in .NET 2003 i.e. framework 1.1 and database in SQLServer 2000. But the reports have been developed using SQLServer 2005 Reporting Services. Now when I am trying to deploy them through deployment project of .NET its giving me following error:"Using other editions of SQL Server for report data sources and/or the report server database" is not supported in this edition of Reporting Services. Now I am really confused with this. Can any one please guide me regarding this ASAP. Thanks, Falguni
I got through the installation hoops for SQLEXPRESS Reporting Services in Vista and set up the default configurations in Report Services Configuration. I can explore the default directory for "Reports" in IIS7, but I can't browse in IE. I get the "The report server is not responding. verify that the report server..." message in the browser. This is after I migrated the app per the initial http 500 error using the preferred method - %systemroot%system32inetservAPPCMD.exe migrate config "Default Web Site/Reports".
I'm running Vista Ultimate, VS2005, SQLEXPRESS SP2. I've tried running IE as admin and also I've disabled UAC from gpedit.msc - ...Windows SettingsSecurity SettingsLocal PolicySecurity Options and unchecking UAC.
I have a database and a dvr that has movies that correspond to the data in the database. Is there a way to run a report and then by selecting a record in the report access the movie that pertains to that record?
