Tuesday, July 3, 2012

Installing MS SQL 2008 Management Studio

I'm making this post, since I have seem to have solved my installation problem with MS SQL 2008 Management Studio installer.  And I want to share, the proven way in solving it.  Somehow, solved anyway.  I don't know what exactly the problem with the installer, but when you try to install it, it gives the following message:


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

I looked for a solution thru google, and this is the most funny and unbelievable work around I found, but it works.  Here is the link: http://stackoverflow.com/questions/1677435/invoke-or-begininvoke-cannot-be-called-on-a-control-until-the-window-handle-has

I don't know what happened, but after minimizing all windows and focusing only on the installation dialog, it somehow let me thru the installation process.  I clicked back and forth the main installation window and the modal status window and somehow, I was able to successfully install my Management Studio 2008.

Reason that I installed the Management Studio 2008, was due to the fact that I cannot manage my data with editable results if I'm accessing MS SQL 2008, thru Management Studio 2005.  It is stated in some forums, that you can use higher versions of Management Studio, but cannot use lower versions to fully use the latest MS SQL version.  It does make sense to me, backwards compatibility only.

Here is the link to the MS SQL 2008 Management Studio Express installer: http://www.microsoft.com/en-us/download/details.aspx?id=7593

It states, express version, but I haven't notice any difference with the one included with the Enterprise edition installer. By the way, they both have bugs during installation, that is why I resorted in installing an express edition, even though I have an enterprise installer of MS SQL 2008.

You may have to install the SP 1 (service pack 1) of MS SQL 2008 after installation of Management Studio 2008. As indicated, during or initial install of Management Studio.





No comments:

Post a Comment