Skip to main content

Microsoft SQL Server 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