Solved

URGENT Server 2003 Domain vs. Workgroup - MYOB over LAN running extremely slow (will add more points :-))

Posted on 2006-07-05
22
739 Views
Last Modified: 2008-01-09
Hi,
Sorry this question is for so few points but thats all I have at the moment, I will add more when I get them :-)

Ok, we had MYOB Accounting Plus 15 running on an old crappy Win98 system with the data file stored on a win2003 server, via a workgroup. Since then, I've replaced all the systems with much newer P4 dell workstations running XP Pro and set them all up on a Domain.

All other systems are running fine and fast, although MYOB is now uselessly slow, as far as I can tell (and I'm fairly new to the domain scene) this slow down must be due to some difference between a workgroup and a domain.

I've tried installing/running MYOB on a different computer, running virus scans and adaware/spybot, etc. on the workstation and the server but nothing major shows up. The LAN throughput/HDD usage of the server is next to nothing, and all other system work fine even when accessing huge files (though not MYOB).

I dont understand what could cause this when the datafile is on the same server as before and its running through the same switch and even the same cables. Plus the LAN port on the server AND the 48 port D-Link switch are both gigabit.

Any and all suggestions will be greatly appriciated,

Thanks,


Ryan.
0
Comment
Question by:Nemesis09
  • 8
  • 5
  • 2
  • +5
22 Comments
 
LVL 9

Expert Comment

by:NYtechGuy
ID: 17047618
nemesis-

You should verify that the MYOB Accounting Plus 15 is in fact compatible with Windows XP.  If it is very old, and made for Win98/NT/2000 it may be suffering because XP does not handle older (16-bit) programs as quickly as the older operting systems.

If this is the case, you can right-click the main executable (myob.exe or something like that) and choose the "compatibility" tab.  On that tab, check the first box, and choose Windows 98/ME.  This does not guarantee anything, but is worth a shot.

Also, just to confirm:  you have MYOB INSTALLED on each workstation, right?  You aren't running the .exe from the server, right?  That wouldn't be suggested.

Thanks,

justin
0
 
LVL 1

Author Comment

by:Nemesis09
ID: 17047652
Thanks forthe quick reply,

MYOB 15 is the latest version which was released in 2005, plus it works fine when the data file is on the local PC.

Previously, the MYOB software was on the server and the old Win98 machine ran it from there (MYOB is the kind of program you can copy and paste, then just run the exe). But now it is actually installed on the one and only workstation which needs to run it. Although I have tried it both ways just in case.

I only installed it on another machine to make sure that the workstaion it was on wasent the problem.

Thanks,

Ryan
0
 
LVL 5

Expert Comment

by:onlinerack
ID: 17047858
Try this.... disable the virus scanner/ antispyware and any sheild you have enabled on the workstation and on the SERVER.... give it a shot and see if this helps....
It could be one of the two machines hangs on it thinking it is a suspected app.
0
 
LVL 22

Expert Comment

by:rickhobbs
ID: 17047920
Had the exact same issue with a dental office management app.  It was the Antivirus software on the server.
0
 
LVL 1

Author Comment

by:Nemesis09
ID: 17048016
At start of all this, neither the server nor workstation had any antivirus software. I'll check the windows firewall though...
0
 
LVL 4

Expert Comment

by:harryballz
ID: 17048959
MYOB runs in 2 modes:  TCI/IP or Netbios

When you bring up the login screen you can easily change it from the drop down menu ;-)

You are probably set for Netbois and it is not happy now.  Reverse them and make sure all PC's are using one or the other (don't mix!)

Also, MYOB does not scale well to 10 users as they say.   After 5-7 it gets slooooooow...
0
 
LVL 1

Author Comment

by:Nemesis09
ID: 17054905
Havent had the chance to test this yet but I think harryballz has the right idea, I knew it would be something like that. As it is though, we only have one user for that data file so all should be well.

I'll let you know how it  goes.
0
 
LVL 1

Author Comment

by:Nemesis09
ID: 17054934
...I dont have a drop down menu...

DAMMIT! I'm still sure this is the problem... I think theres no menu as this is MYOB Accounting Plus and not MYOB Premier.

If I can still change it somehow could you please let me know. Or other wise (I know server2003 domains dont use netBIOS) can I just install NetBIOS on the server and the MYOB workstation and have it run parallel to the TPC/IP?
0
 
LVL 22

Expert Comment

by:rickhobbs
ID: 17055529
What version of Accounting Plus are you running?
0
 
LVL 1

Author Comment

by:Nemesis09
ID: 17055595
15
0
What Security Threats Are You Missing?

Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

 
LVL 4

Expert Comment

by:harryballz
ID: 17056060
Man, I just got back form my client that has this setup.    We were using (all the way back to) MYOB 10 PLUS and it had both options even then.  Dig through the menu options/preferences.  Right when you login with user name/password there is the drop down.

2003 Server uses Netbios - you must be thinking of NetBEUI (the non routable protocol)

Make sure Netbios in enabled on the LAN Adapter of the server (under TCP/IP > Advanced > Wins Tab) it jsut a check box

I found that TCP works much faster on MYOB.
0
 
LVL 2

Expert Comment

by:Urlryn
ID: 17056376
I haven't touched MYOB in a while.

Like the others said before there should be a option to change to TCP/IP.

If this isn't there you could maybe try setting up a terminal server for these users to log into and do MYOB directly there.

But i'd double check on how this program handles multiple users on the local system accessing it.

I don't think it should be a problem if i remember.   Better safe then sorry!

Duane
0
 
LVL 1

Author Comment

by:Nemesis09
ID: 17069991
The version we are running is the australian MYOB Accounting Plus 15. This is only a single user version, it is not possible for more than one person to access the datafile at one time, and is designed to be run on a stand alone workstation. As such (and as I cant find it) I doubt the software will have a NetBIOS - TCP/IP setting.
Also I was under the impression that although Server 2003 supports NetBIOS normally, once it is running as a domain instead of a workgroup all connections were done through TCP/IP via the internal DNS.

I have tried ticking the enable NetBIOS checkbox on both the server and the workstation and it made no diffference.

I'm fairly new to the whole domain/server scene, but I've been playing with PC's for a long time. So far I have done absolutley nothing with terminal servers, but I'm not sure if that would work and if it did I think that maybe it would be overkill.

All it needs to be is a single user on a single workstation accessing a single datafile stored on the server. Just like you could open/edit/save a word document if it was stored on the server. Nothing fancy.

Thanks for all your input so far.
0
 
LVL 4

Expert Comment

by:harryballz
ID: 17070100
Hey Nemesis09,

Sounds like running it across the network is the problem then.  It probably was designed to run "locally" only - mapping a drive might help but why go through all that if its just 1 user?  Just install it on the main machine and back that up.  Sometimes overcomplicating things is not the solution :-)

Also, you may not be able to see that NetBIOS/TCP switch becasue you only have 1 license, adding a second would make it "network aware".
0
 
LVL 1

Author Comment

by:Nemesis09
ID: 17070608
The version we have is not technically networkable, and does not support more than one user/licence. There is a different version speciffically for that.
I do agree that that would be the simplest solution, and more and more likley the only one and I'm currently working on an automated backup program for that.

None the less, I dont understand why this same software, installed from the same CD, even using the same data file ran perfectly over the same network, on the same server, even using the same cables and the same port on the same switch.

All that has changed is the PC went from a 300MHz with Win98 to a 1.9GHz with WinXP, and the network went from a workgroup to a domain.
0
 
LVL 4

Expert Comment

by:harryballz
ID: 17070647
I agree...a little weird.

My other thought (before giving in! - I hate giving in as you might have seen by my ridicules answer rate) is trying to run the .exe in Compatibility Mode of Win 98.  Just right click the .exe > Properties > Compatibility ...choose Win 98.  If the bug was on the "XP" side of things this may fix it.  If its "Domain" side your proably done and best off using it locally.
0
 
LVL 1

Author Comment

by:Nemesis09
ID: 17078345
Yeah, I know what you mean... after all the time and money lost on trying to get this to work, I've finally resigned to writing an automatic backup/synchronization program that sync's the any changed files in the local data file folder with the one on the server, and set it as the logoff script.

It works now... and I guess thats the point, but still its a hollow victory... I never liked MYOB anyway... good thing I'm in IT and not accounting.

It just makes no sense that it takes 10 minutes to read a report from the data file, but the same system can copy the entire file from the server to the local HDD in 20 seconds...

Ah well, thanks to all for your input, especially harryballz.

NEVER SAY DIE!
0
 
LVL 4

Expert Comment

by:harryballz
ID: 17391761
We did resolve it... application was not the networkable version - single license only.

(don't know why he never awarded points only had 45 - tight on money/points - but if someone runs into this they could at least have the solution :-)
0
 
LVL 22

Expert Comment

by:WMIF
ID: 17392261
sounds good to me.
0
 
LVL 1

Accepted Solution

by:
DarthMod earned 0 total points
ID: 17410753
PAQed with points refunded (45)

DarthMod
Community Support Moderator
0

Featured Post

Free Trending Threat Insights Every Day

Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

Join & Write a Comment

Meet the world's only “Transparent Cloud™” from Superb Internet Corporation. Now, you can experience firsthand a cloud platform that consistently outperforms Amazon Web Services (AWS), IBM’s Softlayer, and Microsoft’s Azure when it comes to CPU and …
Join Greg Farro and Ethan Banks from Packet Pushers (http://packetpushers.net/podcast/podcasts/pq-show-93-smart-network-monitoring-paessler-sponsored/) and Greg Ross from Paessler (https://www.paessler.com/prtg) for a discussion about smart network …
After creating this article (http://www.experts-exchange.com/articles/23699/Setup-Mikrotik-routers-with-OSPF.html), I decided to make a video (no audio) to show you how to configure the routers and run some trace routes and pings between the 7 sites…
Here's a very brief overview of the methods PRTG Network Monitor (https://www.paessler.com/prtg) offers for monitoring bandwidth, to help you decide which methods you´d like to investigate in more detail.  The methods are covered in more detail in o…

747 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

9 Experts available now in Live!

Get 1:1 Help Now