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

Solution 1

I found out that you have to go into the SQL Server Surface Area Configuration tool and set "Remote Connections" to "Local and remote connections". Apparently the default is "Local connections only".

Solution 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.

Solution 3

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.

Comments

[Ian P]

Same problem here, turned of the host firewall on windows 7 and got a connection (have done all the good things: browser service on, tcp ip and named hosts enabled, service restarted, fixed port on ip) Now to find which utp/ip I need to create a rule for!