Solved

MYOB AAccountants Office

Posted on 2011-09-21
9
1,135 Views
Last Modified: 2013-11-21
Hi

im having issues with running MYOB on a terminal server (2008 R2) with MYOB Data drive on a SBS 2008 server

Issue is with performance issue and also Accountants office will crash randomly

this never use to happen when the terminal servers were on 2003 machines

any help would be appreciated

Thanks
0
Comment
Question by:greymousesupport
  • 2
  • 2
  • 2
9 Comments
 
LVL 9

Expert Comment

by:ghodder
Comment Utility
In my experience it is best to store your MYOB file directly on the terminal server rather than on a share on another server. Usually this makes a big difference to performance as long as everyone is logging into the TS to access MYOB. Then share the MYOB data directory on the terminal server so your other server can back it up.

I've never seen MYOB be the reason for Office crashing, there isn't really a link between them apart from MYOB export functions and the MYOB97.DOT file Word always tries to load on startup that displays an annoying message. I always delete that file after installing MYOB.
0
 
LVL 9

Expert Comment

by:ghodder
Comment Utility
You should also make sure you purge the MYOB data at the end of each financial year, always making a copy first and noting the financial year (e.g. 2010-2011) in the file name so they can still look up sales history etc.

300MB+ MYOB files are painfully slow and it's rare that anyone needs to access prior FY data so the trouble they have to go through to load last year's file is more than made up for by the perfomance increase in day-to-day use.
0
 

Author Comment

by:greymousesupport
Comment Utility
Hi Ghodder

Thanks for the reply

just to be clearer

the software i am using is MYOB Accountants Office Classic Version 14.0.1(not microsoft Office)

And that crashes randomly

we have the data drive on the sbs because we have more then 1 terminal server

thanks once again
0
Free Gift Card with Acronis Backup Purchase!

Backup any data in any location: local and remote systems, physical and virtual servers, private and public clouds, Macs and PCs, tablets and mobile devices, & more! For limited time only, buy any Acronis backup products and get a FREE Amazon/Best Buy gift card worth up to $200!

 
LVL 1

Expert Comment

by:Bondy74
Comment Utility
Ghodder is correct about MYOB having performance issues when the data resides somewhere else on the network, it is a flaw that MYOB are supposedly rectifying in the long awaited change to their DB structure due out next year.

In the meantime, i have this installed on a few clients with Terminal server and it is on the TermServers data drive, so it is local.
You may also want to exclude from your AV scanning the MYOB working directories, myobp.exe and file extensions MYO, BOX

If your AV is correctly configured and the data is local on the TS then you should have no problems. Using the File optimization tool found in start/Myob/tools will also help fix up the data if it gets to bad.
0
 

Author Comment

by:greymousesupport
Comment Utility
HI

the product im using is MYOB accountants office with three terminal servers with round robin configured on those servers so data must be the same throughout therefore cannot put in local directory. but the fuuny thing is when i was using 2003 terminal server i never use to face this problem the problem occured when moving across to the new 2008 r2 terminal servers, the server where data is stored is the same as b4 without any change and is a sbs 2008 server

AV is already configured to exclude those files.

i was advised to switch off the smb2 feature on my terminal server and have done this which has helped a little bit but am still getting those errors

your help is much appreciated

Thanks
0
 
LVL 1

Accepted Solution

by:
Bondy74 earned 500 total points
Comment Utility
I would not think you would need to turn off SMB2, if you have a mixed environment or even if all the servers are now 2008, i would implement the following fix. the following article has microsoft KB articles to support the documentation.

http://www.danieletosatto.com/2010/10/22/smb-tuning-for-xenapp-and-file-servers-on-windows-server-2008/

I have implemented the changes here on both the 2003 servers and where i have 2008/2011 servers i have made the changes that are relevant to those O/s. On all the sites i have implemented, there has been no issues afterwards and performance with databases and Terminal session response has improved quite noticeably. You will have to reboot the servers after you have made the changes

Let me know how you get on.
0

Featured Post

The curse of the end user strikes again      

You’ve updated all your end user’s email signatures. Hooray! But guess what? They’re playing around with the HTML, adding stupid taglines and ruining the imagery. Find out how you can save your signatures from end users today.

Join & Write a Comment

I was supporting a handful of Windows 2008 (non-R2) 2 node clusters with shared quorum disks. Some had SQL 2008 installed and some were just a vendor application that we supported. For the purposes of this article it doesn’t really matter which so w…
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…
To efficiently enable the rotation of USB drives for backups, storage pools need to be created. This way no matter which USB drive is installed, the backups will successfully write without any administrative intervention. Multiple USB devices need t…
This tutorial will walk an individual through configuring a drive on a Windows Server 2008 to perform shadow copies in order to quickly recover deleted files and folders. Click on Start and then select Computer to view the available drives on the se…

772 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