Thursday, August 10, 2006

SQL Server 2005 SP1 Installation

Tried to install SQL Server Service Pack 1 (SP1) on one of our production SQL Server 2005 servers. I had installed the SP1 on our development server so I am pretty confident that it will be a smooth upgrade. Well, guess what happens during the installation?

The installation for the Database Service component failed while other components are successful. It even causes the SQL Server service not to start because it complains that the service account does not have the right. I change service to use “Local System account” and the service manages to start. I did a restore of the “Master”, “Model” and “Msdb” databases. Set the SQL Server service back to use the designated domain service account and it works. Rebooted the server and tried to install SP1 again. It failed again. Checked through the installation log and did some searching on the net and found out that the culprit was those *$4IDR files residing in the “Data” folder where all other database files were located. Those *$4IDR files were created by Veritas BackupExec and only the backup service account has right over them. After I set those *$4IDR files to inherit permission from the parent, I tried to install the SP1 again. Well, it works!!!

The solution is from a Microsoft forum.

No comments: