|
|
| |
SAP Business One SQL Announcement |
| SAP Business One |
|
SAP Business One is integrated, unified and streamlined accounting, CRM, and manufacturing in one software solution. Designed specifically for small and midsize businesses, SAP Business One software was also made to be affordable to acquire, implement, and maintain. It has all the power you need to manage operations, make decisions, and grow your bottom line.
| |
| |
Microsoft Has Retired its Mainstream Support for SQL 2000 as of April 8, 2008.
For SAP Business One users still running their installation on SQL 2000, this means no new functionality or Service Packs. Microsoft will continue to provide bug fixes and security fixes on demand only. We therefore recommend that customers upgrade their SQL installation to 2005 as soon as possible. Refer to the content below for additional information.
Microsoft launched SQL Server 2005 in November of 2005:
This SAP Note explains the current status of SAP's support of this database release with regard to its SAP Business One software..
Last major update: Oct 02, 2007
Other Microsoft SQL and SAP Business One related terms:
SQL Server 2005, MSSQL, SQL2005, SP1, SP2, PAM, Product Availability Matrix, Platform Validation, B12005ASP01, B1 2005 A SP01, B12005B, B1 2005 B, B12007A, B1 2007 A, B12007B, B1 2007 B, SAP Business One, SBS
Reason and Prerequisites
1. SAP publishes detailed platform support data in its "Product Availability Matrix", accessible at http://service.sap.com/pam.
a) For additional information on supported platform versions, please see the Platform Overview matrix at http://channel.sap.com/sbo/platforms.
2. This section also contains instructions on how to order the SQL Server 2005 upgrade DVD, on where to find the database upgrade guides, and on some prerequisites for the upgrade.
SAP Business One products based on Windows platforms:
| B1 Products |
Windows platforms |
| 2007 B |
x86 + x64 |
| 2007 A |
x86 + x64 |
| 2005 B |
x86 + x64 |
| 2005 A SP01 |
x86 + x64 |
| 2005 Add-Ons SP01 |
x86 + x64 |
Remarks:
- "x86" means Windows Server 2003 32-bit.
- "x64" means Windows Server 2003 64-bit.
- "SPxx" in the table above means that your system needs to be on a support package level equal to or higher of this component.
- As of SAP Business One 2007, the SAP-provided Add-Ons are an integral part of the SAP Business One installation.
- Windows Small Business Server (SBS) 2003 by default only supports 32-bit.
SAP Business One products based on SQL 2000 or SQL 2005
- All SAP Business One products of the tracks 2004 and before are only supported on SQL 2000 and are not being ported to SQL 2005.
- All SAP Business One products based on 2005 A SP01 or 2005 B that are supported on SQL Server 2000 can be upgraded to SQL Server 2005.
- The default shipment for new orders of the above two release versions is SQL 2005.
- SAP Business One 2007 is generally only available on SQL 2005.
- Exception: Customers upgrading to SAP Business One 2007 A can continue to run SQL 2000. SAP Business One will support this database platform until the end of SQL 2000 mainstream maintenance as announced by Microsoft® Corp, which is currentyl scheduled to end on April 8, 2008.
When will the SAP Business One installation and upgrade packages for SQL 2005 become available?
- The installation and upgrade packages for the supported releases are available for order.
- The installation and upgrade packages for the other 2005-based products and higher will come with their release versions.
The entries in the Product Availability Matrix will be made at the same time as the SAP Business One installation and upgrade packages will become available.
How to order the SQL Server 2005 DVD for upgrade purposes ?
Customers/partners need a valid SQL Server 2005 license acquired from SAP as well as a valid maintenance contract before they can order the SQL 2005 DVD from SAP.
- If you have purchased your SQL Server license from SAP, you are entitled to upgrade your SAP Business One system to SQL 2005. The upgrade is free-of-charge as part of the underlying maintenance contract.
- If you have purchased your SQL Server license from any other reseller or from Microsoft® Corp., you will need to contact your vendor to upgrade your license before you may install the new database release. In this case, you cannot order the SQL 2005 DVD from SAP.
- SAP Business One supports the SQL Enterprise, Standard and Workgroup Edition (the latter one is only supported with the Windows Small Business Server 2003) as database backend for the SAP Business One releases.
| |
