Connecting to SQL server from Virtual PC

Question

I have VS 2008 and SQL Server 2005 Developer edition installed on my desktop. I have a instance of XP running in Virtual PC and want to connect to the dev instance. I am logged on as a domain user on both the desktop and the Virtual instance of XP. When I try to connect I get a message saying "Server does not exist or access denied". What do I need to do to connect. I am using trusted connection and the userid has privileges on the DB.

Paul

Answer 1

Make sure that the VPC is not using NAT for its network connection.

Also check your configuration to be sure remote connections are allowed. Remote connection is turned off by default.

Answer 2

Have you tried pinging your desktop from the virtual instance? I had the same problem and figured out that the firewall was preventing any kind of communication between both machines.