After installing SQL Server 2014 Express can't find local db

sql sql-server sql-server-2014-express
Mantvydas Ozerenskis picture Mantvydas Ozerenskis · Aug 6, 2014 · Viewed 115.9k times · Source

I have downloaded and installed SQL Server 2014 Express (from this site: http://www.microsoft.com/en-us/server-cloud/products/sql-server-editions/sql-server-express.aspx#Installation_Options).

The problem is that I can't connect/find my local DB server, and I can't develop DB on my local PC. How can I reach my local server?

My system consists of Windows 8.1 (no Pro or Enterprise editions) 64 bits

Checking the configuration of SQL Server with SQL Server 2014 Configuration Manager tool, I see an empty list selecting "SQL Server Services" from the tree at the left. Below you can find a screenshot.

enter image description here

In the Windows Services list, there is just only one service: "SQL Server VSS Writer"

EDIT My installation window of SQL Server 2014 is the following: enter image description here

Answer

Alberto Solano picture Alberto Solano · Aug 6, 2014

Most probably, you didn't install any SQL Server Engine service. If no SQL Server engine is installed, no service will appear in the SQL Server Configuration Manager tool. Consider that the packages SQLManagementStudio_Architecture_Language.exe and SQLEXPR_Architecture_Language.exe, available in the Microsoft site contain, respectively only the Management Studio GUI Tools and the SQL Server engine.

If you want to have a full featured SQL Server installation, with the database engine and Management Studio, download the installer file of SQL Server with Advanced Services. Moreover, to have a sample database in order to perform some local tests, use the Adventure Works database.

Considering the package of SQL Server with Advanced Services, at the beginning at the installation you should see something like this (the screenshot below is about SQL Server 2008 Express, but the feature selection is very similar). The checkbox next to "Database Engine Services" must be checked. In the next steps, you will be able to configure the instance settings and other options.

Execute again the installation process and select the database engine services in the feature selection step. At the end of the installation, you should be able to see the SQL Server services in the SQL Server Configuration Manager.

enter image description here

Related questions

Uninstalling SQL Server Management Studio 2014 in Windows 8

I have a student who installed SQL Server 2014 with tools, but the Management Studio part did not install. There is no SSMMS.EXE on the machine. So I tried to reinstall it, and the Management Studio tools come up checked …

Read More
SQL Server 2014 Express Set Up

I have downloaded Microsoft SQL Server Management Studio 2014 Express. I have set it up and I now need to connect to the server. I think my server name has something to do with my computer name but its not working. …

Read More
How do I UPDATE from a SELECT in SQL Server?

In SQL Server, it is possible to insert rows into a table with an INSERT.. SELECT statement: INSERT INTO Table (col1, col2, col3) SELECT col1, col2, col3 FROM other_table WHERE sql = 'cool' Is it also possible to update a …

Read More