Common upgrade issues with SQL Server 2008

When updating to SQL server 2008, running the update advisor is a good start. However, there are a few issues that the advisor does not properly identify. The purpose of this article is to list these types of issues. As you find more, please add to this document.

 

Prior to starting an upgrade, make sure that the existing instances have the newest service pack applied. At this time, SQL Server 2000 sp4 and SQL Server 2005 sp2 are the latest service packs. If you install a service pack, you will have to reboot the server prior to upgrading to SQL Server 2008.

 

The installer also runs through several validation checks. One of these checks is to verify the validity of all registry keys pertaining to existing instances of SQL Server.  If the installer fails at this (or any) point, check the files in %ProgramFiles%\Microsoft SQL Server\100\Setup Bootstrap\Log  for details regarding why the step failed.

For example:

2008-06-13 12:05:25 Slp: Could not fix registry key HKEY_LOCAL_MACHINE\Software\Microsoft\Microsoft SQL Server\ACT7\MSSQLServer\SuperSocketNetLib\Lpc.
2008-06-13 12:05:25 Slp: System.UnauthorizedAccessException: Attempted to perform an unauthorized operation.
2008-06-13 12:05:25 Slp:    at Microsoft.SqlServer.Configuration.FixSqlRegistryKey.Program.OpenKey(String keyName)
2008-06-13 12:05:25 Slp:    at Microsoft.SqlServer.Configuration.FixSqlRegistryKey.Program.FixRegistryKey(String keyName)
2008-06-13 12:05:25 Slp:    at Microsoft.SqlServer.Configuration.FixSqlRegistryKey.Program.FixRegistryKeyAndSubKeys(RegistryKey key)

 

This indicates that the current user (you, administrator) does not have access to modify registry keys. to correct this, perform the following steps:

  1. Start > Run > Regedit
  2. Create a backup of the registry just in case
  3. Find the problematic key as indicated in the logs
  4. Right click key, permissions
  5. Check for entries for 'Administrator' or 'Administrators'
  6. If they do not exist, click add, advanced, find now
  7. Select 'Administrators'
  8. Add 'Full Control' and click 'OK' through all dialog boxes
  9. Close regedit
  10. Click 'retry' at the top of the SQL Server 2008 installer validation screen