Connecting SQL to a database in Azure

Question

Hello, I am setting up my first database in Azure and am trying to connect through SQL. Every session has timed out on me so far and I can't figure out what the problem might be. I get the following message - "Can't connect to local MySQL server through socket '(null)' (57)" Any Suggestions?

Thanks

Answer 1

Hello,

These MSDN forums are related to Microsoft SQL Server and not to MySQL.  Below forum may be more appropriate:

https://social.msdn.microsoft.com/forums/azure/en-US/home?category=windowsazureplatform%2Cazuremarketplace%2Cwindowsazureplatformctp

The following article may be useful:

https://azure.microsoft.com/en-us/documentation/articles/store-php-create-mysql-database/

Hope this helps.

Regards,

Alberto Morillo
SQLCoffee.com

Answer 2

Hi Tmar4,

Could you please be more specific about the issue? Are you trying to connect to Azure SQL database from some management tools other than SQL Server Management Studio? If so, I would suggest you download and install SQL Server Management Studio from here. Here’s a detailed instruction of how to connect to Azure SQL database via SSMS for your reference.

If you have any other questions, please let me know.

Regards,
Lin

Answer 3

Hi Alberto,

I need to connect to Azure SQL DB. However, I am unable to do so. I have added Client IPs to the SQL and DB firewall settings. Also I have enabled Port 1433 on the local machine. The local machine is an Azure VM.

Please advise any help on the same.

Regards,

Rameshwari