Unable to run reports from CRM

Hi Guys
I've been struggling to get reports running on a crm system. Rollup 2 was applied recently but I'm not absolutely sure the reports were functioning prior to this.
I have seen the MS article that describes the tracelog error but I'm not going across a trust for domain queries and I'm not importing companies so I don't think it applies to me.

The configuration is a CRM server then behind that an sql server with reporting services, there is a provisioning server as well.

There are a few other CRM servers with reports functioning correctly with a similar setup in this environment but for the life of me I can't see where the problem lies.

I've been over and verified microsofts additional steps when SQL RS is install on a seperate server from CRM and it all fits. The crm IIS site runs as a service account and the reporting service iis runs as the network service.
From the user perspective they receive the error crm window in IE with the following

Reporting error
The report cannot be displayed

From the CRM servers event log.
Web service request SetDataSourceCredentials to Report Server http://server.domain/ReportServer failed with SoapException. Error: An error has occurred during report processing. (rsProcessingAborted)

For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.

Event code: 3005
Event message: An unhandled exception has occurred.
Event time: 1/05/2009 8:52:43 a.m.
Event time (UTC): 30/04/2009 8:52:43 p.m.
Event ID: 34f16dca62ca417a83a702819f5d7de0
Event sequence: 11895
Event occurrence: 18
Event detail code: 0
 
Application information:
    Application domain: /LM/W3SVC/1/ROOT-1-128855114073071492
    Trust level: Full
    Application Virtual Path: /
    Application Path: c:\inetpub\wwwroot\
    Machine name: SERVER
 
Process information:
    Process ID: 3220
    Process name: w3wp.exe
    Account name: DOMAIN\SERVICEACCOUNT
 
Exception information:
    Exception type: CrmReportingException
    Exception message: An error has occurred during report processing. (rsProcessingAborted)
 
Request information:
    Request URL: http://EXTERNALURL/CRMReports/rsviewer/reportviewer.aspx
    Request path: /CRMReports/rsviewer/reportviewer.aspx
    User host address: HOSTIP
    User: {9693860f-c118-de11-9982-005056973caf}
    Is authenticated: True
    Authentication Type: CrmPostAuthentication
    Thread account name: DOMAIN\SERVICEACCOUNT
 
Thread information:
    Thread ID: 1
    Thread account name: DOMAIN\SERVICEACCOUNT
    Is impersonating: False
    Stack trace:    at Microsoft.Crm.Web.Reporting.SrsReportViewer.SetExecutionCredentials(ServerReport report)
   at Microsoft.Crm.Web.Reporting.SrsReportViewer.ConfigurePage()
   at Microsoft.Crm.Application.Controls.AppUIPage.OnPreRender(EventArgs e)
   at System.Web.UI.Control.PreRenderRecursiveInternal()
   at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
 
 
Custom event details:

For more information, see Help and Support Center at


From the Reporting Services tracelog

w3wp!processing!5!4/30/2009-20:09:29:: e ERROR: Throwing Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: Cannot create a connection to data source 'CRM'., ;
 Info: Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: Cannot create a connection to data source 'CRM'. ---> System.DirectoryServices.DirectoryServicesCOMException (0x80072030): There is no such object on the server.

   at System.DirectoryServices.DirectoryEntry.Bind(Boolean throwIfFail)
   at System.DirectoryServices.DirectoryEntry.Bind()
   at System.DirectoryServices.DirectoryEntry.get_AdsObject()
   at System.DirectoryServices.PropertyValueCollection.PopulateList()
   at System.DirectoryServices.PropertyValueCollection..ctor(DirectoryEntry entry, String propertyName)
   at System.DirectoryServices.PropertyCollection.get_Item(String propertyName)
   at Microsoft.Crm.BusinessEntities.SecurityUtils.GetSidFromAD(Guid objectGuid)
   at Microsoft.Crm.Reporting.DataConnector.SrsExtConnection.ValidateCaller(Guid systemUserId, Guid organizationId)
   at Microsoft.Crm.Reporting.DataConnector.SrsExtConnection.Microsoft.ReportingServices.DataProcessing.IDbConnection.Open()
   at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.ReportRuntimeDataSourceNode.OpenConnection(DataSource dataSourceObj, ReportProcessingContext pc)
   --- End of inner exception stack trace ---
w3wp!processing!5!4/30/2009-20:09:29:: e ERROR: Data source 'CRM': An error has occurred. Details: Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: Cannot create a connection to data source 'CRM'. --->8:18 p.m. 30/04/2009.

w3wp!processing!5!4/30/2009-20:09:29:: e ERROR: An exception has occurred in data source 'CRM'. Details: Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: Cannot create a connection to data source 'CRM'. ---> System.DirectoryServices.DirectoryServicesCOMException: There is no such object on the server.

w3wp!processing!5!4/30/2009-20:09:29:: i INFO: Merge abort handler called. Aborting data sources ...
w3wp!processing!5!4/30/2009-20:09:29:: e ERROR: Throwing Microsoft.ReportingServices.ReportProcessing.ProcessingAbortedException: An error has occurred during report processing., ;
 Info: Microsoft.ReportingServices.ReportProcessing.ProcessingAbortedException: An error has occurred during report processing. ---> Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: Cannot create a connection to data source 'CRM'. ---> System.DirectoryServices.DirectoryServicesCOMException: There is no such object on the server.