Configuring the Microsoft SQL Server Database
Before you install Sterling B2B Integrator with the Microsoft SQL Server database, you must configure the database.
- If you are reinstalling the software, be aware that data in your existing database is deleted. To preserve your data, either back up the existing database or save it under a different name.
- After you create and configure your database, recycle the database. Then, stop and restart to apply the changes.
- You can use the Microsoft SQL Server Always ON feature-enabled database to install Sterling B2B Integrator. This feature provides high availability at the database level. In a multi node environment, if failover occurs, the secondary node takes over as the primary node with minimal interruption.
Use the following checklist to configure Microsoft SQL Server for Sterling B2B Integrator:
| Item | Microsoft SQL Server Database Configuration Checklist | Your Notes |
|---|---|---|
| 1 | If you do not have Microsoft SQL Server installed, follow
the installation procedures in the SQL Server installation manual. Refer to the Microsoft SQL Server documentation on creating the database, including creating a schema repository, login, and table space. Be sure to install the correct version and patches. See System Requirements for supported version information. |
|
| 3 | Microsoft SQL Server database parameters | |
| 4 | Microsoft SQL Server database user privileges | |
| 5 | Configuring the snapshot feature for Microsoft SQL Server |
Note: At present, named instances of MS SQL server are not supported.