How can I limit the number of reboots when applying hotfixes and the like to SQL Server and OS?

Avoiding reboots after applying a Service Pack or a hotfix to SQL is a big concern to our customers.   In SQL 2005, we have made several enhancements to help you avoid a reboot after applying Service Packs and hotfixes.   To learn about these enhancements, read our MSDN article here.   Happy reading!  …


We upgraded our servers to Windows 2003 SP1, and now our data-driven application fails with strange errors!

Problem Description After upgrading an application server or database server to Windows 2003 SP1, the application encounters errors originating from data-access components.  Typically we’ll see this when one server in the application server/database server scenario is updated and the second server is left on a previous version of the OS (particularly Windows 2000 Server).  …


Tracking License Information in SQL 2005

SQL 2005 no longer tracks licensing (per seat or per processor) via registry entries. SQL 2005 still reads the registry for this information, but the SQL 2005 setup doesn’t put licensing information in the registry during setup as in SQL 2000.   This is by-design. Hence, when ServerProperty(‘LicenseType’) is run on a SQL 2005 installation,…


Installing MS06-061 on NT4

When installing MS06-061 for MSXML4 SP2, you may receive the following error when trying to run msxml4-KB925672-enu.exe:   The specified program requires a newer version of Windows.   NOTE – Before installing this update, please make sure you have already installed SP2 for MSXML4.   In order to install the update properly, you need to…


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…


PART I – Data security enhancements in SQL Server 2005

In this two part series, we will talk about data encryption and its implementation in SQL Server 2005.   You may encrypt sensitive data like credit card numbers, client information etc. using SQL Server data encryption functionality.   Let’s take an example to demonstrate the different steps involved in encrypting and decrypting your data.  …


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…


“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…