连接到 Azure 中的 SSIS 目录 (SSISDB)Connect to the SSIS Catalog (SSISDB) in Azure

适用范围:SQL Server,包括 Linux Azure SQL 数据库yesAzure SQL 数据仓库no并行数据仓库 APPLIES TO: yesSQL Server, including on Linux yesAzure SQL Database yesAzure SQL Data Warehouse noParallel Data Warehouse

查找连接到 Azure SQL 数据库服务器上托管的 SSIS 目录 (SSISDB) 所需的连接信息。Find the connection information you need to connect to the SSIS Catalog (SSISDB) hosted on an Azure SQL Database server. 连接时需要以下项:You need the following items to connect:

  • 完全限定服务器名称fully qualified server name
  • 数据库名称database name
  • 登录信息login information

重要

如果尚未在 Azure 数据工厂中创建 Azure-SSIS Integration Runtime,则无法在 Azure SQL 数据库中创建 SSISDB 目录数据库。You can't create the SSISDB Catalog database on Azure SQL Database at this time independently of creating the Azure-SSIS Integration Runtime in Azure Data Factory. Azure-SSIS IR 是在 Azure 上运行 SSIS 包的运行时环境。The Azure-SSIS IR is the runtime environment that runs SSIS packages on Azure. 有关过程的演练,请参阅在 Azure 中部署和运行 SSIS 包For a walkthrough of the process, see Deploy and run an SSIS package in Azure.

必备条件Prerequisites

开始之前,请确保具有 SQL Server Management Studio (SSMS) 版本 17.2 或更高版本。Before you start, make sure you have version 17.2 or later of SQL Server Management Studio (SSMS). 如果 SSISDB 目录数据库托管在 SQL 数据库托管实例中,请确保安装了 17.6 版或更高版本的 SSMS。If the SSISDB Catalog database is hosted on SQL Database Managed Instance, make sure you have version 17.6 or later of SSMS. 若要下载 SSMS 最新版本,请参阅下载 SQL Server Management Studio (SSMS)To download the latest version of SSMS, see Download SQL Server Management Studio (SSMS).

从 Azure 门户获取连接信息Get the connection info from the Azure portal

  1. 登录到 Azure 门户Log in to the Azure portal.

  2. 从 Azure 门户的左侧菜单中选择“SQL 数据库” ,然后在“SQL 数据库” 页上选择 SSISDB 数据库。In the Azure portal, select SQL Databases from the left-hand menu, and then select the SSISDB database on the SQL databases page.

  3. SSISDB 数据库的“概述” 页上,查看完全限定服务器名称,如下图所示。On the Overview page for the SSISDB database, review the fully qualified server name as shown in the following image. 将鼠标悬停在服务器名称上,以打开“单击进行复制” 选项。Hover over the server name to bring up the Click to copy option.

    服务器连接信息

  4. 如果忘记了 SQL 数据库服务器的登录信息,则导航到 SQL 数据库服务器页。If you have forgotten the login information for the SQL Database server, navigate to the SQL Database server page. 可在其中查看服务器管理员名称,如有必要,还可重置密码。There you can view the server admin name and, if necessary, reset the password.

与 SSMS 连接Connect with SSMS

  1. 打开 SQL Server Management Studio。Open SQL Server Management Studio.

  2. 连接到该服务器Connect to the server. 在“连接到服务器”对话框中,输入以下信息 :In the Connect to Server dialog box, enter the following information:

    设置Setting 建议的值Suggested value 描述Description
    服务器类型Server type 数据库引擎Database Engine 此值是必需的。This value is required.
    服务器名称Server name 完全限定的服务器名称The fully qualified server name 名称应采用此格式:mysqldbserver.database.windows.netThe name should be in this format: mysqldbserver.database.windows.net.
    身份验证Authentication SQL Server 身份验证SQL Server Authentication
    登录Login 服务器管理员帐户The server admin account 此帐户是在创建服务器时指定的帐户。This is the account that you specified when you created the server.
    密码Password 服务器管理员帐户的密码The password for your server admin account 此密码是在创建服务器时指定的密码。This is the password that you specified when you created the server.

    使用 SSMS 连接到服务器

  3. 连接到 SSISDB 数据库Connect to the SSISDB database. 选择“选项” 展开“连接到服务器” 对话框。Select Options to expand the Connect to Server dialog box. 在展开的“连接到服务器” 对话框中,选择“连接属性” 选项卡。在“连接到数据库” 字段中,选择或输入 SSISDBIn the expanded Connect to Server dialog box, select the Connection Properties tab. In the Connect to database field, select or enter SSISDB.

    重要

    如果连接时未选择 SSISDB,对象资源管理器中可能不会显示 SSIS 目录。If you don't select SSISDB when you connect, you may not see the SSIS Catalog in Object Explorer.

    选择 SSISDB 数据库以供连接

  4. 然后选择“连接” 。Then select Connect.

  5. 在对象资源管理器中,展开“Integration Services 目录”,然后展开“SSISDB”,查看 SSIS 目录数据库中的对象 。In Object Explorer, expand Integration Services Catalogs and then expand SSISDB to view the objects in the SSIS Catalog database.

    在 SSMS 对象资源管理器中查找 SSISDB 数据库

后续步骤Next steps