I am running Windows Server 2008 R2 Enterprise and Forefront TMG 2010 adn SQL-Express as local database
After upgrading Forefront TMG 2010 to sp1 reports stopped generates. Reports are empty. First problem was "The report server cannot process the report. The data source connection information has been deleted. (rsInvalidDataSourceReference)" but I`ve solved it by re-writing connection string(I`ve add 1433 port to Data Source) + unblocking port 1434. So reports are accessible, but they are blank. I`ve checked sql-tables(by creating "select" procedure) and recovered that after upgrading date there is no data was writing to tables, that`s why reports are empty. Logs work without any problem, but I`ve tried to generate and view report from ForeFront TMG Management but it throw error "Report Server error information: System.Web.Services.Protocols.SoapException: The report server cannot process the report. The data source connection information has been deleted". Kindly suggest me the solution ,how can I fix this problem
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!