Strange connection problem

Hi Everyone,

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?

TIA

Greg


.

Relevant Pages

  • Re: Strange connection problem
    ... With Windows Firewall turned ON, users in the same workgroup as the 2003 ... Server can connect to the SQL Database. ... open port 1433 in the firewall. ...
    (comp.databases.ms-sqlserver)
  • Help adding users for sql connection
    ... used to allow them access to the sql database. ... workgroup called IT now since they are no longer on the domain they cannot ... passwords for each user? ... John ...
    (microsoft.public.sqlserver.security)
  • Setup a backup server
    ... i've got a w2k server running with SQL database; server is not a DC; ... it's simply a workgroup; how to set up another w2k server as an onlie ...
    (microsoft.public.windows.server.setup)
  • Re: [SLE] Network Confusion (Long Post)
    ... You have a linux samba server - please post the smb.conf file. ... Attempting to become logon server for workgroup ASTRA_ENT on subnet 192.168.2.2 ... Attempting to become domain master browser on workgroup ASTRA_ENT, ...
    (SuSE)
  • RE: Upgrade to Premium After Installing WSS 3.0
    ... This newsgroup is primarily for issues involving deployment, configuration, ... Installing SQL Server 2005 WorkGroup Edition in Windows Small Business ...
    (microsoft.public.windows.server.sbs)