This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(204.8, 72%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAU%3C/text%3E%3C/svg%3E)
I want to export SQL Server 2016 query output into Azure blob storage account. Part of this I need to establish connection between our company SQL Server 2016 in an Azure Powershell runbook.
Could anyone suggest on how can I achieve this?
Thanks,
Upendar
Hi anonymous user
It will help your question, refer to the below url
https://model-technology.com/blog/azure-automation-runbook-to-interact-with-on-prem-sql-via-hybrid-runbook-worker/
If the Answer is helpful, please click Accept Answer and up-vote, this can be beneficial to other community members.
Hi learn2skills,
Thanks for quick reply.
I'm able to login Azure automation account as per step1. but not sure how to proceed on step2.
Please guide me in detail please.
Step 2 of this guide is the installation of an on-premises SQL server. If you already running an on-premises SQL server you can skip the first part.
The important part in step 2 is to create a SQL login with "enforce password policy” box unchecked. This user will be used later to connect to the SQL server by Azure Automation.
(If the reply was helpful please don't forget to upvote and/or accept as answer, thank you)
Regards
Andreas Baumgarten
![98875-capture.jpg][1] [1]: /api/attachments/98875-capture.jpg?platform=QnA Hi, PFA jpg, I have imported the runbook from the Runbook Gallery for Windows Hybrid Runbook Worker. I'm able to provide mandatory values like resource group, account name, createLA as true, createvm as true, registerHW as true, while I don't know how to get the location (The location for the Log Analytics workspace.). Could you please advice on how to get it.
Hi anonymous user,
The description is provided incorrectly in this document i.e., for Location parameter, description should be as "The Location of the automation account in which the script is executed." but not "The location for the Log Analytics workspace." so I have verified and updated the document as required. The change should reflect in some time i.e., at the most in less than 24 hours.
So, based on the correct description, Location parameter is for providing location of your Automation account in which the script is executed. Hope this clarifies. Let me know if you have further queries.