Topic: Microsoft Office Accounting 2008

[RupertTHEbare]

I have the latest SME 7.x ISO image on a CD and Microsoft Office Accounting 2008 3-user to install on a Dell Poweredge 830 (3.2GHz/1GB/140GB/DLT) server Windows XP Pro workstations. 

Has anyone done this already and if so, can you give me any tips or guidance to avoid any problems? 

There seems to be a real lack of how-to's regarding Microsoft Office Accounting in a mult-user invironment, let alone using a Linux server with a SAMBA hosted data file. 

Any help at all would be much appreciated.

RTB.

[Stefano]

IMO this is a question you should post in another place..

infact it's a m$ or samba issue, not a sme one.

Ciao
Stefano

[RupertTHEbare]

You could be right, but I posted it in here because I couldn't find anywhere more appropriate. 

I had in mind that it would be more of a "How-to" issue.

[gippsweb]

As long as the ibay is shared to all users and the ibay is a mapped drive on the pc's it shouldn't ba a problem.
I haven't used MS Accounting but have been running Quickbooks that way for a few years now.

[RupertTHEbare]

Yes, that is the way I thought it would go as we were running Quickbooks before, but unlike QB, which has an individual internal QB defined profile for each QB user, MOA uses the Windows security model and takes its security levels from Windows' inbuilt User profiles plus an access level which is set internally per Windows User inside MOA.  I wasn't expecting this level of security/complication for Samba to have to deal with.  If it were simply file serving from a HDD which it made look like any other drive on the network, a la QB, then OK, but I don't know how Samba will cope with individual domain level security profiles rather than simple workgroup security.  Maybe I should be asking this question over at the Samba site.

[pfloor]

I'm pretty sure that MS Office Accounting 2008 in a multi-user install requires MSSQL be installed on the "Main" computer sharing the data.  This is done in one of 3 ways:

1-Install Accounting on the "Main" client (XP SP-2 or later) and the installation automatically installs MSSQL-Express.
2-Install Accounting on a server (Server 2003 SP-1 or later) and the installation automatically installs MSSQL-Express.
3-Install Accounting on a server (Server 2003 SP-1 or later) with MSSQL installed and configure Accounting to use MSSQL.

[RupertTHEbare]

Yes, I have come to the same conclusion as, having progressed a little further by installing it locally, I can now see that MOAP is dependent upon Microsoft's SQL server, so that is going to put paid to running it on SME, I imagine, unless I can find a way to get it to use MYSQL.  

[thomasch]

unless I can find a way to get it to use MYSQL.   

You want it only for 3 user. What if you install MSSQL on MSWindows on VMware on SME server ?

my 2 cents.

thomas

[p-jones]

I have installed VMWare onto SME V7.2 as instructed in the WIKI, then installed XP Pro and SQLExpress and setup an MSSQL application.

All seemed to work reliably although performance was a bit down. Having said that, I havent done anything about tweaking anything for performance. At certain times of SME updates, the VMWare needed to be reactivated. That is a simple enough task, just annoying to have to keep doing.

I dont have it in production and my work was only exploratory in so far I a need an option for a possible future server upgrade.

I am interested in other users experiences or progressions beyond where I left off. In my part of the world, I am seeing a number of developers embracing SQLExpress (YUK) because it is a freebie (so far) and I think we will see more and more applications requiring this.

[RupertTHEbare]

You want it only for 3 user. What if you install MSSQL on MSWindows on VMware on SME server ?

If I were doing it for my own office, I might be tempted to virtualize in order to provide a solution.  The problem that I have here Thomas is that I am not always present and cannot sometimes get to this particular site and there is nobody there that can deal with the level of complexity and support issues this will probably throw up.  Great fun for US to play with a learn from in the 'lab' of our own office/study, but nightmares waiting to happen for neophite business owners and non-techie users.