Upgrade to Microsoft SQL Server 2008 R2 RTM - Express with Advanced Services Failed

I am trying to upgrade my current version of Express to Express using Advanced Services to support full text search.

Current system setup:

  • OS Version: Windows Server 2008 R2 Web Server 64 bit
  • SQL Server 2008 R2 Express, SP1, v10.50.2500.0

I downloaded SQL Server with advanced services. I cannot update the version. The installation step goes through without any problems and even with the completed version update page. But as soon as I click the close this page button, an error message appears.

The following error was encountered in SQL Server Setup: Call or BeginInvoke cannot be called on the control until the window handle is available.

Can someone please help me here in the right direction?

I saw that the version of SQL Server Express with Advanced Services is 10.50.1600.1. This is the reason? So, should I override sp1 to regular Express r2 before upgrading?

Downloaded link for Express with Advanced Services http://www.microsoft.com/download/en/details.aspx?id=25174

+3


source to share


2 answers


I'm finally working!

I got below error. This is a bug and related to the user interface. So I upgraded using the command line, which is also in QUIET mode, to prevent interference with the interface.

"SQL Server Setup encountered the following error: Invoke or BeginInvoke cannot be called on the control until the window handle has been created."

Following are the steps I used: -

  • Downloaded the latest sp1 for SQL Server 2008 r2 with extended services (SQLEXPRADV_x64_ENU.exe) from http://www.microsoft.com/download/en/details.aspx?id=26729

  • Extracted file SQLEXPRADV_x64_ENU.exe to D: \ SQL2008

  • Open Command Prompt as "Administrator"
  • The following commands were executed

    D:\sql2008\setup.exe /ACTION=editionupgrade /INSTANCENAME=MyInstance /IACCEPTSQLSERVERLICENSETERMS  /FEATURES=SQL,RS  /INDICATEPROGRESS  /Q
    
          



* MyInstance is the sql server instance name

* / INDICATEPROGRESS will show the installation progress on the command line (to confirm :))

You can follow this document for more customization options        http://msdn.microsoft.com/en-us/library/ms144259(v=sql.105).aspx

  • Make sure the update was successful.
  • Unfortunately, the FULL-TEXT Search feature was not included.
  • So, run setup.exe as normalall (double click) and add "FULL-TEXT Search" function to the existing instance.

    Everything is fine now. Thanks everyone.

+5


source


I can verify that this error and same resolution apply to SQL Server 2008 R2 Express SP2 v10.50.4000.0



0


source







All Articles