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

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

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

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

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