asked on

SQL Server 2008 upgraded to R2 hosting MOSS

Dear experts,
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.
thanks
Dani

SOLUTION

honmapog

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

daniberes

ASKER

Thank you, there are a couple things in that article that I did not check on my servers so that was helpful. There are just so many different articles all over and you never know which is right. Or if its referring to the right combo of SharePoint and SQL, I also found out, that the add-in I was using was incorrect. I am going to try this one:
http://www.microsoft.com/download/en/details.aspx?id=793
Microsoft SQL Server 2008 SP2 Reporting Services Add-in for Microsoft SharePoint Technologies

Misleading without the R2, I will keep you posted if it works. I found this for supported combinations, hopefully someone may find it useful also:
http://msdn.microsoft.com/en-us/library/ff946054(v=SQL.100).aspx

thanks again, I appreciate any suggetions!!

ASKER CERTIFIED SOLUTION

daniberes

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

daniberes

ASKER

This is what i ended up using as the Add-in and it worked