安装 SQL Server 2014 Express 后找不到本地数据库 [英] After installing SQL Server 2014 Express can't find local db
问题描述
我已经下载并安装了 SQL Server 2014 Express(来自该站点:分别仅包含 Management Studio GUI 工具和 SQL Server 引擎.
如果您想使用数据库引擎和 Management Studio 安装功能齐全的 SQL Server,下载带有高级服务的SQL Server的安装程序文件.此外,要使用示例数据库来执行一些本地测试,请使用 Adventure Works 数据库.
考虑到SQL Server with Advanced Services的包,在安装开始时你应该看到这样的东西(下面的截图是关于SQL Server 2008 Express的,但功能选择非常相似).必须选中数据库引擎服务"旁边的复选框.在接下来的步骤中,您将能够配置实例设置和其他选项.
再次执行安装过程,在特性选择步骤中选择数据库引擎服务.安装结束时,您应该能够在 SQL Server 配置管理器中看到 SQL Server 服务.
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.
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:
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.
这篇关于安装 SQL Server 2014 Express 后找不到本地数据库的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!