Azure SQL Database
An Azure relational database service.
Getting Login Failed and TCP/IP Connection Error while connecting springboot with azure sql server from windows local machine
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(185.6, 74%, 27%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBT%3C/text%3E%3C/svg%3E)
bina trivedi
1
Reputation point
Application.Properties file created for connection with Azure SQL
239028-image.png
I got the following error while connecting with the azure SQL server
Error:239029-image.png
com.microsoft.sqlserver.jdbc.SQLServerException: Cannot open server "example.com" requested by the login. The login failed
what is the possible solution for resolving this issue?
Azure SQL Database
{count} votes
-
Oury Ba-MSFT 21,146 Reputation points Microsoft Employee Moderator2022-09-08T21:52:01.567+00:00 Hi @bina trivedi Thank you for posting your question on Microsoft Q&A and for using Azure services.
My understanding is that you are facing an issue connection spring boot to an Azure SQL database. Looks like you have share 2 images of the error message, but I am not able to see them. Could you please share a screen shot of the error message and also connection details used from Azure SQL Server. Please remember not to share any sensitive information on this public forum.
Regards,
Oury -
Oury Ba-MSFT 21,146 Reputation points Microsoft Employee Moderator
2022-09-08T21:53:04.55+00:00 Hi @bina trivedi Please also share the steps you took while connecting.
Regards,
Oury -
bina trivedi 1 Reputation point
2022-09-09T05:14:11.323+00:00 Application.properties:
logging.level.org.hibernate.SQL=DEBUGspring.datasource.url=jdbc:sqlserver://example.databasename.windows.net:123;database=databasename;encrypt=true;trustServerCertificate=false;hostNameInCertificate=*.database.windows.net;loginTimeout=30;
spring.datasource.username=example@ssss .com
spring.datasource.password=#####
spring.jpa.show-sql=true
spring.jpa.hibernate.ddl-auto=create
spring.jpa.properties.hibernate.dialect=org.hibernate.dialect.MySQLDialect
in the Application.properties file we are giving username and password of Azure Portal.Erorr Message:
Error-1
com.microsoft.sqlserver.jdbc.SQLServerException: Cannot open server "example.com" requested by the login. The login failed.
Error-2
Error creating bean with name 'entityManagerFactory' defined in class path resource [org/springframework/boot/autoconfigure/orm/jpa/HibernateJpaConfiguration.class]: Invocation of init method failed; nested exception is javax.persistence.PersistenceException: [PersistenceUnit: default] Unable to build Hibernate SessionFactory; nested exception is org.hibernate.exception.SQLGrammarException: Unable to open JDBC Connection for DDL execution -
Oury Ba-MSFT 21,146 Reputation points Microsoft Employee Moderator
2023-05-22T17:25:16.92+00:00 Please check the below if none of them worked then try creating a support ticket and provide the network traces. so, we can further investigate this.
Check firewall setting if you are connecting from external source.
Make sure you have the necessary permissions to connect.
Regards,
Oury
Sign in to comment
Sign in to answer