• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 853
  • Last Modified:

CRM 4.0 Report errors following demoting domain controller

Hi,

Over the weekend, I demoted our last Server 2003 doman controller to member server, It is currently a SQL server and serves the SRS component of our CRM 4 environment.

Following the demotion, everything appeared to be fine. Other SQL databases were accessible, CRM and SharePoint funtioned correctly.

Today I found an error when trying to run a report through CRM. The text file attached holds the contents, and the messages below are the most relevant I think:

Client found response content type of 'text/html; charset=utf-8', but expected 'text/xml'.

Error Number:
0x80048300

I thought it might be a permissions issue, but that doesn't match what the error indicates.

Cheers
CRMReportError.txt
0
GlennCameron
Asked:
GlennCameron
  • 4
1 Solution
 
GlennCameronAuthor Commented:
I have applied these changes:

http://support.microsoft.com/kb/332097

and

http://technet.microsoft.com/en-us/library/bb418935.aspx

And now have a different error:

Server Error in '/' Application.
--------------------------------------------------------------------------------

Object reference not set to an instance of an object.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.NullReferenceException: Object reference not set to an instance of an object
.



0
 
pcsmitpraCommented:
On the server side change the error mode Off or local only in Web.config. Also change the Internet explorer -> tools -Internet options -> Advance -> "Show HTTP friendly error message" Uncheck this option.
Check event viewer for related error and please mention both error details here.
0
 
GlennCameronAuthor Commented:
I think some progress has been made now. I modified permissions of several of the IIS folders,and I changed the account the SRS service runs under to the domain admin for the time being.

I'm getting this error now:

Error Details:
An error has occurred during report processing. (rsProcessingAborted)

Full Stack:
[ReportServerException: For more information about this error navigate to the report server on the local server machine, or enable remote errors]


[ReportServerException: Cannot create a connection to data source 'CRM'. (rsErrorOpeningConnection)]

0
 
GlennCameronAuthor Commented:
I think the issue was permissions in several locations.

All the IIS related folders needed to be modified, and the accco"Execution Account" in the Reporting Services had to be changed to an admin account.
0
 
GlennCameronAuthor Commented:
There was not a lot of info to help with this issue, and my efforts were not very structured, but achieved a result all the same. I suspect the Execution account should not be an admin account, and I might look at changing this later on.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

  • 4
Tackle projects and never again get stuck behind a technical roadblock.
Join Now