Welcome to MSDN Blogs Sign in | Join | Help

Jesper's blog about integrating with Office Accounting

This blog discusses how to write applications that integrate with Office Accounting.
Max number of users?

This topic came up a lot in SBA 2006 and I see it still causes some misunderstandings in places. So I thought I'd blog about it here and link to it in future news group postings.


There is no preset limit to the number of users in Office Accounting - concurrent or otherwise.
The old MSDE (used by SBA 2006) used to have a built-in performance degration when more than 5 concurrent connections were used (concurrent workload governor - a performance throttle). Note that even that did NOT translate into a maximum number of users - you could have an unlimited number of users and only if more than 5 just happened to use a connection at the exact same time would it result in a performance degration.
But there is no such limitation in SQL Express 2005 - instead they have created other limitations like; never use more than one CPU, max use 1Gb RAM, and max size of each database (4Gb).


Here's a link to a page explaining the limits of SQL Express 2005 :
http://msdn2.microsoft.com/en-us/library/ms165672.aspx
If you want to overcome those limitations you can easily use the full SQL Server 2005 instead.


In fact Office Accounting should scale very well since it relies on Sql Server - but you might find that if your company grows to more than 25 employees it could require more advanced accounting software with more features than Office Accounting.


 

Posted: Wednesday, November 08, 2006 10:21 AM by Jesper Birk Olsen
Filed under: , ,

Comments

Chris Schatte said:

Thanks very much for the blog!

# November 10, 2006 9:36 PM

CyberROB410 said:

Hi Jesper,

I am pulling my hair out trying to get OA2K7 Pro working with a SQL Server standard database server.

How does one go about using SQL Server Standard rather than installing the Express on the local machine? There is virtually no documentation on how to go about this.

I've been tweaking variations in my sbc and instance configurations for about 2 hours now to no avail.

The scenario is I want to use the OA2K7 client as a stand alone, and have my SQL Server on my database server be the data store. It seems no matter what I try, it attempts to connect to an Express named instance.

Any help would be appreciated.

-Rob

# December 27, 2006 1:25 AM

Jesper Birk Olsen said:

Just got back from vacation - glad you found the answer already.

Thx.

# January 4, 2007 1:25 PM
Anonymous comments are disabled
Page view tracker