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

Question

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 server 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.

I have been tried, close ssms, in the servername i type localhost, but result is same. ssms2008 and 2005 database.. — Ironman
– Ironman, Commented Mar 22, 2011 at 20:24

SQLMenace · Accepted Answer · 2011-03-22 20:43:52Z

3

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

edited Mar 22, 2011 at 20:43

answered Mar 22, 2011 at 19:27

SQLMenace

136k25 gold badges212 silver badges227 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Ironman Over a year ago

I have been tried, close ssms, in the servername i type localhost, but result is same. ssms2008 and 2005 database...

Ironman Over a year ago

okay, is like this.. i installed 2005 express on Feb, but just installed 2008 standard this week... also i can't uninstall/remove 2005 because 1 application is using 2005 express.

sqlmaster · Accepted Answer · 2011-03-23 13:17:49Z

-1

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

answered Mar 23, 2011 at 13:17

sqlmaster

341 bronze badge

1 Comment

vikingben Over a year ago

This should be a comment not an answer.

Collectives™ on Stack Overflow

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

2 Answers 2

2 Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related