The database does exist.

There are two ways to see a list of the databases in SSMS.

The first is from the object explorer.

The second is to open a new query from any database. When focus is on the query edit section of SSMS there is a drop down list that becomes available on the menu bar. If you click the down arrow of that list it will also give a list of the databases.

I cannot see my database from the object explorer.

I can see it from the list of databases available from the query editor. I can also select it and switch to it from the list available from the query editor.

I can also see it from sysdatabases and i can see it from the list return when running sp_helpdb. I can see it everywhere except in object explorer.

Thanks