02-21-2013 10:03 AM
Currently I have a database ACT! 2013 Premium
I have currently 25 users
But I'll have 15 more users.
I must do something with the version of SQL Server 2008 R2 Express?
I need to upgrade to the Standard version??
What is the limitation of SQL Server 2008 R2 Express in terms of number of users?
Thanks for the help
02-21-2013 12:22 PM
Greig Hollister
Note: Effective 6/1/13, Sage no longers provides support for the Act! software. This is now provided by Swiftpage.
02-21-2013 10:34 AM
I don't believe there's a limit on the number of users. There is a limit on the database size. The big issue with that many users is performace. The SQL Express is limited on how much memory it will use and it will only use one processor regardless of what the server has available. I would definitely upgrade to SCL Standard.
02-21-2013 12:22 PM
Greig Hollister
Note: Effective 6/1/13, Sage no longers provides support for the Act! software. This is now provided by Swiftpage.
02-21-2013 03:48 PM
Yup, there are only three limitations that SQL Server 2008 R2 Express has, 1CPU, 1GB of RAM for the instance, 10GB file size. Going to SQL STD removes those limits. There is no user limit.