Microsoft SQL Server

This help file applies to an out-of-date version of MainBoss.
The most recent version of MainBoss is MainBoss 4.2.4.
This help file does not exist in MainBoss 4.2.4, but the index for that version can be found here.

< Previous section | Table of Contents | Index | Next section >

MainBoss Advanced uses Microsoft's SQL Server 2005, 2008, or 2008 R2 to read and write all data. SQL Server must be installed at your site before you can begin using MainBoss Advanced. Specifically, you must have:

SQL Server 2005 SP3 (Version 9.00.4035.00 or greater), or
SQL Server 2008 SP1 or SQL Server 2008 R2
SQL Server 2012

MainBoss doesn't work with earlier versions of SQL Server.

If you've installed MainBoss, you can determine what version of SQL Server you have by going to Help →> About in the MainBoss menus.

While this Installation and Administration Guide offers suggestions of how to work with SQL Server, SQL Server is a Microsoft product and Thinkage has no control over its behavior. If you have any difficulties with SQL Server, contact Microsoft, not MainBoss support.

SQL Server is actually a family of compatible software products, with different members of the family designed for different work loads. If you have a small organization, you can use SQL Express, a free version of SQL Server available from Microsoft. For more information, see SQL Express Considerations.

SQL Express will likely be adequate if you intend to run the SQL Server on Windows XP Windows XP Pro (which supports fewer than five simultaneous users). The same applies to Windows 7 and Vista. If you will have more than five simultaneous users, you should run SQL Server on Windows Server 2003 or Server 2008 and buy a version of SQL Server whose size is appropriate to your needs.

If you intend to have multiple people using MainBoss, or you intend to access MainBoss from multiple machines, you should install SQL Server Management Studio and the configuration tools at the same time that you install SQL Server. This is discussed in the Appendix.