Microsoft SQL Server - Authorization

Connecting Microsoft SQL Server to Workflows requires you to have: 1. A Microsoft SQL Server user with read/write access to the database and all associated tables/views you wish to access. We recommend setting up an account specifically for Workflows access, although you can use an existing user. 2. Workflows IP Addresses whitelisted

Creating a New User

1. Login to your Microsoft SQL Server

2. Create a login either:
   a. On the command line by running CREATE LOGIN <login value> WITH PASSWORD = '<new password>';
   b. In the Object Explorer following these instructions

3. Create a user either:
   a. On the command line by running CREATE USER <user name> FOR LOGIN '<login value>';
   b. In the Object Explorer following these instructions

4. The server URL, the username, and password are all used in the Blueprints below