Home / server / Questions / 39684
In Process
Simon Hartcher
Asked: 2009-07-13 18:08:04 +0800 CST

Accessing SQL Server on Host from Windows XP Virtual PC

  • 772

I have SQL Server 2005 Express Edition installed on my Windows 7 host machine, and I would like to be able to access that from a Windows XP Virtual PC.

This way, I can develop using Delphi 7 on XP alongside Visual Studio projects on Windows 7 which both use the same data.

EDIT: At this point I have only installed the Windows XP Virtual PC and Delphi 7 within it. I cannot ping the host machine and all the host drives are mounted using:

//tsclient/share/

So my question is - How do I see the host machine's SQL 2005 Server from a Windows XP Virtual PC?

virtualization sql-server-2005 windows-7

3 Answers

  1. Go to Start->Control Panel->Administrative Tools->Services and ensure that the SQL Server Browser service has been started and set to automatic.

    Use the SQL Surface Configuration Manager->Services & Connections. Expand Database Engine, click Remote Connections and ensure Local & Remote connections selected and you have TCP/IP selected (you can use named pipes & tcp/ip)

    Now to ensure is not a firewall issue, disable the firewall on your windows 7 host and now try to connect from your virtual XP machine (also disable the firewall within this VM environment as well).

    Update: Ok, so you have enabled SQL Browser service, enabled TCP/IP sockets and can connect by IP address\SQLEXPRESS. Sorry for making you possibly feel stupid but you did try WIN7MACHINENAME\SQLEXPRESS yes? Can you make a share on the Win7 machine and try to access that share from xp via \\WIN7MACHINENAME\SHARENAME and tell us the error. You may also want to update your top comment to reflect what you have done to get things working till this point. Can you also try without using a RDP session but using the raw VM console?

    • 2

  2. You'll have to ensure the SQLSever and SQLBrowser executables are allowed through Windows 7's Windows Firewall.

    Try this on your Win 7 machine:

    • Start->Run-> firewall.cpl
    • Allow a program through Windows Firewall
    • Click button "Add Program", and Browse
    • Add these two executables: (assuming SQL Server Express on these filepaths, but if not, SqlServer.exe and SqlBrowser.exe paths are easy to find in Services.msc)
    C:\Program Files\Microsoft SQL Server\MSSQL10.SQLEXPRESS\MSSQL\Binn\SqlServer.exe      
C:\Program Files\Microsoft SQL Server\90\Shared\SqlBrowser.exe

    Fire up the SQL Server Configuration Manager utility.

    • Ensure that TCP/IP is enabled as a Network Configuration
    • Ensure that the SQL Server Browser is set to Automatic startup. Right Click, Properties, Service tab, Start Mode -- set to Automatic. This will ensure the SQL Browser service is startup upon reboot.

    To allow a ping on a Windows 7 machine, you need to:

    • Windows Firewall, Advanced Settings
    • Inbound Rules
    • File and Printer Sharing (Echo Request – ICMPv4-In)
    • Right-click, and choose Enable.
    • 1

  3. You could also try installing the "XPMode" supplement to "Virtual PC" . That basically gives you a pre-configured 512MB virtual machine pre-made by microsoft. That VM would be a good "reference" as to what capabilities your hand-built VM should have.

    Also, you might want to enable the tcp-ip listener for SQL server so that the VM can access the SQL Server remotely through port 1433. SQL disables the listener by default on new installs.

    • 0