Error occurred while establishing a connection to SQL Server, Remote connections error 35

[ssquadri]

Hi Folks,

We are getting this error a lot kindly let us know how to resolve it

Invoke-Sqlcmd: /home/xyz/Commercial-Marketplace-SaaS-Accelerator/deployment/Deploy.ps1:579
Line |
579 | Invoke-Sqlcmd -InputFile ./script.sql -ServerInstance $ServerUri -dat …
| ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
| 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: 35 - An internal exception was caught)

[eyalhconnact]

I have the same error.
Any help will be appreciated

[ssquadri]

@eyalhconnact one of the possible causes might be the subscription does not have regional access to create SQL (For eg East US)

Try doing this and let me know if it solves anything

Link - https://learn.microsoft.com/en-us/azure/azure-sql/database/quota-increase-request?view=azuresql

[pmillart]

@ssquadri and @eyalhconnact did you register the Microsoft.SQL provider ?
I had the same issue this morning, and after registering the provider the issue did not occurs anymore.