CRM issue and report server

Posted on 2013-09-19
Medium Priority
Last Modified: 2013-11-26
I have a CRM 2011 on premise server and have some custom reports that I have been using for months now.  This week 1 of the 4 reports stopped working.  It basically times out and will not produce the report.

The only error that Is on the CRM server is the following:

Web service request SetDataSourceCredentials to Report Server http://xxx-xxx/reportserver failed. Error: The operation has timed out

I also see some login errors for the CRM administrator account (on the SQL log file viewer) at the same time of the report inquiry.

" login failed for user "xxxxx\CRMSYS".  Reason: Failed to open the explicitly specified database. {Client:<local machine>}

any help would be appreciated ...
Question by:beckredder
  • 2
LVL 27

Expert Comment

by:Chinmay Patel
ID: 39506944
Can you check if recently the password for this crm sys account has not been changed or expired?
LVL 16

Expert Comment

ID: 39508025
After checking the password, can you think of any changes that have been made recently to the database? After that, have you been steadily increasing the amount of data  involved in the report? If it has been getting slower and slower then you may have finally gone over the time-out limit somewhere, and you'll need to look at the query and try to optimise it somehow so that it takes less time.



Author Comment

ID: 39515430
Thanks, there have been no changes to the Sys account.

The data has not increase substantially as we are testing a new add on to the CRM.  Where do I chang the time out limit btw?

look at the attached error log please and let me know your views
LVL 27

Accepted Solution

Chinmay Patel earned 1000 total points
ID: 39590144
Hmmm I saw    NT AUTHORITY\NETWORK SERVICE generally it is not recommended to use Network Service and use a service account to run services.

Also if you need to change timeout values you can try this KB Article. Look at OLEDBTimeout.


Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

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

I tried to use the SharePoint app to Import a Spreadsheet and import an Excel sheet into a Team site made in SharePoint 2016. But that just resulted in getting an error message 'Unknown Error'...
In this article, we will see two different methods to recover deleted data. The first option will be using the transaction log to identify the operation and restore it in a specified section of the transaction log. The second option is simpler and c…
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…
Enter Foreign and Special Characters Enter characters you can't find on a keyboard using its ASCII code ... and learn how to make a handy reference for yourself using Excel ~ Use these codes in any Windows application! ... whether it is a Micr…

624 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