January 23, 2004 at 1:47 pm
I have Enterprise Manager installed on my local machine, and am trying to connect to one of the two instances of MSSQL on another machine.
When I go into Query Analyzer and click File > Connect, I get the dialog box to pick a SQL Server and connect to it.
The dropdown list at the top lists the ones I have recently connected to. And the [...] button to the right apparently surveys the network to show me a refreshed list of instances.
My question: That list from the [...] button is weirdly wrong. It includes two instances that I deleted months ago. I have rebooted, I have refreshed, and it keeps showing me three -- one valid, and two long gone.
Further, that list does NOT include another instance that DOES exist. That instance (call it Instance B), however, DOES appear in Enterprise Manager! I can look at it, refresh it, open up its tables, look at data, etc. But Query Analyzer is certain that it doesn't exist.
Suggestions?
- Tom
January 23, 2004 at 1:50 pm
Okay, half of the problem is solved.
Why isn't Instance B showing up in Query Analyzer?
Because my crappy old firewall software decided today that it was evil and needs to be kept hidden. When I turn that off, it shows in the list
However, the other question remains. Why does it show these other two instances that I removed?
- Tom
January 23, 2004 at 3:15 pm
Do you have the other two registered in EM or as an alias?
K. Brian Kelley
@kbriankelley
January 26, 2004 at 10:10 am
Brian,
All of these MSSQL installations/instances were registered through EM at one time -- but the two puzzling ones were long ago unregistered and their underlying data files deleted.
- Tom
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply