question

AvireniUpendar-3214 avatar image
0 Votes"
AvireniUpendar-3214 asked tbgangav-MSFT commented

How to connect to an on-premise SQL Server from Azure Powershell runbook?

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

azure-automation
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

learn2skills avatar image
0 Votes"
learn2skills answered tbgangav-MSFT commented

Hi @AvireniUpendar-3214

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.


· 4
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

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.

0 Votes 0 ·

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

1 Vote 1 ·

98875-capture.jpg


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.

0 Votes 0 ·
capture.jpg (71.1 KiB)
Show more comments