Windows firewall settings for HQ Server

Jul 16, 2010 2 Replies
Z

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.


Vote
Twitter Facebook LinkedIn
W

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.

Vote
Twitter Facebook LinkedIn

Join the Discussion

Have something to add? Share your thoughts — no account required.

Didn't find your answer?

Ask the community — no account required