how to connect local sql server database in Azure Application Service using JDBC.

Question

my property file is:

spring.datasource.url=jdbc:sqlserver:/servername:1433;encrypt=true;trustServerCertificate=true;hostNameInCertificate=*;DatabaseName=SDT_Bulletin
spring.datasource.username=user
spring.datasource.password=****
spring.datasource.driver-class-name = com.microsoft.sqlserver.jdbc.SQLServerDriver.

code works fine in my machine. database is in the LAN so i have used the hybird connection.

Answer 1

I deploy the project in Azure App service , it callbacks with a connect to database time out result.

Answer 2

Hi sumail233333,

Your property file seems all right(make sure your servername is correct), suggest you to check your firewall rules to allow the outbound connections to port 1433 on your local server and confirm your Hybrid Connections work well.

Here is a detailed article about how to work with Hybrid Connections.

Hope this helped you.

---

MSDN 社区技术支持
如果该回复解决了您的问题，请及时点击“标记为答案”选项，如未解决请选择“取消标记为答案”，这会有利于其他人员来阅读您的帖子。如果您对MSDN 技术支持有任何的建议或意见，请随时联系 [e-mail]。