View Complete Post
I upgraded our enterprise sql server 2008 to sql server 2008 r2 last weekend. Along with this i installed the report builder 3.0 on the servers as well and the updated ssrs add in for sharepoint. The upgrade went fine, no errors that i could
find. The problem is now when i go to a library that has the report builder content type enabled and click report builder report under new it does not load report builder 3.0.
I updated the custom report builder url in central administration from /_vti_bin/ReportBuilder/ReportBuilder_2_0_0_0.application to /_vti_bin/ReportBuilder/ReportBuilder_3_0_0_0.application
however when i do click the new report builder report it kicks me over to
http://company.com/ReportServer_MossEnt which itemizes out each individual sharepoint site in the farm.
Is the integration of ssrs 2008 r2, sharepoint 2007 and report builder 3.0 work? did i install the wrong version of the report builder add in? The above is the only problem i am having now.
all servers are server 2008, 64 bit and moss 2007 enterprise with sp2 & april 2010 cu
our sharepoint server needs to be restarted twice a day now - always around 9.30am and 14.30pm. this has only started in the last 2 weeks. its working along fine then all of a sudden it goes to a dead page.
i have spent the last week trying to identify what it is. i have set the logging to verbose and put plenty of the messages in there into google but can not see anything relevant. the event viewer shows nothing.
i have sp2 installed but no cumalitve updates. i am wary of installing these at the mo and wreaking the whole thing. if noone has any suggestions ill install them. ill list soem details about the problem below.
it doesnt happen on weekends so it must have something to do with users using the system so im thinking something to do with the database (SQL Server 2000). NB users dont use our sp2007 on weekends.
if i restart iis, the layout of the page comes back but some of the webparts are dead so that doesnt work.
if i resart sql server, that doesnt work either.
there is plenty of room on drives and the task manager is at 20-30% when i check it when the site is down.
only a server resart seems to work.
there are just so many messages in the sp logs that i cant identify what it could be. is there any other loggi