Solved

Windows 7 Pro and Sage 50 simply accounting firewall port issue

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

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Suggested Solutions

One of the features I've come to appreciate about Windows 7 and Windows Server 2008 R2 is the ability to pin applications to the task bar. As useful a feature as I've found this, it does have some quirks.  For example, have you ever tried pinning an…
If you get continual lockouts after changing your Active Directory password, there are several possible reasons.  Two of the most common are using other devices to access your email and stored passwords in the credential manager of windows.
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.
This Micro Tutorial will give you a basic overview of Windows Live Photo Gallery and show you various editing filters and touches to photos you can apply. This will be demonstrated using Windows Live Photo Gallery on Windows 7 operating system.

839 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