如何在SQL Server Management Studio中连接到本地数据库？ [英] How to connect to a local database in SQL Server Management Studio?

问题描述

我已经下载了SQL Server Management Studio（SSMS）2016，以恢复巨大的.bak文件，该文件是数据库的旧备份。但是首先我需要连接到数据库服务器。

I have downloaded the SQL Server Management Studio (SSMS) 2016 to recover a huge .bak file which is an old backup of a database. But first of all I need to connect to a DB Server.

安装后，我执行SSMS并要求我连接到数据库服务器。我没有任何人，我看到可以通过仅在服务器名称中键入点。并使用Windows身份验证来创建本地数据库。

After install, I execute SSMS and it asks me to connect to a DB Server. I don't have any and I saw that it is possible to create a "local" db by typing only a dot '.' for Server Name and use Windows authentication.

它不起作用；

推荐答案

您需要下载并安装 SQL LocalDB 。它是SQL Server的特殊版本，不允许远程连接，仅支持Windows集成身份验证。这是一个简单的一键式MSI安装，因此易于部署。

You need to download and install SQL LocalDB. It is a special edition of SQL Server that does not allow remote connection and supports windows integrated authentication only. It is a simple one click MSI install so it is easy to deploy.

要下载并安装SQL Server 2016 Express，请转到SQL Server
下载。 LocalDB是您在安装过程中选择的功能，在下载介质时
可用。如果您下载媒体，则
可以选择Express Advanced或LocalDB软件包。

To download and install SQL Server 2016 Express, go to SQL Server downloads. LocalDB is a feature you select during installation, and is available when you download the media. If you download the media, either choose Express Advanced or the LocalDB package.

以上说明，现在您必须下载并运行一个小型下载程序（cca 5 MB），选择LocalDB（44 MB），Microsoft下载程序会将MSI软件包下载到您选择的文件夹中。然后只需运行MSI软件包，便会安装LocalDB。

The above means that now you have to download and run a small downloader (cca 5 MB), select LocalDB (44 MB) and the Microsoft downloader will download MSI package to the folder you select. Then just run MSI package and LocalDB gets installed.

这篇关于如何在SQL Server Management Studio中连接到本地数据库？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！