I have CRM 2011 and the MS SQL server hosting the CRM database on a single server installation (OS: MS Server 2008 R2) .
I attempted to install Rollup 18 (the CRM installation was at Rollup 8) which failed. Attempting to access CRM via the web interface came up with Unexpected Error.
I tried updating again and this time the install went in, but I still have the error, and even uninstalling the updates hasn't fixed it.
I can see the CRM server and it's services working, SSRS and Reporting Extensions are installed, the MS SQL server is running and the CRM database and Config database are present. I can even run reports through SQL Server Business Intelligence Development Studio.
However, the Deployment Manager has the messages 'Reporting is not enabled' and 'One or more server roles are missing from this deployment', specifically the 'Full Server' role when I open the message. However, when I look at the Server list in the Deployment Manager it says that I have Full Server, SRS Data Connector and SQL Server roles.
Somehow the CRM server has lost contact with the SQL server, and I don't know how to get them to talk to each other again.