Scribd
Upload
470 views5 pages

Goal: Install Sample Database (Adventureworks Database) Step 1: Download Adventure Works Database. at The Time of Writing, It Was Available at

The document provides steps to install the AdventureWorks sample database. It instructs the user to download the AdventureWorks backup file, place it in a folder with full permissions, open SQL Server Management Studio, select "Restore Database" and navigate to the backup file to complete the restoration. It also notes that the user may need to change the SQL service to run under their credentials if they cannot access the backup file location.

Uploaded by

Acecr Khan
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
470 views5 pages

Goal: Install Sample Database (Adventureworks Database) Step 1: Download Adventure Works Database. at The Time of Writing, It Was Available at

The document provides steps to install the AdventureWorks sample database. It instructs the user to download the AdventureWorks backup file, place it in a folder with full permissions, open SQL Server Management Studio, select "Restore Database" and navigate to the backup file to complete the restoration. It also notes that the user may need to change the SQL service to run under their credentials if they cannot access the backup file location.

Uploaded by

Acecr Khan
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd

[Link].

com

Goal: Install Sample Database (AdventureWorks Database)

Step 1 : Download adventure works database. At the time of writing, it was available at:

[Link]

(if the link has changed, please google Adventure Works 2016)

Step 2: Download the AdventureWorks Database.

pg. 1
[Link]

Step 3: Place the download .bak file in a folder (avoid placing in the OS drive like c:\).

Right click on the folder, Click properties and go to security Tab, and give full rights to yourself.

Step 4: Goto Start  Run  ssms

pg. 2
[Link]

Step 5: Enter the server name as .\sql2016

Step 6: Right on Databases  Restore Database

pg. 3
[Link]

Step 7 : Fill in all the details as shown. Navigate to your DB backup path. In case you can’t see you DB,
that means 1 of the 2 things:

1. You don’t have access to that location


2. OR, goto start  run  [Link]  find SQL (2016) change the running account to your
windows credentials.

pg. 4
[Link]

Step 8: That’s it. You have setup all the required components (DB engine, SSRS and Sample
databases)

pg. 5

You might also like