Solved

CRM 4.0 Report errors following demoting domain controller

Posted on 2011-03-15
5
834 Views
Last Modified: 2012-06-21
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
Comment
Question by:GlennCameron
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
5 Comments
 

Author Comment

by:GlennCameron
ID: 35144595
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
 
LVL 15

Expert Comment

by:pcsmitpra
ID: 35148813
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
 

Author Comment

by:GlennCameron
ID: 35153513
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
 

Accepted Solution

by:
GlennCameron earned 0 total points
ID: 35265449
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
 

Author Closing Comment

by:GlennCameron
ID: 35312649
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

Featured Post

Best Practices: Disaster Recovery Testing

Besides backup, any IT division should have a disaster recovery plan. You will find a few tips below relating to the development of such a plan and to what issues one should pay special attention in the course of backup planning.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Introduction: Sometimes when I receive a call from my users to solve their problems it is very difficult for me to found their computer IP address. Even finding their computer Host to provide remote support can be a problem.  So I resorted to Goo…
This is a fairly complicated script that will install the required prerequisites to install SCCM 2012 R2 on a server.  It was designed under the functional model in order to compartmentalize each step required, reducing the overall complexity.  The …
The Email Laundry PDF encryption service allows companies to send confidential encrypted  emails to anybody. The PDF document can also contain attachments that are embedded in the encrypted PDF. The password is randomly generated by The Email Laundr…
Attackers love to prey on accounts that have privileges. Reducing privileged accounts and protecting privileged accounts therefore is paramount. Users, groups, and service accounts need to be protected to help protect the entire Active Directory …

756 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question