I recently set up an internal VM for a dev environment, using Windows Azure. For simplicity, I set the server name and the account username (administrator) exactly the same. I named them both the same, e.g. ‘ServerApp1’. The installation of the VM worked perfectly fine. I only experienced an issue when trying to install SQL Server 2008 R2 Enterprise. The Database Engine, Analysis & Reporting Services would not install, and the error message (Username ” could not be found) was not very helpful! However, I googled the message and managed to find a SQL forum where someone suggested that SQL Server does not install properly when the administrator username and VM machine name are the same.
As a result of the above, I had to go into Control Panel and physically change the username for the Admin account. Unfortunately, once a username and VM name are specified in Azure, YOU CANNOT CHANGE IT. Or at least I could not find a way. I would strongly recommend that when setting up a VM, always ensure the admin username differs from the machine name. For example, I changed the username to something different, e.g. ‘ServerApp1Admin’. Afterwards, I re-installed SQL Server 2008 R2 and all components installed correctly.
I am not 100% sure if this is just an isolated problem with SQL Server 2008 R2, but it would be best to assume that all versions would cause the same issue.
Introduction to Data Wrangler in Microsoft Fabric
What is Data Wrangler? A key selling point of Microsoft Fabric is the Data Science
Jul
Autogen Power BI Model in Tabular Editor
In the realm of business intelligence, Power BI has emerged as a powerful tool for
Jul
Microsoft Healthcare Accelerator for Fabric
Microsoft released the Healthcare Data Solutions in Microsoft Fabric in Q1 2024. It was introduced
Jul
Unlock the Power of Colour: Make Your Power BI Reports Pop
Colour is a powerful visual tool that can enhance the appeal and readability of your
Jul
Python vs. PySpark: Navigating Data Analytics in Databricks – Part 2
Part 2: Exploring Advanced Functionalities in Databricks Welcome back to our Databricks journey! In this
May
GPT-4 with Vision vs Custom Vision in Anomaly Detection
Businesses today are generating data at an unprecedented rate. Automated processing of data is essential
May
Exploring DALL·E Capabilities
What is DALL·E? DALL·E is text-to-image generation system developed by OpenAI using deep learning methodologies.
May
Using Copilot Studio to Develop a HR Policy Bot
The next addition to Microsoft’s generative AI and large language model tools is Microsoft Copilot
Apr