• Download AdventureWorks2019.bak from https://github.com/Microsoft/sql-server-samples/releases/download/adventureworks/AdventureWorks2019.bak
  • For other versions see https://learn.microsoft.com/en-us/sql/samples/adventureworks-install-configure?view=sql-server-ver16&tabs=ssms
• Put the file in C:\Program Files\Microsoft SQL Server\MSSQL16.MSSQLSERVER\MSSQL\Backup
• To install start SSMS → object explorer → Databases → right click → “Restore Database…” → Device → … → Backup media type: → choose “File” → Add → Choose the .bak file → OK → OK → OK
• For other users to access it
  • SSMS → Object explorer → Security → Logins → DESKTOP-CRLPVE5\<username> → double click → Server Roles → check “sysadmin”

["give access rights to users in microsoft sql server management studio"]