I was the happy admin of some reportservers (build 3175) until someone asked me to get the ReportBuilder to work. I've read through the documentation and configured the SSRS site security so that the icon is visible. However when I click on it nothing happens. If I try to launch it by right clicking and then save as -- open I receive the following error:
- Downloading file:///C:/UserTemp/_temp/ReportBuilder.exe.manifest did not succeed.
- Source: System.Deployment
- Stack trace:
at System.Deployment.Application.SystemNetDownloader.DownloadSingleFile(DownloadQueueItem next)
at System.Deployment.Application.SystemNetDownloader.DownloadAllFiles()
at System.Deployment.Application.FileDownloader.Download(SubscriptionState subState)
at System.Deployment.Application.DownloadManager.DownloadManifestAsRawFile(Uri& sourceUri, String targetPath, IDownloadNotification notification, DownloadOptions options, ServerInformation& serverInformation)
at System.Deployment.Application.DownloadManager.DownloadApplicationManifest(AssemblyManifest deploymentManifest, String targetDir, Uri deploymentUri, IDownloadNotification notification, DownloadOptions options, Uri& appSourceUri, String& appManifestPath)
at System.Deployment.Application.ApplicationActivator.DownloadApplication(SubscriptionState subState, ActivationDescription actDesc, Int64 transactionId, TempDirectory& downloadTemp)
at System.Deployment.Application.ApplicationActivator.InstallApplication(SubscriptionState subState, ActivationDescription actDesc)
at System.Deployment.Application.ApplicationActivator.PerformDeploymentActivation(Uri activationUri, Boolean isShortcut)
at System.Deployment.Application.ApplicationActivator.ActivateDeploymentWorker(Object state)
--- Inner Exception ---
System.Net.WebException
- Could not find file 'C:UserTemp\_tempReportBuilder.exe.manifest'.
- Source: System
- Stack trace:
at System.Net.FileWebRequest.EndGetResponse(IAsyncResult asyncResult)
at System.Net.FileWebRequest.GetResponse()
at System.Deployment.Application.SystemNetDownloader.DownloadSingleFile(DownloadQueueItem next)
--- Inner Exception ---
System.Net.WebException
- Could not find file 'C:UserTemp\_tempReportBuilder.exe.manifest'.
- Source: System
- Stack trace:
at System.Net.FileWebResponse..ctor(FileWebRequest request, Uri uri, FileAccess access, Boolean asyncHint)
at System.Net.FileWebRequest.WrappedGetResponseCallback(Object state)
--- Inner Exception ---
System.IO.FileNotFoundException
- Could not find file 'C:UserTemp\_tempReportBuilder.exe.manifest'.
- Source: mscorlib
- Stack trace:
at System.IO.__Error.WinIOError(Int32 errorCode, String maybeFullPath)
at System.IO.FileStream.Init(String path, FileMode mode, FileAccess access, Int32 rights, Boolean useRights, FileShare share, Int32 bufferSize, FileOptions options, SECURITY_ATTRIBUTES secAttrs, String msgPath, Boolean bFromProxy)
at System.IO.FileStream..ctor(String path, FileMode mode, FileAccess access, FileShare share, Int32 bufferSize, Boolean useAsync)
at System.Net.FileWebStream..ctor(FileWebRequest request, String path, FileMode mode, FileAccess access, FileShare sharing, Int32 length, Boolean async)
at System.Net.FileWebResponse..ctor(FileWebRequest request, Uri uri, FileAccess access, Boolean asyncHint)
COMPONENT STORE TRANSACTION DETAILS
No transaction information is available.
Here are the things I have checked/tried:
Ensured the .NET Framework Reliant components are enabled in the browser
Running the browser with a user account that is local admin on the workstation
MIME settings on IIS server look ok
I am not seeing any access denieds on my workstation (checked with file and regmon)
I am not seeing any failures in the security event log
For the test that I am doing, both the user account, workstation and server are in the same domain
Don't see any errors in the SSRS logs
Can anyone think of anything else that would lead me to resolving this problem?
We created a custom security extension for RS using Forms Authentication. The issue I am having is in ReportBuilder when the forms authentication ticket expires. Forms auth will attempt to redirect (send a HTTP 302) and the report builder will show the error message "Object moved to here" instead of prompt for credentials. I have been watching the IIS logs and I see the first time report builder start it attempt to connect using default windows credentials and after the FormsAuthenticationRequired exception it will prompt for credentials and invoke LogonUser method, but this only happens the first time or if change the server in the url. I was expecting ReportBuilder to consider the Forms Authentication expiration at any time.
I have a question about table layout report. I want to do that:
I have a table report and on that report i have a Total field of money. And i want to do that if condition on that field, so if the prize is less then 150, the color of the text it should be red otherwise it should be other color. So how can i achieve that. I know that this is possible in Reporting services in Report Designer is like =IIF(field.???.Value<150;"red";"gree")
But if i make that same in report builder, the what it does, it displays not the value in color, but it displays the text "red" od "green".
I will be very happy and gratefull if somebody can help me.
Hi, Is there a way to change the size of the fields (in this case a drop down list) on the filter page of ReportBuilder? I have an attribute I want to filter by, but the contents are too wide so the full thing can't be read if I set up an 'equals to' filter in ReportBuilder.
I am trying to open the reportbuilder from within a web application so that I can pass the credentials. I would like to be able to have the reportbuilder open within the app. Is this possible.
I'm trying to avoid keeping the report builder credentials and the app's credentials both up to date.
I'm trying to figure out how can i get a list of the reports made with reportbuilder. I have create a folder in ReportManger and all my report are in this folder. When i create report with ReportDesigner i get a .RDL file, but when i create a report using reportBuilder i can't file the file created. What i want to do is to create in our web application a Web page with a list of report that our client has create using ReportBuilder. I was thinking about doing a loop on the folder for each report File but i can't find those files.
ERROR SUMMARY Below is a summary of the errors, details of these errors are listed later in the log. * Activation of https://reports.mysite.com/ReportServer/ReportBuilder/ReportBuilder.application resulted in exception. Following failure messages were detected: + Downloading https://reports.mysite.com/ReportServer/ReportBuilder/ReportBuilder.application did not succeed. + The remote server returned an error: (401) Unauthorized.
COMPONENT STORE TRANSACTION FAILURE SUMMARY No transaction error was detected.
WARNINGS There were no warnings during this operation.
OPERATION PROGRESS STATUS * [5/10/2006 8:48:02 AM] : Activation of https://reports.mysite.com/ReportServer/ReportBuilder/ReportBuilder.application has started.
ERROR DETAILS Following errors were detected during this operation. * [5/10/2006 8:48:11 AM] System.Deployment.Application.DeploymentDownloadException (Unknown subtype) - Downloading https://reports.mysite.com/ReportServer/ReportBuilder/ReportBuilder.application did not succeed. - Source: System.Deployment - Stack trace: at System.Deployment.Application.SystemNetDownloader.DownloadSingleFile(DownloadQueueItem next) at System.Deployment.Application.SystemNetDownloader.DownloadAllFiles() at System.Deployment.Application.FileDownloader.Download(SubscriptionState subState) at System.Deployment.Application.DownloadManager.DownloadManifestAsRawFile(Uri& sourceUri, String targetPath, IDownloadNotification notification, DownloadOptions options, ServerInformation& serverInformation) at System.Deployment.Application.DownloadManager.DownloadDeploymentManifestDirectBypass(SubscriptionStore subStore, Uri& sourceUri, TempFile& tempFile, SubscriptionState& subState, IDownloadNotification notification, DownloadOptions options, ServerInformation& serverInformation) at System.Deployment.Application.DownloadManager.DownloadDeploymentManifestBypass(SubscriptionStore subStore, Uri& sourceUri, TempFile& tempFile, SubscriptionState& subState, IDownloadNotification notification, DownloadOptions options) at System.Deployment.Application.ApplicationActivator.PerformDeploymentActivation(Uri activationUri, Boolean isShortcut) at System.Deployment.Application.ApplicationActivator.ActivateDeploymentWorker(Object state) --- Inner Exception --- System.Net.WebException - The remote server returned an error: (401) Unauthorized. - Source: System - Stack trace: at System.Net.HttpWebRequest.GetResponse() at System.Deployment.Application.SystemNetDownloader.DownloadSingleFile(DownloadQueueItem next)
COMPONENT STORE TRANSACTION DETAILS No transaction informtion is available. -------------------------------
Ok, so here's the catch. It works one 1 machine, a co-workers machine. I can login as any user and it'll work fine. But when I try it on any other machine, including my laptop, my desktop, my server, etc. I get that error. I've tried adjusting the IE Security settings, firewall settings, even tried different browsers. Here's some of the stuff installed on my machines:
Laptop -Windows XP Pro -ASP.NET Validation Tool -Visual Basic Express w/ SQL Server Express -.NET 1.1/2.0 Framework
Desktop -Windows XP Home -Visual Studio 2005 Professional -.NET 1.1/2.0 Framework
Server -Windows Server 2003 Enterprise -SQL Server 2005 -.NET 1.1/2.0 Framework
Any help on this would be greatly appreciated. Even our lead developer has no clue, it won't work on his machine either!
We have made a lot of reports using Visual Studio. Now some of our client would like to customize those reports. We have install ReportBuilder on their server to allow them to create their own reports. Everything is working fine when they are trying to create new reports. The problem is when they are trying to customize reports that we have made using Visual Studio.
When they are trying to open those reports in ReportBuilder they get this Error:
One or more unexpected Report Definition Language (RDL) elements of the following type have been removed: DataSetMicrosoft.ReportingServices.ReportBuilder.ReportModel.Report: System.Web.Services.Protocols.SoapException: The operation you are attempting on item "/Data Sources/DataSource1" is not allowed for this item type. ---> Microsoft.ReportingServices.Diagnostics.Utilities.WrongItemTypeException: The operation you are attempting on item "/Data Sources/DataSource1" is not allowed for this item type. at Microsoft.ReportingServices.Library.ModelCatalogItem.ModelStorage.GetModelItemIDAndItemSecurity(ModelCatalogItem model) at Microsoft.ReportingServices.Library.ModelCatalogItem.ModelStorage.LoadModel(ModelCatalogItem model, Boolean getModelDefinition) at Microsoft.ReportingServices.Library.ModelCatalogItem.LoadModel(CatalogItemContext modelContext, Nullable`1 requiredOperation, Boolean getModelDefinition) at Microsoft.ReportingServices.Library.ModelCatalogItem.LoadUserModel(CatalogItemContext modelContext, Nullable`1 requiredOperation, String perspectiveID) at Microsoft.ReportingServices.Library.GetUserModelAction.PerformActionNow() at Microsoft.ReportingServices.Library.RSSoapAction.Execute() at Microsoft.ReportingServices.WebServer.ReportingService2005.GetUserModel(String Model, String Perspective, Byte[]& Definition) --- End of inner exception stack trace --- at Microsoft.ReportingServices.WebServer.ReportingService2005.GetUserModel(String Model, String Perspective, Byte[]& Definition)
We get this error for each report that we have create under Visual Studio (All those report use parameters). Is there a way to allow our client to customize those reports ?
ERROR SUMMARY Below is a summary of the errors, details of these errors are listed later in the log. * Activation of http://webdev.ci.lubbock.tx.us/ReportServer$SQL05/ReportBuilder/ReportBuilder.application resulted in exception. Following failure messages were detected: + Downloading http://webdev.ci.lubbock.tx.us/ReportServer$SQL05/ReportBuilder/ReportBuilder.application did not succeed. + The remote server returned an error: (401) Unauthorized.
COMPONENT STORE TRANSACTION FAILURE SUMMARY No transaction error was detected.
WARNINGS There were no warnings during this operation.
OPERATION PROGRESS STATUS * [4/10/2006 11:34:29 AM] : Activation of http://webdev.ci.lubbock.tx.us/ReportServer$SQL05/ReportBuilder/ReportBuilder.application has started.
ERROR DETAILS Following errors were detected during this operation. * [4/10/2006 11:34:29 AM] System.Deployment.Application.DeploymentDownloadException (Unknown subtype) - Downloading http://webdev.ci.lubbock.tx.us/ReportServer$SQL05/ReportBuilder/ReportBuilder.application did not succeed. - Source: System.Deployment - Stack trace: at System.Deployment.Application.SystemNetDownloader.DownloadSingleFile(DownloadQueueItem next) at System.Deployment.Application.SystemNetDownloader.DownloadAllFiles() at System.Deployment.Application.FileDownloader.Download(SubscriptionState subState) at System.Deployment.Application.DownloadManager.DownloadManifestAsRawFile(Uri& sourceUri, String targetPath, IDownloadNotification notification, DownloadOptions options, ServerInformation& serverInformation) at System.Deployment.Application.DownloadManager.DownloadDeploymentManifestDirectBypass(SubscriptionStore subStore, Uri& sourceUri, TempFile& tempFile, SubscriptionState& subState, IDownloadNotification notification, DownloadOptions options, ServerInformation& serverInformation) at System.Deployment.Application.DownloadManager.DownloadDeploymentManifestBypass(SubscriptionStore subStore, Uri& sourceUri, TempFile& tempFile, SubscriptionState& subState, IDownloadNotification notification, DownloadOptions options) at System.Deployment.Application.ApplicationActivator.PerformDeploymentActivation(Uri activationUri, Boolean isShortcut) at System.Deployment.Application.ApplicationActivator.ActivateDeploymentWorker(Object state) --- Inner Exception --- System.Net.WebException - The remote server returned an error: (401) Unauthorized. - Source: System - Stack trace: at System.Net.HttpWebRequest.GetResponse() at System.Deployment.Application.SystemNetDownloader.DownloadSingleFile(DownloadQueueItem next)
COMPONENT STORE TRANSACTION DETAILS No transaction information is available.
Does anyone know how that I can get the reportbuilder.application to run on a client on the network. It seems that if I have to remote into the actual server to get the report builder to work would be pointless for users on the network. I get the 401 Unauthorized all the time. Any comments would help.
(I wish I was able to attach pictures....anyhow I'll try my best without them)
The customer's goal is to via ReportBuilder to select fields from multiple many-to-many relationships. They are able to see the fields that exists within the various many-to-many relationships but IS ONLY able to select fields from ONE many-to-many relationship. Example using AdventureWorks:
So the goal in the ReportBuilder is to be able select fields from Contact/Vendor/Store/ and CreditCard. PROBLEM is that the ReportBuilder ONLY allows user to select fields from Contact/Vendor OR Contact/Store OR Contact/CreditCard (exclusively)
The only workaround I've found is to reverse the relationships in the DataSourceView to the following
We have installed SQL Server 2005 reporting services and reportbuilder. On the local machine and local network we can start and use reportbuilder perfectly.
We are using ISA server for security. When we get around ISA it works fine, but when we have to get access via ISA, we get the error 'unauthorised', when starting the reportbuilder application.
The virtual folder 'reportbuilder' is configured in IIS for Anonymous access, the report en reportserver virtual folder, we need basis authentication.
Our vb application throws .dtsx by means of the usual methods.
When I want to run packages allocated in my Windows folder I use LoadPackage; when I want to run packages allocated in my MSDB I use LoadFromSqlServer and at the end of the day when I want to run packages allocated in my File System SSIS folder I use LoadFromDtsServer.
Drawbacks come here according a "new sort of SSIS packages". I'm talking about those packages which are imported from Sql2k from Database Engine->Management->Legacy->Data Transformation Services.
How do I launch this kind of SSIS packages??
I'm totally stuck with this. Or maybe the problem is easier: the ones aren't ssis but dts????????????????
I inherited a computer from a co-worker who left. On it she installed SQL Server 2005. The help system is chock full of references to the various and sundry tutorials that come with the product, but I can't find so much as a syllable about how one actually accesses those tutorials.
When I select Start, Programs, Microsoft SQL Server 2005, Documentation and Tutorials, Tutorials, SQL Server Tutorials, it simply launches one of the help screens. That screen, and the ones it contains links to, describe the tutorials topics in great detail, but nowhere is there any explanation of how you actually launch the tutorials.
I'm trying to launch a SIS package from a VBA macro in excel...now I launch the dtexec.exe from a shell but a have this error:
Started: 10.14.33 Could not load package "Package1" because of error 0xC0014062. Description: The LoadFromSQLServer method has encountered OLE DB error code 0x80004005 (Login timeout expired). The SQL statement that was issued has failed. Source: Started: 10.14.33 Finished: 10.14.49 Elapsed: 16.594 seconds
I need to know a few things about this.. 1. What do I need running or available on SQL Server machine (presuming an Oracle client) 2. Has anyone done this and perhaps can give me some quidance? 3. Any concerns about going from outside a firewall to the Oracle instance?
Architecture is probably going look like this:
SQL -> ON INSERT Trigger -> business logic -> Call Oracle Procedure
My understanding is that Microsoft acquired the rights to use and re-badge Sybase as SQL Server and since then have engaged in a substantial re-write as part of their commitment to it.
Is this correct and can anyone give me some dates ?
Poor me :o I have to share a home PC now so cannot have things my own way. When using my own PC I had SQL Server 2005 dev edition run on start up. Now I am sharing it seems rather churlish to not have it start on demand.With 2000 you got a little icon in the taskbar that indicated the status of SQL Server and a quick right click -> start was all you needed to get the little fella up and running. With 2005 you need to go all the way to configuration manager and start it. I have four options:#1 - a few mouse clicks to start SQL Server via configuration manager (unacceptable - imagine all the wasted time and RSI!)#2 - bat file to start SQL Server (ok)#3 - more sophisticated little app that shows the status of SQL Server in the taskbar and allows me to start it (nice but a pain to put together)#4 - something much spiffier which one of you gurus can let me in on I am sat on the edge of my little seat in anticipation :)
I want to build a task that does 3 things automatically at a fixed time interval:
1) Refresh the data (copy newly inserted data from a datamart to a datawarehouse) 2) Run a program (exe) to produce some external reports 3) Refresh an OLAP Cube with the new data so that users can access it
Basically, using SQL Server Agent, setting up steps 1 and 2 was pretty straightforward (for step 1, the main point of entry is a single sp).
I ran into some trouble figuring the easiest way to complete step 3. I created a DTS package with one object that updates the Cude on my server. This seems to be working fine. Then, I created step 3 in Agent and chose 'CmdExec' as the type of command. I then referenced the external exe 'dtsrun' to execute my DTS package.
Everything seems fine but I'm not sure I used the "best" way of doing things. Since the SQL Server Agent and DTS manager are both SQL Server tools (so is the Analysis services), I'm wondering if there wasn't an easier (thus more robust) way of completing my 3rd step?
hiI have a scenario where I have created a stored procedure wich task isto search in my database with certain criterias. For each record fromthis search, I want to run a couple of other stored procedure.Here is some code:decare $myid nvarchar(15)select id, desc, customer from project where customer = 'cust1'--------------------------------------------HERE IS CODE MISSING----------------------------------------------for each of the records returned, I want to run 4 stored procedureswith the id as parameter.beginexecute StoredProcedure1 $myidexecute StoredProcedure2 $myidexecute StoredProcedure3 $myidexecute StoredProcedure4 $myidendThe problem is I don't know how to get hold of the result set and loopthrough. Maybe you can help me.regardsRoger
I am having problems launching the Report Builder. I click the button and nothing happens. I did see the other suggestions about re-installing the .NET 2.0 Framework but that did not help. I tried to launch it directly from the address bar and I am getting the same reponse as when I click on the Report Builder button. I can access the Report Builder from other machines and it works fine. I did just recently install IE 7 and I tried to uninstall it and go back to IE 6 but I got the same results.
I've SQL instance used for Telecom Software, that SQL instance kept to run automatically consume 2 GB RAM and slow my machine..How could I configure it to lunch only when I open my Telecom Software and to close when I exit it.
I use one-way Transactional Replication on 38 servers with same configuration. On one server I have problem with OSQL.EXE path.
On Publication properties -> snapshot -> Additional scripts -> Before applying the snapshot, execute this script: Is set preinit script (C:ReplDataReplPreInit.sql).
On Distribution agent properties -> step "Run Agent" I set additional command for log problem. command= -Output C:ReplOutFile.txt -Outputverboselevel 2
Here is part of ReplOutFile.txt: -------------------------------- The osql command is: "C:Program FilesMicrosoft SQL Server80ToolBinnosql.exe" -U"***" -P"***" -i "\STROSBBReplDatauncSTROSBB_antikor_DataCDB20060908104051ReplPreInit_0.sql" -S "BTSVR" -d "AntikorCDB" -o "C:WINNTTEMPReplPreInit_0.sql_20060912150416.log" -b -X1 Launching osql to apply the script 'ReplPreInit_0.sql' [9/12/2006 3:04:16 PM]STROSBB.distributionAntikor: {call sp_MSadd_distribution_history(1, 3, ?, ?, 0, 0, 0.00, 0x00, 1, ?, 0, 0x01, 0x00)} Agent message code 20130. Failed to launch 'osql' [9/12/2006 3:04:16 PM]STROSBB.distributionAntikor: {call sp_MSadd_distribution_history(1, 6, ?, ?, 0, 0, 0.00, 0x01, 1, ?, 4, 0x01, 0x01)} Adding alert to msdb..sysreplicationalerts: ErrorId = 1233, Transaction Seqno = 00000491000618f4007000000001, Command ID = 4 Message: Replication-Replication Distribution Subsystem: agent STROSBB-antikor-BTSVR-1 failed. Failed to launch 'osql'[9/12/2006 3:04:16 PM]STROSBB.distributionAntikor: {call sp_MSadd_repl_alert(3, 1, 1233, 14151, ?, 4, N'STROSBB', N'antikor', N'BTSVR', N'AntikorCDB', ?)} ErrorId = 1233, SourceTypeId = 3 ErrorCode = '3' ErrorText = 'The system cannot find the path specified. --------------------------------
Problem is that the path to osql command in log ReplOutFile.txt is C:Program FilesMicrosoft SQL Server80ToolBinn but SQL is installed on path C:Program FilesMicrosoft SQL Server80ToolsBinn
Diferences is between Tool vs. Tools
I think that when server create OSQL command for preinit sql script he use STATIC path to osql.exe and there is my problem.
Which in summary is that I am trying to execute DTS packages containing OLAP tasks to process cubes from an application. It hangs and fails after an hour and some minutes.
I have launched the DTS on command prompt using DTSRUN on the computer I am trying to execute my code, and it executes marvellously.
DTSRUN can also execute a DTS on another physical server Alpha for instance which process a cube of AS2000 found on another physical server Beta for instance.
Since I need to check that each steps have been executed properly and that running DTSRUN from the application is not a possibility to do so, I need a way to be able to launch the DTS and get to know which steps is failing. the above code is supposingly a way but its failing on LoadFromSQLServer() method.
I am using SQL Server 2000 and AS2000 and .net 1.1 (modifying a legacy system to enable the above facility).
Dear all, I am looking for any snippet of code where you can launch a SSIS package by DMO or VB 6.0. I read that it was posible to call dts.runtime assembly from VB 6.0 but at first it might be converted or something like that. Issue comes from the moment that we€™ve got an ASP 3.0 scheduler for hundreds of dts and now we have to migrate them to sql25k. Thanks in advance for any info regarding this,
I'm new to SSRS. I would like to launch a report from a C# desktop application, supplying parameters programatically. I was able to do this using System.Diagnostics.Process p ... then p.Start(@"(path)iexplore.exe","(reportURL)"); I'm betting there's a much better way to do this.
Ideally I would like to create an IE window that shows only the report, that is, only the report viewer toolbar is visible, the IE toolbars and menus are hidden. I want to specify IE as the browser in case some other browser is installed as the default web browser.
Can anyone link me to a tutorial or provide a code snip? Thanks.
Not sure what has caused this to suddenly happen, but each time I attempt to launch Enterprise Manager I get the error:
"MMC cannot open the file C:MSSQLBINNSQL Server Enterprises Manager.MSC This may be because the file does not exist, is not an MMC console, or was created by a later version of MMC. This may also be because you do not have sufficient access rights to the file."
Now, I've already attempted to reinstall the client tools with no luck. The file does exist, and I have not changed my security settings -- at least that I'm aware of.
I use EM daily, so I'm perplexed as to why over night it stopped working. Is it possible a Windows Update could have caused this?
If you have any insight I'd appreciate it. Thanks.
