.svg?alt=media&token=0f6df7c7-5b98-4a62-98b8-a54e38a8329e){kind=logo}
MSSQL Server database
Create a Microsoft SQL (MSSQL) Server database in DuploCloud
Last updated
Create a Microsoft SQL (MSSQL) Server database in DuploCloud
Last updated
© DuploCloud, Inc. All rights reserved. DuploCloud trademarks used herein are registered trademarks of DuploCloud and affiliates
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.
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.
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.
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.
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.
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.
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.
