Microsoft SQL server

The Microsoft SQL server connector A software component that allows seamless integration with third-party services, business applications, and content stores. Examples include Salesforce, Box, and Microsoft SharePoint. Connectors are used to create connections required for workflow actions and start events. is used to create connections for Microsoft SQL server actions. Use Microsoft SQL server actions to query for data stored in your database in Microsoft SQL server.

Create a Microsoft SQL Server connection

Note: Your browser-stored credentials are accessed to create connections. Either clear credentials from browser memory or make sure the stored credentials are for the intended environment.

For instructions on SQL Server firewall configuration, see the Configure the Windows Firewall to Allow SQL Server Access Microsoft article or, for SQL Server on Windows Azure, see the Creating Microsoft SQL Server Connection to SQL Azure from Nintex Automation Cloud Nintex Community article. See also Allowlist IP addresses for references to the IP addresses that you may need to allowlist in your firewalls and networking devices to enable communications with Nintex Automation Cloud.

  1. Create a connection from the connections page or from the action configuration panel when configuring the action. For information about creating connections and assigning permissions, see Manage connections.

  2. In the Connection window, complete the fields as follows.

    In this field

    Select or enter the following
    Connection name A user-friendly name for your new connection

    Username

    Username with access to the Microsoft SQL server.

    Password

    Password for above username.

    Database Host Microsoft SQL server on which the database resides. For example: yourDBhost.mssql.database.com. You can use "," or ":" to specify the port.
    Database Name

    Name of the database.

  3. Click Connect.

  4. Follow the prompts to grant access to Nintex Automation Cloud.

    Your new connection appears in the Connection field of your action or start event.