How do you automatically connect Servers in the Object Explorer??

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

I know it's silly, but it saves me time... I'd like to know how to
automatically connect servers to the Object Explorer in SQL Server
2005. Every time I start SQL Server 2005 I have to connect my servers
(I have at least 6 servers that I connect daily so it becomes quite
annoying). I've registered all the servers thinking it would help,
but every time I start up SQL Server Management Studio, I'm prompted
to connect to a server. Then I have to connect to the other 5 servers
in the object explorer manually. In SQL Server 2005, the servers
already exist on the pane in the left side. All you have to do it
start browsing and it will automatically connect. I'd like this for
SQL Server 2005 since it would reduce annoyances of having to do it
manually.

Thanks!

.

Relevant Pages

  • Re: Remote disk space analysis
    ... Check the drive space on all of the servers listed in a text file and store the output like Server name, Drive Name, Disk Space and Free space information on a SQL Server table. ...
    (microsoft.public.scripting.vbscript)
  • Re: SQL Clustered Node restarting unexpectedly
    ... Found it to be a NMI that was caught by the system BIOS ... Mike Epprecht, Microsoft SQL Server MVP ... > Servers on 2 nodes connected to SAN Storage using Fibre ... > for network name resource SQL network name ...
    (microsoft.public.sqlserver.clustering)
  • Re: how to sort object explorer items?
    ... similar to Sqlserver 2000 Enterprise Manager. ... Since Object Explorer lists only servers that you are currently connected ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxxxxxxx Online for SQL ...
    (microsoft.public.sqlserver.tools)
  • Re: using windows authentication...
    ... SQL Server DOES NOT TALK TO WEB ... Web clients request access and data from database servers, ... Server security. ...
    (microsoft.public.sqlserver.server)
  • Re: Hiding MS SQL databases in Enterprise Manager
    ... > When I create a database in the Microsoft SQL Server, ... > security issue, I would like to set it up so that users can only see ... > databases for which they've been assigned a role. ... your SQL servers, not at preventing a list of them. ...
    (Focus-Microsoft)