How to assign User Connect Permissions to Azure DB[pastacode lang=”sql” manual=”CREATE%20USER%20%5Bemail%40domain.com%5D%20FROM%20EXTERNAL%20PROVIDER%3B” message=”” highlight=”” provider=”manual”/]How to find current Roles assigned to Azure DB[pastacode lang=”sql” manual=”SELECT%20DISTINCT%20pr.principal_id%2C%20pr.name%2C%20pr.type_desc%2C%20%0A%20%20%20%20pr.authentication_type_desc%2C%20pe.state_desc%2C%20pe.permission_name%0AFROM%20sys.database_principals%20AS%20pr%0AJOIN%20sys.database_permissions%20AS%20pe%0A%20%20%20%20ON%20pe.grantee_principal_id%20%3D%20pr.principal_id%3B” message=”” highlight=”” provider=”manual”/]How […]
Category: Azure
Azure Files Robocopy Error Access Denied when copying NTFS Permissions
Azure Files Currently does not have “Take Ownership” permission on the file share using Domain Auth So if robocopy requires setting the owner, it will fail with access […]
How to get IP Restrictions working behind Azure Waf V1
Unlike WAF v2 , the v1 product does not have custom rules for blocking IP , so you will need to do this at the IIS Level […]
How to report on current Azure MFA registrations in your organisation
Login to Azure Active Directory. Locate Usage & insights , under MonitoringSelect “Users registerd for Multi-Factor Authentication” Can also be done in powershell : https://dirteam.com/sander/2020/05/14/todo-optimize-the-azure-multi-factor-authentication-methods-used-throughout-your-organization/https://www.cyberdrain.com/monitoring-with-powershell-monitoring-the-used-mfa-type-for-o365-azure/
InTune – Copy file using PowerShell to the computer from an Azure Blob location
I set a 100 Year Expiry , and leave access as Read Only It will give you URI and query string Copy the URI ONLY up to […]
How to create NAT rules in a Azure Resource Manager
If you are looking to Migrate a classic VM in Azure to ARM , you will need to change your Endpoint port forwards via a Load BalancerGo to […]
Prerequisites for Microsoft Azure Planning Toolkit
Server to install MAP onto ( this will install a SQL instance as well ). This server will need to be on constantly for 7 daysV-Mware Login […]
Azure Multi-Factor Authentication Server Error
Error that determining the Current Master Multi-Factor Authentication Server. the user interface will closeThings to check Make sure the server can access via IEhttps://pfd.phonefactor.nethttps://pfd2.phonefactor.nethttps://css.phonefactor.net2. Make sure you have […]
Script to Provision Azure Setup for Small to Medium Business
https://itnetxbe.github.io/SMBblueprint-Docs/azure-install/ That reduces our implementation effort, which will in turn reduce the overall costs to the client.