Pipeline Setup: Microsoft SQL Server
Last updated
Last updated
Time Required: 10-15 Minutes (Setup: 5-10 Minutes; Data Relocation: 5 Minutes)
While DigitalOcean doesn't have a tutorial for installing Microsoft SQL Server, Microsoft provides a simple quickstart guide for DigitalOcean:
, which covers provisioning for AWS, DigitalOcean, and Google Cloud; each of these then link to
If you're not ready (or licensed) to use SQL Server 2017 or just don't want to run it on Linux, you'll need a Windows instance. Vultr, Google Cloud, and AWS (or Lightsail) all provide these for a marginal additional cost. Some Google-fu will suggest that you can puzzle your way through installing Windows with your own licensing on a DigitalOcean droplet with a custom image. As of April 2019, this is unsupported, but it is possible.
If you can move to SQL Server 2017 (or 2019) for Linux but don't know where to begin, Microsoft provides an
Once you've completed the basic setup guide, you'll want to change the default file directory location for the master database and backup directory location so we can take advantage of block storage. These options (along with several other popular configuration directives) are documented in . Just remember to use the mount point you named in Instance Prep: The guide uses /mnt/db, so if you did the same then you'd use that instead of the example in the Microsoft documentation of /tmp/masterdatabasedir.
Most of our access control will come from the provider-level firewall rather than UFW, so for now we'll just open port 1433 (and port 1434 for the admin console) on UFW and deal with the bulk of the firewall rules in the next section.