Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

CRM 4.0 Report errors following demoting domain controller

Posted on 2011-03-15
5
Medium Priority
?
843 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

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

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…
A phishing scam that claims a recipient’s credit card details have been “suspended” is the latest trend in spoof emails.
Add bar graphs to Access queries using Unicode block characters. Graphs appear on every record in the color you want. Give life to numbers. Hopes this gives you ideas on visualizing your data in new ways ~ Create a calculated field in a query: …
We’ve all felt that sense of false security before—locking down external access to a database or component and feeling like we’ve done all we need to do to secure company data. But that feeling is fleeting. Attacks these days can happen in many w…
Suggested Courses

670 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