November 30, 2007 at 6:31 am
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?
November 30, 2007 at 6:36 am
Have you enabled remote connections?
You can enable this using SQL Surface Area Configuration.
--Ramesh
November 30, 2007 at 8:43 am
I looked at the remote connections in the Surface Area Configuration Tool and it allows both local and remote connections.
November 30, 2007 at 8:59 am
Are you connected to it in the Registered Servers window? How are you connecting?
Follow me on Twitter: http://www.twitter.com/way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
November 30, 2007 at 10:07 am
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.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply