Adding & Removing SQL Features via Command
This is a quick guide on how to add and remove features from SQL Server via command, following the theme of recent posts.
Tech Blog – Home
Install/Uninstall SQL Server via Command
This is a post on installing SQL Server via command; I have a Windows Server 2016 Core running on a local Hyper-V test environment, and I’m installing SQL Server 2019, then uninstalling it.
Configuring Windows Server Core
Windows Server Core is the CLI only version of the Windows OS. This post is a run-through of configuring a new Windows Server 2016 Core host, detailed in the following steps;
Joining a Windows Host to a Domain
A run-through of joining a Windows Server onto a test domain which created in my previous post. There’s 2 parts to this one;# Creating a New Domain User Account.# Joining a Windows Server to a Domain.
Installing Active Directory on Windows Server 2016
This is a run-through on installing Active Directory within a Hyper-V test environment. There’s 5 parts to this one: # Create a Hyper-V Private Network.# Configure Windows TCP/IP Settings.# Rename the Windows Server Host.# Install Active Directory.# Promote the Server to a Domain Controller.
Installing Windows Server 2016 with Hyper-V
This is a simple guide on installing Windows Server 2016 with Hyper-V. There are two parts to this one.. # Create a new Hyper-V Virtual Machine.# Install Windows Server 2016.
“Windows could not start the SQL Server”
The “Windows could not start the SQL Server on 127.0.0.1” is a generic error message when the SQL Server service cannot start-up.
“Index was out of range” SQL Server Management Studio
I’ve seen this Index was out of range error within SQL Server Management Studio (SSMS) when trying to change the order of Agent Jobs.
