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,598 questions

3 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Olaf Helper 43,896 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 109.4K 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
  3. ZoeHui-MSFT 36,101 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.

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.