Solved

Windows 7 Pro and Sage 50 simply accounting firewall port issue

Posted on 2013-10-24
1
2,093 Views
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?
0
Comment
Question by:johnny181
1 Comment
 
LVL 24

Accepted Solution

by:
smckeown777 earned 500 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
0

Featured Post

Live: Real-Time Solutions, Start Here

Receive instant 1:1 support from technology experts, using our real-time conversation and whiteboard interface. Your first 5 minutes are always free.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Windows 7s template 4 61
M2 SSD questions 14 31
What processes are using my external hard drive 2 25
New User Account Creation Issue 4 19
New Windows 7 Installations take days for Windows-Updates to show up and install. This can easily be fixed. I have finally decided to write an article because this seems to get asked several times a day lately. This Article and the Links apply to…
When you start your Windows 10 PC and got an "Operating system not found" error or just saw  "Auto repair for startup" or a blinking cursor with black screen. A loop for Auto repair will start but fix nothing.  You will be panic as there are no back…
This Micro Tutorial will give you a introduction in two parts how to utilize Windows Live Movie Maker to its maximum editing capability. This will be demonstrated using Windows Live Movie Maker on Windows 7 operating system.
The viewer will learn how to successfully download and install the SARDU utility on Windows 7, without downloading adware.

785 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