Create a Microsoft SQL Server connection

  • リリースバージョン: Australia
  • 更新日 2026年03月12日
  • 所要時間：3分

    • Establish a zero copy connection to a Microsoft SQL Server database in Zero Copy Connector Hub.

    始める前に

    Role required: df_connection_admin

    このタスクについて

    Work with your data source admin to create a connection to SQL Server. For additional information about connecting, refer to the SQL Server connector documentation.

    注:
    This connector was developed by the open-source community and made available through the ServiceNow AI Platform for general use. Functionality can vary and might not cover all use cases supported by primary connectors.

    手順

    1. Navigate to the available community connectors in Zero Copy Connector Hub in one of the following ways:
      • Navigate to All > Zero Copy Connector Hub > Available connectors > Community connectors.
      • Navigate to Admin > Zero Copy Connector Hub > Available connectors > Community connectors.
    2. Find the Microsoft SQL Server connector and select Connect.
    3. On the form, fill in the fields.
      表 : 1. New Microsoft SQL Server Connection form
      Field Description
      Name and description
      Connection label Unique name for this connection. This helps in identifying the connection within your system.
      Connection name System-generated name based on the Connection label. This field cannot be modified once the connection is established.
      Short description Description of the connection explaining what it is about.
      Connection attributes
      Connection URL JDBC URL to establish the connection. For example:

      jdbc:sqlserver://<host>:<port>;databaseName=<databaseName>;encrypt=true;trustServerCertificate=true
      Authentication method
      Username Username associated with the source.
      Password Password associated with the username.
    4. Select Connect.

    タスクの結果

    A test connection is made to the external data source, verifying that the connection details are correct and the data source is accessible.

    次のタスク

    If the connection succeeds, configure data steward access on the Access Control tab. See Manage access to an established connection using roles.

    If the connection fails, verify the connection details with your data source administrator and try again.