Solved

Windows 7 Pro and Sage 50 simply accounting firewall port issue

Posted on 2013-10-24
1
2,145 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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

Creating Instructional Tutorials  

For Any Use & On Any Platform

Contextual Guidance at the moment of need helps your employees/users adopt software o& achieve even the most complex tasks instantly. Boost knowledge retention, software adoption & employee engagement with easy solution.

Question has a verified solution.

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

Article by: Lee
Windows 7 Ultimate and Enterprise (and 2008 R2) introduced a new feature you may not be aware of - Boot from VHD.   Boot from VHD (or what Microsoft refers to asNative Boot allows you to install Windows to a VHD (Virtual Hard Disk) file that is t…
First some basics on Windows 7 Backup.  It has 2 components one is a file based backup which is stored in .zip files each zip is split at around 200 Megabytes and there is the Image Backup which is as the name implies a total image of the partition …
This Micro Tutorial will give you basic overview of the control panel section on Windows 7. It will depth in Network and Internet, Hardware and Sound, etc. This will be demonstrated using Windows 7 operating system.
The Task Scheduler is a powerful tool that is built into Windows. It allows you to schedule tasks (actions) on a recurring basis, such as hourly, daily, weekly, monthly, at log on, at startup, on idle, etc. This video Micro Tutorial is a brief intro…

717 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