Home > Archive > Microsoft SQL Server forum > February 2006 > Virtual Servers cannot connect to host PC Database









You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

 

Author Virtual Servers cannot connect to host PC Database
sunstarwu@yahoo.com

2006-02-25, 9:45 am

Hi,

On my laptop I am running Virtual Server 2005 with 2 x Windows 2003
Servers. Both the VS can access the internet and shared files on the
host laptop. On the host laptop I have a SQL Server 2000 running.

I have written a Windows Service to detect Application Errors and fire
duplicates of events to the database, and this service sits on both VS.
It does work as I have tested it on host. BUT everytime I make
application errors on the VS nothing is deposited into my database.
Very frustrating!

I have also tried to create a ODBC connection through the Data Source
Administrator, and when I enter the login credentials for SQL I get
connection error messages.

Any suggestions would be great!

Thanks
Sun

Lorenzo Barbieri [MVP]

2006-02-25, 9:45 am

sunstarwu@yahoo.com wrote:
> Hi,
>
> On my laptop I am running Virtual Server 2005 with 2 x Windows 2003
> Servers. Both the VS can access the internet and shared files on the
> host laptop. On the host laptop I have a SQL Server 2000 running.


How have you configured the virtual network?
--
Lorenzo Barbieri
MVP Windows - Virtual Machines, MCT, MCSD.NET, MCDBA
INETA lead South Europe
IT: http://www.geniodelmale.info
EN: http://www.lorenzobarbieri.info
UGIdotNET - http://www.ugidotnet.org
My Dark Side - http://www.windowserver.it


sunstarwu@yahoo.com

2006-02-25, 9:45 am

The host & VS all use the wireless card to communicate, which is
connected to my wireless DCHP router. There is no problem in the hosts
and VS communicating as I can ping each of them from each other.

Thanks

benamar@gmail.com

2006-02-25, 9:45 am

A few things to try:
1. Have you enabled TCP/IP connections to the SQL server ? (to check,
enter the properties page of the server, click on "network
configuration and make sure tcp/ip is enabled).

2. If no.1 doesn't help - Are you using a host name or an IP ? Try
using an IP.

3. Check for a firewall on the host.

Dan.

sunstarwu@yahoo.com wrote:
> The host & VS all use the wireless card to communicate, which is
> connected to my wireless DCHP router. There is no problem in the hosts
> and VS communicating as I can ping each of them from each other.
>
> Thanks


Sponsored Links





Also available: Server administration forum archive | Web Design forum archive | Software forum archive | Hardware reviews archive | Programming forum archive

Copyright 2008 droptable.com