Can we perform all steps for Azure Managed Database Instance?
I am trying to perform this on Azure Managed database instance. But getting following error message
Invoke-Sqlcmd : A network-related or instance-specific error occurred while establishing a connection to SQL Server.
The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is
configured to allow remote connections. (provider: TCP Provider, error: 0 - A connection attempt failed because the
connected party did not properly respond after a period of time, or established connection failed because connected
host has failed to respond.)
At line:6 char:16
+ ... LOutput = $(Invoke-Sqlcmd -ServerInstance $AzureSQLServerName -Userna ...
+ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
+ CategoryInfo : InvalidOperation: (:) [Invoke-Sqlcmd], SqlException
+ FullyQualifiedErrorId : SqlExceptionError,Microsoft.SqlServer.Management.PowerShell.GetScriptCommand
Invoke-Sqlcmd :
At line:6 char:16
+ ... LOutput = $(Invoke-Sqlcmd -ServerInstance $AzureSQLServerName -Userna ...
+ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
+ CategoryInfo : ParserError: (:) [Invoke-Sqlcmd], ParserException
+ FullyQualifiedErrorId : ExecutionFailureException,Microsoft.SqlServer.Management.PowerShell.GetScriptCommand