How do I install the AdventureWorks sample database with SQL Server 2005 Express?
File Download: • Navigate to: http://www.codeplex.com/MSFTDBProdSamples. • From the: Releases tab, click: SQL Server 2005 (hyperlink). • Scroll down and click: AdventureWorksLT.msi. • Save the file to your desktop or other known location. • Once the download is complete, click: Run (or navigate to the location where you saved the file and double-click: AdventureWorksLT.msi) to start the install. • Follow the prompts (using the default selections) to complete the install. DB Permissions Configuration: • From the keyboard, press: Windows Key + E to launch Windows Explorer. • In Windows Explorer, navigate to: C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data. • Right-click: AdventureWorksLT_Data.mdf then select: Properties. • Click: Security > Edit > Add. • Type your login name into the: Enter the object names… textbox then click: Check Names. Your entry will automatically resolve to: MACHINENAME\Login. • Click: OK. • Select your login name from the: Groups or usernames list. • I
