{"action":"created","issue":{"url":"https://api.github.com/repos/Microsoft/vsts-tasks/issues/5820","repository_url":"https://api.github.com/repos/Microsoft/vsts-tasks","labels_url":"https://api.github.com/repos/Microsoft/vsts-tasks/issues/5820/labels{/name}","comments_url":"https://api.github.com/repos/Microsoft/vsts-tasks/issues/5820/comments","events_url":"https://api.github.com/repos/Microsoft/vsts-tasks/issues/5820/events","html_url":"https://github.com/Microsoft/vsts-tasks/issues/5820","id":272723718,"node_id":"MDU6SXNzdWUyNzI3MjM3MTg=","number":5820,"title":"Dacpac deployment with AD authentication","user":{"login":"debashis1982","id":11267855,"node_id":"MDQ6VXNlcjExMjY3ODU1","avatar_url":"https://avatars1.githubusercontent.com/u/11267855?v=4","gravatar_id":"","url":"https://api.github.com/users/debashis1982","html_url":"https://github.com/debashis1982","followers_url":"https://api.github.com/users/debashis1982/followers","following_url":"https://api.github.com/users/debashis1982/following{/other_user}","gists_url":"https://api.github.com/users/debashis1982/gists{/gist_id}","starred_url":"https://api.github.com/users/debashis1982/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/debashis1982/subscriptions","organizations_url":"https://api.github.com/users/debashis1982/orgs","repos_url":"https://api.github.com/users/debashis1982/repos","events_url":"https://api.github.com/users/debashis1982/events{/privacy}","received_events_url":"https://api.github.com/users/debashis1982/received_events","type":"User","site_admin":false},"labels":[{"id":391088230,"node_id":"MDU6TGFiZWwzOTEwODgyMzA=","url":"https://api.github.com/repos/Microsoft/vsts-tasks/labels/Area:%20Release","name":"Area: Release","color":"5319e7","default":false},{"id":154814013,"node_id":"MDU6TGFiZWwxNTQ4MTQwMTM=","url":"https://api.github.com/repos/Microsoft/vsts-tasks/labels/enhancement","name":"enhancement","color":"84b6eb","default":true}],"state":"open","locked":false,"assignee":{"login":"RoopeshNair","id":1370480,"node_id":"MDQ6VXNlcjEzNzA0ODA=","avatar_url":"https://avatars3.githubusercontent.com/u/1370480?v=4","gravatar_id":"","url":"https://api.github.com/users/RoopeshNair","html_url":"https://github.com/RoopeshNair","followers_url":"https://api.github.com/users/RoopeshNair/followers","following_url":"https://api.github.com/users/RoopeshNair/following{/other_user}","gists_url":"https://api.github.com/users/RoopeshNair/gists{/gist_id}","starred_url":"https://api.github.com/users/RoopeshNair/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/RoopeshNair/subscriptions","organizations_url":"https://api.github.com/users/RoopeshNair/orgs","repos_url":"https://api.github.com/users/RoopeshNair/repos","events_url":"https://api.github.com/users/RoopeshNair/events{/privacy}","received_events_url":"https://api.github.com/users/RoopeshNair/received_events","type":"User","site_admin":false},"assignees":[{"login":"RoopeshNair","id":1370480,"node_id":"MDQ6VXNlcjEzNzA0ODA=","avatar_url":"https://avatars3.githubusercontent.com/u/1370480?v=4","gravatar_id":"","url":"https://api.github.com/users/RoopeshNair","html_url":"https://github.com/RoopeshNair","followers_url":"https://api.github.com/users/RoopeshNair/followers","following_url":"https://api.github.com/users/RoopeshNair/following{/other_user}","gists_url":"https://api.github.com/users/RoopeshNair/gists{/gist_id}","starred_url":"https://api.github.com/users/RoopeshNair/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/RoopeshNair/subscriptions","organizations_url":"https://api.github.com/users/RoopeshNair/orgs","repos_url":"https://api.github.com/users/RoopeshNair/repos","events_url":"https://api.github.com/users/RoopeshNair/events{/privacy}","received_events_url":"https://api.github.com/users/RoopeshNair/received_events","type":"User","site_admin":false},{"login":"kmkumaran","id":11780076,"node_id":"MDQ6VXNlcjExNzgwMDc2","avatar_url":"https://avatars2.githubusercontent.com/u/11780076?v=4","gravatar_id":"","url":"https://api.github.com/users/kmkumaran","html_url":"https://github.com/kmkumaran","followers_url":"https://api.github.com/users/kmkumaran/followers","following_url":"https://api.github.com/users/kmkumaran/following{/other_user}","gists_url":"https://api.github.com/users/kmkumaran/gists{/gist_id}","starred_url":"https://api.github.com/users/kmkumaran/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/kmkumaran/subscriptions","organizations_url":"https://api.github.com/users/kmkumaran/orgs","repos_url":"https://api.github.com/users/kmkumaran/repos","events_url":"https://api.github.com/users/kmkumaran/events{/privacy}","received_events_url":"https://api.github.com/users/kmkumaran/received_events","type":"User","site_admin":false},{"login":"RoshanKumarMicrosoft","id":33001640,"node_id":"MDQ6VXNlcjMzMDAxNjQw","avatar_url":"https://avatars3.githubusercontent.com/u/33001640?v=4","gravatar_id":"","url":"https://api.github.com/users/RoshanKumarMicrosoft","html_url":"https://github.com/RoshanKumarMicrosoft","followers_url":"https://api.github.com/users/RoshanKumarMicrosoft/followers","following_url":"https://api.github.com/users/RoshanKumarMicrosoft/following{/other_user}","gists_url":"https://api.github.com/users/RoshanKumarMicrosoft/gists{/gist_id}","starred_url":"https://api.github.com/users/RoshanKumarMicrosoft/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/RoshanKumarMicrosoft/subscriptions","organizations_url":"https://api.github.com/users/RoshanKumarMicrosoft/orgs","repos_url":"https://api.github.com/users/RoshanKumarMicrosoft/repos","events_url":"https://api.github.com/users/RoshanKumarMicrosoft/events{/privacy}","received_events_url":"https://api.github.com/users/RoshanKumarMicrosoft/received_events","type":"User","site_admin":false}],"milestone":null,"comments":5,"created_at":"2017-11-09T21:05:11Z","updated_at":"2018-10-03T05:28:46Z","closed_at":null,"author_association":"NONE","body":"Hi ,\r\n\r\nI have a Azure SQL DB server and a database in it. I am trying to use VSTS' Azure SQL Database Deployment task to deploy a DACPAC file.\r\nLooks like the task uses SQL authentication for executing SQLPackage.exe. Can I use \"Active Directory user with password\" type authentication to deploy the DB? If so, could you please tell me how?\r\n\r\nThanks,\r\nDebashis"},"comment":{"url":"https://api.github.com/repos/Microsoft/vsts-tasks/issues/comments/426516105","html_url":"https://github.com/Microsoft/vsts-tasks/issues/5820#issuecomment-426516105","issue_url":"https://api.github.com/repos/Microsoft/vsts-tasks/issues/5820","id":426516105,"node_id":"MDEyOklzc3VlQ29tbWVudDQyNjUxNjEwNQ==","user":{"login":"Ajay-MS","id":16772764,"node_id":"MDQ6VXNlcjE2NzcyNzY0","avatar_url":"https://avatars2.githubusercontent.com/u/16772764?v=4","gravatar_id":"","url":"https://api.github.com/users/Ajay-MS","html_url":"https://github.com/Ajay-MS","followers_url":"https://api.github.com/users/Ajay-MS/followers","following_url":"https://api.github.com/users/Ajay-MS/following{/other_user}","gists_url":"https://api.github.com/users/Ajay-MS/gists{/gist_id}","starred_url":"https://api.github.com/users/Ajay-MS/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/Ajay-MS/subscriptions","organizations_url":"https://api.github.com/users/Ajay-MS/orgs","repos_url":"https://api.github.com/users/Ajay-MS/repos","events_url":"https://api.github.com/users/Ajay-MS/events{/privacy}","received_events_url":"https://api.github.com/users/Ajay-MS/received_events","type":"User","site_admin":false},"created_at":"2018-10-03T05:28:46Z","updated_at":"2018-10-03T05:28:46Z","author_association":"CONTRIBUTOR","body":"@govanikunal \r\n\r\nIt's still pending. \r\n\r\nFor AAD authentication, please refer below documentation:\r\n[Connect to Azure SQL Database by obtaining a token from Azure Active Directory](https://blogs.technet.microsoft.com/stefan_stranger/2018/06/06/connect-to-azure-sql-database-by-obtaining-a-token-from-azure-active-directory-aad/) \r\n\r\nYou can execute the script from this documentation using Azure PS/PS task. \r\n\r\nI hope this would be helpful. \r\n"}}
{"actor":{"display_login":"Ajay-MS"}}