Hi,
Does anyone know how to change the Appearance of the Report Manager Homepage
i.e http://Localhost/Reports
Basically I want to add some Images instead of the Blank SQL Server RS Homepage.
Thanks in Advance for your Help,
Regards,
Sundar
Afternoon everyone,
Just a quickie. Besides creating a new folder and using the folder description, is there a way to display a message on the report manager home page?
I'd like to display a quick message in large bold font about how users can get Reporting Services Support.
Thanks,
Paul
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
Hi,
My Reportserver Homepage is http://d620xp/Reports
Requirement is that Users should be able to view all the reports from this URL( from their Desktops)
What are the steps I need to do, to get this ?
Thanks in Advance,
Sundar
I have a package that I plan to run against about 700 databases to look for anomalies. I have several package variables in place that are passed in at runtime. One of them will hold the path and filename of the error log for the current database in process. I want each database to generate it's own error log for documentation and research purposes. However, when I run the package, it continues to use the path and filename that I entered when I created the File Connection Manager. I am trying to update that value in a Script Task by using the ConnectionManager class and setting the value for the "ConnectionString" property. This method is working for the OLEDB Connection Manager (which tells the package which Access database to process), but not for my File Connection Manager. Please help!
DO
I originally developed SSIS packages with the destination DB to be SQL Server 2005 for unit testing on my desktop. We are planning on deploying to Oracle. After changing the Provider and other attributes in the configuration file the package loads, however there are lots of issues. The primary one is that the mappings are gone. I'm not sure if that is the result of how the table names are stored "Oracle"."File" versus [SQLSERVER].[File] . Even after attempting to change the way the table names appear I still get the message "the external metadata column is out of sync with the data source columns". Then it lists all of the columns that need to be added.
Is there any way to accomplish this that you are aware of.
Thanks
John Shaening
I got an error while deploying my report: The permissions granted to user machineNameuserName are insufficient for performing this operation. After reading the posts in the forum, I realized that my RS setup may be incorrect. On http://localhost/reports, Contents and Properties tabs are missing... Please let me know how I can correct the problems.
I am using SQL Server 2005, and I have admin rights on my local machine
Hi all,
I have installed SQL Server 2005 Express Edition with Advanced Services and also Toolkit in my system. Following which I cofigured the Reporting Services Configuration.
When I try http://localhost/Reports it throws the following error.
---------------------------------------------------------------------------------------------------------------------------------------------------------------------
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) (rsRPCError) Get Online Help
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)
Bad Data. (Exception from HRESULT: 0x80090005)
---------------------------------------------------------------------------------------------------------------------------------------------------------------------
I have tried to search exhaustively for the solution and nothing seems to be crystal clear in solving the above error.
Under Reporting Services Configuraiton Manager (RSCM) all are ticked excepting:
Initialization, SharePoint Integration,Encryption Keys, EMail Settings,Execution Account.
Before this unknowingly I have changed "Windows Service Identity" during configuration which is not the same as Web Service Identity. Under "Web Service Identity" ASP.Net Service Account is listed as <machinename>ASPNET.
Now under "Windows Service Identity" it is selected to "Windows Account" : homequinn. After reading the installation steps it is suggested to have it with "Buil-in Account" ->"Network Services" is recommended. When I try to change it asks me for password and key file. Once I provide it, it is throwing me the following error.
---------------------------------------------------------------------------------------------------------------------------------------------------------------------
ReportServicesConfigUI.WMIProvider.WMIProviderException: 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)
at ReportServicesConfigUI.WMIProvider.RSReportServerAdmin.ThrowOnError(ManagementBaseObject mo)
at ReportServicesConfigUI.WMIProvider.RSReportServerAdmin.BackupEncryptionKey(Byte[]& encryptedBytes, String password)
---------------------------------------------------------------------------------------------------------------------------------------------------------------------
Can someone tell how should I proceed to get the reporting services working.
I have done the following and a domain user would not access report created a login to the SQL server to the user (this SQL Server is where data source DB is)went to site setting in Report Manager and made this use a system userright clicked on report folder and made this user in the browser roleeven checked that in the report in question, the user is already in the browser role Still the user would not access the report! "User .......... does not have required permission" is the error message I am getting.
View 6 Replies View RelatedI have written a report visual studio. The report has 10 multi-value parameters that pull data from their individual data sets within the reports. When running the report from within Visual Studio it renders fine. There are no errors reported, only a warning related to a pathname I have use to retrieve image data and display on the report.Deployment of the report is error free.When I view the report I briefly get the "Loading" splash window, but then nothing. None of the headers or static text is displayed. The results window is blank.
The report defaults all the parameter values. In trying to debug the issue I have found by reducing the number of parameter values the report will render. Once I have all the values added, the report does nothing.Below is the query being used for the report. The where clause in the query shows the parameters being used and the syntax.We are running on Windows Server 2008 R2 and SQL Server 2008 R2.
Ralph
SELECT RTRIM(a.ITEMNMBR) AS Style, RTRIM(a.ITEMDESC) AS Description, a.ITMSHNAM AS UPC, c.LOCNCODE AS Store, d.LISTPRCE AS ListPrice, a.CURRCOST AS Cost,
a.USCATVLS_1 AS [Main Category], a.USCATVLS_2 AS Market, a.USCATVLS_3 AS [Alternate Retail], a.USCATVLS_4 AS Country, b.ITEMXTRAS_1_Type AS Type,
b.ITEMXTRAS_2_Finish AS Finish, b.ITEMXTRAS_3_SubCategory AS SubCategory, b.ITEMXTRAS_4_Department AS Department,
[code]...
I am working on reports in SSRS 2008 (not R2)... There are some reports with parameters that are hidden when the report is accessed through normal URL using ReportViewer.asx..The thing is that these hidden parameters need to be visible when the report is accessed using SSRS Report Manager.
View 3 Replies View RelatedHi,
I'm trying to deploy Reporting Services on an Internet-facing web server using a custom security extension (forms authentication). We will be putting Report Manager on the Web Server outside of the firewall, and Report Server on another machine inside the firewall. When testing the solution in a development environment with Report Manager and Report Server on the same box, the solution works fine.
When testing it using the Internet-facing environment described above, it almost works but there seems to be an issue with the authentication cookie that is generated. Here's what happens:
1. User enters credentials on UILogon.aspx and submits form.
2. In the code-behind, LogonUser() is called through a web service proxy and the authentication cookie is returned successfully. The code used here to set the cookie is the same code used in the Forms Authentication sample that ships with RS2005.
3. The user is redirected to Folder.aspx, and the request hangs for a while, and eventually kicks you back out to UILogon.aspx, as if it lost the authentication cookie. When doing a trace on the HTTP header, the cookie is still there.
Is there anything special I need to do to make the Report Server "see" the cookie when I have Report Manager and Report Server on different machines?
Any help would be much appreciated!
Mike
Hi,
I am unable to launch report builder from the report manager from a client machine. But I am able to launch from the localhost.
Even I am able to launch report builder by clicking reportbuilder.exe on the local machine.
Please help !!
OS - Windows XP professional
SQL Reporting Services 2005.
Hello everyone,
I created a custom assembly using C# to transform some binary data into text, and in this assembly I used one win32 dll developed by our customer to help me to do the tranformation.
The code I used to call the win32 dll is like below:
[DllImport("tdasuie.dll", EntryPoint = "AlrtLogConditionToText",
ExactSpelling = false, CharSet = CharSet.Auto, SetLastError = true)]
private static extern UInt32 AlrtLogConditionToText(Byte[] pbCondition, StringBuilder pszText, UInt32 dwSize);
I defined a C# method to call the above win32 method and return a string. Then in the report, I called this C# method to get the correct string.
In the report designer, the C# method in the custom assembly can return the correct string in the preview window. But after I deployed the report into the report server, the textbox will only display "#error" in the report manager web page.
Can anybody help me on it? Thanks a lot.
Danny
I am getting the following error when I attempt to deploy my test report.
"Failed to Deploy Report, The user 'XXX/IUSR_XXX' has insufficient rights to perform this action."
Has anyone gotten this error before, I have tried every permission option I could with the IUSR account by adding it to each folder etc ...and still get no resolve. Anyone have a fix for this bug ?
Responses are much appreciated!!
I have few reports under different folders in Report Manager. Is there a way to set the data source for the whole folder rather than each report individually? There is also a folder where reports generate dynamically. Since the report project doesn't exist anymore, I can't set the data source through code. How can I set the data source for the whole folder?
View 7 Replies View RelatedCan a person change the page title from "Report Viewer/Manager" to the actual report name?
View 3 Replies View RelatedHI, there,
I added a new windows user "ReportUser" which is a local user (not in administrator group). When I connect to the report manage's web page, I use reportuser to log in (when the anonymous access is disabled it will ask a log in). Report builder icon is not showing up on the report manager home page.
If I log in as a user in administrator group, the reportr builder icon shows up so I can download it and build report.
I have assigned reportuser "Content manager" and "repoter builder" access to the home folder. Is there anything else I have to do to make the report build icon show up on the home page?
Thanks
Jack
I was able to log in to SSRS report manager. But i was unable to run a report i designed on report builder.
It prompts for login when i wanted to run the report and i used the same windows authentication to sign in
It will show me the parameters but when i click on view report it gives this error
"Data source 'DataSource1': An error has occurred.
Details: Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: Cannot create a connection to data source 'DataSource1'. ---> System.Data.SqlClient.SqlException: Login failed for user 'Acc-11Admin'."
Hi,
I'm encounter lately some weird behaviour of SSRS in BIDS as well as after deploying on Reporting Server.
I'm running basic classical SQL SSRS Reports with Oracle DB connection. My reports have header and footer pagination and well defined report layer configuration. All the reports are simple based on one table and some basic parameters passed to query.
In query builder from BIDS from data tab, the query is running fine without any other execution delays. Also the query is runnign fine in PL/Dev environment.
When I switch in "Preview" mode the report hangs in execution and just showing "Report is being generated" without any resuts. After a while is generating an execution error (after 20 min).
The behaviour is the same after deployment on Report Server .
I now...here it comes...the problem is intermitent...some times the report is working...but most of the times it hangs on execution.
I checked the report from top to bottom and nothing's wrong from design perspective.
On other reports I don't have this problem and I don't understand where to start to investigate.
Any suggestions...I'm stuck here.
Thanks
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.
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
New ssrs istall. I think they loaded sp2. It's a cluster, but ssrs was not clustered (I think)
When I attempt to open report manager, i just get
SQL Server Reporting Services
Home
with no option for creating a folder etc, like i have on development
When I attempt to deploy to ther server I get :
Deploying to http://amsqlclusterxx/reportserver/
Error rsItemAlreadyExists : The item '/Retailer' already exists.
How do I create an ssrs reports folder?
Also, and this is strange, but in vs.net I had to create a new shared datasource after removing the old one on the report with the same name. The report renders fine when I do an f5 pointing to a new datasource, but I no longer have the RUN "!" icon available while in the data tag to run my query. Why is this?
Thanks for any help or information.
Is it possible to add hyperlinks to the Report Manager Home Page that link to other aspx pages? I have created some associated data entry aspx pages that I want to enable access to from the Report Manager Home Page (if possible).
Thanks!
I have a report model that I am trying to deploy using report manager web service. A folder is created by the administrator to place all my SSRS reports. I deployed .rdl files using the "Upload file" function in "Report Manager". All the SSRS reports work fine but when I tried to upload .smdl file (report model file) using the Report Manager's "Upload file" function it gave me the following error message.
The permissions granted to user 'xxxxxxman' are insufficient for performing this operation. (rsAccessDenied)
Does this mean I only have permission to upload .rdl file but NOT .smdl file to my designated folder?
I have some OLAP reports in which I have to alter the MDX statements each month, in the VS2005 report designer. They are deployed to the web and they contain Descriptions and Subscriptions which I create once they get to the web. The way I am currently updating them each month is by editing the reports in VS2005 and re-deploying them to the Reports Server. I then have to add the descriptions again and create new Subscriptions because the orig reports are deleted when the new ones, with the same name are deployed. There has to be a way that I can just alter the existing reports in the web environment and not have to recreate the Subscriptions each month. Any help would be appreciated.
View 1 Replies View RelatedHi,
Is there a way of passing a default parameter value into the subject title on a report subscription?
Currently there are std global variables i.e. @ReportName was executed at @ExecutionTime, but what other variables can be passed here to make it more relevant to the recipient?
Thx
Duh I know.
I'm am on the report server as administrator. How can I cleanly delete a report? How can I see what folders and reports I have under the reportserver?
I'm looking under sql management studio and see the reportserver db, now what? I open up the IIS virtual for reportserver, now what? Nothing seems to point to a folder where I know I am able to deploy to and run reports from.
Is it possible to add custom controls in for parameters in report manager??
I have a parameter that requires the user to click a button and select a bunch of things in another form. How can i do this in reporting services??
I also would like to change the layout of the parameters toolbar, ie. make text boxes smaller widths, show/hide parameters based on other parameter values.
I know i could write my own web page that does this and hide the parameters toolbar when they run the report, but this would mean that we lose other functionality that report manager has, eg. scheduling.
Does anyone know if customising the report manager will become available in a later version??
Hi Everyone,
I recently updated my instance of SQL Server 2005 express to install reporting services. I am able to navigate to the report manager url but the report builder button is missing. Also, when I go to the report manager url, It prompts me for the server's username and password. Does anyone know how I can fix this?
Hi All,
I have a report which gets data for around 5 different parameters for 5 servers. It needs to render different graph for each parameter, each server. It renders it properly (after running long though, which can be understandable) on the Visual Studio Preview. But when deployed on the Report Manager, it does not produce the graphs. It runs for long time and ends up with this error:
The following error was encountered:
We can not connect to the server you have requested.
This means that:
The server might be busy at this time.
The server is not reachable.
Please try later to see if you can go through.
Though I have configured the report execution NOT to time out. As such, subscriptions also do not work, It says, "Failure sending mail: An error has occurred during report processing."
So, has anyone faced similar problem and fixed it? If yes, can you please share the same?
Thanks a lot.
Manoj.
Hi i have created serveral reports in sql and uploaded it to report manager. We have an issue here. We have 5 departments at our place. Each of the department has 5 reports. We want the department for instance Administration to open/view only their reports and no others. How is this done "Credentials supplied by the user running the report" Basically if i give sa and sa as username and password, i will be able to enter any department reports but i want something like sa say 'admin' this user will only open his reports and no one else. there is also security for the folder. I could clump all the reports instead of type do it by department. So all admin reports in one folder and only admin should have access and no one else say if there is another user manager he cant access it. Do you have any idea on how to go abt this situation?
Sheldon
Hello, a
Where can I find, or how can I get the Report Server URL, not the Report Manager URL.
I an running MS, SB Server 2003 R2, Premium edition. I have install SQL 2005, and SP2.