What Kind of Database Works with AAMail Mail Server

2015/04/02 12:15

AAMail supports two kind of databases, they are Access and SQL Server databases. You can choose an appropriate database according to your business size and mail counts. We recommend that you choose the relevant version of SQL Server 2005. If you have already installed SQL Server on your server, please note that SQL Server must support the "user name + password" authentication mode. If it is "Windows Integration Authentication Mode", then please refer to "Set Windows Integration Authentication Mode".

Platform recommend: Windows 2003 Server + SQL Server 2000 Standard Edition or Enterprise Edition

Price-performance ratio recommend: Windows 2003 Server + SQL Server 2000 Standard Edition or above

Recommendation Order	Database Type	Number of Accounts	Features
1	SQL Server 2000/2005/2008 Standard / Enterprise Edition	All enterprises (more than 120 accounts)	Good performance, but you need to install the SQL Server by yourself
2	SQL Server 2000/2005/2008 Express (free)	Small and medium-size enterprises (50-120 accounts)	Free, physical file limit 2G/4G, but you need to install the SQL Server by yourself
3	Microsoft Access (Free)	Small enterprises (less than 50 accounts)	Free, limited performance, no need to install, but it needs to be compressed regularly

Note: If it is 64bit Windows platform, then you need to install 64bit version of SQL Server and 64bit version of SQL Server Management Studio Express. If you are using Windows 64 + Access database, then you need to enable the 32bit mode in Windows IIS, because Access ADO connection is 32bit. For details, please refer to "Notes when Install Mail Server on Windows 64bit".