July, 2008

During the upgrade for the SQL Server 2000 to SQL Server 2005, the upgrade completes but with an error message related to the "Enforce Password Policy". The error message can be found in the setup log files but the server upgrade completes and you cans...

Maintenance Plans with “Backup Database Task” fails when the “Create a sub-directory for each database” option is checked, with error similar to the below, “Cannot open backup device 'D... The package execution fa... The step failed.,00:00:01,0,0,...

While installing security patch KB 948109 on the sql server 2005, the installation of the patch may fail. In order to find the cause of the failure we need to look into the setup bootstrap logs which are located in the following location C:\Progarm...

We have a production database in which the data is encrypted. The encryption follows the following hierarchy 1) The data is encrypted using Symmetric key 2) The symmetric key was encrypted using asymmetric key 3) The asymmetric key was encrypted...

The ACT7 software installs sql server 2005 express edition along with the installation of ACT7 software. When we try to apply the latest security patch 948109 released by Microsoft for SQL server 2005, the installation may fail. In order to find the...

There are new vulnerability security patches which have been released for sql server 2000,sql server 2005. We can refer the following KB article which provides the overview of the new patches which are released http://support.microsoft.com/?id=941203...

Did you know that Windows Server 2008 installation, by default, enables the Windows firewall to be ON just like Windows Vista. So there is a possibility that in the previous installations, you have not been using the Windows Firewall and disabled it for...