Windows firewall settings for HQ Server

[zzee]

Can anyone tell me how I should set Windows 7 Firewall for HQ Server
PC?
When firewall is off, it connects to stores (over VPN).
I did click on for HQ Server and Manager in the firewall settings.

I read on a newsgroup that
"Opening 1433 port is unnecessary and it
is dangerous. You have to configure the Windows Firewall Advanced
Configuration and enable Incoming and Outgoing settings for ICMP,
Network
Discovery and File and Printing Sharing for Private networks. Make
sure they
all communicate to all IP address in stead of just subnets."

Is this right? I don't want to open unnecessary hales.

[Wil J]

Hi all,

Well I'm probably going to get flamed for this, but wth. I run a db for a
chain of 25 stores, and our HQ database is 11g. It's also about 10 months
old, and we don't have any performance issues. We are running an excellent
server(Dual Processor 4g of ram) as our SQL server, and we only have around
1000 items. We also do not use any addons (yet), but our reseller (who
shall remain nameless) says that our DB size is fine. They have experience
with other chains who have databases of a much larger size than ours and
they don't have any issues worksheet's or reporting.

That said, are you performing maintenance on these databases? The stores
AND the hq? Are there any worksheets that haven't completed successfully?
Is windows running well on these machines? I have scheduled weekly
defrag's and daily restart.

It was recommended to me to periodically (quarterly was our solution) remove
completed worksheets, and reindex the databases. Both require exclusive
access to the database (No Pos, or manager running, no sync happening) but
may help you some.

[Wil J]

Oops, wrong thread. HQ ports are listed on ms web site. try googeling rms
hq and firewall.
"Wil J" <wi...@cjeateries.com> wrote in message
news:%23hCVI5T...@TK2MSFTNGP06.phx.gbl...