Windows – How to connect to IIS and SQL Server Express on Windows 7 host from XP Mode

iisnetworkingsql serverwindowswindows 7

I am running IIS and SQL Server 2008 Express on my Windows 7 host, and I'd like to be able to connect to them in XP Mode. My host machine is not a part of a domain, only a workgroup.

So far, I've tried these instructions on connecting to SQL Server, but I'm not able to telnet to port 1433 on the host from XP Mode. I'm also not able to connect using a SQL client.

I'm not able to connect to IIS on the host from XP Mode.

Advice from those who have had success doing this would be appreciated.



Update: I'm wondering if this is a simple permissions issue. I'm on a workgroup, not a domain, so I can't test/fix this simply by granting permissions in SQL Server and IIS to a domain user.

Best Answer

This turned out to be a permissions issue. Since I am not on a domain, I was trying to connect to the host machine from the virtual machine using a local account on the virtual machine.

To fix the problem, I modified the

The steps I used are as follows:

  1. In the virtual machine, click Start > Control Panels > Users.
  2. Click the name of the current user (or whichever user you're using to run the client apps that are connecting to the host machine).
  3. Click "Manage my Network Passwords".
  4. Click Add to open the Logon Information Properties dialog.
  5. Type the name of the host machine in the Server text box.
  6. Type the name of the appropriate host machine local account in the User name text box (\).
  7. Type the password for the host machine local account in the Password text box.
  8. Click OK > Close.

I also had to open the Windows firewall to HTTP requests to be able to access IIS.

Following this procedure, I can now access SQL Server and IIS from the XP Mode virtual machine.