Scott Hanselman

Download SQL Server Express

June 17, '14 Comments [59] Posted in Tools
Sponsored By

There's a funny blog post about how to download SQL Server Express from Long Zheng. It surprisingly how complex some companies make downloading things. I've always thought that a giant Download Now button is the best way, but perhaps that's just me?

Downloading SQL Server Express is unnecessarily hard, and it's made harder by the new Microsoft Download Center "download multiple files" interface that doesn't include descriptions or primary file recommendations. It should be a list of links, and you should be able to right click and Save As.

Introducing http://downloadsqlserverexpress.com 
(this short link goes directly to this post)

So, I've done the HTTP sniffing and work, and written this blog post in the hopes that it helps you (and I'm bookmarking it for myself, for the future).

Download SQL Server 2014 Express

Download SQL Server 2012 Express

Download SQL Server 2008 Express R2 SP2

You can get back here via downloadsqlserverexpress.com. Tell your friends.


Sponsor: A big thank you to my friends at Octopus Deploy. They are sponsoring the blog feed this week. Using NuGet and powerful conventions, Octopus Deploy makes it easy to automate releases of ASP.NET applications and Windows Services. Say goodbye to remote desktop and start automating today!

About Scott

Scott Hanselman is a former professor, former Chief Architect in finance, now speaker, consultant, father, diabetic, and Microsoft employee. He is a failed stand-up comic, a cornrower, and a book author.

facebook twitter subscribe
About   Newsletter
Sponsored By
Hosting By
Dedicated Windows Server Hosting by ORCS Web
Tuesday, June 17, 2014 6:29:28 PM UTC
*Knock Knock*
Scott: "Who's there?"

Voice: "It's Ed from Legal."
Ryan Smith
Tuesday, June 17, 2014 6:33:01 PM UTC
Let me take

http://downloadvisualstudioexpress.com

domain before Scott.
Tuesday, June 17, 2014 6:34:08 PM UTC
Uploaded to Chocolatey: SqlServer2014Express
Tuesday, June 17, 2014 6:36:25 PM UTC
Good stuff!
Tuesday, June 17, 2014 6:44:33 PM UTC
No offence, but the if Long Zheng just searched Microsoft Download Center he would not have had to go through all those hoops: http://www.microsoft.com/en-us/search/DownloadResults.aspx?q=sql%20server%202014%20express

Maybe a future blog post on Microsoft Download Center to increase awareness?
Tuesday, June 17, 2014 6:46:45 PM UTC
Peter - Even if you DO get to the center, do you know which one to download? Try it.
Tuesday, June 17, 2014 6:46:55 PM UTC
I haven't had to download Express in forever but tried to get VS Express for my 12-year-old son the other day so he could write code for the finch robot. It's a very similar problem but instead of Express w/tools or management studio alone, etc you have to decide whether to get the web or windows version etc.

People new to dev and more likely to download Express won't know the difference.

Perhaps links should say something like this?
"Want to create your own website?"
Click here

"Want to write a cool game that runs within a browser like IE?"
Click here

"Want to run an immersive app that will run on your smartphone?"
Click here

Or
"Want to see a cool example of what you could do with this?"
Click here

I did get the download but it was confusing, still don't get DreamSpark connection either but wasn't interested in finding out either
Taki
Tuesday, June 17, 2014 6:46:56 PM UTC
I've always wondered whether I'm the only person who finds this process cumbersome. Thanks for compiling this list, I'm going to hit your fancy new URL from now on. ;-)
Tuesday, June 17, 2014 6:48:53 PM UTC
@Scott, yes *that* part isn't as good as your page--but no where near as complex as what Long detailed.
Tuesday, June 17, 2014 6:54:29 PM UTC
I am so happy that chocolatey exists and seems to be getting traction
Tuesday, June 17, 2014 7:11:53 PM UTC
Might worth including a link to the LocalDb-only install file as well, just today I wanted to download it and took longer than I thought it should have.
Tuesday, June 17, 2014 8:00:23 PM UTC
Scott Hanselman: Making Microsoft accessible to the common man.
Mike
Tuesday, June 17, 2014 8:09:21 PM UTC
Nice post. But what about x86 edition of SQL Express 2012?
Benny Tordrup
Tuesday, June 17, 2014 8:32:13 PM UTC
I wonder why they don't use the web platform installer.
It's a great tool which is made exactly for that, and it even has sql server express 2008 in it.
Yehuda
Tuesday, June 17, 2014 8:49:27 PM UTC
Went through this pain only last week, trying to upgrade to SQL Server Management Studio 2014 for better Azure comparability. Chose the wrong file twice before getting the right one. Had no clue which was the correct download based on the list of files on the MS site. Just lucky, I guess it didn't take longer! Thanks Scott.
Tuesday, June 17, 2014 8:53:15 PM UTC
Scott, could you include links for editions with advanced services?
Tuesday, June 17, 2014 8:57:46 PM UTC
SQL 2014 x64 Express with Advanced Services: http://download.microsoft.com/download/E/A/E/EAE6F7FC-767A-4038-A954-49B8B05D04EB/SQLEXPRADV_x64_ENU.exe

SQL 2014 x86 Express with Advanced Services: http://download.microsoft.com/download/E/A/E/EAE6F7FC-767A-4038-A954-49B8B05D04EB/SQLEXPRADV_x86_ENU.exe
Tuesday, June 17, 2014 9:10:00 PM UTC
After they fix this mess, they could reorganize the SQL Server Setup
Tuesday, June 17, 2014 9:19:25 PM UTC
I haven't had the pleasure of installing SQL 2012 or 2014, but I really hope they have improved the installation process. It is one of the worst experiences I can remember.
Charlie Maggot
Tuesday, June 17, 2014 9:28:54 PM UTC
i'm donating 1000 internets to both you and Long Zheng
st
Tuesday, June 17, 2014 11:04:04 PM UTC
I've run into similar woes since having to rebuild my VM, so this is a welcome help and quick link. I went one step further and started working with BoxStarter, which allowed me to pull Visual Studio, SQL Server Express, and more into an automated script so I could sit back and install deploy. Here's a blog post I did on setting it up.
Tuesday, June 17, 2014 11:24:21 PM UTC
+1 for the Management Studio links. I have spent quite a few times searching for that download.
Adam Stechschulte
Wednesday, June 18, 2014 2:15:21 AM UTC
Thanks Scott, this is very useful. As one who develops on and uses SQL express all the time, I found/find the new download process so annoying that I now carry SQL express with me on a USB drive.
Now hopefully I can return to downloading it online as needed.
James Makumbi
Wednesday, June 18, 2014 4:32:03 AM UTC
So glad Scott has put this up.

On numerous occasions I've wasted an hour or two trying to figure this out.

Like @fujiy said, they should fix up the installer next!
Wednesday, June 18, 2014 5:24:49 AM UTC
Thanks Scott!

I don't understand why they are making this download so complicated...
Wednesday, June 18, 2014 5:28:03 AM UTC
for 2012, you can install with chocolatey :

cinst SqlServer2012Express
aaron
Wednesday, June 18, 2014 6:17:39 AM UTC
Do you also know how to get rid of these tons of SQL Server programs?

I bought my computer with Win8 in September last year. I never installed SQL Server and I have this in my Programs and Features list:
Microsoft SQL Server 2005 Compact Edition [ENU]
Microsoft SQL Server 2008 R2 Management Objects
Microsoft SQL Server 2008 Setup Support Files
Microsoft SQL Server 2012
Microsoft SQL Server 2012 Command Line Utilities
Microsoft SQL Server 2012 Data-Tier App Framework
Microsoft SQL Server 2012 Data-Tier App Framework (x64)
Microsoft SQL Server 2012 Express LocalDB
Microsoft SQL Server 2012 Management Objects
Microsoft SQL Server 2012 Management Objects (x64)
Microsoft SQL Server 2012 Native Client
Microsoft SQL Server 2012 Setup (English)
Microsoft SQL Server 2012 Transact-SQL Compiler Service
Microsoft SQL Server 2012 Transact-SQL ScriptDom
Microsoft SQL Server 2012 T-SQL Language Service
Microsoft SQL Server 2014 Express LocalDB
Microsoft SQL Server 2014 Management Objects
Microsoft SQL Server 2014 Management Objects (x64)
Microsoft SQL Server 2014 Transact-SQL Compiler Service
Microsoft SQL Server 2014 Transact-SQL ScriptDom
Microsoft SQL Server 2014 T-SQL Language Service
Microsoft SQL Server Compact 4.0 SP1 x64 ENU
Microsoft SQL Server Data Tools - enu (12.0.40403.0)
Microsoft SQL Server Data Tools 2013
Microsoft SQL Server Data Tools Build Utilities - enu (12.0.40403.0)
Microsoft SQL Server Migration Assistant for Access
Microsoft SQL Server System CLR Types
Microsoft SQL Server System CLR Types (x64)
Microsoft System CLR Types for SQL Server 2012
Microsoft System CLR Types for SQL Server 2012 (x64)
Microsoft System CLR Types for SQL Server 2014
Microsoft System CLR Types for SQL Server 2014

Maybe somebody can tell the SQL Server guys that it doesn't make sense to list a separate program if you can't use it separately without the other stuff. To install/uninstall features of any program you should use the Change button.
I also don't care about old versions. They could be overwritten with the new version whenever any program installs the newer version.

And the same goes for Microsoft Visual C++ 20xx Redistributable of course. I also have 12 of those.
Wednesday, June 18, 2014 8:00:42 AM UTC
Normally a google with bing search itself takes me to the download center page, which has all but listed items of what you want to download, so that should be ok.

I am surprised, someone visits marketing site and hope to find a direct link to download, aren't we the techie who should know better?
Wednesday, June 18, 2014 8:21:48 AM UTC
I took this as a challenge and my first attempt I did:
- Microsoft.com
- Click Downloads at top >> Download center (since I was looking for SQL not Windows/Office which have their own specific links)
- Enter in to the search input: sql server express 2014
- Single result shown - click the circular, down arrow icon button to get the download list of files to appear.

Alternatively I tried:
- Microsoft.com
- Enter in to the search input: sql server express 2014
- In results click the big radio button labelled "Downloads" instead of the current "All" selection.
- Single result shown - click the circular, down arrow button to get the download list of files appear.

It was trivial and natural to do either of the above IMHO. So far so good. The only real thing wrong with it is that you just get the raw file names but even from that I could work it out more or less. Don't know what the MSIs at the top were for.

Looking at the full download page the "Details" section explains clearly what everything is. So if MS combined those details in an expandable section for each file and like your links Scott gave nice link text, i.e. the product title (as in the details) not the filename then I think that would pretty much sort it out.
Peter
Wednesday, June 18, 2014 8:22:10 AM UTC
Any similarity with the heavy handed way to try to force Windows 8.1 users to use a Microsoft Account as main logging is *not* accidental.

In the context of the equally heavy handed tentative by the various US justice department to get access to MS servers all over the world, this is becoming a reason for rejecting MS tools and products.

I think a number of MS marketing people should be sent behind the wood shed and shot at dawn. For the good of the company.

Michel
Wednesday, June 18, 2014 8:38:06 AM UTC
As an afterthought, this situation is seriously aggravated bu the lack of a place where I can give feedback.
For instance, there is no way in W8.1u1 to change a (new) wifi network to private if you have UAC maxed on a non administrator account.

No way, as in no way to get even a credential prompt to fix things.

I tried to report this as some sort of bug / usability problem, got lost in a maze of web pages trying to get me to use my "free / payed support options".

This is bordering on autism.
Michel
Wednesday, June 18, 2014 9:20:43 AM UTC
Nice one Scott.
I'm guessing like the majority of dev's I simply though "this really shouldn't be this hard, should it???" but you've done something about it, whereas I... didn't :)
Andy
Wednesday, June 18, 2014 12:50:36 PM UTC
I agree the Download center could definitely use a redesign. It does look a little like the download pages were designed by a team of lawyers, and is not nearly as obvious as your post. I for one never go directly to the download center either.

I search for what I'm looking for and then somehow stumble on to the download page. Then after some time of searching I find the download button. I click it a dialogue pops up with many choices with a list of possible options, of which none seem correct. I close the dialogue. I search for the secret dictionary describing the exe names. Its of course hidden in the minimized detail section on the page (behind the dialog the is in my face). Once I think I find the one I want I either try to remember the name or copy/paste it somewhere. I hit the download button again search for the exe name. Hope I selected the right one, and then download it. Typically I install it then realize I installed the wrong version then start the process over again. That is my typical experience with the download center. It is a tiny bit confusing to say the least. Simple improvement would be longer more descriptive EXE names or descriptions next to them on the dialog box. I would have had no idea WT means "With tools" if your post wouldn't have pointed it out. I think your solution is a good one. I just wish the Download Center did things more like that.

Thanks for making this one tiny corner of the internet a better place.





Adam Wright
Wednesday, June 18, 2014 12:52:21 PM UTC
I hope this post makes it on to Satya's radar and he makes someone actually do something about it. It is ridiculous how complicated MS makes it to download software and how poor the quality of many of their websites are (MSDN blogs, TechNet).

Even the Roslyn CTP, which is from Dev Div and you'd think might be straightforward, required you to download some stupid download manager in order to install it.
Sam
Wednesday, June 18, 2014 12:55:43 PM UTC
Whooaaaah. Best page on the internet in years! Handy :)
Tom Deleu
Wednesday, June 18, 2014 1:01:28 PM UTC
If you could do this for the Visual Studio Express Editions, now that would be awesome! All Express downloads in one handy location!
Wednesday, June 18, 2014 4:39:19 PM UTC
NOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOO

The giant "Download Now" button is a LIE


http://www.hanselman.com/blog/DownloadWrappersAndUnwantedSoftwareArePureEvil.aspx
Wednesday, June 18, 2014 4:50:48 PM UTC
In one word, excellent.

Thanks, Scott.

'Nuff said.

Cheers,

BDS
Brian Schnackel
Wednesday, June 18, 2014 5:01:24 PM UTC
Great! Now we need this for more of MS's offerings...
Wednesday, June 18, 2014 6:49:21 PM UTC
This is fantastic Scott - thank you!

I've been through the 10-step rigmarole. You've made the world a better place.

Those guys at Microsoft should jump to give you a job... or something.
Govert
Wednesday, June 18, 2014 7:01:19 PM UTC
Wow unfortunate that this is even necessary. Thanks though Scott!
Wednesday, June 18, 2014 10:29:19 PM UTC
.com in 2014?

Register the http://sqlserver.link domain!
John
Thursday, June 19, 2014 2:37:03 AM UTC
I like the big fat download buttons too, you just need to check *where* they actually go...
Thanks Scott!
:-]
Thursday, June 19, 2014 8:12:22 AM UTC
Your contribution in bringing sqlserver12 to us is great. Everything worked just fine on the x64 machine as well as in the x86. Thanks so much!
Fritz
Thursday, June 19, 2014 8:58:33 AM UTC
Thanks
Peter
Saturday, June 21, 2014 5:12:10 PM UTC
Sorry, but I don't think it is as difficult as you're all making it out to be.
http://www.microsoft.com/en-us/download/details.aspx?id=42299
Then click the "+" beside Details and it will expand to give you details about what the various files are and a description of what you'll find in them.

By the way, you could also just go to
Http://microsoft.com/downloads
And then type in "SQL Server 2014 Express" in the search box and it will take you straight there.

I guess we're all just too used to being spoon fed ;)

Cheers
Scott Prokopetz
Monday, June 23, 2014 3:04:36 PM UTC
little off topic but omg sqlserver.com is not a microsoft domain?!?!
Ed
Tuesday, June 24, 2014 11:19:13 PM UTC
Looks like 2014 version is busted
Wednesday, June 25, 2014 12:27:49 AM UTC
To concur with Sean Feldman above it looks like they broke the links even for their own installers.

I tried updating SSDT today and this appeared in the log. Error 0x80070002: Failed attempt to download URL: 'http://go.microsoft.com/fwlink/?LinkId=329097&clcid=0x409' Goes to http://download.microsoft.com/download/E/A/E/EAE6F7FC-767A-4038-A954-49B8B05D04EB/ENU/x64/SqlLocalDB.msi which is broken atm.

The Microsoft page updated today: http://www.microsoft.com/en-us/download/details.aspx?id=42299 now goes to http://download.microsoft.com/download/E/A/E/EAE6F7FC-767A-4038-A954-49B8B05D04EB/LocalDB%2064BIT/SqlLocalDB.msi now...
Steve
Wednesday, June 25, 2014 2:57:42 PM UTC
I just need SQL Server Management Studio.

Maybe I should get my DBA certification first, but when I go here[1], click the big red DOWNLOAD button and select the file "MgmtStudio 64BIT\SQLManagementStudio_x64_ENU.exe", I get a big old 640 MB self-extracting file. When I run _that_, I get a multiple-menus-deep landing page, which doesn't list "SQL Server Management Studio" anywhere.

I see that among the extracted files, there's a very tempting file called "x64\Setup\SQL_SSMS.MSI", but alas, it won't actually install anything.

Am I stupid?

[1] http://www.microsoft.com/en-us/download/details.aspx?id=42299
Joost Molenaar
Wednesday, June 25, 2014 3:02:42 PM UTC
Apparently, I am. From the landing page, you have to follow "Installation" > "New SQL Server stand-alone installation or add features to an existing installation", which starts another installer, which downloads another installer, which actually installs SSMS. All 1023 MB of it.
Joost Molenaar
Thursday, June 26, 2014 8:46:01 PM UTC
Scott, none of these download links appear to be working. I tried the first four and none of them work for me.

Thank for doing this and all of the other good stuff you've done for us developers over the years!
John Booty
Friday, June 27, 2014 4:53:09 AM UTC
It's amazing how often one thinks they are an idiot and then it turns out that "everybody" is having just as much trouble with such-and-such as one is.

Microsoft websites definitely suffer from a lack of adherence to the SRP.

They are clearly built with numerous competing constraints in mind but typically end up being so convoluted and generalised, as to be specifically useless.

The download sites are a classic example. You can eventually get the job done but you have to grit your teeth and clench your buttocks the whole way through and even then you typically only know whether you got the right thing once you've downloaded and installed the wrong thing at least once.

Downloads are, to me, an aspect of search, and Microsoft just doesn't do search very well at all.

So I typically Google for what I want and then have some blog or another point me at the thing I need rather than relying on insanely decontextualised UI that the MS download centre provides.
Richard
Friday, June 27, 2014 2:50:56 PM UTC
Links are not working anymore :(
Friday, June 27, 2014 8:12:17 PM UTC
Fixing the links. They re-released.
Thursday, July 17, 2014 12:17:05 PM UTC
Hi Scott,
as already mentioned above, please add a link for the SQLLocalDb.msi files.

2014 x64:
http://care.dlservice.microsoft.com/dl/download/E/A/E/EAE6F7FC-767A-4038-A954-49B8B05D04EB/LocalDB%2064BIT/SqlLocalDB.msi

2014 x86:
http://care.dlservice.microsoft.com/dl/download/E/A/E/EAE6F7FC-767A-4038-A954-49B8B05D04EB/LocalDB%2032BIT/SqlLocalDB.msi

Thanks
kapsi
Wednesday, August 06, 2014 10:31:24 PM UTC
Scott, could you link to the latest SP release notes as well? I was surprised to find links to the downloads from there.
2012 SP2: http://msdn.microsoft.com/en-us/library/67cb8b3e-3d82-47f4-840d-0f12a3bff565
Sunday, August 17, 2014 7:10:37 PM UTC
Thank You, Thank You, Thank You!!!
Accessing the software via Download Center is a pain in the...
Mats
Tuesday, August 19, 2014 4:51:37 PM UTC
Thank you Scott. This is incredibly helpful and saved me a lot of time hunting around for just the SQL management tools package for the 2014 release.
Chris Lee
Name
E-mail (will show your gravatar icon)
Home page
 
Comment (Some html is allowed: a@href@title, b, blockquote@cite, em, i, li, ol, pre, strike, strong, sub, super, u, ul) where the @ means "attribute." For example, you can use <a href="" title=""> or <blockquote cite="Scott">.
Live Comment Preview

Disclaimer: The opinions expressed herein are my own personal opinions and do not represent my employer's view in any way.