Wednesday, July 23, 2014

Why can't I use a local database with Microsoft SQL Server 2014 Express?

Well, maybe you just got a watered-down version of the installer that doesn't have that option. If you go here and then click "Download" and finally pick "MgmtStudio 64BIT\SQLManagementStudio_x64_ENU.exe" from the list of checkboxes which appears, you will get just such a watered-down installer. It is instead better to use "ExpressAndTools 64BIT\SQLEXPRWT_x64_ENU.exe" and then when you run the installation you should see a checkbox for "LocalDB" like so:

 
 

Afterwards, there will be a step called "Instance Configuration" where you may name the instance. The default is: SQLEXPRESS

 
 

When it's all done, you should be able to connect to:

YOURCOMPUTERNAMEHERE\SQLEXPRESS

No comments:

Post a Comment