locked
Use the microsoft sql connector and use windows auth instead of sql auth RRS feed

  • Question

  • From @CBovalina Corey Bovalina via Twitter
     
    is it possible to use the microsoft sql connector and use windows auth instead of sql auth?
    Reviewed http://aka.ms/d947343 but I don't think this helps. When setting up the sql connector in the new azure portal it asks for a username and password but it uses sql with with no option to switch to Windows auth for onprem connections.

    Over DM
     
    Thanks,
    @AzureSupport
    Tuesday, February 9, 2016 2:51 PM

Answers

All replies

  • This is for an OnPrem sql database that we are using a hybrid connection to use the with logic apps.
    Tuesday, February 9, 2016 8:45 PM
  • The portal experience is optimized for Azure VMs, which typically use SQL Logins.

    As a work around, you can follow the steps here to install the connector and configure access to Azure Key Vault - https://msdn.microsoft.com/en-us/library/dn198405.aspx. Nothing in here requires SQL Logins for connecting to SQL.


    This posting is provided "AS IS" with no warranties, and confers no rights.

    Friday, February 12, 2016 5:44 PM