SQL Server 2008 upgraded to R2 hosting MOSS
Posted on 2011-09-28
So I have a development environment with a MOSS 2007 server and a SQL Server 2008 and SSRS configured. The dba in my company decided to upgrade the SQL Server to 2008R2, and we started running into one issue after another, I finally realized that the Reporting services add-in had to be upgraded also. (I am NO SSRS expert) once I upgraded the add-in my sharepoint does not want to work anymore, I have tried running the Wizard AND psconfig. fails, at the SharePoint Services :
An exception of type System.Reflection.REflectionTypeLoadException was trhown. Additional esceoption information: Unable to load one or more of the requested types. RetrievetheLoaderExceptions property for more information.
PLEASE HELP if anyone has any suggestions. I dont think the DBA even backed up these servers and a lot of data will be lost if I cant reconnect to the existing databases.