Microsoft SQL Server (MSSQL)

A powerful relational database management system developed by Microsoft.

Usage

Deploy the template and navigate to the Networking tab. Copy the domain and port, then connect using your SQL management tool. The connection URL should be in the format domain:port. Log in with the admin username sa. If you did not set a password, a random password is generated at deploy time. You can find the password in the Variable tab under the MSSQL_SA_PASSWORD variable.

Environment Variable

• ACCEPT_EULA: Confirms your acceptance of the End-User Licensing Agreement⁠
  • Default Value: Y
• MSSQL_SA_PASSWORD: The database system administrator (userid = 'sa') password used to connect to SQL Server once the container is running.
  • Default Value: a random password generated at deploy time
  • If you set your own, the password needs to include at least 8 characters of at least three of these four categories: uppercase letters, lowercase letters, numbers and non-alphanumeric symbols.
• MSSQL_PID:
  • Default Value: Evaluation
  • Developer : This will run the container using the Developer Edition (this is the default if no MSSQL_PID environment variable is supplied)
  • Express : This will run the container using the Express Edition
  • Standard : This will run the container using the Standard Edition
  • Enterprise : This will run the container using the Enterprise Edition
  • EnterpriseCore : This will run the container using the Enterprise Edition Core : This will run the container with the edition that is associated with the PID