Forum Widgets
Latest Discussions
Microsoft Entra /Azure Connect Reinstallation and Source Anchor Change
Hello everyone, I would like to talk about the possibility of changing the SourceAnchor in Azure Connect. Officially, this is not supported by Microsoft, but there is still a way to do this via a few detours. the running AD Sync must be stopped first of all. to make the changeover, all users must first be soft-deleted. The most practical way to do this is to synchronize an OU in which there are no users. Now the Entra objects are stored under deleted It is important to note that before restoring the users who do not have an Exchange Online mailbox, Entra P1 or 2 must be removed so that a second mailbox is not created here. Now all users must be restored. After this has been done, the Immutable id of the users must be removed via PowerShell. This is possible with the following command: Get-MsolUser -all | Set-MsolUser -ImmutableID "$Null" (If this command is required for individual users, replace -all with -userpricipalname "example@email,de") If the Immutable Id has been removed for all users, the status in Entra must be set to Cloud Only. If this is the case, you can start with the next steps. It is important to note that the actions carried out above can lead to short-term failures and should therefore ideally be carried out before the weekend! In the next step, a clean uninstallation of Azure Connect must be carried out. Here I would recommend the article ADsync uninstallation from MSXFAQ where it is well explained. When uninstalling, only the steps that do not hinder a new installation should be carried out, but this is well explained in the article. after successfully uninstalling the AD Sync, there may be delays, which is why I would recommend waiting 24 hours before reinstalling. The waiting time can be skipped, but it still worked for me. as soon as you have installed the AD Sync with the new desired attribute, you can start the sync. The users should now be matched with the existing cloud objects via Softmatch. If this does not work, it is possible to delete the Immutable ID again or to correct the errors via the AD Connect error display of the Entra ID. Under the function other errors, several errors may be displayed, this was fixed by us by fixing all duplicate attribute errors. I hope this has helped you a little. I am always open to feedback!How do I use Azure Data Studio with schemas?
I had thought that a database schema was the name of the structure on which tables are interconnected by primary keys and foreign keys. But in the tool, Azure Data Studio, the user is asked to select from a pre-defined set of schemas when creating a table. What is more is that when setting up or createing a database through Azure, we are given the opportuniityh to use a sample database and this is where "SalesLT" comes from and so there must be some place where we can define a schema with Azure Data Studio. Where would that be? It was generated when deciding to use a demo sample database. So there must be some way, using SQL code or otherwise, to generate a schema.az mysql flexible-server command returns 'flexible-server' is not in 'az mysql' command group in WSL
I recently started scripting with Azure CLI within my Windows Subsystem for Linux (WSL) environment and tried to create a database on an Azure Database for MySQL Flexible-Server instance and received an error 'flexible-server' is not in the 'az mysql' command group. I also tried to list out the flexible-servers in my subscription, but it also give the same error! I tried to see if maybe my Azure CLI was out of date, but it was already at the newest version! As I test, I tried running the command in Microsoft's pre-package Azure CLI Docker container within my WSL Ubuntu environment: (You will need Docker Desktop installed) ~$ docker run -it mcr.microsoft.com/azure-cli Sure enough, it worked just fine! Something is wrong with my installation of Azure CLI within the WSL environment. It is a relatively new install, so possibly Azure CLI did not install completely when setting up WSL… Not matter, I found the instructions for reinstalling Azure CLI here… (https://docs.microsoft.com/en-us/cli/azure/install-azure-cli-linux?pivots=apt) 1) Get packages needed for the install process: ~$ sudo apt-get update ~$ sudo apt-get install ca-certificates curl apt-transport-https lsb-release gnupg 2) Download and install the Microsoft signing key: ~$ curl -sL https://packages.microsoft.com/keys/microsoft.asc | gpg --dearmor | ~$ sudo tee /etc/apt/trusted.gpg.d/microsoft.gpg > /dev/null 3) Add the Azure CLI software repository: ~$ AZ_REPO=$(lsb_release -cs) ~$ echo"deb [arch=amd64] https://packages.microsoft.com/repos/azure-cli/ $AZ_REPOmain"| sudo tee /etc/apt/sources.list.d/azure-cli.list Note: This step did not work as expected in the WSL Ubuntu environment, lsb_release doesn't return any information, so you have to set AZ_REPO environment variable manually: ~$ cat /etc/*release Look for VERSION_CODENAME, or UBUNTU_CODENAME, which in our case is focal Now you can continue with the rest of the command ~$ AZ_REPO=focal ~$ echo"deb [arch=amd64] https://packages.microsoft.com/repos/azure-cli/ $AZ_REPOmain"| sudo tee /etc/apt/sources.list.d/azure-cli.list 4) Update repository information and install the azure-cli package: ~$ sudo apt-get update ~$ sudo apt-get install azure-cli The az mysql flexible-server module did not light up right away, I had to restart my Ubuntu WSL session. After that, it works fine!
Azure Insights
I have an Azure VM Running Debian 11, Built using the Azure tools. I am unfortunately having issues with it where it randomly max's CPU + Ram + Disk. I have attempted to install the insights application but i was presented with the below message Is there any way i can get it to work. While we encourage you to enable VM insights, you may be using an OS version (Publisher: debian, Offer: debian-11, Sku: 11-gen2) that is not supported. For more details on supported OS and kernel versions please review our support matrix.
Unable to deploy to Azure Web App because path, file name, or both are too long
Hi, I have recently encountered the following error when I tried to deploy my web app to Azure using Visual Studio Code. "The specified path, file name, or both are too long. The fully qualified file name must be less than 260 characters, and the directory name must be less than 248 characters." I have tried to use Azure CLI to deploy the web app, by following the steps outlined in https://docs.microsoft.com/en-us/azure/app-service/deploy-zip?tabs=cli. However, I am getting the same error. My colleague who is using a Macbook, is able to deploy to the web app to Azure without any issues. I am using Windows 10 Enterprise. Can anyone advise? Thank You
Dynamic dates in Azure Data Factory
Dear Folks I am trying to copy the data from the Azure SQL table to the CSV file in Azure Data Factory. CSV Filename must be appended with below date Filename_11_07 Where Filename --> comes from dynamic content 11 --> month 07 --> current date of last Sunday (Current date is 10th of Nov) Would it be possible to manipulate the dates in dynamic content? Any other way to achieve this? Regards Santosh
Create Function App using arm template
Creating a function app in premium plan requires two app settings: WEBSITE_CONTENTAZUREFILECONNECTIONSTRING WEBSITE_CONTENTSHARE Based on the documentation https://docs.microsoft.com/en-us/azure/azure-functions/functions-app-settingsWhen using an Azure Resource Manager template to create a function app during deployment, don't include WEBSITE_CONTENTSHARE in the template. However, including only WEBSITE_CONTENTAZUREFILECONNECTIONSTRING will cause the deployment error: "Required parameter WEBSITE_CONTENTSHARE is missing".
