How to change default database from SQL Server 2005 to SQL Server 2008

I have installed SQL Server 2005 Express with/on the time I installed some software few months ago, but then, I just install SQL Server 2008 Standard..

My question is why I run SQL Server Management Studio 2008, connected serve开发者_高级运维r is the SQL Server 2005 Express (9.0.5000) why does it not connect to the 2008 database?

I have been tried close ssms, in the servername field I entered localhost, but result is same. ssms 2008 and 2005 express database..

Why? How come?? How to fix it I mean change the default database to 2008

I think LOCALHOST or the server computer name is already default set to database 2005 express, is above I said, I installed 2005 express first then 2008 standard in a same server.

Thank you very much.

For me when I start up SSMS it pops up the connection to the server last accessed, just type in the IP/Servername from the 2008 Server..connect. Close SSMS, open it again and it should display the 2008 server from now on. You can also add the server to the registered server group of course (CTRL + ALT + G)

based on your comment

why would you type localhost..is the 2008 install a default or a named instance? if it is a named instance you need localhost\Instancename Where Instancename is the name you gave the 2008 instance when you installed it

FOr the first time the SQL Server management Studio will use the settings from SQL2005, you can change as referred above.