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
source to share
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.
source to share