Today I attempted to install the April 1, 2012 general release of SQL Server 2012 Developer Edition on my work laptop – I want to have a chance to play with all the cool new stuff in Integration Services!
Turns out Microsoft had a little April Fool’s joke in store for me.
So here I am, perking along swimmingly (after installing VS 2010 SP1). Partway through the installation process, though, I receive an error message that the installer couldn’t locate the vs_setup.msi in the directory where it expected to find it.
Perkins Consulting is a Microsoft partner, receiving most of our software through MSDN subscriber downloads. We run Visual Studio 2010 Premium with our TFS installation, which is apparently the version SQL Server 2012 is looking for. However, to save time during our last new laptop swap, I used the web installer rather than downloading the entire ISO file. Apparently, the web installer doesn’t leave the vs_setup.msi behind. Ergo, nothing for SQL Server 2012 to locate on my hard drive.
When I cancelled out of that error window, the installer rolled back a part of the installation, but continued through to the end. The parts that failed installation were related to Management Tools (aka, the components that are closely related to Visual Studio).
I was able to download SQL Server Data Tools (there’s a link to the download site on the SQL Server setup documentation), but the tools didn’t appear to do everything I expected them to do. I remain suspicious and resigned.
Bottom line? I’m now waiting for that VS 2010 Premium download just so I can point to vs_setup.msi.
So remember, boys and girls, before you try this at home and click that Install button on SQL Server 2012, make sure you’ve got your VS 2010 Premium-or-better installation media. Otherwise you may end up taking a header in a late-arriving April Fool’s pratfall.
In the MSDN social area, I found one thread regarding this issue. Apparently this has been identified as a bug, but the date for the fix wasn’t mentioned.
Ahmed Ibrahim from Microsoft offered this workaround in that thread:
1-Go to control panel programs and features select VS ultimate and then click Uninstall/Change
2-Select Add or Remove Features then click download since media source is missing.
3-Select all VS ultimate features
4-Start download and install all features
5-Install Visual Studio 2010 SP1
6-Install SQL server 2012.