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
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.