Ok, so the DB is attached but suspect. Please run the following.
ALTER DATABASE <database name> SET EMERGENCY
Once you've done that, you should be able to access the DB, though it will be restricted to single user. Please confirm once you've run that, that you can access the database and you can run a simple query (just query one of the system views, like sys.objects)
If you get any errors, post the complete messages here.
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
We walk in the dark places no others will enter
We stand on the bridge and no one may pass