.svg?alt=media&token=0f6df7c7-5b98-4a62-98b8-a54e38a8329e){kind=logo}
MSSQL Server database
Create a Microsoft SQL (MSSQL) Server database in DuploCloud
Prerequisites
Enable public access for an MSSQL Server database
To create an MSSQL Server database with public access, configure the following Tenant setting to allow public network access for databases and cache servers. If the database does not need public access, skip this step and create an MSSQL Server database.
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.
From the Select Feature list box, select Allow Public Network Access for Databases and Cache Servers.
Enable the setting, and click Add. Public database access is enabled.
Creating an MSSQL Server database
Select the Tenant from the Tenant list box.
In the DuploCloud Portal, navigate to Cloud Services -> Database -> MSSQLServer, and click Add.
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 enable this option.
Click Submit. The MSSQL Server database is created.
Adding a private endpoint for an MSSQL Server database (optional)
A private endpoint is a network interface that connects you privately and securely to your MSSQL Server database. 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.
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.
Viewing MSSQL Server database details
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.
Select the Databases tab to view the databases and details.
Configuring Azure SQL 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:
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.
Select the Elastic Pools tab, and click Add. The Add SQL Elastic Pool pane displays.
Enter a name for the elastic pool, select your service tier, and select the correct SKU.
Click Submit. The elastic pool is created.
Setting virtual network rules
Virtual network rules restrict access to your Azure SQL Database server to specific subnets within a virtual network to enhance security and network isolation. Public access must be disabled to add virtual network rules.
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.
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 for your MSSQL database. Click Create. The virtual network rule is created.
Setting firewall rules
Firewall rules for an MSSQL Server help control access to your database server by allowing or denying traffic based on IP addresses. These rules secure your database by restricting access to only trusted sources. Public access must be disabled to add firewall rules.
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.
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 select the starting and ending IP addresses for your MSSQL database. Click Create. The firewall rule is created.
Last updated
