Hi Everyone:
For the life of me I cannot run reports no matter what I've done. It seems like every deployment I've ever done gets me in a bind with reporting and I cannot ever get it right without several days of trying various hacks and workarounds found on the web. Well, here's today's modern reporting mystery. I run any report and get a screen that looks like the one pictured below then get an error in event viewer relating to ASP.NET 2.0 with code 1309 event 3005
Log Name: Application Source: ASP.NET 2.0.50727.0 Date: 2/17/2023 10:37:00 AM Event ID: 1309 Task Category: Web Event Level: Warning Keywords: Classic User: N/A Computer: omega2.WINX-CESD-US.LOCAL Description: Event code: 3005 Event message: An unhandled exception has occurred. Event time: 2/17/2023 10:37:00 AM Event time (UTC): 2/17/2023 6:37:00 PM Event ID: 108cd028e4f74ecb8cd1dea66ca14733 Event sequence: 3 Event occurrence: 2 Event detail code: 0 Application information: Application domain: /LM/W3SVC/1/ROOT/CRMReports/rsviewer-2-133210874250954911 Trust level: Full Application Virtual Path: /CRMReports/rsviewer Application Path: C:\inetpub\wwwroot\CRMReports\rsviewer Machine name: OMEGA2 Process information: Process ID: 2884 Process name: w3wp.exe Account name: NT AUTHORITY\NETWORK SERVICE Exception information: Exception type: ArgumentException Exception message: 'Microsoft.Crm.WebServices.Crm2007.CookieAndSoapHeaderAuthenticationProvider, Microsoft.Crm.WebServices, Version=4.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35' doesn't exist. Parameter name: Microsoft.Crm.WebServices.Crm2007.CookieAndSoapHeaderAuthenticationProvider, Microsoft.Crm.WebServices, Version=4.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35 Request information: Request URL: http://icare-live.omega2.winx-cesd-us.local/CRMReports/rsviewer/reportviewer.aspx Request path: /CRMReports/rsviewer/reportviewer.aspx User host address: 192.168.27.2 User: WINX-CESD-US\cfleischmann Is authenticated: True Authentication Type: Negotiate Thread account name: NT AUTHORITY\NETWORK SERVICE Thread information: Thread ID: 13 Thread account name: NT AUTHORITY\NETWORK SERVICE Is impersonating: True Stack trace: at Microsoft.Crm.Authentication.BaseAuthenticationSettings.CreateType(String typeName, Type requiredBaseType) at Microsoft.Crm.Authentication.BaseAuthenticationSettings.CreateProvider(String typeName, IDictionary`2 configuration) at Microsoft.Crm.Authentication.AuthenticationPipelineSettings.LoadPipeline() at Microsoft.Crm.Authentication.AuthenticationPipelineSettings.get_AuthenticationProvider() at Microsoft.Crm.Authentication.AuthenticationEngine.Execute(Object sender, EventArgs e) at System.Web.HttpApplication.SyncEventExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) Custom event details: Event Xml:
Here's More information:
What Machines:
* WINX-MAGIX1: Domain Controller
* WINX-MAGIX2: Domain Controller
* DARCY909: SQL 2005 With Service Pack 4 Database Server This also has reporting services on it which means that IIS is installed
* OMEGA2: Microsoft Dynamics CRM 4.0 with UR-21 and help update. This also has IIS installed
What Configurations:
* All Relevant computers are Windows Server 2008 (32-Bit)
* ASP.Net Execution Runtime increased in the web.config at the CRM Server
* Anonymous Authentication enabled
* I had to manually configure CRM as an IFD so the registry key is set to: 192.168.27.110-255.255.255.255 (Forms-Auth for all) (I Think that I might be able to attach the instructions I followed as a PDF)[View:/cfs-file/__key/communityserver-discussions-components-files/117/8272._5F00_Enable-forms-auth-CRM-4.pdf]
Note that I had to basically read a bunch of books and even various Microsoft deployment and setup guides to get all the information concatenated into this PDF and the reason I went this route is that MS took away the download for the IDF Configuration Tool eons ago so I had to hack it together like this. Also sorry for any spelling errors and the like in that document
* Report Viewer control has been updated on the CRM Server
* Both CRM Server and SQL Server have been set for trust for delegation (Kerberos Only) in ADUC
Where have I gone so wrong short of my odd preference for IFD and Forms Auth? I know... I'm probably going to hear it from the security folks in the back "you shouldn't be running such old software..." but I have my various medical reasons for doing so. Anyhow, I would really appreciate any help that can be given to me on this one.