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

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.