Microsoft SQL server
The Microsoft SQL server connector Service used to define a connection required for associated actions and start events. Examples include Salesforce and Box. Method of integration to cloud services, business applications and content stores. 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.
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.
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 with access to the Microsoft SQL server.
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.
Follow the prompts to grant access to Nintex Automation Cloud.
Your new connection appears in the Connection field of your action or start event.