Installing SQL Server 2022 Developer Edition

It is finally out!  SQL Server 2022 was released on 11/16/2022 and there are a bunch of new features and enhancements.  Today we are going to install the developer edition so you can see the new install screens. Lots of screenshots today!

First thing you need to do is to go to Microsoft’s site and initiate the download.  Here is the link I used:  https://www.microsoft.com/en-us/sql-server/sql-server-downloads

That brings you to the screen below.  Click the download now button under developer to get the correct version.  The Developer edition is the full blown Enterprise version, but can only use for development or testing and cannot be used for production workloads!

This downloads a 4 meg installer file. Click to run it.

After double clicking this screen pops up, I click “Download Media” to download the ISO.

It then asks you what format you want to get the download file in.  I choose ISO and pick a location to save the file to.

Now it is downloading the ISO.

Now we finally have the ISO.

After you press close, confirm you want to exit.

Now find the download in the location you specified to save it at.

Double clicking the ISO should mount it and show you contents of the ISO.  Double click the “setup” file.

This opens the SQL Server Installation Center.  This should look familiar to anyone that has installed the database before. 

Pick the New SQL Server standalone installation option.

Next, select Developer for what version to install. There is also a pay as you go version which is new for 2022 and looks interesting for a small business, but we do not need to concern ourselves with it.

Now you need to accept the license.  Feel free to read it, I’ll wait.

For today’s installation, I am only going to install the database engine.  Looking below, you can see all of the new items that have been added to the install process.

I already have two SQL Server instances installed on this server, so for any additional installs I need to create a Named Instance.  I pick: SQL2022 for the name.  Remember this as you need it to connect to it.

Now you need to pick the service accounts that will be used for the services.  In a production environment I use Active Directory accounts, but for this install, I will just use the defaults.  By using Active Directory accounts, you can save backups to a UNC path  (\\backupserver\backups) and other cases like Log Shipping and Availability Groups this is required.

Next we need to decide on an Authentication Mode.  Using Windows authentication is the preferred way, but some legacy applications still need Mixed Mode to run.  You can change this after installing if you “choose poorly”, but it requires a restart of the service.

On the Data Directories tab you specify where the default locations for the databases should go to.

On the Temp DB tab we can leave it as the defaults.

During the install it is asking what MaxDOP we should use.  This was a new option in 2019 and continues in 2022. To read more about what you should set this at, please follow this link: https://learn.microsoft.com/en-us/sql/database-engine/configure-windows/configure-the-max-degree-of-parallelism-server-configuration-option?view=sql-server-ver16

The Memory tab was also a new addition in 2019 and continues in 2022. It now asks you what percentage of RAM you should allocate for this SQL Server instance.  There are plenty of formulas out there, but for this install and my server having limited resources, I choose to only use 11gigs or what the setup is recommending.

In previous versions before this new screen, most people would not change this value and have all kinds of swapping problems with the OS because SQL Server would default to using all of the RAM on the server.

Finally we get to the summary screen.  Press Install to start.

The install time depends on how fast your disks are and what other activity is happening on the server and what options you choose.

Finally the install is done and it is requesting a reboot.

After rebooting, you can see all of the new entries for SQL Server 2022.

Let us see if we can login to our new instance.  I have to specify the instance name SQL2022 since we have multiple versions of SQL Server installed already. NOPE, I receive the error below.

I cannot get to the server, let us check the network configuration. Open up the SQL Server 2022 Configuration Manager.

Now click the SQL Server Network Configuration on the left side. Choose the SQL2022 instance that we just installed. On the right side double click the TCP/IP that shows disabled.

Change the Enabled to YES and press Apply.

It is warning that we need to restart the instance so the settings take effect.

In the Sql Server Configuration Manager, click SQL Server Services on the left side. on the right side right click the SQL2022 name and restart the service.

After the service restarts we try to connect again.

Yay, we can connect!  Looking at the properties we see that the Developer edition is installed.

Running the @@version query shows additional information.

And there you have it.  The install process is similar to previous versions, but there are some new beneficial prompts that have to be answered.

Now you can restore a database and look at all of the new options and start checking out all of the new features.

If you want to see how I did the install of SQL Server 2019 Developer edition, here is my link: Installing SQL Server 2019 Developer Edition