How do I create a new Server

Question

On my initial creation of our Azure SQL account I was asked to create a server, so I started with a development server housing several databases, but now I'd like to create a test/staging and production server so that I can migrate updates to databases through the proper channels. There isn't a place I can see where I can create two more servers, how do I do that?

Answer 1

Hi EFS •,

Welcome to Microsoft Q&A forum.

As I understand, you want to create a new SQL Server for your Azure SQL Databases.

Open Azure Portal.

Search in Marketplace for "SQL Server", below screen will appear with different options:

Next create this server:

Fill in the details and create server:

Once SQL Server is created, you can add your Azure SQL Databases to it and will be visible in the Settings sections of the SQL Server:

Let us know if this answers your question.

If not, please share more details so that we can assist you.

Thanks.

Answer 2

Hello EFS ,

Thanks for reaching out in the Microsoft Q&A!

To create new servers in Azure SQL Database for test/staging and production environments, you need to sign in to the Azure portal, navigate to "Azure SQL databases," and select your Azure SQL account. Click "Create server" and configure the server settings, including a unique server name, resource group, location, and deployment option (typically a "Single database"). Choose your authentication method, either "Azure Active Directory (AAD) authentication" for improved security or "SQL Server authentication" for traditional login credentials. After reviewing your selections, click "Create" to provision the new server. Repeat this process for each environment. Finally, configure firewall rules to restrict access to authorized IP addresses or AAD identities and create databases within the servers as needed. This approach establishes separate, secure environments for development, testing, and production, facilitating a structured deployment pipeline.

If you find this helpful, please accept this answer to close the thread. Thanks!