Blog Post

Azure Database Support Blog
3 MIN READ

Automating Azure SQL DB index and statistics maintenance using Azure Automation

Yochanan_Rachamim's avatar
Yochanan_Rachamim
Icon for Microsoft rankMicrosoft
Mar 14, 2019
First published on MSDN on Jan 15, 2018 To provide complete solution to maintain you Azure SQL DB statistics and maintenance we provide our maintenance script here In this article, we will...
Updated Oct 27, 2024
Version 3.0
kulpreetm's avatar
kulpreetm
Copper Contributor
Sep 24, 2020

Hi Yochanan_Rachamim 

 

I have setup azure SQL maintenance as per this article. But while running the runbook, I am getting below error. Now, I know this is related to network, but what can be done to fix this. I have already allowed by client ip on Azure firewall. Not sure where am I missing. Would you please be able to help me out here.

 

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 - No such host is known.) At line:6 char:16 + ... LOutput = $(Invoke-Sqlcmd -ServerInstance $AzureSQLServerName -Userna ... + ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ + CategoryInfo : InvalidOperation: (:) [Invoke-Sqlcmd], SqlException + FullyQualifiedErrorId : SqlExceptionError,Microsoft.SqlServer.Management.PowerShell.GetScriptCommand