SQL Server supports two types of installation −
- Standalone
- Cluster based
Checks
- Check RDP access for the server.
- Check OS bit, IP, domain of server.
- Check if your account is in admin group to run setup.exe file.
- Software location.
- Which version, edition, SP and hotfix if any.
- Service accounts for database engine, agent, SSAS, SSIS, SSRS, if any.
- Named instance name if any.
- Location for binaries, system, user databases.
- Authentication mode.
- Collation setting.
- List of features.
- Pre-requisites for 2005
- Setup support files.
- .net framework 2.0.
- SQL Server native client
Pre-requisites for 2008&2008R2
- Setup support files.
- .net framework 3.5 SP1.
- SQL Server native client.
- Windows installer 4.5/later version.
Pre-requisites for 2012&2014
- Setup support files.
- .net framework 4.0.
- SQL Server native client.
- Windows installer 4.5/later version.
- Windows PowerShell 2.0.
Installation Steps
Step 1 − Download the Evaluation Edition from https://www.microsoft.com/en-us/evalcenter/download-sql-server-2019
Once the software is downloaded, the following files will be available based on your download (32 or 64 bit) option.
ENU\x86\SQLFULL_x86_ENU_Core.box
ENU\x86\SQLFULL_x86_ENU_Install.exe
ENU\x86\SQLFULL_x86_ENU_Lang.box
OR
ENU\x86\SQLFULL_x64_ENU_Core.box
ENU\x86\SQLFULL_x64_ENU_Install.exe
ENU\x86\SQLFULL_x64_ENU_Lang.box
Note − X86 (32 bit) and X64 (64 bit)
Step 2 − Double-click the “SQLFULL_x86_ENU_Install.exe” or “SQLFULL_x64_ENU_Install.exe”, it will extract the required files for installation in the“SQLFULL_x86_ENU” or “SQLFULL_x86_ENU” folder respectively.
Step 3 − Click the “SQLFULL_x86_ENU” or “SQLFULL_x64_ENU_Install.exe” folder and double-click “SETUP” application.
For understanding, here we have used SQLFULL_x64_ENU_Install.exe software.
Step 4 − Once we click on 'setup' application, the following screen will open.
Step 5 − Click Installation which is on the left side of the above screen.
Step 6 − Click the first option of the right side seen on the above screen. The following screen will open.
Step 7 − Click OK and the following screen pops up.
Step 8 − Click Next to get the following screen.
Step 9 − Make sure to check the product key selection and click Next.
Step 10 − Select the checkbox to accept the license option and click Next.
Step 11 − Select SQL Server feature installation option and click Next.
Step 12 − Select Database engine services checkbox and click Next.
Step 13 − Enter the named instance (here I used TestInstance) and click Next.
Step 14 − Click Next on the above screen and the following screen appears.
Step 15 − Select service account names and start-up types for the above listed services and click Collation.
Step 16 − Make sure the correct collation selection is checked and click Next.
Step 17 − Make sure authentication mode selection and administrators are checked and click Data Directories.
Step 18 − Make sure to select the above directory locations and click Next. The following screen appears.
Step 19 − Click Next on the above screen.
Step 20 − Click Next on the above screen to the get the following screen.
Step 21 − Make sure to check the above selection correctly and click Install.
Installation is successful as shown in the above screen. Click Close to finish.
