Create new AD Object , then Enable it for Remote Mailbox After this make sure you change the SMTP Address as it will create it with the […]
Tag: Azure
Cannot login to Windows 10 PC thats joined to Azure Active Directory Services – Remote Desktop – RDP – Azure AD
fdsfsddfssdf Issue : Login is denied with the following error Subject:Security ID: NULL SIDAccount Name: -Account Domain: -Logon ID: 0x0Logon Type: 3Account For Which Logon Failed:Security ID: […]
Azure SQL Profiler – In order to run a trace against SQL Server you must be a member of sysadmin
You are not allowed to run a trace against Azure SQL Database. To do query profiling on Azure SQL, you can use Dynamic Management Views or take a look at the Azure SQL […]
Azure SQL export
Recently I was trying to Export a Azure database to a bacpac file , however SQL Management Studio gave the following error——————————One or more unsupported elements were […]
Add User to Azure SQL DB and Assign permissions
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 […]
How to register azure site recovery agent with powershell cli
This is useful for when you have a hyper v host only nope with CLI and no GUIDRConfigurator.exe /r /friendlyname MyServerName /credentials “C:\Software\vaultname_asr_DayMonthDateYear.VaultCredentials”
How to upload VHDX\VHD to Azure and use it for an Azure VM
PreReq’sYou need to have the HyperV Role installed on the server if you want to convert VHDX -> VHD , Azure only support VHDYou need to create […]
Azure – Couldn’t add a Azure Vnet to Application Gateway and Virtual network gateways
Recently after creating a site with Virtual Machines sitting on a Vnet on the application Gateway , I could not add this subnet to be routable from […]
Could not activate Windows License on server in Azure
Recently we had moved some onpremise Server 2016 machines to Azure using ASR. When trying to activate them using the Microsoft stepscscript c:\windows\system32\slmgr.vbs /dlvcscript c:\windows\system32\slmgr.vbs /ipk WC2BQ-8NRM3-FDDYY-2BFGV-KHKQYcscript […]
Log analytics query for Azure WAF Web Application Firewall to Check URI’s and blocking rule ID’s
How to Track HTTP Status 504 Track Azure WAF 949110 You need to use the TransactionID_g of a blocked Result which will then give you what leads […]
Cannot change Azure SQL Virtual Machines from Express to Developer
I got deployment failed when trying to change a SQL servers License from Express to Developer.I checked the Server and it had developer license installed on SQLLooking […]
App Proxy Settings for PasswordState
Enter internal URL , will be presented external URL