0

I have a SQL Server instance that I'd like to remove from the list that shows up in the available servers in Object Explorer. How do I do this?

marc_s
  • 732,580
  • 175
  • 1,330
  • 1,459
Eric
  • 2,861
  • 6
  • 28
  • 59

2 Answers2

7

Assuming you mean the dropdown list of servers when making a new connection, you simply highlight the row in the dropdown and hit delete.

Pang
  • 9,564
  • 146
  • 81
  • 122
Sean Lange
  • 33,028
  • 3
  • 25
  • 40
1

Here is the simplest way to clear items from this list.

  1. Open the Microsoft SQL Server Management Studio (SSMS) version you want to affect.
  2. Open the Connect to Server dialog (File > Connect Object Explorer, Object Explorer > Connect > Database Engine, etc).
  3. Click on the Server Name field drop down list’s down arrow.
  4. Hover over the items you want to remove.
  5. Press the delete (DEL) key on your keyboard.
Pang
  • 9,564
  • 146
  • 81
  • 122