I have been using SQL Server 2008 for a num­ber of report­ing and ana­lyt­i­cal func­tions in the Be-Mobile plat­form. Most impor­tantly, I have been using SSRS for the daily oper­a­tional site reports. The sys­tem has been up and run­ning for some time now, but about a month ago started giv­ing me seri­ous prob­lems. When I deploy the main report, it sim­ply times out. No error mes­sage is given, sim­ply “The oper­a­tion has timed out”

SSRS 2008 Deploy Timeout

I cre­ated a new project to test if it was just an issue with this one report, or if it was a sys­tem wide issue. What I found is that when a report is small and sim­ple, it deploys per­fectly, but as soon as it get a lit­tle bit big­ger or more com­plex it does not deploy.

To resolve the issue I have unin­stalled and rein­stalled SQL Server, and tried it with both SP1 and with­out SP1. Still noth­ing works, and I am unable to deploy reports. I have also encoun­tered a major issue with data dri­ven sub­scrip­tions now, in that the Report Man­ager hangs when try­ing to cre­ate a data dri­ven subscription.

I believe it could be one of two things. Firstly, I am run­ning SQL Server on Win­dows XP, which I do not think is a good idea. I plan to upgrade to Win­dows Server to see if that resolves the issue. Sec­ondly my data source is a MySQL data­base, and I believe that that could be caus­ing prob­lems too. Should the upgrade to Win­dows Server not help, my next step will be to load the data into SQL Server for report­ing purposes.

I have not found any­thing on the web that has helped me, and if any­one has any ideas I would be very very grateful.