Create a Microsoft SQL (MSSQL) Server database in DuploCloud
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.
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 .
From the DuploCloud Portal, navigate to Administrator -> Tenants.
Select the Tenant from the NAME column.
Select the Settings tab, and click Add. The Add Tenant Feature pane displays.
Create a new Microsoft SQL Server instance in your tenant to host one or more SQL databases for your applications.
Select the Tenant from the Tenant list box.
In the DuploCloud Portal, navigate to Cloud Services -> Database -> MSSQLServer.
Click Add. The Add SQL Server pane displays.
After creating an MSSQL Server, you must add one or more SQL databases to store your application data.
Select the Tenant from the Tenant list box.
Navigate to Cloud Services → Database → MSSQL Server.
Select the MSSQL Server from the NAME column.
Click Submit to create the 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.
Select the Tenant from the Tenant list box.
Navigate to Cloud Services → Database → MSSQLServer.
Select the MSSQL Server from the NAME column.
Enter a value between 1 and 35 days and click Save.
The backup retention period cannot be configured for the master database.
Select the Tenant from the Tenant list box.
In the DuploCloud Portal, navigate to Cloud Services → Database → MSSQLServer.
Select the MSSQL Server from the NAME column. The MSSQL Server details page displays.
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:
The master database is managed by Azure and cannot be edited or deleted.
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.
Select the Tenant from the Tenant list box.
In the DuploCloud Portal, navigate to Cloud Services -> Database -> MSSQLServer.
Select the MSSQL Server database from the NAME column.
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:
Select the Tenant from the Tenant list box.
In the DuploCloud Portal, navigate to Cloud Services -> Database -> MSSQLServer.
Select the MSSQL Server database from the NAME column.
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.
Select the Tenant from the Tenant list box.
In the DuploCloud Portal, navigate to Cloud Services -> Database -> MSSQL Server.
Select the MSSQL Server from the NAME column.
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.
Select the Tenant from the Tenant list box.
In the DuploCloud Portal, navigate to Cloud Services -> Database -> MSSQL Server.
Select the MSSQL Server database from the NAME column.
From the Select Feature list box, select Allow Public Network Access for Databases and Cache Servers.
Enable the setting, and click Add. Public access is enabled.
Provide a name for the MSSQL Server database, your username and password, and database version information.
From the Public Access list box, select Enabled or Disabled. If Enabled is not available, complete the steps above under Prerequisites to .
Click Submit. The MSSQL Server database is created.
In the Databases tab, click Add. The Create SQL Database pane displays.
Complete the following fields:
Select the Databases tab.
Click the menu icon () next to the database and select Update Short Term Retention. The Update Backup Retention Period pane displays.
Use one of the following options to manage the server and its databases:
Select the Private Endpoints tab, and click Add. The Add Private Endpoint pane displays.
Add a name and select a subnet for your private endpoint.
Click Submit. The private endpoint is created and accessible via the selected subnet.
Select the Elastic Pools tab, and click Add. The Add SQL Elastic Pool pane displays.
Enter a name for the elastic pool and configure the SQL Elastic Pool (select your Service Tier, Sku Name, Max Storage Size).
Click Submit. The elastic pool is created.
Select the Virtual Network Rules tab, and click Add. The Add New Virtual Network Rule pane displays.
Add a name for the virtual network rule, and select the subnet. Click Create. The virtual network rule is created.
Select the Firewall Rules tab, and click Add. The Add New SQL Server Firewall Rule pane displays.
Add a name for the firewall rule, and specify the starting and ending IP addresses that should be allowed to access your MSSQL database.
Click Create. The firewall rule is added to the server.
Name
Enter a name for the database.
Use Elastic Pool
Select whether to use an elastic pool. Default is No.
Service Tier
Select the service tier.
SKU Name
Select the SKU name.
Collation
Optionally, enter the collation setting.
Databases
View or manage the databases associated with this server.
Elastic Pools
View or configure elastic pool settings, if applicable.
Private Endpoints
View or manage private network connections.
Virtual Network Rules
View or manage subnet-based access restrictions. This tab is only visible when public access is enabled.
Firewall Rules
View or manage IP-based firewall rules. This tab is only visible when public access is enabled.
Azure Portal
Open the server directly in the Azure Portal.
Delete SQL Server
Delete the server if no databases remain.
Edit
Update the database name or settings.
Update Short Term Retention
Configure the backup retention period for the database.
Delete
Remove the database from the server.
