How to link on-premise SQL Server Management Studio / Azure Data Studio with Azure SQL Managed Instance

Jonathan Hobdell 20

Hello all

I hope my tag is correct - I couldn't see one for Managed Instance.

So, I have created a new Managed Instance, which comes with:

Network security Group

Route table

Virtual cluster

Virtual network

I'm trying to make this visible to my on-premise SSMS, so far without success. I always get the generic error:

ADDITIONAL INFORMATION:

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.) (Microsoft SQL Server, Error: 10060)

For help, click: https://docs.microsoft.com/sql/relational-databases/errors-events/mssqlserver-10060-database-engine-error

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

This is now the 3rd time I've created a Managed Instance and then destroyed it all because it's not working and I'm not knowledgable enough to find the issue.

In the current case I've followed the docs here and @Ronen Ariely 's notes here but it gives the same error. Does anyone have any idea what may be wrong?

Thank you!

Sai Raghunadh M 1,045 Reputation points Microsoft Vendor

2024-11-11T18:22:46.81+00:00

Hi @Jonathan Hobdell,

Thanks for the question and using MS Q&A platform

The error Error 10060 can often mean that the firewall or network access control is blocking the connection. You should verify both your on-premise firewall and the Azure firewall settings for the SQL Managed Instance.

Managed Instances typically require an SSL connection by default. Ensure that SSMS is configured to use SSL when connecting to the Managed Instance.

Although SQL Managed Instances are generally configured to allow remote connections by default, it’s a good idea to ensure that remote connections are enabled and that your instance allows TCP/IP connectivity.

From your on-premises server, run a telnet <mi-name>.database.windows.net 1433 to check if the port is reachable.

If the above trouble shooting steps don't work, please file a support ticket for deeper investigation and do share the SR# with us?

I hope this information helps, please do let us know if you have any Queries.
Jonathan Hobdell 20 Reputation points

2024-11-12T10:07:11.7933333+00:00

Hi @Sai Raghunadh M

Thank you for your response, and for your continued help.

I'm afraid I'm rather a novice when it comes to Azure. I find the whole thing utterly bewildering, because neither the training, nor the videos, nor the docs can keep up with the rate of change that goes on. There's always another bit that needs to be done that isn't mentioned anywhere. Suffice it to say I'm not especially pleased with my cloud experience so far.

I'm abandoning this for now because although I've confirmed that the correct rules seem to be in place both locally and in my Azure environment, the connection still fails.

Thank you all the same.
Sai Raghunadh M 1,045 Reputation points Microsoft Vendor

2024-11-12T10:46:49.49+00:00

Hi @Jonathan Hobdell,

For a deeper investigation and immediate assistance on this issue, if you have a support plan you may file a support ticket for deeper investigation and do share the SR# with us? In case if you don't have a support plan, please let us know here.
Jonathan Hobdell 20 Reputation points

2024-11-12T10:51:05.47+00:00

Hi @Sai Raghunadh M

Apologies, I forgot to include this in my previous reply. I'm only on a free Azure subscription for learning purposes at this point, so there's only the basic support.
Deleted

This comment has been deleted due to a violation of our Code of Conduct. The comment was manually reported or identified through automated detection before action was taken. Please refer to our Code of Conduct for more information.

Share via

How to link on-premise SQL Server Management Studio / Azure Data Studio with Azure SQL Managed Instance

Your answer