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. Use the admin username sa along with your password to log in. If you forget your password, you can find it 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. Important note: This 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