Solved

Windows 7 Pro and Sage 50 simply accounting firewall port issue

Posted on 2013-10-24
1
2,047 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
Comment Utility
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

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

By now, it is common knowledge that Windows 7 has been successfully been able to live up to the hype of being touted as Microsoft’s most anticipated O.S. ever. This latest 2010 Windows release builds up on its predecessor’s positives, adding new…
The recent Microsoft changes on update philosophy for Windows pre-10 and their impact on existing WSUS implementations.
The viewer will learn how to successfully download and install the SARDU utility on Windows 7, without downloading adware.
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…

771 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

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now