Connecting to 2005 and MSDE

[jshurst]

I just installed SQL 2005 Developer Edition on my computer. I also have MSDE. During the install of SQL 2005 I accepted the default instance of for the server. However when I open management Studio and connect to (local) it connects to the MSDE (which I fully expect).

My question is, could someone tell me how to connect to the 2005 service? I know in the express version it is something like (local)\SQLEXPRESS, but I don't know about this version.

thanks in advance,

J

 

[jbenson001]

Try going to the View menu and choosing Object Explorer. There will be a button to connect, choose database engine. You will have a dialog box to choose the server/instance to connect too.

Jim

 

[mrdenny]

If you already had a default instance and you installed SQL 2005 as a default instance one of two things should have happened.

1. The SQL 2000 default instance was upgraded to SQL 2005.
2. The SQL 2005 installed exited and did not install.

Denny
MCSA (2003) / MCDBA (SQL 2000) / MCTS (SQL 2005) / MCITP Database Administrator (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com