==== install adventureworks database ====
  * 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"

{{tag>["give access rights to users in microsoft sql server management studio"]}}