SQL Server 2008 R2 Service Pack or Hotfix for ReportExecutionService2005 broken with IMAGE/EMF

Vlad_MSFT, any update on the ExecutionInfo.NumPages workaround? It's well over a month since you posted to this thread and by the looks of it I'm not the only person who is unable to get any useful information out of that.

As Bob_eBlueprint mentioned, it always seems to return zero. Do you actually have a tested code sample where it works?

Posted by edwardforgacs on 7/20/2010 at 2:11 AM

Yes, ExecutionInfo does not return the number of pages properly either. I have tried every possible combination including GetExecutionInfo, GetExecutionInfo2, before and after render, and combined with Render, and Render2. Guess we need to open another
bug about GetExecutionInfo not working in 2008 either?

Posted by Bob_eBlueprint on 7/9/2010 at 10:32 AM

I tried using the code posted by JasonRAC, but I am not getting an exception thrown when I try to render a page that doesn't exist. Instead a zero byte array is returned. So I'm using code like this to stop rendering when the end of the report is researched:

Microsoft SQL Server 2005 Express Edition Service Pack 3 (KB955706) (update 1 of 1)
This update seems to be stuck in a loop of installing, each time it successfull installs acccording to automatic updates. Then says it requires installing again straight away. This has been happening for 10 days now. I have tried a manual
update from the website rather than automatic updates, no change. Any ideas why? Have posted in Windows update which is where I think the problem lies but they have suggested I post here also.

I have tried and tried unsuccessfully to get this download to install properly. I get no error message at all but it quite clearly is not working properly. This has all ready taken me hours and hours of my time with no success (after following the fixes
mentioned on this site).
I look forward to suggestions at to how to proceed that may actually work.
Many thanks
cdbc81

I have Windows 2008 Small Business Server Standard Edition. When I scan for updates I get two different SQL service packs showing up, with the same KB955706 number. I'm wondering which I should install, or if both, what order to install
them in? The first one is labeled:
Microsoft SQL Server 2005 Express Edition Service Pack 3
The second one is labeled:
Microsoft SQL Server 2005 Express Edition with Advanced Services Service Pack 3
For applications, I have Blackbaud The Financial Edge v7.78 (accounting package for clubs) installed that uses SQL Server 2005 Express Edition for its database engine. The new upgrade for this software requires SP3 which is why I need to know which
service pack to install. Also, please let me know if there are any tricks to getting the service packs installed on 2008 SBS Standard Edition. I know sometimes registry settings need to be changed for SQL service packs to be installed properly.
Thank you for your help.

Hi @ all
I installed two SQL Server 2008 on Server 2008 R2 Std (principal and mirror) and an AD Server 2008, with sperate service accounts, connect as SA, localy all works fine.
I created some agent tasks (PowerShell, T-SQL), but I get some Error massages in the history, that service account of SQL Agent didn't have the permission to query a remote machine(access denied for wmi (HRESULT: 0x80070005 (E_ACCESSDENIED)) and linked database(SQLSTATE
42000 Error(7314)).
The simple query with SA permissions on the remote machine works and the powershell scripts with the local domain user works too. But not with the SQL Agent. WHY?? Where ist the different between the user account permisions and service account permissions?
Which settings are needed?
Example: get-wmiobject -class win32_service -computername 192.168.xxx.xxx| where {$_.name -like '*SQL*'}
Powershell Console: works SQL Agent Job:
access denied
I tried some solutions with user rights, group policies and security permissions but nothing works.
like:
Configuration -Service Accounts, SQL Server or SQL Server Agent service account
http://support.microsoft.com/kb/283811/en-us
http://msdn2.microsoft.com/

Hi,
I'm using Reporting Services web services endpoint ReportService2005.asmx with 2008 report server R2 and I'm facing some issues in getting the data source names for a report definition using the GetItemDataSources web service. The problem is that the data
source names returned are different from the names of the actual data sources on the report server.
The report has the following data sources:
0 1 _0 _A Data Source
And the names returned by the GetItemDataSources for 2008 report server R2 is:
AutoGen_0 AutoGen_1 AutoGen__0 AutoGen__A Data_Source
When I make the same calls using a 2005 report server, the names returned are the same as that in the report definition.
To summarize, only numeric data source names are changed to "Autogen_<number>"(eg. Autogen_0), data source names beginning with "_" are changed to "Autogen_<data source name>"(eg. AutoGen__A) and spaces are
replaced by an "_".
What is the problem for the data source names returned for 2008 report server R2? Or has there been any change in the way in which report server stores the data source names?
Thanks,
Kulbhushan Singhal.

After repeated attempts, I am unable to install the MSSQL Server 2005 (Express Edition) Service Pack 3 (KB955706). From Live Update, the installation initializes but then reports that it was unable to install. The first couple of times I received
Error Code 0x65B, but that doesn't come up any longer.
I have ACT! Database version 2007 (9.0) and it is unable to access the database to open it because it uses the MSSQL?? Also, there used to be an MSSQL icon below in my system tray, but that no longer appears. When I reboot it will be on briefly,
but then goes away..
MS Customer Support has attempted to help (Case ID SRX1135612820) but now tell me that this is beyond their expertise. They had me try to reload MMSQL 2005 but no change.
Please help!
Thanks!! Terry

I have some 32bit Dlls which i want to use it in 64bit OS as i do not have a source code of this to recompile it for 64 bit OS. I have created a x86(32 Bit) WCF service which calls these Dlls and hosted it as a Windows Service on a x64(64 Bit) machine using Windows Server 2008. I have created one more x64 client which calls a function in the WCF which in turn calls a function from the 32 bit native Dll. Whenever i try calling this WCF from the client I get an error as given below.Can anybody please guide as to where I am going wrong and what is needed to solve this issue. Thanks in advance for any help.******The Error Message********************System.BadImageFormatException: Could not load file or assembly 'TestWCFWrapper, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null' or one of its dependencies. An attempt was made to load a program with an incorrect format.File name: 'TestWCFWrapper, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null' at TestWrapperWCFClient.Form2.button1_Click(Object sender, EventArgs e) at System.Windows.Forms.Control.OnClick(EventArgs e) at System.Windows.Forms.Button.OnMouseUp(MouseEventArgs mevent) at System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons button, Int32 clicks) at System.Windows.Forms.Control.WndProc(Message& m) at System.Windows.Forms

I have spent a few hours trying to get this to work. I am using Report Builder 3.0 (locally), with SQL Server 2008 R2 Express Edition on a remote web server.
I am running Report Builder as an Admin under Win7 64bit.
All is OK until I attempt a Save of a newly created shared dataset. The error message is:
Failed to save dataset "mydataset.rsd"
The feature "Shared dataset" is not supported in this edition of Reporting Services.
Details:
The feature: "Shared dataset" is not supported in this edition of Reporting Services. ---> Microsoft.ReportingServices.Diagnostics.Utilities.OperationNotSupportedException: The feature: "Shared dataset" is not supported in this edition of Reporting Services.
I have researched the web, and the list of features for Express Edition does not list this feature as not being supported, although it does list "Shared component library" as being missing.
Could anyone please confirm the situation please. If it is a bug, is there any fix or workaround?
John Walton