Just as yourself, got a lot to do, but occasionally get pulled back in.
SQL Server 2008-R2 Upgrade
My manager has signed us up to upgrade all SQL Servers to the most recent version, 2016. Or at minimum the version that precedes the latest; btw, that is 2014.
The SQL Instance that I am looking at currently is v2008-R2 and the OS is 2008/R2.
That latest SQL Server supported on Windows 2008-R2 is SQL Server 2014.
Upgrade 2008-R2 to 2014
Trying to upgrade v2008-R2 to v2014, but ran into a constraint right away.
This computer has an installation of Visual Studio 2010 that requires a Service Pack 1 update that is needed for a successful installation of SQL Server based on your feature selection.
To continue, install the required Visual Studio 2010 Service Pack 1 from SQL Server media or from http://go.microsoft.com/fwlink/?LinkID=220649.
Download Visual Studio 2010 SP1
Tried a drive by visiting https://www.microsoft.com/en-us/download/details.aspx?id=23691.
Download Visual Studio 2010 SP1 – Download 23691
We are sorry, this download is no longer available.
|my.visualstudio.com/Downloads?q=visual%20studio%202010%20service%20pack%201 ( All )||Link||Yes|
|my.visualstudio.com/Downloads?pid=2300 ( Visual Studio 2010 Service Pack 1 )||Link||Yes|
Please download the online installer availed here.
BTW the link noted above is from my.visualstudio.com web site.
And, you need a registered user.
If you have yet to register for my.visualstudio.com, please do so.
It is a free.
Here are results that matches “Visual Studio Service Pack 1”
Visual Studio 2010 Service Pack 1 – Details
The file’s name is mu_visual_studio_2010_sp1_web_installer_x86_651694.exe.
It is a relatively small file, 795 KB.
It is an online installer and it is a bootstrap as it simply connects to the website and downloads the actual install media.