Bobby Heid wrote:
Hey,
I have SQL Server 2005 standard installed on my pc. What I want to do
is to install SQL 2005 standard on XP Pro inside of a Virtual PC 2007
VM. And I have done that.
What I have not been able to do is access the SQL Server from my PC
when the VM is running. I have turned on named pipes, TCP/IP, and one
other one (can't remember at the moment what it is). I have also
installed IIS onto the VM also and was not able to access a Web
Service from my machine.
What else do I need to do to allow my machine to see SQL Server and
IIS in the VM?
Thanks,
Bobby
Is the Windows Firewall turned on? If so, it'll block remote access. Try
pinging the remote machine, and if that works telnet to port 1433 - you
should get gibberish back, but that'll confirm that the connection works.
If the two machines are not a member of the same domain, you'll also
have to use SQL authentication - you won't be able to use Windows
authentication as that expects both machines to be in the same domain.
This is something you can change through the server properties dialog
(right click on the server node in SQL Management studio, properties,
Security tab, change the server authentication type).
Jamie
