Windows 7 Pro and Sage 50 simply accounting firewall port issue
Posted on 2013-10-24
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.