How to save connections in Object Explorer?

3 Oct 2007 4:36 PM

sjones

Is it possible to save your Database Engine connections in SQL Server 2005
Managment Studio Object Explorer, so that the next time you open the
Management Studio you don't have to reconnect?

Thank you!

3 Oct 2007 4:44 PM

Aaron Bertrand [SQL Server MVP]

I'm not sure exactly what you mean. Do you want SQL Server to honor and
maintain a connection from your machine, even when Management Studio is not
even open? I'm afraid that's not possible. If you want to access your
connections (other than the default with the prompt) more quickly when you
launch SSMS, then you should save your connections in the Registered Servers
window. Then you can just right-click, connect.

A

Show quote

"sjones" <sjo***@discussions.microsoft.com> wrote in message
news:CC34B975-0DBE-4386-AD0B-56B40D907041@microsoft.com...
> Is it possible to save your Database Engine connections in SQL Server 2005
> Managment Studio Object Explorer, so that the next time you open the
> Management Studio you don't have to reconnect?
>
> Thank you!

4 Oct 2007 5:37 AM

Mohit K. Gupta

Too add to Aaron's, if you don't want to get the pop-up that asks for server
to connect to in the options under environment, select Open empty environment.

--
Mohit K. Gupta
B.Sc. CS, Minor Japanese
MCTS: SQL Server 2005

Show quote

"Aaron Bertrand [SQL Server MVP]" wrote:

> I'm not sure exactly what you mean. Do you want SQL Server to honor and
> maintain a connection from your machine, even when Management Studio is not
> even open? I'm afraid that's not possible. If you want to access your
> connections (other than the default with the prompt) more quickly when you
> launch SSMS, then you should save your connections in the Registered Servers
> window. Then you can just right-click, connect.
>
> A
>
>
>
> "sjones" <sjo***@discussions.microsoft.com> wrote in message
> news:CC34B975-0DBE-4386-AD0B-56B40D907041@microsoft.com...
> > Is it possible to save your Database Engine connections in SQL Server 2005
> > Managment Studio Object Explorer, so that the next time you open the
> > Management Studio you don't have to reconnect?
> >
> > Thank you!
>
>
>