DataFactory -Linked service using Service account RRS feed

  • Question

  • Hello Experts,

    I already have SQL On premise and Azure DB Linked Service
    SQL On Premise- Use Window Authentication , Names as "LS_mySQLOnprem_DB1"
    Azure DB-         Use SQL Authentication,Names as "LS_mySQLAzure_DB1"

    All of above are working fine to load data.

    Requirement: Now I need to create SQL on Premises Linked service , which use SERVICE ACCOUNT .
    How can I create that, I did not get any reference Link

    What change should  I make in LS_mySQLOnprem_DB1 to create New link service using service account.
    Below is the Code use to create On PREMISES SQL LINKED SERVICE , using Window Authentication

        "name": "ls_mySqlOnPrem_DB1",
        "properties": {
            "description": "",
            "hubName": "myDatafactory_hub",
            "type": "OnPremisesSqlServer",
            "typeProperties": {
                "connectionString": "Data Source=myOnPremServerName;Initial Catalog=myOnPremDBName;Integrated Security=true;",
                "gatewayName": "myDataGateway",
                "userName": "xx",
                "password": "**********"


    • Edited by Rihan8585 Tuesday, November 29, 2016 1:45 PM edited
    Friday, November 18, 2016 5:06 AM