Forum Discussion
rozeboosje
May 11, 2023Copper Contributor
Creating a Server with current nuget packages?
I want to programmatically create an Azure SQL Server and I found an example piece of code online static void CreateServer()
{
// Create a SQL Database management client
SqlManagementClient...
Kidd_Ip
Sep 14, 2025MVP
How about this:
using Azure.Identity;
using Azure.ResourceManager;
using Azure.ResourceManager.Resources;
using Azure.ResourceManager.Sql;
using Azure.ResourceManager.Sql.Models;
async Task CreateSqlServerAsync()
{
string subscriptionId = "<your-subscription-id>";
string resourceGroupName = "<your-resource-group>";
string location = "eastus";
string serverName = "<your-server-name>";
string adminLogin = "sqladmin";
string adminPassword = "<your-password>";
// Authenticate
var credential = new DefaultAzureCredential();
var armClient = new ArmClient(credential, subscriptionId);
// Get the resource group
ResourceGroupResource resourceGroup = await armClient.GetDefaultSubscriptionAsync()
.Result.GetResourceGroups().GetAsync(resourceGroupName);
// Define server data
var serverData = new SqlServerData(location)
{
AdministratorLogin = adminLogin,
AdministratorLoginPassword = adminPassword
};
// Create the SQL Server
var sqlServerLro = await resourceGroup.GetSqlServers().CreateOrUpdateAsync(
WaitUntil.Completed,
serverName,
serverData);
SqlServerResource sqlServer = sqlServerLro.Value;
Console.WriteLine($"SQL Server created: {sqlServer.Data.Name}");
}