Post New Web Links

Unable to deploy reports from VS 2008 to SSRS 2008

Posted By: Posted Date: October 19, 2010 Points: 0 Category :Sql Server

I have a server that has SQL 2005 and SQL 2008 installed. At one point, I was able to deploy reports from VS 2008 to SQL 2008, but can no longer do so. Any ideas what could have changed that prevents the deployment? Should I remove SQL 2005, as it's not being used on this particular server?

View Complete Post

More Related Resource Links

Schedule reports with integrated authentication SSRS 2008

Hi All, Having an issue with SSRS 2008 at the moment, trying to setup subscriptions. Our system is configured so that any one of 10 users can login to the SSRS website using their windows domain account, and then launch report builder to design and save reports. This all works very well, however, they have a problem when trying to setup subscriptions - the famous "Subscriptions cannot be created because the credentials used to run the report are not stored....." What the message says is true - the credentials are not stored as they are supplied by the user when they login to report builder. Is the /any/ workaround at all that doesn't involve storing the credentials? It seems totally crazy that they cannot be prompted for them when setting up the subscription. For this application its 100% essential to make the user provide their credentials when running reports, because they each see a filtered subset of the data in the report model (this is controlled DB side depeding on the login account), so their domain account needs to be passed to SQL server to enable this filtering to work. If we saved their credentials then they would see all the data..and thats nasty. The only workaround I can come up with would be to create a separate datasource for each user and upload a separate model, but thats really nasty to be hones

SSRS 2008 SP1 - Enabling "My Reports" allows users delete reports in folders they should not be able

Issue: Users that have “My Reports” SSRS Role assigned to them can delete reports in other “shared” folders. My understanding was that they will be able to do the tasks specified only in the “My Reports” workspace not everywhere. I have “My Reports” enabled via SSMS. Users have “My Reports” role assigned to them at the root level. My SSRS Role “My Reports” has only the following tasks assigned: 1. View Reports 2. Manage reports 3. View Folders 4. Manage Folders To test, I'm using Development version of SQL Server 2008 SP1. Thanks in advance, Martina

Where are the 2008 SSRS sample reports?

All the CodePlex 2008 links now go to the 2008R2 examples. Are the 2008 report samples still around somewhere?

SSRS 2008- redirect to /Reports virtual directory?

We have just configured a new SQL Server Reporting Services 2008 server. So far, everything is going well, with the exception of one thing: we want anyone who hits the root of the webserver to be redirected to the /Reports virtual directory. So, if the user enters http://servername.domain.com/ it would redirect to http://servername.domain.com/reports.ÃÂ In SSRS 2005, it was easy to configure IIS to do this, but with SSRS 2008, I cannot figure out how to make this change. Help?

SSRS 2008 - report manager: System.Net.WebException: Unable to connect to the remote server

I have an instance of Reporting Services 2008 running on Windows 2003 server. So, the webservice URL is running on port 801, and runs fine (I can browse reports from that directory, and upload / deploy new reports and overwrite existing reports. Report manager is set to use port 800 (IIS is also on that machine running port 80). When I attempt to connect to report manager, I get the following error, with a link to "Home" in report manager (which brings me back to the existing error page): Unable to connect to the remote server In the logfiles for reporting services, the following error is there: " System.Net.WebException: Unable to connect to the remote server ---> System.Net.Sockets.SocketException: No connection could be made because the target machine actively refused it. Any ideas? Windows Firewall is NOT running on this machine. Thanks, Chrisrjp

Are there workarounds for SSRS 2008 Reports that have issues in SSRS 2008 R2

We have some SSRS 2008 reports which have a few issues in SSRS 2008 R2: - Page Numbering: Our reports use [PageNumber] of [TotalPages] however, in R2 [Total Pages] only relates to a particular section. Do we really need to update every single report in design mode to use [OverallTotalPages]? Is there a workaround? - Report Rendering: Each page of a report is only rendered when each new page of the report is requested. How do we prevent this is R2? - Missing Data: If we run a report that should have 50 pages of data, not all pages are shown when viewing the report. For example, only 2 pages might show. However, if we export to PDF the whole 50 pages are exported. Does anyone know why this is happening? Looking for patches, workarounds, etc. Hoping that we don't need to upgrade desktops to R2 and edit hundreds of reports to fix these issues. Thanks, Howie999

SSRS 2008 Against OLAP Cube reports rendering slow in IE 6 and IE8

We have SSAS cube built on SQL Server 2008 that has multiple parameters that have a default vault on running of all. The first time we run the report it renders the report in less than 30 seconds, but when we change one value on the data cube pull the reports can take up to 5 mins to run. If I do the same report in Firefox 3.6 it renders the report in 30 seconds. I have change changing the cache size in the IE explorer and ave the latest .net frame work on the computer. What would be causing this issue? The company upgrade from SSRS, SSIS, SSAS, SQL 2005 to 2008. Please advice, this is very annoying for our business end users. Thanks for your help in advance.

Deploying SSRS Reports from Visual Studio 2010 to Report Manager 2008

Our Report server is using Report Manager 2008. Previously I would load reports to it that I created via BIDS. Now I have to use VS 2010. I see that I can build and deploy reports there. Can I send it from VS 2010 to the REport manager 2008 on the other machine? I should add that now i have to develop on laptop only before i was on the server.

If not what are my options? I recall that vs 2005 objects were not taken in Report manager 2008.

SSRS 2008: Multiple Sub-Reports with conditional visibility in one List control

MainReport: a List containing two Sub-Reports. The data of the List only has two rows. Set the visibility of the sub-report based on the data.

SubReport1: a textbox showing "Sub Report 1"

SubReport2: a textbox showing "Sub Report 2"

I expect to see SubReport1 in Page 1 and SubReport2 in Page 2.

But I only see SubReport1 in Page 1 and Page 2 is a blank page.

These reports work in SSRS 2005, but not in SSRS 2008.

Thanks.

Report Definition:

MainReport.rdl:

<?xml version="1.0" encoding="utf-8"?>
<Report xmlns:rd="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner

SSRS 2008 - email subscription - 7 minute delay between two reports emailed out (normally less than

We have a report subscription that emails out through a 3rd / separate smtp server.

I was watching the progress on the report server subscription page (where it shows executing, x of y completed, 0 errors) and noticed a long pause between updates about half way through the subscription.

It sends out around 500 emails and email 475 of 500 was still on screen after a few minutes (it hadn't ticket up to 476, or 479, etc...)

So I quer

SSRS 2008 SP1 Unable to get cataloge items from server.

When I access the report server locally I can access the report builder 1.0 click-once application without problems and it is able to show me a list of the reports. When I access the same report server via our load balancer that does SSL off-loading I get the error message "Unable to get cataloge items from server." the details of which are below:

An existing connection was forcibly closed by the remote host
----------------------------
Unable to read data from the transport connection: An existing connection was forcibly closed by the remote host.
----------------------------
The underlying connection was closed: A connection that was expected to be kept alive was closed by the server.

I had to enable basic authentication and allow anonymous access to the report builder so my client could access it from their computers on their domain. They have accounts on my domain which they are prompted for and enables them to access the reports website and the report builder application. Its only when they try to open a report with the report builder that they get this error message about being able to get the catalog.

SQL Server 2008 SP1
Windows Server 2008

Any ideas?

Is SSRS 2008 capable enough to be a solution for generating really huge reports?

Hi All,

I have been doing performance analysis for SSRS 2008 for some really huge reports that return between 1 to 5 million records (with single user) and reports that return 100K to 200K records with multiple users. I have observed lot of issues which made me to think that may be SSRS 2008 is not good enough for such a huge reports even less good if there is a multiple users scenario for those big reports(though I wanted to use it). Please go through my points and share your views on this.

Before putting up the points I would like to mention my configuration, Windows Server 2003 Enterprise Edition R2 SP2 64 bit (totally dedicated to SSRS reports as the data source for these reports was SQL Server 2005 Enterprise Edition), Microsoft Reporting Services 2008 R2 64 bit, 8 CPU, 8 GB RAM and the reports are simple tabular reports which are fetching the data from a single table (no joins)

Authenticated, when deploying the reports(SSRS 2008) to a sharepoint site

I created reports in SSRS 2008 for a sharepoint list. But when I tried to deploy it to the report library I used to get an authentication pop-up box again and again. I used all the username and password. But no luck. Does any one knows how to overcome this situation.

Unable to upload report file to SSRS 2008 R2 Express

I'm attempting to upload a report file into an instance of SQL Server 2008 R2 Reporting Services (Express edition), and I'm having difficulty. While I can do things like create folders and manage security, I am unable to upload a report definition (.rdl) file from either the web console or via the ReportService2005.asmx web service. Both avenues eventually time out and generate a 401 error (though I am not sure that this 401 is legitimate, as it takes over a minute and a half to generate the error).

This instance is running the web services on a non-standard port (8080) in HTTP (not HTTPS) mode, as it's on a Windows XP Pro machine with an existing website on IIS.

I have looked at the report server access log, and this appears to happen when it errors out:

    rshost!rshost!380!10/13/2010-14:39:10:: e ERROR: ReadCallback(): failed to read in read callback.
    rshost!rshost!380!10/13/2010-14:39:10:: e ERROR: Failed with win32 error 0x03E3, pipeline=0x016F8D48.
    rshost!rshost!244!10/13/2010-14:39:10:: e ERROR: HttpPipelineCallback::ReadEntityBody(): failed reading data.
    rshost!rshost!244!10/13/2010-14:39:10:: e ERROR: Failed with win32 error 0x03E3, pipeline=0x016F8D48.
    library!ReportManag

ssrs 2008 reports Datasource error in Test server..

Hi ,

i Have upgraded my Reports from Report server VS 2005 to VS 2008 .

My reports works fine in local, development & test server.

After Ugrading to 2008 it works fine in local server & devlopement serverr.

When i deployed to Test server i am trying to access my reports i am getting below errors,

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 checked the Datasource conncetion properties..its pointing to correct Test database only..

My reports are windows integrated...

Now it works in srs 2005 developement & test server. For same properties it works in dev server, it doesn't works in srs 2008 test server.

Why? Can anyone give me some idea...?

merging reports ssrs 2008

how can i display barchart and linechart in a single report by using ssrs 2008

Reports referencing .NET Framework 4.0 fail to upload to SSRS 2008

We are running SSRS 2008 on a 64-bit Windows Server 2008 SP2

When attempting to deploy a report containing a reference to a .NET Framework 4.0 assembly via the Report Manager, we get an error.

For example, when deploying a report referencing System.Xml, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089, we get the following error:

Error while loading code module: ‘System.Xml, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089’. Details: Could not load file or assembly 'System.Xml, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089' or one of its dependencies. The system cannot find the file specified. (rsErrorLoadingCodeModule)

The same report deploys correctly in a development environment (Windows 7 64-bit, SSRS 2008).

The Win2k8 server has .NET Framework 4.0 installed and is fully patched.

Is there a strategy for troubleshooting this issue?

Thanks!

David


Categories:

ASP.Net	Windows Application	.NET Framework	C#	VB.Net	ADO.Net
Sql Server	SharePoint	Silverlight	Others	All