CRM 2011 server is not working properly after install of Rollup 18

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.

"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.