How come I cannot view my SQL Server database in Management Studio 2008?

Until we upgrade to SQL Server 2008, you can refer to this link in the event you are using Management Studio 2008

If you are seeing issues viewing your SQL Server 2005 database in Management Studio 2008 and the database is provisioned correctly in our system, you can refer to this link

http://sqlblog.com/blogs/aaron_bertrand/archive/2008/07/07/a-little-management-studio-oops.aspx

You are going to have to connect to a SQL 2008 Database engine, click on the Databases folder, right click in the column headers and uncheck collation. Then you can connect to a SQL server 2005 database engine.