12-06-2022 03:10 AM
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 ?
Solved! Go to Solution.
12-07-2022 01:02 AM
We’ve changed the type of the account to MySQL Database Account. After that we’ve managed to connect to the MySQL Azure database.
12-06-2022 09:28 AM
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)
12-07-2022 01:02 AM
We’ve changed the type of the account to MySQL Database Account. After that we’ve managed to connect to the MySQL Azure database.