安装 SQL Server 2014 Express 后找不到本地数据库

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

提问by Mantvydas Ozerenskis

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).

我已经下载并安装了 SQL Server 2014 Express（来自这个站点：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?

问题是我无法连接/找到我的本地数据库服务器，并且我无法在本地 PC 上开发数据库。如何访问我的本地服务器？

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

我的系统包含 64 位 Windows 8.1（无专业版或企业版）

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

使用SQL Server 2014 Configuration Manager工具检查 SQL Server 的配置，我看到一个空列表，从左侧的树中选择“SQL Server 服务”。您可以在下面找到屏幕截图。

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

在 Windows 服务列表中，只有一项服务：“SQL Server VSS Writer”

EDITMy installation window of SQL Server 2014 is the following:

编辑我的 SQL Server 2014 安装窗口如下：

回答by Alberto Solano

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.exeand SQLEXPR_Architecture_Language.exe, available in the Microsoft sitecontain, respectively only the Management Studio GUI Tools and the SQL Server engine.

最有可能的是，您没有安装任何 SQL Server 引擎服务。如果未安装 SQL Server 引擎，则 SQL Server 配置管理器工具中不会显示任何服务。考虑到Microsoft 站点中提供的包SQLManagementStudio_Architecture_Language.exe和分别仅包含 Management Studio GUI 工具和 SQL Server 引擎。SQLEXPR_Architecture_Language.exe

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.

如果您想使用数据库引擎和 Management Studio 安装功能齐全的 SQL Server，请下载带有高级服务的SQL Server的安装程序文件。此外，要使用示例数据库来执行一些本地测试，请使用Adventure Works 数据库。

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.

考虑到SQL Server with Advanced Services的包，在安装开始时你应该看到这样的东西（下面的截图是关于 SQL Server 2008 Express，但功能选择非常相似）。必须选中“数据库引擎服务”旁边的复选框。在接下来的步骤中，您将能够配置实例设置和其他选项。

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.

再次执行安装过程，在特性选择步骤中选择数据库引擎服务。在安装结束时，您应该能够在 SQL Server 配置管理器中看到 SQL Server 服务。

回答by Mantvydas Ozerenskis

I downloaded a different installer "SQL Server 2014 Express with Advanced Services" and found Instance Features in it. Thanks for Alberto Solano's answer, it was really helpful.

我下载了一个不同的安装程序“带有高级服务的 SQL Server 2014 Express”，并在其中找到了实例功能。感谢 Alberto Solano 的回答，这真的很有帮助。

My first installer was "SQL Server 2014 Express". It installed only SQL Management Studio and tools without Instance features. After installation "SQL Server 2014 Express with Advanced Services" my LocalDB is now alive!!!

我的第一个安装程序是“SQL Server 2014 Express”。它只安装了 SQL Management Studio 和没有实例功能的工具。安装“带有高级服务的 SQL Server 2014 Express”后，我的 LocalDB 现在还活着！！！

回答by Sashus

I have noticed that after installation of SQL server 2012 express on Windows 10 you must install ENU\x64\SqlLocalDB.MSI from official Microsoft download site. After that, you could run SqlLocalDB.exe.

我注意到在 Windows 10 上安装 SQL Server 2012 express 后，您必须从 Microsoft 官方下载站点安装 ENU\x64\SqlLocalDB.MSI。之后，您可以运行 SqlLocalDB.exe。

回答by Zelong CHEN

Just download and install LocalDB 64BIT\SqlLocalDB.msi can also solve this problem. You don't really need to uninstall and reinstall SQL Server 2014 Express with Advanced Services.

只需下载安装LocalDB 64BIT\SqlLocalDB.msi 也可以解决这个问题。您实际上并不需要卸载并重新安装带有高级服务的 SQL Server 2014 Express。

回答by John Sketle

Also, if you just installed localDB, you won't see the instance in the configuration manager. You would need to initiate it first, and then connect to it using server name (localdb)\mssqllocaldb. Source

此外，如果您刚刚安装了 localDB，您将不会在配置管理器中看到该实例。您需要先启动它，然后使用服务器名称 (localdb)\mssqllocaldb 连接到它。 来源

回答by NCN

I faced the same issue. Just download and install the SQL Server suite from the following link :http://www.microsoft.com/en-US/download/details.aspx?id=42299

我遇到了同样的问题。只需从以下链接下载并安装 SQL Server 套件：http: //www.microsoft.com/en-US/download/details.aspx?id=42299

restart your SSMS and you should be able to "Register Local Servers" via right-click on "Local Servers Groups", select "tasks", click "register local servers"

重新启动您的 SSMS，您应该能够通过右键单击“本地服务器组”，选择“任务”，单击“注册本地服务器”来“注册本地服务器”