How to make SQL Server running in Virtual PC accessible to host OS?

I'm running SQL Server 2008 Express on Windows XP on a VirtualPC instance inside a Windows XP host. I want to be able to connect to databases on the guest instance using SSMS on the host. When I go to connect from SSMS on the host, and browse for servers, I see the instance of SQL Server on the guest. Yet when I try to connect, using a SQL authentication login, I get the following connection error:

A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 28 - Server doesn't support requested protocol) (Microsoft SQL Server, Error: -1)

I have: * tried connecting with both Name Pipes and TCP/IP * ensured that the SQL Browser service is up * ensured that the firewall on the guest is open * the server is configured to allow remote connections (according to the database engine properties within SSMS on the guest)

What am I missing?

EDIT: I figured this out. My resolution is below.

Answers


SELF-ACCEPTED ANSWER

Thanks for the ideas. After much fiddling I got things working. It turned out that I had not gone into the Sql Server Configuration Manager and enabled TCP/IP and Named Pipes as network protocols. So even though SSMS said remote connections were enabled, there was no protocol to allow for them other than shared memory. After I did this I restarted the SQL Server service, but things still didn't seem to work properly. Yet once I had rebooted both the guest and host, everything was working as expected.


Need Your Help

image corrupted when print base64 encripted image using php

php image base64

I'm encrypting imagea into base64 then storing them in the database. I then print the images using PHP, but sometimes I get a corrupted image. If I put the same code in an HTML file, or if I refres...

How do you write a binary literal in ruby?

ruby binary

Most languages (Ruby included) allow number literals to be written in at least three bases: decimal, octal and hexadecimal. Numbers in decimal base is the usual thing and are written as (most) people