Re: How to make different instances of SQL Server visible to each other?

Hi,

in addition you will have to make sure that you configured your firewall to let the Virtual PC access your host PC. it sometimes saw this, that although ICMP was working the host refused to establish connections to the VPC if they used Shared networking and not NAT.

HTH, Jens K. Suessmeyer.

---
http://www.sqlserver2005.de
---




"Rick Byham, (MSFT)" <rickbyh@xxxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message news:F0034F02-B236-4402-9180-7817FA21CB9F@xxxxxxxxxxxxxxxx
This should work pretty much like connecting any other two computers.
1) Can each computer ping the other successfully using TCP/IP? If not, it's a virtual server problem.
2) Is the firewall on each computer configured to allow access through TCP port 1433 (if you are using the default settings for a default instance)? If not, change the firewall settings.
3) Is each SQL Server accepting TCP/IP connections? Check using the SQL Server Surface Area Configuration tool.
4) If you are not using the default TCP port or if you installed a named instance is the SQL Server Browser service running on each computer/virtual machine to resolve the instance name to the port number? If not, start the SQL Server Browser service.
--
Rick Byham (MSFT)
This posting is provided "AS IS" with no warranties, and confers no rights.

"keith" <kbrickey@xxxxxxxxxxxxxx> wrote in message news:%23QcBFI0SHHA.3428@xxxxxxxxxxxxxxxxxxxxxxx
Two instances of SQL Server 2005 cannot "see" each other. One is Developer edition and one is Standard edition. Standard editon is running under Virtual PC. I would appreciate any suggestions on how make these two instances visible to each other.

Thanks,

Keith



.

Relevant Pages

  • Re: 2008 Server w/2008 SQL EE on a SBS2K3
    ... When trying to connect from the SBS 2003 box to the new ... I have tried authenticating with both Windows and SQL Server authentication. ... Configuring the Windows Firewall to Allow SQL Server Access ... How about in the SQL Server Configuration ...
    (microsoft.public.sqlserver.setup)
  • Re: Client End Firewalls
    ... it doesn't matter if the email client can't be tricked when the ... control such things on a Windows 98 box. ... > than getting the client firewall properly configured. ... > additional costs for configuration and configuration-changes? ...
    (Security-Basics)
  • Re: Cant Ping Windows 2003 server after R2 Upgrade..HELP!
    ... UPDATE* -- i've enabled to the windows firewall just to see what can be ... i then adjust the ICMP setting to allow ALL icmp. ... Enable 3 Allow outbound destination unreachable ... ICMP configuration for Local Area Connection 7: ...
    (microsoft.public.win2000.active_directory)
  • Re: R2 in-place upgrade bug ? ..HELP
    ... UPDATE* -- i've enabled to the windows firewall just to see what can be done ... Enable 3 Allow outbound destination unreachable ... Enable 9 Allow inbound router request ... ICMP configuration for Local Area Connection 7: ...
    (microsoft.public.windows.server.active_directory)
  • Re: Client End Firewalls
    ... depending on the firewall's configuration). ... Even if a client side firewall was to block just one ... Using a firewall with password protection is a must. ... >> connections. ...
    (Security-Basics)