search

microsoft / azure_arc

Automated Azure Arc, Edge, and Platform environments
https://aka.ms/ArcJumpstart
Creative Commons Attribution 4.0 International
744 stars 550 forks source link

Small problems with arc-enabled SQL Server installation #936

Closed sdt-msft closed 2 years ago

sdt-msft commented 2 years ago

Scenario which you are working on A link to the Jumpstart scenario you are working on. azure_arc_sqlsrv_jumpstart (SQL server in a VM) https://azurearcjumpstart.io/azure_arc_jumpstart/azure_arc_sqlsrv/azure/azure_arm_template_winsrv/

Describe the bug A clear and concise description of what the bug is. I found that to run the Arc-conctrolled SQL Server in a VM you have to also enable at the Subscription level the registration to the Microsoft.HybridCompute provider. This is not mentioned in the setup instructions and blocks installation. Also the automated installation of the Microsoft Monitoring Agent is wrong; the right way to fix/setup is in Azure Portal under machine_name (where SQL Server bits are installed)->"Server - AzureArc"->Extensions you need to install "WindowsAgent.SqlServer" and "MicrosoftMonitoringAgent" extensions.

To Reproduce Steps to reproduce the behavior: The basic procedure described at https://azurearcjumpstart.io/azure_arc_jumpstart/azure_arc_sqlsrv/azure/azure_arm_template_winsrv/ does not work unless actions above are taken.

Expected behavior A clear and concise description of what you expected to happen.

Screenshots If applicable, add screenshots to help explain your problem.

Additional context Add any other context about the problem here.

github-actions[bot] commented 2 years ago

This issue has been automatically marked as stale because it has been open 21 days with no activity. It will be closed in 5 days if no further activity occurs.