Reporting Services Staaaarrrrrtttt Up

I hear the complaint a lot that after a time period of no calls to Reporting Services, the first call to the Reporting Services instance is very slow.  This is totally expected because the application pool generally gets spun down and we need to restart everything. If you wire up some basic web service calls,…


Changing the location of Log files for SQL Server Reporting Services

I have found a few occasions where I have needed to change the location of my Reporting Services Logfiles and wanted to share it with you. There are three files you need to modify to change the location of the Reporting Services Logfiles. These files are:    ·   c:Program FilesMicrosoft SQL ServerReporting ServicesReportManagerweb.config ·   c:Program…


Why is the Initialization checkmark sometimes grayed out in Reporting Services 2005 Configuration Manager?

Just a quick post for Reporting Services.   If you are using the Standard edition of Reporting Services, the initialization pane is grayed out in Reporting Services Configuration Manager.   You should still see the checkmark. This is grayed out because scale out to a web farm is not available in this edition. If the Report…


401.1 when trying to access reports from client machines

A lot of times, we will see this issue manifest itself where reports run fine from the web server directly, but client machines get three authentication dialog boxes, then fail with a 401.1 error message.    The problem here is that Windows XP SP2 and Windows 2003 SP1 implemented a security check that compares the…


Help! All of my reports fail with an authentication failure!

Have your Reporting Services 2005 reports started failing recently with the error message?   Logon failed. (rsLogonFailed) Logon failure: unknown user name or bad password. (Exception from HRESULT: 0x8007052E)   Check your Unattended Execution Account (UEA).  Is it a domain user?    If so, check to see if the domain user’s password has changed.  Has…