Skip to content
  • Categories
  • Recent
  • Tags
  • Popular
  • World
  • Users
  • Groups
Skins
  • Light
  • Cerulean
  • Cosmo
  • Flatly
  • Journal
  • Litera
  • Lumen
  • Lux
  • Materia
  • Minty
  • Morph
  • Pulse
  • Sandstone
  • Simplex
  • Sketchy
  • Spacelab
  • United
  • Yeti
  • Zephyr
  • Dark
  • Cyborg
  • Darkly
  • Quartz
  • Slate
  • Solar
  • Superhero
  • Vapor

  • Default (No Skin)
  • No Skin
Collapse
Code Project
  1. Home
  2. General Programming
  3. Design and Architecture
  4. Unable to connect SSMS to an Azure SQL server

Unable to connect SSMS to an Azure SQL server

Scheduled Pinned Locked Moved Design and Architecture
sql-servercsharpasp-netdatabasecom
4 Posts 3 Posters 1 Views 1 Watching
  • Oldest to Newest
  • Newest to Oldest
  • Most Votes
Reply
  • Reply as topic
Log in to reply
This topic has been deleted. Only users with topic management privileges can see it.
  • S Offline
    S Offline
    Stephen Holdorf
    wrote on last edited by
    #1

    I created an Azure SQL server VM and am unable to connect to it with SSMS. I followed this article: https://forums.asp.net/post/edit/6168801 Now when I go to my local machine cmd prompt and type: ping trainingsqldev25.eastus.cloudapp.azure.com I can see the ping resolve the DNS name to the correct IP address but the requests still time out.

    Richard DeemingR J 2 Replies Last reply
    0
    • S Stephen Holdorf

      I created an Azure SQL server VM and am unable to connect to it with SSMS. I followed this article: https://forums.asp.net/post/edit/6168801 Now when I go to my local machine cmd prompt and type: ping trainingsqldev25.eastus.cloudapp.azure.com I can see the ping resolve the DNS name to the correct IP address but the requests still time out.

      Richard DeemingR Offline
      Richard DeemingR Offline
      Richard Deeming
      wrote on last edited by
      #2

      Make sure you're using the latest version of SSMS: Download SQL Server Management Studio (SSMS) | Microsoft Docs[^]


      "These people looked deep within my soul and assigned me a number based on the order in which I joined." - Homer

      "These people looked deep within my soul and assigned me a number based on the order in which I joined" - Homer

      S 1 Reply Last reply
      0
      • Richard DeemingR Richard Deeming

        Make sure you're using the latest version of SSMS: Download SQL Server Management Studio (SSMS) | Microsoft Docs[^]


        "These people looked deep within my soul and assigned me a number based on the order in which I joined." - Homer

        S Offline
        S Offline
        Stephen Holdorf
        wrote on last edited by
        #3

        Installed the latest version of SSMS and used my host name as follows: trainingsqldev25.eastus.cloudapp.azure.com, 1433 I still can't connect. Now, everything I find on the internet points to the same article: Provision a SQL Server Virtual Machine | Microsoft Docs[^] Here I recreated my SQL VM several times and still the same results.

        1 Reply Last reply
        0
        • S Stephen Holdorf

          I created an Azure SQL server VM and am unable to connect to it with SSMS. I followed this article: https://forums.asp.net/post/edit/6168801 Now when I go to my local machine cmd prompt and type: ping trainingsqldev25.eastus.cloudapp.azure.com I can see the ping resolve the DNS name to the correct IP address but the requests still time out.

          J Offline
          J Offline
          jschell
          wrote on last edited by
          #4

          I will note that ping is not a good way to test connectivity. Much better to use 'telnet' and provide the domain and port. Success is with a blank screen and failure is when a error message it reported.

          1 Reply Last reply
          0
          Reply
          • Reply as topic
          Log in to reply
          • Oldest to Newest
          • Newest to Oldest
          • Most Votes


          • Login

          • Don't have an account? Register

          • Login or register to search.
          • First post
            Last post
          0
          • Categories
          • Recent
          • Tags
          • Popular
          • World
          • Users
          • Groups