needed adventureworks db for sql server 2008

The link Gianmaria Gregori is perfectly valid. If you have problems in installing the executable, did you notice that there's also a download link to a ZIP file which contains the MDF and LDF files for the database.

If you're using a Windows version that cannot directly unzip the file, I suggest downloading and installing 7-Zip[^]

you can download the script file available in the internet and run it in the sql server. I faced a problem wherein i was unable to attach the databases due to permission issues. I just downloaded the script file and ran it in the sql server which gave me the adventure works database

U can download the script file from the following link

http://msftdbprodsamples.codeplex.com/downloads/get/389753[^]