Maintaining two Databases with management studio

Hi,
I have been had hosting and a SQL db for over a year (great - no probs) and am in the process of setting up another site with its own space and a separate DB.
My problem is that both databases are on the same server so when I want to access one or the other through management studio I have to close the connection for whichever db I am on and reconnect to see the other db.
I don't seem to be able to have two connections to the same server (maybe I'm just too dumb). Is there a way to have both dbs connected at the same time?

Kevin

 

Yup, was being dumb!


both connections would work when I tried again.


Then added the user from DB1 to DB2 and can now access both DBs from a single connection.


Kevin