SQL Server 2012 Developer Edition no longer exists. However, you can download and install the SQL Server 2022 Developer version. SQL Server 2022 Developer Edition is a great product for developers who wish to create and test database applications. It has all the features of Enterprise Edition but is meant for development and testing only.
Table of Content
Pre-requisites of Installing SQL Server 2022:
1. Recommended Hardware Requirements:
- Processor: 2.0 GHz or faster 64-bit processor.
- Memory (RAM): At least 4 GB.
- Hard Disk Space: 6 GB of free space.
2. Additional Considerations:
- Solid State Drive (SSD): Use SSDs for better I/O performance, especially for high-transaction databases.
- TempDB Configuration: Optimize TempDB configuration for performance. Consider placing TempDB on a separate drive.
- Network: A fast and reliable network connection is important, especially in distributed environments.
We will be downloading the following software and will guide you step-by-step through the process:
- SQL Server
- SSMS (SQL Server Management Studio)
Let’s get started!
Download Microsoft SQL Server
Step 1: You need to go to the official site of Microsoft SQL Server and scroll down to the developer option. It is a full-featured free and licensed edition for development and testing database in a non-production environment.
Step 2: Now click on the ‘Download now’.
After downloading, you will see this setup file in your downloads folder.
Step 3: After that, click on setup and then install the software in your system. The installation process of SQL Server gets started.
Installing SQL Server
Step 1: During the installation process, you have to select the installation type.
There will be three types of installation types, and you will have to select the custom installation type for the installation of the SQL Server database engine, which has the default configuration feature.
You can take reference from the below image:
Step 2: After that, you will be prompted to choose a location. We recommend not changing the default download file location. Simply confirm and click ‘Install’.
Make sure there is enough space in the default location.
Step 3: You will see the installation package for SQL Server is getting loaded.
Step 4: Once the process is completed, the SǪL Server Installation Center window will open automatically. You have to select the Installation option from the left panel.
Step 5: Once you have clicked on the Installation option, you will see the below-given page on your screen.
Click on the New SQL Server Stand-alone installation or add features to an existing installation option.
Step 6: Select Developer under “Specify a free edition” and proceed to select “Next.”
Step 7: After that, you will get the Microsoft SQL Server license terms, where you have to click on the Accept option to proceed further with the installation process.
Step 8: On the next page, you will see a dialogue box. Check that dialogue box and click on the Next option.
Step 9: Now, let the operation be completed. Don’t worry about the warning. Simply click on Next once prompted.
Step 10: Uncheck “Azure Extension for SQL Server” and click on “Next.”.
Step 11: Select “Database Engine Services,” “SQL Server Replication,” and the “Machine Learning” feature under instance features. Select “Next” and Do not select any other features which may require additional packages
Step 12: Now you will have to fill in the Named Instance and InstanceID options, and it should be the same name as displayed in the below image. Click on Next.
Step 13: Now, change the Startup type of the SQL server database engine, SQL Server LaunchPad, and SQL server browse to Automatic. You can take a reference from the below image.
Click on Next.
Now you will see the below-given page on your screen.
Step 14: Click on the Mixed Mode option.
Step 15: Now, you need to enter a password.
Let’s give the Password: 1234
Confirm Password: 1234
Then click on Add Current User
Now, you will be able to see Specify SQL Server administrators. Click on Next.
Step 16: Then click on Install.
After that, it will load the screen and wait until it gets installed.
Step 17: As now, you will see the process has been completed; now click on the Close option.
Now, we will begin with the installation of SQL Server Management Studio (SSMS).
Download SSMS
After the installation of the SQL Server is successfully completed, on the same screen you will get an option for downloading SSMS.
Step 1: Click on the install SSMS button, and then it will redirect you to the SSMS download link.
Step 2: After that, scroll down and click on the first link available to download SSMS.
Take reference from the below image.
Step 3: Now click on the download folder to open the downloaded file.
You can take a reference from the below screenshot.
Installing the SSMS Setup file:
Step 1: Click on Install.
Step 2: Please wait until the screen loads.
Step 3: Now you will see the setup completed for Microsoft SQL Server Management Studio.
Then click on the Close option.
After that, close all the applications that you have opened.
Step 4: Now you have to click in the search box of your windows.
Next, type SSMS in the search box.
Step 5: Now, let the Microsoft SQL Server Management Studio screen load.
Step 6: Now you will see the below-given screen. Click on the Connect option.
Step 7: After connecting, you can see the below interface.
Step 8: Click on the NewQuery option and start writing a query.
Congratulations! You have successfully completed the Microsoft SQL Server and SSMS installation.
Get 100% Hike!
Master Most in Demand Skills Now!