Hi Team, We facing the connectivity issue to SQL server from Azure devops pipeline

veerendra kumar 5 Reputation points
2023-05-28T05:41:41.8533333+00:00

Hi Team,

Greetings of the Day,

We are trying to deploy the sql code script into SQL Database by using Azure DevOps yaml pipeline, but we are encountering connectivity issues to SQL db through pipeline and we are able to login by using Microsoft SSMS but not able to establish connection through pipeline.

Please find the error message " A connection was successfully established with the server, but then an error occurred during the login process. (provider: SSL Provider, error: 0 - An existing connection was forcibly closed by remote host)" .. When we checked microsoft documentation. It's say error related to TLS version. But SQL Server already have TLS 1.2 version

Kindly look into the issue, help me ASAP

Azure SQL Database
Azure
Azure
A cloud computing platform and infrastructure for building, deploying and managing applications and services through a worldwide network of Microsoft-managed datacenters.
1,072 questions
SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,322 questions
{count} votes

2 answers

Sort by: Most helpful
  1. veerendra kumar 5 Reputation points
    2023-05-31T10:34:28.4766667+00:00

    Hi @ZoeHui-MSFT @Erland Sommarskog @Mohammed Thahif BK@ShaktiSingh-MSFT

    Thank you so much your support and guidance. The issue has been resolved.

    Root cause of the issue is TLS 1.2, We have the azure devops pool agent to window-latest agent from private pool agent so now windows agents using TLS 1.2 version to connect SQL database after that it working..

    Once again Thank you

    1 person found this answer helpful.

  2. ZoeHui-MSFT 35,381 Reputation points
    2023-05-29T02:46:10.1833333+00:00

    Hi @veerendra kumar,

    Here is a same thread, you may take a reference to.

    Regards,

    Zoe Hui


    If the answer is helpful, please click "Accept Answer" and upvote it.

    0 comments No comments