SQL Server 2022 on Windows Server 2022 Core Edition

Today I’m going to install SQL Server 2022 on Windows Server 2022 Core Azure Edition. In a previous blog I installed ADDS on Windows Server Core edition.

Part 1: Install and configure ADDS on Windows Server Core in Azure
Part 2: Install and configure ADDS on Windows Server Core in Azure

I have done a large number of SQL server implementations in recent years, both in on-prem datacenter and in Azure (IaaS). Now that SQL 2022 is available, I’ve taken a look at the differences compared to previous versions. Installing on Windows Server Core edition is also supported, so I take that scenario as a starting point.

Basic Infrastructure

As a basis, it is of course important that an Active Directory environment is available. In my demo environment I ran a domain controller in Azure based on Windows Server 2022 Azure Edition. This server provides the other servers with DNS. The domain is called ‘demo.lab’.

Continue reading “SQL Server 2022 on Windows Server 2022 Core Edition”

How to check what features are installed on your SQL environment

When you need to know more information about your SQL environment or cluster, you can check every SQL server separate from each other. This is time consuming to do, definitely if you have a big SQL cluster or environment.

You can use also automate this steps, to use this very simple command!

Go to your SQL environment and browse to the following directory (it depends per SQL version)
* SQL Server 2012 (110)
* SQL Server 2014 (120)
* SQL Server 2016 (130)
* SQL Server 2017 (140)
* SQL Server 2019 (150)
’%programfiles%\Microsoft SQL Server\110\Setup Bootstrap\SQL2012” from the command prompt. Run the command:
’setup.exe /ACTION=RunDiscovery’

By default, there will be created a new file called ‘Summary.txt’, with the configuration of your SQL environment, cluster or AOAG if you’re using Always-On Availability Groups.. Not very usefull and readable. Not very readable, so now Powershell comes in!

Start Powershell and run the following command:
Get-Content “<location of your summary.txt file>. Now you get a report!!

2021-02-26_10h06_15   2021-02-26_10h07_262021-02-26_10h07_50   2021-02-26_10h09_15