I have both SQL Server 2008 and Express 2008 installed. When I try to
connect with Management Studio, neither of those instances appears in the
list of local servers, but I can see them in the list of network servers.

What did I set wrong to make this happen?

1.Open SQL Server Configuration Manager and expand the SQL Server Network
Configuration node
2.Right Click on Protocol for and then select Properties
3.In Flag pane there's a field called HideInstance. You've to change this
flag.

"Paul Pedersen" wrote:

Thanks, but that wasn't the problem. HideInstance was already set to No for
both instances.

Any other ideas?

In both cases, I have protocols Shared Memory, Named Pipes, and TCP/IP
enabled, and VIA disabled. Is that the way it should be?




"Neal Sivley" <NealSivley (AT) discussions (DOT) microsoft.com> wrote

Obviously the local instances should show up as being on the local computer.
A shot in the dark - maybe the DNS cache has old IP addresses for them and
therefore things they are remote.
Open a command prompt window as an administrator, and execute
ipconfig /flushdns
to clear the DNS resolver cache. Then try SSMS again.
--
Rick Byham, MSFT
(Implies no warranty or rights)


"Paul Pedersen" <nospam (AT) no (DOT) spam> wrote

No, that didn't help. Thanks for trying.

Funny thing though - the local Integration Services shows up, but not any of
the others - no Database Engine, Analysis Services, SQL Server Compact
Edition Databases, or Reporting Services. Just Integration Services.

If I look under the Network Servers tab, I see my server with the two
database engines listed (the local named one and SQLEXPRESS).




"Rick Byham, MSFT" <rickbyh (AT) microsoft (DOT) com> wrote