Share via

ADF Error Cannot connect to SQL Database | Error Number = 45032

Lokesh 211 Reputation points
2021-11-16T15:28:00.497+00:00

Hi Team,

Facing a weird issue and have no clue how to troubleshoot. This is urgent so any quick assistance on this would be appreciated. Please read below.

We are using managed identity to connect to the Azure SQL database.

Connection is fine when tested as shown below

149816-1.jpg

We are able to preview the data as well (using lookup activity, name = get_email_address)

149780-2.jpg

However, when we trigger the pipeline we get the following error

149872-3.jpg

Azure SQL Database
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
0 comments
Answer accepted by question author
  1. Lokesh 211 Reputation points
    2021-11-17T06:14:45.267+00:00

    Managed to fix it.

    Just reconfigure the linked service with the same properties, save and publish.

    1 person found this answer helpful.
    0 comments

2 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Nandan Hegde 36,716 Reputation points MVP Volunteer Moderator
    2021-11-16T15:37:50.68+00:00

    Hey,
    Are you using Copy activity in the ADF pipeline?

    If yes, can you please provide the source and the sink details?

    Based on the above scenario, it seems that there is an integration run time involved and in case of a copy activity, it is a need that the server on which the IR is set up should be able to access both the source and sink.

    So you might need to allow connectivity to Azure database from the server either via opening the Ports or IP whitelisting etc.

    This would depend on the details which you provide as the above scenario which I mentioned is only for Copy activity with IR involved

  2. Lokesh 211 Reputation points
    2021-11-17T05:13:15.007+00:00

    Could anyone from Microsoft help us with the above issue?

    0 comments

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.