It doesn't matter if the database is shown in Solution Explorer.

The issues you are having are not about that, but something wrong with the way you are trying to connect to the database (including...