How to connect to IIS and SQL Server Express on Windows 7 host from XP Mode
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.
Thanks,
Jon.
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.
Solution 1:
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:
- In the virtual machine, click Start > Control Panels > Users.
- 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).
- Click "Manage my Network Passwords".
- Click Add to open the Logon Information Properties dialog.
- Type the name of the host machine in the Server text box.
- Type the name of the appropriate host machine local account in the User name text box (\).
- Type the password for the host machine local account in the Password text box.
- 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.