Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

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

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

like image 995
Mantvydas Ozerenskis Avatar asked Aug 06 '14 14:08

Mantvydas Ozerenskis


People also ask

How do I connect to local instance of SQL Server 2014 Express?

In the Command Prompt window, type the following command: SqlLocalDB create NewInstance and press the Enter key. The message will appear which indicates that the LocalDB instance is created: LocalDB instance “NewInstance” created with version 13.0.

How do I enable local DB?

Install LocalDB through the installation wizard or by using the SqlLocalDB. msi program. LocalDB is an option when installing SQL Server Express LocalDB. Select LocalDB on the Feature Selection/Shared Features page during installation.

Where is SQL Express database located?

C:\Program Files\Microsoft SQL Server\MSSQL{nn}. MyInstance\


Video Answer


1 Answers

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

like image 151
Alberto Solano Avatar answered Oct 06 '22 09:10

Alberto Solano