Authorization

Connecting Microsoft SQL Server to Shipyard 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 Shipyard access, although you can use an existing user.
2. Shipyard 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