Post reply

Upgrading SQL 2005 to SQL 2008 R2 on VM - Invalid Function Error

  • April 9, 2012 at 6:11 am

    #258902

    Hello,

    When trying to Upgrade a virtual server from SQL 2005 to SQL 2008 R2 I keep encountering the "Invalid Function ." error. All of the pre-upgrade tasks pass but for some reason I still keep getting this error when trying to upgrade. The error detail is below. If anyone has any ideas please let me know, thanks.

    Description:

    SQL Server 2008 R2 Setup has encountered an error.

    Problem signature:

    Problem Event Name:SQL100Exception

    Problem Signature 01:SQL Server 2008 R2@RTM@

    Problem Signature 02:0x60797DC7

    Problem Signature 03:0x60797DC7

    Problem Signature 04:0xAC9299FD

    Problem Signature 05:0xAC9299FD

    Problem Signature 06:GatherUserSettings

    Problem Signature 07:Unknown

    Problem Signature 08:Unknown

    Problem Signature 09:Unknown

    Problem Signature 10:Unknown

    OS Version:6.0.6002.2.2.0.272.7

    Locale ID:1033

    Additional information about the problem:

    LCID:1033

  • April 10, 2012 at 5:17 am

    #1471144

    Does the upgrade have to install and pre-requisite software before it can start the SQL 2008 R2 install?

    To get from SQL 2005 to SQL 2008 R2 you need to install .Net3, Windows Installer 4.5, and Powershell (preferably v2) . It can be worth installing each of these manually and troubleshooting any problems that arise.

    If you are very unlucky you may find that .Net3 will not install. If your server has had a lot of installs and uninstalls, then .Net3 may not want to play, this happens to maybe 1 in 10 old build servers. There is a Microsoft tool that fixes about half the problems, but in some situations the only way forward is to reinstall Windows.

    If the problem happens during the SQL install, how fast is your server? The SQL install starts and stops services alot of time, and if one of these times out the install can fail. In FineBuild I do a timing test and on a slow server I set the ServicesPipeTimeout registry value to allow for this.

    Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.

    When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply