Error creating reports on Microsoft CRM 4.0

Hi,

When I try to create a report on CRM 4 I get the following error:

"Error Uploading report - An error occurred while trying to add the report to Microsoft Dynamics CRM - Try the action again (...)" No error codes or helpful information at all.

The only errors I see, are on the logs of the CRM server:

Event Type:      Error
Event Source:      MSCRMReporting
Event Category:      None
Event ID:      19969
Date:            20/08/2008
Time:            11:02:25 AM
User:            N/A
Computer:      SERVERCRM
Description:
Web service request CreateReport to Report Server http://SERVERSQL/ReportServer/ReportService2005.asmx failed with SoapException. Error: The item '/MyCompany_MSCRM/4.0' cannot be found.

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

And this one:

Event Type:      Warning
Event Source:      ASP.NET 2.0.50727.0
Event Category:      Web Event
Event ID:      1309
Date:            20/08/2008
Time:            11:02:26 AM
User:            N/A
Computer:      SERVERCRM
Description:
Event code: 3005
Event message: An unhandled exception has occurred.
Event time: 20/08/2008 11:02:26 AM
Event time (UTC): 20/08/2008 10:02:26 AM
Event ID: 43df7809cd9c4e7c9195a1a06f15608b
Event sequence: 168
Event occurrence: 1
Event detail code: 0
 
Application information:
    Application domain: /LM/W3SVC/1/ROOT-1-128636995097340865
    Trust level: Full
    Application Virtual Path: /
    Application Path: c:\inetpub\wwwroot\
    Machine name: SERVERCRM
 
Process information:
    Process ID: 1768
    Process name: w3wp.exe
    Account name: NT AUTHORITY\NETWORK SERVICE
 
Exception information:
    Exception type: TargetInvocationException
    Exception message: Exception has been thrown by the target of an invocation.
 
Request information:
    Request URL: http://SERVERCRM/MyCompany/CRMReports/AdHocWizard/SuccessFailurePage.aspx?id=&CRMWRPCToken=TALAWWxQEd2J8AAMKWQXX2XcSPyOcAMrN7p8mo0U0BCOQgzp3P2TUAn unhandled exception has occurred.b06lAn unhandled exception has occurred.bO9wsO2&CRMWRPCTokenTimeStamp=633548232909971966
    Request path: /MyCompany/CRMReports/AdHocWizard/SuccessFailurePage.aspx
    User host address: 192.168.0.202
    User: MyCompany\CRMuser
    Is authenticated: True
    Authentication Type: Negotiate
    Thread account name: NT AUTHORITY\NETWORK SERVICE
 
Thread information:
    Thread ID: 5
    Thread account name: NT AUTHORITY\NETWORK SERVICE
    Is impersonating: False
    Stack trace:    at System.RuntimeMethodHandle._InvokeMethodFast(Object target, Object[] arguments, SignatureStruct& sig, MethodAttributes methodAttributes, RuntimeTypeHandle typeOwner)
   at System.RuntimeMethodHandle.InvokeMethodFast(Object target, Object[] arguments, Signature sig, MethodAttributes methodAttributes, RuntimeTypeHandle typeOwner)
   at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture, Boolean skipVisibilityChecks)
   at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture)
   at System.Web.Services.Protocols.LogicalMethodInfo.Invoke(Object target, Object[] values)
   at Microsoft.Crm.Extensibility.InternalOperationPlugin.Execute(IPluginExecutionContext context)
   at Microsoft.Crm.Extensibility.PluginStep.Execute(PipelineExecutionContext context)
   at Microsoft.Crm.Extensibility.Pipeline.Execute(PipelineExecutionContext context)
   at Microsoft.Crm.Extensibility.MessageProcessor.Execute(PipelineExecutionContext context)
   at Microsoft.Crm.Extensibility.InternalMessageDispatcher.Execute(PipelineExecutionContext context)
   at Microsoft.Crm.Extensibility.ExternalMessageDispatcher.Execute(String messageName, Int32 primaryObjectTypeCode, Int32 secondaryObjectTypeCode, PropertyBag fields, CorrelationToken correlationToken, CallerOriginToken originToken, UserAuth userAuth, Guid callerId)
   at Microsoft.Crm.Sdk.RequestBase.Process(Int32 primaryObjectTypeCode, Int32 secondaryObjectTypeCode, CorrelationToken correlationToken, CallerOriginToken originToken, UserAuth userAuth, Guid callerId)
   at Microsoft.Crm.Sdk.RequestBase.Process(CorrelationToken correlationToken, CallerOriginToken originToken, UserAuth userAuth, Guid callerId)
   at Microsoft.Crm.Sdk.CrmServiceInternal.Execute(RequestBase request, CorrelationToken correlationToken, CallerOriginToken originToken, UserAuth userAuth, Guid callerId)
   at Microsoft.Crm.Sdk.InProcessCrmService.Execute(Object request)
   at Microsoft.Crm.Application.Platform.ServiceCommands.PlatformCommand.ExecuteInternal()
   at Microsoft.Crm.Application.Platform.ServiceCommands.CreateFromTemplateCommand.Execute()
   at Microsoft.Crm.Application.Platform.DataSource.CreateFromTemplate(String wizardXml)
   at Microsoft.Crm.Web.Reporting.AdHocWizard.SuccessFailurePage.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 http://go.microsoft.com/fwlink/events.asp.

The SQL database is on a dedicated server with reporting services installed and the CRM reportings services connector installed. Reporting Services appear to be working correctly, there are no other error messages either on the CRM or SQL server.

Thanks in advance.Start Free Trial