Solved

CRM 4.0 Report errors following demoting domain controller

Posted on 2011-03-15
5
833 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
  • 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

Microsoft Certification Exam 74-409

Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

Question has a verified solution.

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

Experts-Exchange users below are the steps you can follow to upgrade your Lync server to latest CU's or cumulative updates. Note: Perform it during non-production hours.   Step 1: Backup your lync and SQL server database. Follow below article: h…
As tax season makes its return, so does the increase in cyber crime and tax refund phishing that comes with it
This video shows how to quickly and easily add an email signature for all users on Exchange 2016. The resulting signature is applied on a server level by Exchange Online. The email signature template has been downloaded from: www.mail-signatures…
Established in 1997, Technology Architects has become one of the most reputable technology solutions companies in the country. TA have been providing businesses with cost effective state-of-the-art solutions and unparalleled service that is designed…

808 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