Forum Discussion

Igor_Bozhinovsk's avatar
Igor_Bozhinovsk
New Contributor III
3 years ago
Solved

Azure MySql Database connection

While trying to connect to Azure MySql Database we are getting the following error: Failed to validate account: Failed to retrieve a database connection. Cause: The TCP/IP connection to the host port 3306 has failed. Error: "The driver received an unexpected pre-login response. Verify the connection properties and check that an instance of SQL Server is running on the host and accepting TCP/IP connections at the port.

This is indicating that the jdbc default driver name com.microsoft.sqlserver.jdbc.SQLServerDriver in the account properties needs to be changed. As mentioned we are trying to connect to Azure MYSQL .

Any one had this issue before ?

  • We’ve changed the type of the account to MySQL Database Account. After that we’ve managed to connect to the MySQL Azure database.

2 Replies

  • Which Snap Pack are you using to connect to it? You’d need to use a MySQL Driver rather than Azure Sql (Azure SQL is a different database engine)

    • Igor_Bozhinovsk's avatar
      Igor_Bozhinovsk
      New Contributor III

      We’ve changed the type of the account to MySQL Database Account. After that we’ve managed to connect to the MySQL Azure database.