Can't see SQL Databases using ARC box for it Pros

[carloslone]

Note: For ease of issues and pull requests management and tracking, we kindly ask you to provide a meaningful and concise title to this issue and answer all questions to the best of your ability.

Is your issue related to a Jumpstart scenario, ArcBox, HCIBox, or Agora? ArcBox

Describe the issue or the bug after deploying al the infrastructure, when selecting ARCbox SQL machine, and then select databases the databases available in the sql instance are not showing up.

To Reproduce

1. Go to Arcbox SQL VM
2. Click on sql configuration and select Arcbox-sql
3. Scroll down to Databases
4. No databases displayed

Expected behavior get the list of the available databases of the sql instance

Environment summary I have tried deploying with both Developer and Enterprise edition for the SQL Database Edition. The same error happens

Screenshots

[janegilring]

Hi @carloslone ,

Could you share the logs under C:\ArcBox\Logs ?

When we get those we can have a look at what might have happened to the databases.

[janegilring]

@carloslone Any updates from your side?

[carloslone]

LogsBundle-1rpw0z.zip

Find the information attached. Just redeployed the IT pro Jumpstart ArcBox

[janegilring]

@carloslone Thank you. Looking at the log-files I did not see any errors in the section which configured the SQL VM.

Could you open Hyper-V Manager, connect to the ArcBox-SQL VM, open SQL Management Studio from the desktop and check if you can see these databases?

Based on the outcome, we can check whether to troubleshoot on the SQL- or the Arc-side of things.

[carloslone]

Databases are there, the problem is that dbs are not reflecting on the Azure Portal as the image shared previously.

[janegilring]

@carloslone Thanks. It turns out there might be issues on the portal-side. Could you try this Azure Resource Graph Query?

resources
| where type =~ 'Microsoft.AzureArcData/sqlServerInstances/databases'
| project name, id

alternatively this Azure PowerShell command:

Get-AzResource -ResourceType "Microsoft.AzureArcData/sqlServerInstances/databases" | Select-Object Name, ResourceGroupName, Location

[janegilring]

@carloslone Closing this one after our Teams-conversation where you confirmed the databases is showing via ARG/PowerShell. In addition, they have started to show in the portal - so likely something has changed on the service-side or the portal-side.