且构网

分享程序员开发的那些事...
且构网 - 分享程序员编程开发的那些事

如何在SQL Server Management Studio中连接到本地数据库?

更新时间:2021-12-04 23:11:56

您需要下载并安装 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.