Posts

Showing posts from March, 2012

Warm up the Web application and SQL Server Reporting Services on Windows Server

Image
Let me share the way of warming up the web application and also SSRS with the help of VB script running from the scheduled task. This will keep the applications alive and avoid the problem of long delays on the first hit after some period of inactivity. The VB script presented below sends the GET request to the designated URL using the ServerXMLHTTP object. We can pass the username and password to authenticate the request for reporting services. Dim strURL Set webObj = CreateObject("MSXML2.ServerXMLHTTP") ' Replace below URL with the URL of your report in the reporting server ' Replace below Username and Password with your credentials strURL = "http://MyReportServer/Reports/Pages/Report.aspx?ItemPath=MyReport" webObj.Open "GET", strURL, False, "Username", "Password" webObj.send ' For debugging - uncomment the line below to check the response status ' MsgBox(webObj.Status) ' Replace below URL with the URL of yo