CRM issue and report server

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 ...
beckredderAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Chinmay PatelChief Technical NinjaCommented:
Can you check if recently the password for this crm sys account has not been changed or expired?
0
DcpKingCommented:
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.

hth

Mike
0
beckredderAuthor Commented:
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
Event-1309.txt
0
Chinmay PatelChief Technical NinjaCommented:
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.

http://support.microsoft.com/kb/918609
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Office

From novice to tech pro — start learning today.