locked
Linked Service changes 'Account selection Method' when deploying using Azure Devops pipeline RRS feed

  • Question

  • Hi,

    I am deploying my pipelines from 'Dev' to 'Prod' environment. I am using the 'arm-template-parameters-definition.json' to get custom parameters for the linked service.

    I have a couple of Linked Services that use Azure Key Vault for storing/fetching the passwords. 

    Now, after deployment to 'Prod', when I check the Linked Service, it has changed from using Azure Key Vault to manual password entering as well as it stops working ( I have to renter the details to make it work again)

    Please help.

    Regards,

    Raj

    Linked Service in Dev

    After deploying to 'Prod', it changes to 


    • Edited by Raj_Hillman Wednesday, May 6, 2020 7:53 AM edited
    Wednesday, May 6, 2020 7:52 AM

All replies

  • Hello Raj_Hillman and thank you for your question.

    We think this may be a side-effect of how you are modifying the ARM template or parameters.

    Before diving into that, could you please confirm that the Key Vault linked service is deployed before deploying the linked service you shared above?

    Wednesday, May 6, 2020 5:34 PM
  • Hi Martin,

    Thanks for helping. I am really stuck and struggling with this issue.

    I am deploying to a blank ADF with only the integration Runtimes setup (shared from another ADF).

    All the Linked services, dataset, pipelines  are being generated from the template by the Devops release pipeline.

    " the Key Vault linked service is deployed before deploying the linked service "...its a fresh deployment to a new ADF ...so its doesn't have any LS setup beforehand...evaerthing is being deployed in one go (except IR)

    Key Vault is already setup with access granted to the new ADF.

    please let me know what else if you need more info.

    Regards,

    Raj


    • Edited by Raj_Hillman Wednesday, May 6, 2020 7:53 PM edited
    Wednesday, May 6, 2020 7:28 PM
  • {
       "Microsoft.DataFactory/factories/pipelines":{},
       "Microsoft.DataFactory/factories/integrationRuntimes":{},
       "Microsoft.DataFactory/factories/triggers":{},
       "Microsoft.DataFactory/factories/linkedServices":{
          "AzureSqlDW":{
             "properties":{
                "typeProperties":{
                   "password":{
                      "store":{
                         "referenceName":"-:-kv_name:string"
                      },
                      "secretName":"-:-secret_name:string"
                   }
                }
             }
          },
          "AzureKeyVault":{
             "properties":{
                "typeProperties":{
                   "baseUrl":"-:-prod_kv_url:string"
                }
             }
          },
          "AzureBlobStorage":{
             "properties":{
                "typeProperties":{
                   "accountKey":{
                      "store":{
                         "referenceName":"-:-kv_name"
                      },
                      "secretName":"-:-secret_name:string"
                   }
                }
             }
          }
       },
       "Microsoft.DataFactory/factories/datasets":{}
    }
    This is the 'arm-template-parameters-definition.json' that I am using during deploying. I am trying to parameterize the key-vault secret and LS name for different linked services.
    Thursday, May 7, 2020 3:55 AM
  • My apologies for missing this thread.  If you are still facing this issue, please open as a new thread in Q&A.

    The following forum(s) are migrating to a new home on Microsoft Q&A: All English Microsoft Azure forums!

    Ask new questions on Microsoft Q&A.
    Interact with existing posts until June 10, 2020, after which content will be closed to all new and existing posts.

    Tuesday, June 9, 2020 12:36 AM