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…


“Unexpected error occurred” during SQL Server 2005 SP1 install.

When you are trying to install SP1 you may see “Unexpected error” message. This error message will appear right after package has been extracted in a temporary folder.   Popup window will have a title “Unexpected error occurred” Window text: “The following unexpected error occurred”.   Confirm Behavior In order to confirm this behavior please…


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…


MSDTC and SQL Server on a cluster

Through this blog, we will try to address commonly asked questions about MSDTC and SQL Server on a cluster. All this information is available in BOL and KB articles, but we will summarize it here for your convenience.   Do I need to install MSDTC on my SQL Server 2005 cluster?Before installing SQL Server 2005…


SQL Server and Network Attached Storage (NAS)

Through this blog, we will address some of the commonly asked customer questions on SQL Server and Network Attached Storage (NAS).   Support for NAS database files with SQL ServerYou can configure SQL Server to store a database on a networked server or NAS storage server. You need to enable trace flag 1807 before you…