Problem with CRM 2013 On Premise workflows failing and reporting not working

I have 2 problems, but they are inter-related.

MS CRM 2013 on premise, all functions on a Windows Server 2008 R2 VM with the SQL DB on a separate Windows Server 2008 R2 server.

1) Report Server not working as expected
2) CRM workflows stopped working.

CRM 2013 has been installed and working fine for years. About a month ago they wanted to start using reports, but the report server was never used or tested before. Tried to do some subscriptions and got the error message about credentials not stored. So I researched and at that time the SQL server was SQL 2008 standard. The requirements stated it must be at least SQL 2008 R2. So on Sept 4 I upgraded the SQL server to 2008 R2. Everything still working as normal after that but still no reports or subscriptions. Further research suggested that both the CRM server and the SSRS needed to be at 2013 SPM U4. The Server was 2013 SP1 U3 but SSRS was only 2013 SP1. So Friday afternoon I installed 2013 SP1 U3 on SSRS but it prompted for a restart. Well can not do that so waited until Saturday morning. At that time I restarted the SSRS server then installed 2013 SP1 U4 on the CRM server and on the SSRS server and both were restarted.

So, Monday morning I get an email saying all workflows failed after Friday afternoon.  I was told this AFTER I had been attempting to get reports to work by making some changes to the SSRS via the SQL Reporting Services Configuration Manager.

So, I need urgent help. First to get the workflows back working again and the to get the reports and subscriptions working.

Another indication of a problems is that in the Deployment Manager on the CRM server, the organization version shows 6.1.3.119 when it should be showing 6.1.4.145 and with a status of failed.
LVL 1
John TolmachoffNetwork AdministratorAsked:
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.

Feridun KadirPrincipal ConsultantCommented:
This could be tricky to solve remotely. However, it sounds like your deployment was upgraded but not the database. I fyou right-click on the organization in deployment manager do you see an option to update the database?  If so you should try that BUT it would be wise to have a SQL backup of the CRM database first.  If the update fails, review the log which is somewhere in the depths of the profile for the user that you are logged in as.

Also, does Windows Event viewer report anything useful around the time of the upgrade?
John TolmachoffNetwork AdministratorAuthor Commented:
There is no option to update the organization.
John TolmachoffNetwork AdministratorAuthor Commented:
Forgot to attach screen shotC--Users-jtolmachoff-Desktop-Temp-20.gif
Become a Microsoft Certified Solutions Expert

This course teaches how to install and configure Windows Server 2012 R2.  It is the first step on your path to becoming a Microsoft Certified Solutions Expert (MCSE).

John TolmachoffNetwork AdministratorAuthor Commented:
And no errors or warnings in the event log recorded. How can I manually update the database?
Feridun KadirPrincipal ConsultantCommented:
Hmm, tricky.  How about this?  In SQL Server, perform a backup of your CRM database (the one that ends in _MSCRM). Then restore the backup to a database with a different name, so you are making a copy.
Then in deployment manager, use Import Organization to see if the database will import will come in succesfully and get updated. During this wizard there will be a page on mapping users, select the option to keep existing mappings. This will help decide if the org can be upgraded. If it fails I suspect you will need to contact MS support.
John TolmachoffNetwork AdministratorAuthor Commented:
Can that be done with users connected to the existing DB or does that need to be off line?
Feridun KadirPrincipal ConsultantCommented:
They can be still connected. But performing the backup , the restore and import might slow things down so do consider doing it out of hours.
John TolmachoffNetwork AdministratorAuthor Commented:
Also will then import take on the same organization name, or can I assign a new organization name to avoid any conflict?
Feridun KadirPrincipal ConsultantCommented:
You can and indeed must specify a new organization name during the Import process.
John TolmachoffNetwork AdministratorAuthor Commented:
OK got to the point of choose existing user mappings. That resulted in an error. Looking at details, there are users which are no longer in AD but still exist in CRM. 15 users do not have a mapping of a total of 51. What should I do?
Feridun KadirPrincipal ConsultantCommented:
You can accept the error message and continue anyway. You'll get a message of something like "not all users are mapped"
John TolmachoffNetwork AdministratorAuthor Commented:
OK that test did complete and did work successfully updating the organization.

So now I will delete that and delete that test DB and then make a full backup of the existing DB and delete the existing organization and then recreate the DB restoring from backup and then import the organization.
Feridun KadirPrincipal ConsultantCommented:
Glad to hear that worked.  Thought I don't think you need to delete the database from SQL..

I would in Deployment Manager Disable the test db
In SQL delete the test tb
In SQL make a backup of the production database
In Deployment Manager disable the production database
In Deployment Manager delete the production database but not from SQL
In Deployment Manager, import the production database

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
John TolmachoffNetwork AdministratorAuthor Commented:
OK thank you for your help. I completed that early this morning and it works as expected. I will open a different question with the report server issue later.
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 Dynamics

From novice to tech pro — start learning today.