November 17, 2005 at 12:09 am
I have a sql 2000 Default instance and a sql 2005 Named instance installed on the same Win 2003 Server box. When I go to the sql 2005 Management Studio, I can add connections to both of them in the Object explorer. But when I close, and then re-open the Management Studio, the connections are gone! I expected both of them to remain so I could easily administer them. What am I doing wrong?
TIA,
Bill
November 17, 2005 at 11:36 am
Bill,
What you want is the Registered Servers tool, not the Object Explorer. Go to View and select Registered Servers; from there, you can add servers and server groups just like you're used to in Enterprise Manager for SQL2K.
~Tim
Tim Mitchell
TimMitchell.net | @tmitch.net | Tyleris.com
ETL Best Practices
April 26, 2006 at 7:06 pm
That still doesn't seem as easy as the old enterprise manager. However, I suppose it is just a matter of getting used to it.
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy