cancel
Showing results for 
Search instead for 
Did you mean: 

Azure MySql Database connection

Igor_Bozhinovsk
New Contributor III

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 ?

1 ACCEPTED SOLUTION

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

View solution in original post

2 REPLIES 2

ddellsperger
Moderator
Moderator

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)

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