Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago

Connect to Azure SQL

I'm unable to connect to Azure SQL database with below error message, any1 know what's that means? 

Need Help

3 Replies

  • v-sihou-msft's avatar
    v-sihou-msft
    Microsoft Employee
    9 years ago

    Anonymous

     

    Make sure your input correct server name. You can also try to connect SQL Azure via SSMS. If it also fails, please check the Azure firewall configuration as Greg_Deckler suggested.

     

    Regards,

    • Diegres's avatar
      Diegres
      New Member
      9 years ago

      I have a similar / identical issue:

      Details: "Microsoft SQL: 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. (provider: TCP Provider, error: 0 - No such host is known.)"


      Details: "An error happened while reading data from the provider: 'System.IO.FileLoadException"

       

      I am able to connect to my Azure SQL Database from SSMS, so the firewall ports are configured as expected. Exhausted my options - Please help.