SQL login issue

Gurpreet Khaira 0 Reputation points

I'm trying to connect via local SSMS to the SQL Server on my Azure VM but it's failing saying the Server is not found or accessible. I can RDP into my VM without issue. Any ideas please?

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,040 questions
0 comments No comments
{count} votes

3 answers

Sort by: Most helpful
  1. Olaf Helper 42,451 Reputation points

    Have you unblocked the required IP ports in Firewall?

    See Configure the Windows Firewall to allow SQL Server access

  2. Erland Sommarskog 103.1K Reputation points MVP

    Windows firewall is not enough. You also need to go the blade for the VM in the Azure portal to open the port.

    However, exposing an SQL Server instance with a public IP is a lousy idea. There will be lot of folks knocking on that door trying to get in. You need to set up a private network so you can connect with VPN.

    How do that? Cough, I don't really know. I create a VM for a test last night and I set up a public IP - but I also deleted the VM directly since it was for a quick test.

    0 comments No comments

  3. ZoeHui-MSFT 34,426 Reputation points

    Hi @Gurpreet Khaira,

    Please check the documentation step by step.

    Connect to a SQL Server virtual machine on Azure


    Zoe Hui

    If the answer is helpful, please click "Accept Answer" and upvote it.

    0 comments No comments