Windows 7 Pro and Sage 50 simply accounting firewall port issue

Posted on 2013-10-24
Medium Priority
Last Modified: 2013-10-27
I just installed a new Windows 7 Pro workstation into an office to replace an existing PC running Windows XP Pro. It was running the latest version of Sage 50 accounting and shared the database to three other stations running XP and Windows 7.

I installed the Sage 50 software and then opened the database. I went over to another computer opened up Sage 50 and then pointed the new location to the new workstation share. I received an error. I double checked that I had ports 13531, 13540, and 13541 open on the new workstation even though I had the firewall turned off.

On the XP machine, I opened a telnet session and tested all three ports. 13531 opens fine but 13540 and 13541 both fail. check the firewall again and nothing. (By the way, I did call Sage support and they are the one's that told me to telnet into all three ports and basically quit talking to me after I was not able to telnet to the last two...

...so as I go through this, I ask myself, doesn't something on the Windows 7 Pro machine have to be running a program that is receiving data from ports 13540 and 13541?

(Side note, telneting to those two ports on the 'retired' workstation that hosted the data gave me the same results, works for 13531 but not the other two as I suspected.)

Anyway, the error that I get within Sage is "The connection manager could not start the database engine. The database engine returned an error"

Not sure where to find that error but that is my problem.

Any ideas?
Question by:johnny181
1 Comment
LVL 24

Accepted Solution

smckeown777 earned 2000 total points
ID: 39600724
Did you turn on Windows File&Print Sharing on the new Win7 box?

I'm not a Sage expert at all but possibly this is a simple file sharing issue
Go into Network and Sharing center
Left hand column click Advanced Sharing settings
Make sure Network Discovery and File&Print Sharing are on

If the old station doesn't show anything listening on ports 13540&13541 then that tells me this isn't a firewall issue at all...yes something needs to be opened and listening for you to get a response on those ports

Download this application on the old station and run it - it will show the listening ports and numbers - http://www.nirsoft.net/utils/cports.html

See what ports are listening on the old machine while you've clients connected - then do the same on the new box - if something doesn't match then you can work from there...if all does match then its not a firewall issue...

Also what AV have you on the new Win7 machine? Some AV products come with firewall sections that might be getting in the way so that's another thing to check

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

IF you are either unfamiliar with rootkits, or want to know more about them, read on ....
In a question here at Experts Exchange, a member was looking for "a little app that would allow sound to be turned OFF and ON by simply clicking on an icon in the system tray". This article shows how to achieve that, as well as providing the same OF…
In this Micro Tutorial viewers will learn how to use Boot Corrector from Paragon Rescue Kit Free to identify and fix the boot problems of Windows 7/8/2012R2 etc. As an example is used Windows 2012R2 which lost its active partition flag (often happen…
Want to learn how to record your desktop screen without having to use an outside camera. Click on this video and learn how to use the cool google extension called "Screencastify"! Step 1: Open a new google tab Step 2: Go to the left hand upper corn…

587 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question