Solved

CRM 4.0 Report errors following demoting domain controller

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

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

Question has a verified solution.

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

Introduction Earlier I wrote an article about the new lookup functions (http://www.experts-exchange.com/A_3433.html) that ship with SQL Server 2008 R2.  In this article I’m going to show you another new feature of SSRS 2008 R2, this time in the vis…
If you are a web developer, you would be aware of the <iframe> tag in HTML. The <iframe> stands for inline frame and is used to embed another document within the current HTML document. The embedded document could be even another website.
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …
A short tutorial showing how to set up an email signature in Outlook on the Web (previously known as OWA). For free email signatures designs, visit https://www.mail-signatures.com/articles/signature-templates/?sts=6651 If you want to manage em…

770 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