In this azure tutorial, we will discuss how to fix the error, The ‘New-AzSqlServer’ command was found in the module ‘Az.Sql’, but the module could not be loaded. which comes while trying to create an Azure SQL database using PowerShell in Azure.
We will also discuss how to fix the below errors
- The ‘New-AzSqlServerFirewallRule’ command was found in the module ‘Az.Sql’, but the module could not be loaded.
- The ‘New-AzSqlDatabase’ command was found in the module ‘Az.Sql’, but the module could not be loaded.
Table of Contents
- The ‘New-AzSqlServer’ command was found in the module ‘Az.Sql’, but the module could not be loaded.
- The ‘New-AzSqlServerFirewallRule’ command was found in the module ‘Az.Sql’, but the module could not be loaded.
- The ‘New-AzSqlDatabase’ command was found in the module ‘Az.Sql’, but the module could not be loaded.
The ‘New-AzSqlServer’ command was found in the module ‘Az.Sql’, but the module could not be loaded.
Recently, while trying to create an Azure SQL database using PowerShell, I got the above error message. Below was the cmdlet I was executing for creating the AzureSQL database.
# Creation of server
$Myserver = New-AzSqlServer -ResourceGroupName $MyresourceGroupName `
-ServerName $NewserverName `
-Location $Mylocation `
-SqlAdministratorCredentials $(New-Object -TypeName System.Management.Automation.PSCredential -ArgumentList $NewadminSqlLogin, $(ConvertTo-SecureString -String $Newpassword -AsPlainText -Force))

Note: This is the part of my actual script.
The exact error message was
New-AzSqlServer: The ‘New-AzSqlServer’ command was found in the module ‘Az.Sql’, but the module could not be loaded. For more information, run ‘Import-Module Az.Sql’.
At line:25 char:13
- $Myserver = New-AzSqlServer -ResourceGroupName $MyresourceGroupName `
~~~- CategoryInfo : ObjectNotFound: (New-AzSqlServer:String) [], CommandNotFoundException
- FullyQualifiedErrorId : CouldNotAutoloadMatchingModule
To fix the above issue, you need to follow the below steps
Run the below command to import the Az.Sql
PS C:\windows\system32> Import-Module Az.Sql

After importing the Az.Sql module, run the below cmdlet again to create the SQL server. Now you should not get any error
# Creation of server
$Myserver = New-AzSqlServer -ResourceGroupName $MyresourceGroupName `
-ServerName $NewserverName `
-Location $Mylocation `
-SqlAdministratorCredentials $(New-Object -TypeName System.Management.Automation.PSCredential -ArgumentList $NewadminSqlLogin, $(ConvertTo-SecureString -String $Newpassword -AsPlainText -Force))

The ‘New-AzSqlServerFirewallRule’ command was found in the module ‘Az.Sql’, but the module could not be loaded.
I also got the error “The ‘New-AzSqlServerFirewallRule’ command was found in the module ‘Az.Sql’, but the module could not be loaded”. which comes while trying to create an Azure SQL database using PowerShell in Azure.
I was using the below cmdlet
$MyserverFirewallRule = New-AzSqlServerFirewallRule -ResourceGroupName $resourceGroupName `
-ServerName $NewserverName `
-FirewallRuleName "AllowedIPs" -StartIpAddress $NewstartIp -EndIpAddress $NewendIp

The actual error was
New-AzSqlServerFirewallRule: The ‘New-AzSqlServerFirewallRule’ command was found in the module ‘Az.Sql’, but the module could not be loaded. For more information, run ‘Import-Module Az.Sql’.
At line:31 char:23
- $serverFirewallRule = New-AzSqlServerFirewallRule -ResourceGroupName …
~~~~~~~- CategoryInfo : ObjectNotFound: (New-AzSqlServerFirewallRule:String) [], CommandNotFoundException
- FullyQualifiedErrorId : CouldNotAutoloadMatchingModule
To fix this issue, we need to follow the same steps as above.
The ‘New-AzSqlDatabase’ command was found in the module ‘Az.Sql’, but the module could not be loaded.
I also got the above error which comes while trying to create an Azure SQL database using PowerShell in Azure.
Below is the cmdlet
# Create a blank DB
$mydatabase = New-AzSqlDatabase -ResourceGroupName $MyresourceGroupName `
-ServerName $NewserverName `
-DatabaseName $NewdatabaseName `
-RequestedServiceObjectiveName "S0" `

The exact error message was
New-AzSqlDatabase: The ‘New-AzSqlDatabase’ command was found in the module ‘Az.Sql’, but the module could not be loaded. For more information, run ‘Import-Module Az.Sql’.
At line:36 char:15
- $mydatabase = New-AzSqlDatabase -ResourceGroupName $MyresourceGroupN …
~~~~~- CategoryInfo : ObjectNotFound: (New-AzSqlDatabase:String) [], CommandNotFoundException
- FullyQualifiedErrorId : CouldNotAutoloadMatchingModule
To fix this error message we need to follow the above same steps.
Before I was getting the error message like below

After fixing all these issues by following the above mentioned steps, I didn’t get these errors again

Now after the script executed successfully, you can see it created the SQL DB without any issue.

You may like following Azure tutorials:
In this Azure tutorial, we discussed how to fix the below errors,
The ‘New-AzSqlServer’ command was found in the module ‘Az.Sql’, but the module could not be loaded.
The ‘New-AzSqlServerFirewallRule’ command was found in the module ‘Az.Sql’, but the module could not be loaded.
The ‘New-AzSqlDatabase’ command was found in the module ‘Az.Sql’, but the module could not be loaded.
I hope it helped you to fix your issue.