Prerequisites for Creating a Connection

You must satisfy the following prerequisites to create a connection with the Microsoft SQL Server Adapter:

Prerequisites to Create a Connection Using the Username Password Token Security Policy

  • Ensure that you have write permissions on the database.

  • Ensure that you have the required permissions to run stored procedures and packages and SQL statements against the Microsoft SQL Server.

  • Know the database hostname or IP address and the port number.

  • Know the database or instance name.

  • Know the user name and password for connecting to the database.

Prerequisites to Create a Connection Using the Active Directory Service Principal Security Policy

  • Create a service principal using the Azure portal. See Create a Service Principal. The resulting client ID and client secret are entered on the Connections page.
  • Log in to Fabric to recognize and provide access to the service principal.
    • Enable service principal usage in the Fabric admin settings.
      1. Ensure the tenant admin can enable Service principals can use Fabric APIs in the Fabric Admin portal.
      2. Ensure that in the Fabric Admin/Tenant settings, the option Service principals can use Fabric APIs is turned ON.
      3. Confirm that workspace roles (Admin/Contributor/Member) allow you to assign access to service principals.

      See Service principals in Fabric Data Warehouse.

    • Grant the service principal access to the Fabric Workspace.
      1. Go to the workspace in the Fabric portal.
      2. Use Manage Access or similar (Add People/Groups).
      3. Select your service principal by its name (or client ID/app name) and assign a workspace role (Contributor or above) so it can access the SQL/warehouse endpoint.
    • Inside the Fabric database/warehouse, create a database user for the service principal.
      1. Connect to the Fabric SQL endpoint using Azure Active Directory (or a user with sufficient privileges).
      2. In the Fabric portal, create your workspace.
      3. Inside the workspace, create a database.
      4. Copy the server name and database name that appear in the SQL Server Management Studio dialog.

        The server name consists of the host name and port number separated by a , (comma).

      5. Use the database name, host, and port number to create a connection.