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, Microsoft Data Platform MVP
Data Warehouse and ETL Consultant
TimMitchell.net | @Tim_Mitchell | 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 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply