Microsoft SQL Server (MSSQL)

DuploCloud supports the deployment and management of Microsoft SQL Server (MSSQL) on Azure. You can use the DuploCloud Portal to create MSSQL Servers, add databases, and apply network and security configurations such as firewall rules, private endpoints, and virtual network rules.

Prerequisites

Enable public access for MSSQL Servers

To create an MSSQL Server with public access, you must first enable a Tenant setting that allows public network access for databases and cache servers. If public access is not required, you can skip this step and proceed directly to create an MSSQL Server.

1. From the DuploCloud Portal, navigate to Administrator -> Tenants.

2. Select the Tenant from the NAME column.

3. Select the Settings tab, and click Add. The Add Tenant Feature pane displays.

4. From the Select Feature list box, select Allow Public Network Access for Databases and Cache Servers.

5. Enable the setting, and click Add. Public access is enabled.

Creating an MSSQL Server

Create a new Microsoft SQL Server instance in your tenant to host one or more SQL databases for your applications.

1. Select the Tenant from the Tenant list box.

2. In the DuploCloud Portal, navigate to Cloud Services -> Database -> MSSQL Server.

3. Click Add. The Add SQL Server pane displays.

   
4. Provide a name for the MSSQL Server, your username and password, and database version information.

5. From the Public Access list box, select Enabled or Disabled. If Enabled is not available, complete the steps above under Prerequisites to enable this option.

6. Click Submit. The MSSQL Server is created.

Adding an SQL database

After creating an MSSQL Server, you must add one or more SQL databases to store your application data.

1. Select the Tenant from the Tenant list box.

2. Navigate to Cloud Services → Database → MSSQL Server.

3. Select the MSSQL Server from the NAME column.

4. In the Databases tab, click Add. The Create SQL Database pane displays.

   
5. Complete the following fields:

1. Click Submit to create the database.

Updating the backup retention period for a database

The default backup retention period for an SQL database is 7 days. You can update this setting to retain backups for up to 35 days.

1. Select the Tenant from the Tenant list box.

2. Navigate to Cloud Services → Database → MSSQLServer.

3. Select the MSSQL Server from the NAME column.

4. Select the Databases tab.

5. Click the menu icon () next to the database and select Update Short Term Retention. The Update Backup Retention Period pane displays.

1. Enter a value between 1 and 35 days and click Save.

Viewing MSSQL Server and database details

1. Select the Tenant from the Tenant list box.

2. In the DuploCloud Portal, navigate to Cloud Services → Database → MSSQLServer.

3. Select the MSSQL Server from the NAME column. The MSSQL Server details page displays.

   
4. Use one of the following options to manage the server and its databases:

Use the tabs to view server details:

You can also use the Actions button at the top right of the page:

To manage an individual database, go to the Databases tab and click the menu icon () next to the database name:

Adding private endpoints

A private endpoint is a network interface that connects you privately and securely to your MSSQL Server. This ensures that the traffic between your virtual network and the MSSQL database travels entirely without using the public internet.

1. Select the Tenant from the Tenant list box.

2. In the DuploCloud Portal, navigate to Cloud Services -> Database -> MSSQLServer.

3. Select the MSSQL Server database from the NAME column.

4. Select the Private Endpoints tab, and click Add. The Add Private Endpoint pane displays.

   
5. Add a name and select a subnet for your private endpoint.

6. Click Submit. The private endpoint is created and accessible via the selected subnet.

Configuring elastic pools

Azure SQL Database Elastic Pools provide cost-effective database resource management by pooling multiple databases together and sharing resources based on their individual needs.

Configure Azure Elastic Pools for an MSSQL Server in the DuploCloud Portal:

1. Select the Tenant from the Tenant list box.

2. In the DuploCloud Portal, navigate to Cloud Services -> Database -> MSSQLServer.

3. Select the MSSQL Server database from the NAME column.

4. Select the Elastic Pools tab, and click Add. The Add SQL Elastic Pool pane displays.

   
5. Enter a name for the elastic pool, select your service tier, and select the correct SKU.

6. Click Submit. The elastic pool is created.

   

Setting virtual network rules

Virtual network rules restrict access to your MSSQL Server to specific subnets within a virtual network, enhancing security and network isolation. Public access must be enabled to add virtual network rules.

1. Select the Tenant from the Tenant list box.

2. In the DuploCloud Portal, navigate to Cloud Services -> Database -> MSSQL Server.

3. Select the MSSQL Server from the NAME column.

4. Select the Virtual Network Rules tab, and click Add. The Add New Virtual Network Rule pane displays.

5. Add a name for the virtual network rule, and select the subnet. Click Create. The virtual network rule is created.

Setting firewall rules

Firewall rules for an MSSQL Server control access by allowing or denying traffic based on IP addresses. These rules help secure your databases by restricting access to trusted sources. Public access must be enabled to add firewall rules.

1. Select the Tenant from the Tenant list box.

2. In the DuploCloud Portal, navigate to Cloud Services -> Database -> MSSQL Server.

3. Select the MSSQL Server database from the NAME column.

4. Select the Firewall Rules tab, and click Add. The Add New SQL Server Firewall Rule pane displays.

   
5. Add a name for the firewall rule, and specify the starting and ending IP addresses that should be allowed to access your MSSQL database.

6. Click Create. The firewall rule is added to the server.