SQL Server Instance Not in Explorer Window

Question

Post reply

SQL Server Instance Not in Explorer Window

Lettia Milito

SSC Veteran

Points: 264
More actions
November 30, 2007 at 6:31 am

#177085

I have an instance of SQL Server installed in a Virtual PC. The default server instance (USATONMILITOL9) shows up in the Registered Server window but not in the Object Explorer window. I am unable to open this instance (USATONMILITOL9) because it does not allow connections. In order to change this setting I need to have it display in the Object Explorer window. I have tried everything I can think of to get it to show up there but I obviously must be missing something. Can anyone help?

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

Ramesh Saive SSC-Insane Points: 24275 More actions · Answer 1

Have you enabled remote connections?

You can enable this using SQL Surface Area Configuration.

--Ramesh

Lettia Milito SSC Veteran Points: 264 More actions · Answer 2

I looked at the remote connections in the Surface Area Configuration Tool and it allows both local and remote connections.

Steve Jones - SSC Editor SSC Guru Points: 736212 More actions · Answer 3

Are you connected to it in the Registered Servers window? How are you connecting?

Lettia Milito SSC Veteran Points: 264 More actions · Answer 4

Thanks for the help but I found the problem. For some reason when I installed SQL Server on a Virtual PC it did not start the SQL services. Once I started the services then I was able to connect to the server instance and it showed up in the Object Explorer window.