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

  • 问题

  • 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.

    2018年6月28日 8:14

全部回复

  • I deploy the project in Azure App service , it callbacks with a connect to database time out result.
    2018年6月28日 8:19
  • 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 技术支持有任何的建议或意见,请随时联系 MSDNFSF@microsoft.com

    2018年6月28日 11:06
    版主