One of a unique advantage of freelancing is learning more and more. I get a chance to hear some of the real word problem and it gives me immense pleasure to provide a feasible solution to them. This blog is interaction on the airport when I was coming back from a recent trip from Canada. After seeing me on airport, an old client of mine met and said hello. While having a discussion, he told an interesting issue of SQL upgrade and he wanted an idea. He showed me below error message related to edition upgrade.
Here is the text of the error message. Did you know that you can click on that little copy icon to get details like below?
SQL Server Setup has encountered the following error:
Invoke or BeginInvoke cannot be called on a control until the window handle has been created..
After we hit OK on the dialog, SQL Server installation exits.
When I searched for the error on the internet, It was easy to find here.
But we were running SQL 2012 upgrade so above was not applicable.
I have given him below idea to avoid using UI to run the installer. I shared below with him and he agreed to update me via email if it worked for him.
setup.exe /ACTION=EditionUpgrade /INSTANCENAME=MSSQLSERVER /IACCEPTSQLSERVERLICENSETERMS /FEATURES=SQL,RS /INDICATEPROGRESS /Q
How many times do you install SQL Server or a patch via command line? In larger enterprise, it is very common and they love scripts and command line. Feel free to comment and let me know.
Reference: Pinal Dave (http://blog.SQLAuthority.com)