Can't connect to SQL Server 2005 on Virtual PC 2007 guest

I am running Windows 7 Ultimate with Virtual PC 2007 installed.  I also have Visual Studio 2008/2010 installed, and Norton Internet Security 2011.  

I setup Windows XP SP3 on a virtual machine (with a static IP) and installed SQL Server 2005 Developer.  I turned off Windows Firewall on the guest.  I can ping the guest VM from the host and vice-versa.  The guest can browser the internet.  I can access the guest via VNC as well.

I cannot connect to SQL Server on the guest via ODBC from the host.  I have used both the SQL Native Client and  SQL server drivers.  With SQL Native Client I get the errors:

Connection Failed"
SQL State: '08001'
SQL Server Error: 10061
.... No connection could be made becuase the target machine actively refused it.

Connection Failed:
SQL State: 'HYT00'
SQL Server Error: 0
... Login timeout expired

Connection Failed:
SQL State: '08001'
SQL Server Error: 10061
...  An error has ocurred while establishing a connection to the server.  When connection to SQL server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections.


In SQL Server I allowed remote connections and enabled TCP/IP and Named Pipes.  I also turned off everything in Norton but still no luck.  

Need an answer or guidance about how to debug the problem to get more info to get an answer.
ByronJAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

tigin44Commented:
did you check the firewall settings on the guest? You should disable or set an exception rule for the sql server related ports...
0
arnoldCommented:
Make sure that you enabled TCP/IP under the microsoft sql configuration tool.
0
ByronJAuthor Commented:
tiqin44: I turned off the firewall on the guest

arnold: I enabled TCP/IP and named pipes using the SQl config tool

Are there some low level tools that I can use on the host to diagnose where things are breaking down?  I enabled logging in ODBC but it didn't show anything.  There is nothing in the Event Logs either when the connection fails.
0
Big Business Goals? Which KPIs Will Help You

The most successful MSPs rely on metrics – known as key performance indicators (KPIs) – for making informed decisions that help their businesses thrive, rather than just survive. This eBook provides an overview of the most important KPIs used by top MSPs.

arnoldCommented:
When you connect to the sql server locally using SSMS, check the properties of the server to see whether it is configured to use windows authentication or mixed mode.
can you: telnet <mssqlservername> 1433?

you need to look at the firewall on the virtual PC, also check what IP does the virtual PC system has, make sure it is on the LAN as is the other system.
0
ByronJAuthor Commented:

I decided to install SQL Server on the host instead and was able to access it from the guest.  Not optimal, but it works so I will have to go with this solution as I need to move on.  

Thanks for your comments and assistance.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
arnoldCommented:
For Host to access resource of the guest, the Guest IP must not be NAT but it should be bridged to the host such that both systems will have an IP on the same LAN.
0
ByronJAuthor Commented:
I need to move on and found a workaround.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server

From novice to tech pro — start learning today.