January 18, 2010 at 6:20 pm
The Host machine is Windows Vista Home Premium SP2, running SQLExpress 2008. On this machine I am running a VM with Windows Server 2003.
I am have installed SQL Native Client 10 on the VM and I am trying to connect to a named SQL2008 instance running in the windows host. I get a Error Locating Server/Instance error.
The SQL instance is configured to allow remote connections. The named Pipes and TCP/IP protocols are enabled.
Last week (after trying lots of things) I was able to connect after opening command windows in both OS's and pinging each other. But this week no joy.
What am I missing?
January 18, 2010 at 6:38 pm
What is your VM (Virtual PC/Server or VMWare)? Virtual PC/ Server allows the NIC to be seen back and forth between the host and VM. It seems like it is a setting like this that could resolve the problem.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
January 18, 2010 at 7:07 pm
It is VMWare. The network setting is bridged, which means the VM has it's own IP and is supposed to act like it's own machine on the LAN. I am able to access the internet and download files from within the VM.
January 18, 2010 at 9:45 pm
Is the firewall enabled on the Vista host?
When trying to connect are you trying to use the vista\instance or vista,1433 method?
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
January 18, 2010 at 10:07 pm
First, can each machine see the other on the network? Using IP or the Explorer network browser, can you find the VM from the host and vice versa?
January 19, 2010 at 10:30 am
OK,
I try to connect to the server by machinename\SQLEXPRESS or by IP\SQLEXPRESS.
When I power up the VM, the VM can ping other machines on the network - the DSL Router, my wife's computer, the TiVo, but not the host machine (?). If I ping the VM from the host OS, THEN the VM can ping the host - at least for a few minutes.
The VM can see the host from Network Neighborhood, but not my wifes computer. (Keep in mind that this is a workgroup - not a Windows domain).
Generally I do have Windows Firewall enabled from the host, but I have an exception enabled for Port 1433 (TCP). Is this correct?
I disabled Windows firewall. After restarting the host, restarting the VM, and pinging back and forth between the VM and the Host, I was able to successfully test an ODBC connection between the VM and the host SQL2008 instance, then launch a SQL client Application on the VM that connects to a database on the SQL2008 instance.
So... What configuration do I need to do on Windows Firewall or elsewhere to make this connection more reliable?
January 19, 2010 at 10:46 am
Change the port number for your instance to a static port.
1433 is for the default instance (I apologize if my previous post was misleading - just used that as a bad example).
Use the following as a reference to change your SQL Port.
http://support.microsoft.com/kb/823938
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
January 20, 2010 at 6:30 pm
The SQLServer instance is configured with 1433 on IPall. In Windows Firewall I have a Exception for TCP Port 1433 and an exception for sqlservr.exe. Yet the VM can connect to the SQL on the host only when Windows Firewall is turned off. What more needs to happen?
January 20, 2010 at 6:41 pm
dan-572483 (1/20/2010)
The SQLServer instance is configured with 1433 on IPall. In Windows Firewall I have a Exception for TCP Port 1433 and an exception for sqlservr.exe. Yet the VM can connect to the SQL on the host only when Windows Firewall is turned off. What more needs to happen?
Also check for UDP port 1434 on your windows firewall. That port will need to be allowed through as well.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
Viewing 9 posts - 1 through 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply