SQL login issue

Gurpreet Khaira 0 Reputation points
2024-06-10T10:03:55.5233333+00:00

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
    2024-06-10T10:18:50.6666667+00:00

    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
    2024-06-10T20:50:06.61+00:00

    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
    2024-06-11T05:35:58.9033333+00:00

    Hi @Gurpreet Khaira,

    Please check the documentation step by step.

    Connect to a SQL Server virtual machine on Azure

    Regards,

    Zoe Hui


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

    0 comments No comments