连接到服务器(“连接属性”页)(数据库引擎)Connect to Server (Connection Properties Page) Database Engine
08/14/2017
本文内容
适用于:Applies to: SQL ServerSQL Server(所有支持的版本)
SQL ServerSQL Server (all supported versions)
Azure SQL 数据库Azure SQL Database
Azure SQL 数据库Azure SQL Database
Azure SQL 托管实例Azure SQL Managed Instance
Azure SQL 托管实例Azure SQL Managed Instance
Azure Synapse AnalyticsAzure Synapse Analytics
Azure Synapse AnalyticsAzure Synapse Analytics
并行数据仓库Parallel Data Warehouse
并行数据仓库Parallel Data Warehouse适用于:Applies to:
SQL ServerSQL Server(所有支持的版本)
SQL ServerSQL Server (all supported versions)
Azure SQL 数据库Azure SQL Database
Azure SQL 数据库Azure SQL Database
Azure SQL 托管实例Azure SQL Managed Instance
Azure SQL 托管实例Azure SQL Managed Instance
Azure Synapse AnalyticsAzure Synapse Analytics
Azure Synapse AnalyticsAzure Synapse Analytics
并行数据仓库Parallel Data Warehouse
并行数据仓库Parallel Data Warehouse
使用此选项卡可在连接到 MicrosoftMicrosoft SQL Server 数据库引擎SQL Server Database Engine 实例或在“已注册的服务器”**** 中注册 数据库引擎Database Engine 时查看或指定选项。Use this tab to view or specify options when connecting to an instance of MicrosoftMicrosoft SQL Server 数据库引擎SQL Server Database Engine or registering 数据库引擎Database Engine in Registered Servers. 只有在连接到 数据库引擎Database Engine 实例时,此对话框中才显示“连接”**** 和“选项”****。Connect and Options only appear in this dialog box when connecting to an instance of the 数据库引擎Database Engine. 注册 数据库引擎Database Engine 时,此对话框中仅显示“测试”**** 和“保存”****。Test and Save only appear in this dialog box when registering 数据库引擎Database Engine.
连接到数据库Connect to database
从列表中选择要连接到的数据库。Select a database to connect to from the list. 如果选择“”,则将连接到服务器的默认数据库。If you select , you connect to the default database for the server. 如果选择 ,则可以浏览要连接的数据库的服务器。If you select , you can browse the server for the database to which to connect.
在通过 Azure SQL 数据库Azure SQL Database 连接到 SQL ServerSQL Server 数据库引擎的一个实例时,必须使用 SQL ServerSQL Server 身份验证,并且必须在“连接到服务器” 对话框的“连接属性” 选项卡上指定一个数据库。请确保选中“加密连接” 复选框。When connecting to an instance of the SQL ServerSQL Server Database Engine through Azure SQL 数据库Azure SQL Database, you must use SQL ServerSQL Server Authentication and specify a database in the Connect to Server dialog box, on the Connection Properties tab. Ensure that you select the Encrypt connection checkbox.
默认情况下, SQL ServerSQL Server 将连接到 master。By default, SQL ServerSQL Server connects to master. 连接到 SQL 数据库SQL Database 时,如果指定用户数据库,则对象资源管理器中仅显示该数据库及其对象。When connecting to SQL 数据库SQL Database, if you specify a user database, you only see that database and its objects in Object Explorer. 如果连接到 master ,则会显示所有数据库。If you connect to master, you can see all databases.
网络协议Network protocol
从该列表中选择某个协议。Select a protocol from the list. 可用客户端协议是你通过“计算机管理”中的“客户端网络配置”配置的协议。The available client protocols are configured using the Client Network Configuration in Computer Management.
网络数据包大小Network packet size
输入要发送的网络数据包的大小。Enter the size of the network packets to be sent. 默认值为 4096 字节。The default is 4096 bytes.
连接超时值Connection timeout
输入在超时之前等待建立连接的秒数。默认值为 15 秒。Enter the number of seconds to wait for a connection to be established before timing out. The default value is 15 seconds.
执行超时值Execution timeout
输入在服务器上完成任务执行之前等待的时间(秒)。Enter the amount of time in seconds to wait before execution of a task is completed on the server. 默认值为零秒,指示无超时。The default value is zero seconds, which indicates there is no time-out.
加密连接Encrypt connection
强制对连接进行加密。Forces encryption of the connection.
使用自定义颜色Use custom color
选择此选项可以指定 数据库引擎Database Engine 查询编辑器窗口中状态栏的背景颜色。Select to specify the background color for the status bar in a 数据库引擎Database Engine Query Editor window. 若要指定颜色,请单击“选择”****。To specify the color, click Select. 在“颜色”**** 对话框中,从“基本颜色”**** 网格中选择一种预定义颜色,或者单击“定义自定义颜色”**** 定义并使用自定义颜色。In the Color dialog box, select a predefined color from the Basic Colors grid or click Define Custom Colors to define and use a custom color.
如果在“对象资源管理器”**** 窗格中指定了服务器条目的颜色,则在打开查询编辑器窗口时将使用此颜色。When you specify a color for a server entry in the Object Explorer pane, that color is used when you open a Query Editor window. 若要打开查询编辑器窗口,可以右键单击服务器条目,然后选择“新建查询”****,或者如果“对象资源管理器”**** 窗格处于活动状态且其焦点位于此服务器上,则可以单击工具栏上的“新建查询”****。To open a Query Editor window, either right-click the server entry and select New Query; or, when the Object Explorer pane is active and focused on this server, click New Query on the toolbar.
如果在“已注册的服务器”**** 窗格中指定了服务器条目的颜色,则在打开查询编辑器窗口时将使用此颜色。When you specify a color for a server entry in the Registered Servers pane, that color is used when you open a Query Editor window. 若要打开查询编辑器窗口,可以右键单击服务器条目,然后选择“新建查询”****,或者如果“已注册的服务器”**** 窗格处于活动状态且其焦点位于此服务器上,则可以单击工具栏上的“新建查询”****。To open a Query Editor window, either right-click the server entry and select New Query; or, when the Registered Server pane is active and focused on this server, click New Query on the toolbar.
依次单击“文件”**** 菜单上的“新建”**** 和“数据库引擎查询”**** 后,在“连接到服务器”**** 对话框中指定的颜色即应用于此查询编辑器窗口。On the File menu, when you click New and then Database Engine Query, the color you that you specify in the Connect to Server dialog box applies to that Query Editor window.
AD 域名或租户 IDAD domain name or tenant ID
通过“Active Directory - 含 MFA 支持的通用身份验证”**** 连接时,请指定身份验证的域。When connecting with Active Directory - Universal with MFA authentication, specify the authenticating domain. 仅当使用 SSMS 17.2 或更高版本时,此选项才可用。This option is only available when using SSMS version 17.2 or later.
全部重置Reset All
将所有手动输入的连接属性值替换为默认值。Replace all manually entered connection property values with their defaults.
“连接”Connect
使用列出的值尝试连接。Attempt a connection using the listed values.
选项Options
单击此选项更改对话框并隐藏其他服务器连接选项,例如记住密码。Click to change the dialog box and hide the additional server connection options, such as remembering the password.
测试Test
在“已注册的服务器”**** 中注册 数据库引擎Database Engine 时,单击此选项可以测试连接。When registering 数据库引擎Database Engine in Registered Servers, click to test the connection.
保存Save
保存“已注册的服务器”**** 中的设置。Saves the settings in Registered Servers.
另请参阅See Also