Install MS SQL SERVER 2022 Evaluation Edition

MS SQL SERVER 2022 & VISUAL STUDIO 2022

Lesson-1: Installing MS SQL SERVER 2022 - Evaluation Edition

Lesson 2: How to Install Microsoft SQL Server 2022 Evaluation Edition

Step 1: Download SQL Server 2022 Evaluation Edition

Visit the Official Microsoft Website:
- Go to the Microsoft SQL Server Evaluation Center.
- Scroll down to the “SQL Server 2022” section.
- Click on Download now under “SQL Server 2022 Evaluation.”
Register for the Evaluation:
- You might be required to sign in with your Microsoft account.
- Fill in the necessary details for registration and submit.
Download the Installer:
- Once registered, the download for the SQL Server installer (SQL2022-SSEI-Eval.exe) should start automatically. Save the file to your computer.

Step 2: Run the SQL Server Installer

Launch the Installer:
- Locate the downloaded SQL2022-SSEI-Eval.exe file and double-click to run it.
Select Installation Type:
- You will be prompted to select an installation type:
  - Basic: Quick installation with default settings.
  - Custom: Allows more configuration options.
  - Download Media: Downloads the full setup files for later use.
- For a basic installation, select Basic.
Accept the License Terms:
- Read and accept the license terms by checking the box and then click Accept.
Choose the Installation Location:
- By default, SQL Server will be installed in C:\Program Files\Microsoft SQL Server. You can change the location if desired.
Download and Install:
- The installer will download and install the required files. This process may take several minutes.

Step 3: Configure SQL Server

Instance Configuration:
- You may be prompted to name the SQL Server instance. The default instance name is MSSQLSERVER. You can also choose a named instance.
Server Configuration:
- Choose the authentication mode:
  - Windows Authentication Mode: Only allows Windows users to authenticate.
  - Mixed Mode: Allows both Windows and SQL Server users to authenticate.
- If you select Mixed Mode, you’ll need to create a strong password for the sa (system administrator) account.
Feature Selection:
- Select the SQL Server features you need (e.g., Database Engine Services, SQL Server Replication, etc.).
- By default, the necessary features for a basic SQL Server instance are selected.
Collation Settings:
- You can leave the default collation settings unless you have specific collation requirements.
Set SQL Server Administrators:
- Add users who should have administrative privileges over the SQL Server instance.
Complete Installation:
- Review the summary of the selected options and click Install.
- The installation process will take a few minutes to complete.

Step 4: Verify the Installation

Open SQL Server Management Studio (SSMS):
- If you don’t have SSMS installed, download it from the SQL Server Management Studio download page.
- Install and launch SSMS.
Connect to the SQL Server Instance:
- In SSMS, connect to your SQL Server instance using the credentials you configured during installation.

Lesson 3: How to Uninstall Microsoft SQL Server OLDER VERSION

Step 1: Uninstall SQL Server from Control Panel

Open Control Panel:
- Press Win + R, type control, and hit Enter.
- Navigate to Programs > Programs and Features.
Find SQL Server Installation:
- Look for Microsoft SQL Server in the list of installed programs.
- If you see multiple entries for different SQL Server components, make sure to select the main SQL Server instance first.
Initiate Uninstallation:
- Right-click on Microsoft SQL Server (version) and select Uninstall/Change.
- This will open the SQL Server Installation Center.
Select the Instance to Remove:
- In the SQL Server Installation Center, click on Remove SQL Server instance.
- Choose the instance you wish to remove from the list of installed SQL Server instances and click Next.
Select Features to Uninstall:
- You’ll be presented with a list of SQL Server features associated with the instance.
- Ensure all features are selected if you want to completely remove SQL Server.
Proceed with Uninstallation:
- Review the features to be uninstalled and click Next.
- SQL Server will begin the process of uninstalling the selected components. This might take several minutes.
Finish Uninstallation:
- Once the uninstallation process is complete, click Close.

Step 2: Remove SQL Server Shared Components

Even after uninstalling the SQL Server instance, some shared components might remain. These include tools like SQL Server Management Studio (SSMS) or SQL Server Browser.

Return to Programs and Features:
- In the Programs and Features list, look for any other components that start with “Microsoft SQL Server,” such as:
  - SQL Server Management Studio
  - SQL Server Data Tools
  - SQL Server Browser
  - SQL Server Native Client
- Right-click each one and select Uninstall.
Complete the Uninstallation:
- Follow the prompts to remove these components from your system.

Step 3: Delete SQL Server Folders (Optional)

If you want to ensure that no traces of SQL Server remain on your system, you can manually delete the SQL Server installation folders.

Navigate to the Installation Folders:
- By default, SQL Server is installed in the following directories:
  - C:\Program Files\Microsoft SQL Server
  - C:\Program Files (x86)\Microsoft SQL Server
Delete the Folders:
- If these folders still exist after uninstallation, you can delete them manually.

Step 4: Clean Up the Registry (Advanced, Optional)

If you’re comfortable editing the Windows Registry, you can remove SQL Server-related registry entries. This step is optional and should be done with caution.

Open the Registry Editor:
- Press Win + R, type regedit, and hit Enter.
Find SQL Server Entries:
- Navigate to HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server.
- Delete the relevant keys associated with the uninstalled SQL Server instance.
Clean Up Services:
- Check HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services for any SQL Server-related services and delete them if they are still present.

Step 5: Restart Your Computer

After uninstalling the SQL Server and performing any cleanup, restarting your computer is recommended to ensure all changes are applied.