none
Can't connect from SQL Server Management Studio RRS feed

  • Question

  • I have an Azure SQL Server instance on a pay-as-you-go subscription.
    It contains one SQL Server database.
    I can use the database successfully from my Access front-end.
    I want to make a design change so I opened up SQL Server Management Studio 17 on my laptop and entered the server name (myservername.windows.database,net) Selected SQL Server Authentication and entered the admin user name and password.
    I get an error message:
    <<
    Cannot connect to myservername.windows.database.net
    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 (how?)
    (provider: named pipes provider, error: 40 - could not open a connection to SQL Server) (Microsoft SQL Server, Error: 53)

    The network path was not found
    >>

    I have tried the troubleshooting utility which found nothing wrong.
    I am sure that I could previously access that server from SQL Server Management Studio running on this machine
    Help please!


    Bill Manville. Excel MVP, Oxford, England. www.manville.org.uk

    Thursday, November 21, 2019 12:43 AM

Answers

  • D'uh

    I had recorded the server name incorrectly.

    Should be myservername.database.windows.net and I had interchanged the middle 2 components.

    Sorry to have troubled you.


    Bill Manville. Excel MVP, Oxford, England. www.manville.org.uk

    • Marked as answer by Bill Manville Thursday, November 21, 2019 8:52 AM
    Thursday, November 21, 2019 8:52 AM

All replies

  • Hello Bill,

    Please add the client IP of the machine you are connecting from to the Firewall.

    Also check if you are specifying the database name in Connection Properties while connecting via SSMS

    -

    If this answers your query, do click “Mark as Answer” and Up-Vote for the same which might be beneficial to other community members reading this thread .

    And, if you have any further query do let us know.

    Thursday, November 21, 2019 2:36 AM
    Moderator
  • Thank you for the reply.

    My laptop's IP is within the range specified in the server's firewall.
    (and I can run my Access application that connects to the database on the laptop successfully)

    I replaced <default> by the name of the database in Connection Properties in the SSMS dialog and got the same response as before.


    Bill Manville. Excel MVP, Oxford, England. www.manville.org.uk

    • Marked as answer by Bill Manville Thursday, November 21, 2019 8:52 AM
    • Unmarked as answer by Bill Manville Thursday, November 21, 2019 8:52 AM
    Thursday, November 21, 2019 7:58 AM
  • D'uh

    I had recorded the server name incorrectly.

    Should be myservername.database.windows.net and I had interchanged the middle 2 components.

    Sorry to have troubled you.


    Bill Manville. Excel MVP, Oxford, England. www.manville.org.uk

    • Marked as answer by Bill Manville Thursday, November 21, 2019 8:52 AM
    Thursday, November 21, 2019 8:52 AM