Monday 24 January 2011

SBS 2011 – Simply Accounting Firewall Exceptions Needed for Db Manager and MySQL

It seems that Simply Accounting’s database manager will need to be allowed through the Windows Firewall with Advanced Security:

image

When we look in the Windows Firewall log we see lots of dropped packets:

image

The base connection port required is 13531:

image

While that port is listed in the dropped packets list, there are also others. So, we need to make an exception for the Simply Database Manager program as well as others.

  • Simply Connection Manager
    • image
  • Simply Tray Icon
    • image
  • Simply’s MySQL Daemon
    • image
  • Simply’s MySQL Admin Service
    • image

Once the rules were created we restarted the Simply Accounting Database Manager in Services.msc we were able to make a successful company file connection to the server.

We will also be setting this configuration into our GPO linked to the Computers OU so that any workstation or Remote Desktop Server will not get hung up on Simply connections.

Philip Elder
MPECS Inc.
Microsoft Small Business Specialists
Co-Author: SBS 2008 Blueprint Book

*Our original iMac was stolen (previous blog post). We now have a new MacBook Pro courtesy of Vlad Mazek, owner of OWN.

Windows Live Writer

2 comments:

Colm said...

Thanks Philip, that worked for me with Simply Accounting Premium 2010 on SBS2001. Much appreciated.

Anonymous said...

Thanks, worked for me.

Henri