Re: Strange connection problem


"Erland Sommarskog" <esquel@xxxxxxxxxxxxx> wrote in message
news:Xns9AABEE839705EYazorman@xxxxxxxxxxxx
Greg Hines (ghines@xxxxxxxxxxxxxxxxxxxxxxxxx) writes:
MSDE2000 installed on 2003 Server.

With Windows Firewall turned ON, users in the same workgroup as the 2003
Server can connect to the SQL Database. Users on a different Workgroups
cannot connect to the SQL Database using either IP or ComputerName.

With the Firewall turned OFF, all users from all Workgroups can connect
to
the SQL Database.

Can anyone explain to me why users in the same Workgroup can connect to
the SQL Database with the Firewall ON, while the Firewall must be turned
OFF to enable users from a different Workgroup to connect?

I assume the users connect with SQL authentication?

I would look for the answer in the firewall configuration. The default
is that no one could connect to SQL Server when Windows Firewall is on.
So if users in the same workgroup can connect, I suspect that someone
open port 1433 in the firewall. But possibly he only opened the port for
some IP addresses?


Yes, SQL authentication only.

I've found nothing about any firewall ports being open. So I opened port
445 (Named Pipes) and I'm still getting the same results. Seems very
strange to me.

Greg


.

Relevant Pages

  • Re: Port for Adding PC to Domain
    ... > I have Win2003 Server running. ... Some PCs are on a Workgroup and I would ... What port on the firewall do I open to allow ... I usually turn off the firewall until the workstation is ...
    (microsoft.public.windows.server.general)
  • Re: Addressing web pages on another workgroup computer
    ... The firewall, of course. ... I have now set up my IIS to work on a different port, ... I can now access IIS from anywhere in my workgroup by adding the port number ...
    (microsoft.public.inetserver.iis)
  • Port for Adding PC to Domain
    ... I have Win2003 Server running. ... Some PCs are on a Workgroup and I would like ... What port on the firewall do I open to allow ...
    (microsoft.public.windows.server.general)
  • Re: Can not find other devices on Network
    ... The link you specified shows the workgroup the way it displays in XP. ... Network traffic as trusted. ... start by running the Network Setup Wizard on all machines (see ... by 1) a misconfigured firewall or overlooked firewall (including a stateful ...
    (microsoft.public.windows.vista.networking_sharing)
  • Re: Can not find other devices on Network
    ... The link you specified shows the workgroup the way it displays in XP. ... Network traffic as trusted. ... start by running the Network Setup Wizard on all machines (see ... by 1) a misconfigured firewall or overlooked firewall (including a stateful ...
    (microsoft.public.windows.vista.networking_sharing)