Note: Before Installation make sure to Download SQL Server 2022
STEP 1: Click Installation from left hand side then select
first option.
On left hand side click on Installation then select the
first option ‘NEW SQL Server standalone installation or add features to an
existing installation’.
STEP 2: Select Developer and click on Next.
The first thing that it asks is what version of SQL Server
do you want.
- Do you want the Developer Edition?
- Do you want the Express Edition?
- Do you want a 180 day trial?
Note: If you choose the Standard or Enterprise Edition. You
must have a product key.
STEP 3: Read and accept the license and click Next.
STEP 4: Click Next.
Don’t worry about the Windows Firewall warning. It’s just a
standard warning.
STEP 5: Click Next.
STEP 6: Select Database Engine Services and click Next.
What features do you want?
- If you are looking for SSAS, SQL
Server Analysis Services, then you should check this.
- If you are looking for SSIS, Integration Services, then
check this, and if you are looking for any of these additional features, then
check that as well.
- If you are looking for SSRS, SQL Server Reporting Services,
it is not actually here. You can click on Download link from the web. However,
this is not needed unless you want to host your own SQL Server Reporting
Services reports on your computer. But you can still run and print them.
STEP 7: Click Default instance and click Next.
What instance do you want?
- If it’s your first time installing SQL Server, then you
should have a default instance. It’s the first instance that anyone will try to
connect to on your computer. It’s the easiest to connect to.
- If not, then you need to select Named instance and give a
name of your choice.
If it’s not your first time installation and you select
default instance. You will get the below error message dialog.
STEP 8: Click Next.
STEP 9: Check on Windows authentication mode, then click on
Add Current User and then click Next.
- Windows authentication means that anyone who tries to
connect to the instance and then to a database, will be using their Windows
login as opposed to supplying a password and username.
- Add Current User to the list of SQL Server administrators.
Administrators have all of the power that you need in an instance. And because
this is the Developer edition, it’s going on your computer, you can be the
administrator.
STEP 10: Click Install.
Next:
Download and Install SQL Server Management Studio (SSMS)