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.
How does Terraform work?
Terraform is an Infrastructure as Code (IaC) tool which allows the building, changing and versioning
Oct
Overview of Data Migration Assistant (DMA)
The Data Migration Assistant (DMA) helps you upgrade to a modern data platform by detecting compatibility
Oct
How global supply chains changed throughout the pandemic and what’s the new future?
Covid-19 hits the global supply chain: There have been significant challenges throughout global supply chains
Oct
Cloud Migration
In the past years, organisations have been migrating existing systems and services to the cloud.
Sep
Using Azure Data Studio SQL Notebooks
There are a number of database tools for managing and developing databases and it’s interesting
Sep
How has the travel and transport sector reacted to the Covid-19 crisis?
The Covid-19 pandemic shocked the world. It sent unprecedented ripples of change within numerous sectors
Sep
Databricks for Dummies: An Introduction to Databricks
Databricks is an organisation and industry-leading commercial cloud-based data engineering platform for processing and transforming
Sep
Prepare and pass DP-300 (Administrating relational databases on Microsoft Azure)
Azure Database Administration? An Azure Database Administrator is responsible for implementing, managing, troubleshooting and operating the data
Sep