User Profile
AzureBrian
Brass Contributor
Joined 6 years ago
User Widgets
Recent Discussions
Update Management not installing SQL Server Service Pack
Greetings. I’m using Azure Update Management for patching my VMs. This works well most of the time, but I’ve noticed it doesn’t seem to recognize SQL Server service packs that need to be installed. If I use the pswindowsupdate module to query for available updates on the VM manually, I see the service pack available. My deployment schedule is set to include service packs and all update categories except for “tools”. Anyone else running into similar issues or have suggestions? Thanks in advance for any help. BrianGuest user access to SSAS cube on Azure VM
Greetings. I need to allow users outside of our Azure AD tenant the ability to access a multidimensional SSAS cube that resides on an Azure VM. It doesn't reside in Azure SQL Database or Azure Analysis Services. We have Microsoft SQL Server 2019 installed on an Azure VM and are providing access to the cube via a URL pointing to the msmdpump.dll. I have also created a group, assigned the proper read permissions via SSAS cube security, and added a non-guest user to that group. Everything works as expected for that user, and it is able to access the cube successfully. However, I have invited an outside user to our Azure AD tenant as a Guest user. The user has accepted the invitation and I have added the user to the same group as the test user in Azure AD. Each time the user uses Excel to attempt to connect to the cube in question, he sees this error: I've even set the Guest user access setting under External collaboration settings to Guest users have the same access as members (most inclusive). Yet, I cannot seem to find what is needed to allow the guest user access. Is there a restriction on this access such that Guest users can't read data from a cube in this way? Any information or documentation would be most appreciated. Thanks in advance! BrianInvalid Managed Identity when running Vulnerability Assessment on Azure SQL Database
Greetings. I'm hoping someone can shed some light on how to resolve an error I'm getting when running a scan on my Azure SQL Database from within the Azure portal. I'm getting this line of output in the scan history: However, I cannot find a managed identity for this functionality. Maybe that's part of the problem, but I don't remember seeing one before either. I guess what I'm struggling with most is where the managed identity would be set as I don't see any place in the UI to set this from Defender for Cloud's point-of-view. I'm assuming the issue is with it writing the results to the storage account, yet the storage account settings appear to be configured correctly and allow Azure services to access. Any thoughts on where to look to further triage this? Any feedback would be most appreciated. Thanks in advance BrianInvalid Template Deployment
Greetings. I've been trying to deploy some variation of an N-series Spot VM over the past couple or three days. However, I can never get past the validation stage. I've tried doing so using a VM Scale Set via an ARM template as well as just a single VM via the portal. As this link suggests, I've tried using the az vm list-skus --location eastus2 --size Standard_N --output table command to check availability. I see that there are some available: ResourceType Locations Name Zones Restrictions --------------- ----------- ----------------- ------- -------------- virtualMachines eastus2 Standard_NV6s_v2 3 None virtualMachines eastus2 Standard_NV12s_v2 3 None virtualMachines eastus2 Standard_NV24s_v2 3 None virtualMachines eastus2 Standard_NV12s_v3 3 None virtualMachines eastus2 Standard_NV24s_v3 3 None virtualMachines eastus2 Standard_NV48s_v3 3 None I've tried different combinations of VM sizes and regions. The constants that I can see are: I'm always requesting a spot VM I'm always using the same subscription (Visual Studio Enterprise) I haven't been able to find any documentation that shows any conflicts with what I'm trying to do. However, I always get this error: { "code": "InvalidTemplateDeployment", "message": "The template deployment failed with error: 'The resource with id: '/subscriptions/<subscriptionid>/resourceGroups/FoldingAtHomeRG/providers/Microsoft.Compute/virtualMachines/foldingAtHomeWorker' failed validation with message: 'The requested size for resource '/subscriptions/<subscriptionid>/resourceGroups/FoldingAtHomeRG/providers/Microsoft.Compute/virtualMachines/foldingAtHomeWorker' is currently not available in location 'eastus2' zones '3' for subscription '<subscriptionid>'. Please try another size or deploy to a different location or zones. See https://aka.ms/azureskunotavailable for details.'.'." } Anyone seen this before or have any advice to offer? Any would be appreciated. Thanks. Brian
