- Microsoft SQL Server Developer Edition or Better
- Microsoft SQL Server Management Studio
- Visual Studio Community or Better with Reporting Services Projects Extension
- AdventureWorks and WideWorldImporters Sample Databases
For Windows, download the latest version of MSSQL Server Developer edition. This is free software and requires no registration.
Execute the SQL20XX-SSEI-Dev.exe, choose Download Media at a specified location
Use ISO packaging, mount and install
After checking your computer, select Custom Installation and ensure that Database Engine, Integration Services, Analysis Services are all selected for installation. Add current user in all cases when prompted.
For authentication, choose mixed mode authentication (it may be shown as SQL Server and Windows Authentication mode). If you are asked for a user name, use sa, and for the password use passw0rd (we will only use publicly available sample data for the project so we are ok with basic security)
For Windows, download the latest version of MSSQL Server Management Studio. This is free software and requires no registration.
Once it is installed, run it and it will connect to the SQL Server that you installed in the previous step
For authentication, choose SQL server authentication, and enter the user name and password which you created in the previous step for the SQL Server
The installation of the databases in SQL Server will be shown in one of the course sessions.
Visual Studio 2022 Community or better with the Data storage and processing workload installed, including the SQL Server Data Tools component.
The SQL Server Reporting Services Projects installed for Visual Studio.