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...

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...

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...

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...

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...

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 Server You can configure SQL Server to store a database on a networked...

It is important to understand that SQL Server database on compressed volumes are not supported. This blog will help you understand the differences between SQL 2000 and SQL 2005 w.r.t compressed drives. SQL 2000 In SQL Server 2000, you could create...