Sorry, this is not enough information to work with. Are you saying that you can see AdventureWorks2008 from Object Explorer but cannot access the database, or that AdventureWorks2008 does not appear in the Object Explorer at all? What error message are you getting?
Unlike the other AdventureWorks sample databases, AdventureWorks2008 requires that you have Full-text Search installed and FILESTREAM enabled. You should start by verifying that these are properly installed. Start by reading the prerequisite information for installing the sample databases and (http://msftdbprodsamples.codeplex.com/Wiki/View.aspx?title=Database%20Prerequisites) and follow all instructions. If you continue to have problems after following these instructions, please provide a detailed explanation of the problem including any error messages you see.
Kind regards,
Gail
Gail Erickson [MS] This posting is provided "AS IS" with no warranties, and confers no rights