I was going to update an old post with some links to download the SSMS from SQL 2008 R2, because this was related to the original post subject. It turns out the updates were going to be too big, because Microsoft is re-organizing some of it’s download and product pages – with a strong focus on latest versions, so we poor users of previous versions are left in the dust.
So here it is, an update as a post. And a lot of links to download your version of SSMS 2008R2 of choice (remember: this version does not include Job Activity Monitor neither BIDS (SSIS Designer), Profiler and advanced stuff).
UPDATE as of 2012-09-06: It looks like the product site from SQL2012 will not list the SSMS for 2008 anymore (I tried searching for it in several ways), so I google around a bit to find the correct links to get the most recent version of it directly from Microsoft (before they remove the download and we have to start using torrents to get official software). Below are the links for your (and mine) delight:
sql server 2008 r2 sp1 management studio express sp1 direct link:
x64-enu – http://go.microsoft.com/fwlink/?LinkID=228417&clcid=0x409
x86-enu – http://go.microsoft.com/fwlink/?LinkID=228416&clcid=0x409
(search for the “SQL Server 2008 R2 SP1 Management Studio Express” string in the page. The download links are hidden in the end of the paragraph. Yeah, hard to spot).
It looks like now the reccomendation is to install Express (wich includes a database instance) to get your SSMS up and running. Because I like to have options and to choose what to install on my machine, I decided to find this download and share here with you. Unfortunately all we have in the page is the english version, because I could not find the download in any other language right now (or stick with RTM and choose another language).
UPDATE 2: I finally found the product download page for SSMS2008R2 in several languages. Get the smaller files, that start with “SQLManagementStudio_…” (gosh, this shouldn’t be this hard to find…):
SSMS 2008 R2 with SP1:
SSMS 2008 R2 with SP2:
While we are at it: SQL Server 2008 R2 SP2 download:
Well, enough links for today (and tomorrow, and the day after).
UPDATE 3: Ok, after 2 years using these files, it happened to me. Installation failed because a Windows 2003 server was missing PowerShell. I even needed help to find this old download on the sea of files Microsoft throws at us. So if it ever happens to you, this is the link to download Windows PowerShell 1.0 for Windows 2003 servers: http://www.microsoft.com/en-us/download/confirmation.aspx?id=16000
UPDATE 4: And now, for the final update of this post (and also last SP for this version), here are the links for SQL Server 2008 R2 Service Pack 3. There will be no Express version this time, so you have to install SSMS SP2 and then run the full SP3 installation in order to get your tools up-to-date. Or just start using 2012 already, it’s about time!
SQL Server 2008 R2 Service Pack 3: http://www.microsoft.com/en-us/download/details.aspx?id=44271
SQL Server 2008 R2 SP3 Feature Pack: http://www.microsoft.com/en-us/download/details.aspx?id=44272
And some articles about this last SP: http://blogs.technet.com/b/dataplatforminsider/archive/2014/10/01/sql-server-2008-r2-sp3-and-sql-server-2008-sp4-are-now-available.aspx , http://sqlblog.com/blogs/aaron_bertrand/archive/2014/09/28/sql-server-2008-r2-service-pack-3-is-available.aspx and http://sqlperformance.com/2014/07/sql-lock-block-deadlock/2008-r2-bug-fix-breaks-rcsi
Pay attention to the Read Committed Snapshot Isolation bug. That’s an important fix, I’m glad they corrected it in this last Service Pack!
Cya next week!