- INSTALLING SQL MANAGEMENT STUDIO 2008 R2 ONLY INSTALL
- INSTALLING SQL MANAGEMENT STUDIO 2008 R2 ONLY 64 BIT
- INSTALLING SQL MANAGEMENT STUDIO 2008 R2 ONLY UPDATE
- INSTALLING SQL MANAGEMENT STUDIO 2008 R2 ONLY 32 BIT
- INSTALLING SQL MANAGEMENT STUDIO 2008 R2 ONLY UPGRADE
Get the smaller files, that start with “SQLManagementStudio_…” (gosh, this shouldn’t be this hard to find…):
INSTALLING SQL MANAGEMENT STUDIO 2008 R2 ONLY UPDATE
UPDATE 2: I finally found the product download page for SSMS2008R2 in several languages. 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).
INSTALLING SQL MANAGEMENT STUDIO 2008 R2 ONLY INSTALL
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. It looks like now the reccomendation is to install Express (wich includes a database instance) to get your SSMS up and running. The download links are hidden in the end of the paragraph. (search for the “SQL Server 2008 R2 SP1 Management Studio Express” string in the page. Sql server 2008 r2 sp1 management studio express sp1 direct link: Below are the links for your (and mine) delight: UPDATE as of : 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). 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). 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. Databases that can now grow to be 10 GB, all for free.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. When you hit Connect you'll be connected to the SQL Instance that has all your SharePoint databases. If you did a Basic Install you'll need to connect to the OFFICESERVERS instance. After the installation is finished you'll have a link the SQL Management Studio under All Programs: On the Installation Type screen choose " New installation or add shared features." On the next screen clear all the boxes except the one next to "Management Tools – Basic." SQL might try to install another database engine instance too, don't fall for that.Ĭlick next a bunch of times and you should be finished. From the splash screen choose New Installation or Feature.
If everything goes well, you'll be greeted with this cheerful message:Īt this point your database engine has been upgraded, but you don't have the fancy Management Studio.
INSTALLING SQL MANAGEMENT STUDIO 2008 R2 ONLY UPGRADE
If you didn't install SQL to a named instance the instance name will be MSSQLSERVER.Īfter that click Next a bunch of times and let the upgrade happen. If you're not upgrading a Basic Install your instance name will be different. That's the instance SharePoint creates when it does a Basic Install. When it comes to the upgrade screen, pick the OFFICESERVERS instance. When you start the installer, choose the upgrade option: Since we're going version to version, we don't need to do anything tricky like using the SKUUPGRADE switch. Okay, now that that is done and you've downloaded the install, go ahead and run it. If you're using SQL Express with SharePoint you can do a Farm backup in Central Administration to back up all your databases. In my tests the upgrade always went smooth, but that's hardly a guarantee. If you're upgrading I highly recommend running a backup first.
INSTALLING SQL MANAGEMENT STUDIO 2008 R2 ONLY 32 BIT
If you're on 32 bit hardware, or if you're upgrading from SQL Express 2005 you'll need the 32 bit version.
INSTALLING SQL MANAGEMENT STUDIO 2008 R2 ONLY 64 BIT
If this is a fresh install, and you're on 64 bit hardware, I recommend using the 64 bit version. You can download just the database engine, but I recommend grabbing the download that includes the Management Tools. Your first step, regardless if this is a new install or an upgrade is to download SQL Express 2008 R2. In this blog post I'm going to walk through upgrading SQL Express 2005 to SQL Express 2008 R2. The 4 GB limit with earlier versions of SQL Express was quite a pain, but fortunately even if you did the dreaded Basic Install of MOSS 2007 you can take advantage of SQL Express 2008 R2's 10 GB limit.
If you, against my pleading, did a Basic Install of MOSS 2007, SharePoint Foundation 2010 or SharePoint Server 2010 you get an instance of SQL Express also. SQL Express is a great way to try SharePoint, without paying big bucks for SQL Server Standard or Enterprise. Glory be! For us SharePoint folks, this is great news. The 2008 R2 was getting a promotion to 10 GB. Last week the SQL Express team announced that the 2008 R2 version of SQL Express would no longer have the stingy 4 GB database limit that SQL Express had in its 20 iterations.