Management Studio and Server Connections

[Steffi1013]

In SQL Server 2005 Management Studio -- how do you get your servers to stay listed and connected when you close and reopen Mgmt Studio.

In 2000, when you registered a server, no matter when you opened or closed enterprise manager, you could see the list of your servers you had registered.

How do you get that feature in 2K5? When I use Connect DAtabase Engine" and select my server, as soon as I close the application, the next time I open I must connect again... is there a way to avoid this.

 

[ptheriault]

From SSMS click on the view menu option. The select registered servers. This will open the a window on the top left. Register your servers in there.

- Paul
- If at first you don't succeed, find out if the loser gets anything.

 

[mrdenny]

You want to register the servers, not just connect to them in the Object Explorer.

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

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

http://www.mrdenny.com

 

[Steffi1013]

Thanks for the info... my brain has been asleep this week and I knew I was missing something easy.

Thanks again

 

[mrdenny]

No problem.

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

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

http://www.mrdenny.com