SAP Business One Installation From Scratch on Microsoft SQL Server
A step-by-step walkthrough of a clean SAP Business One installation: SQL Server preparation, Server Components, the SLD, License Manager, client setup, and your first company database.
SAP B1 Academy Editorial
Published • 4 min read
Installing SAP Business One for the first time can feel intimidating: several components, a license file, and a database server that all need to talk to each other. The good news is that the process is very predictable once you know the order. This guide follows the same sequence as the video above, for SAP Business One 10.0 on Microsoft SQL Server.
What You Need Before You Start
- A supported Windows Server (or Windows 10/11 for a training or demo machine) with administrator rights.
- A supported Microsoft SQL Server version. Always check the Product Availability Matrix (PAM) for your exact Feature Package.
- The SAP Business One installation package downloaded from the SAP Software Download Center and extracted to a short path such as
C:\B1_Installto avoid path-length errors. - A license key file from SAP or your partner, or a temporary license for a demo environment.
- At least 8 GB of RAM for a single-server demo setup. Production sizing depends on users and data volume.
Step 1: Install and Prepare SQL Server
- Run the SQL Server setup and choose Database Engine Services.
- Select Mixed Mode authentication and set a strong password for the
saaccount. SAP Business One components connect with a SQL login. - Use a case-insensitive collation supported by SAP Business One.
SQL_Latin1_General_CP850_CI_ASis a common choice, but confirm it against the Installation Guide for your localization. - Install SQL Server Management Studio (SSMS) so you can check databases and logins later.
- Make sure the SQL Server service and the SQL Server Browser service are running.
Step 2: Install the Server Components
Launch setup.exe from the installation package and select the Server Components. The key pieces are:
- System Landscape Directory (SLD): the central registry of servers, databases, and licenses. It also hosts the authentication service used by clients.
- License Manager: issues licenses to users. Note the server's hardware key here; it is needed to request the permanent license.
- Server Tools: includes the Job Service, Mailer, Backup Service and other background services.
During setup you enter the SQL Server name, the sa credentials, and a password for the SLD site user (B1SiteUser). Write these down; you will need them for every future upgrade.
Step 3: Create the Common and Company Databases
- The installer creates the shared SBO-COMMON database, which stores system-wide settings.
- Optionally install a demo database (for example OEC Computers) to explore the system with sample data.
- Create your own company database later from the client via Administration → Choose Company → New, selecting your localization and chart of accounts template.
Step 4: Install the Client
Run the Client installation on the server (and later on each workstation). On first launch, point the client to the SLD server address and log in with the default manager user of the demo or new company.
Step 5: Import the License
- Open the License Control Center in the SLD web console (or Administration → License → License Administration in the client).
- Import the license key file you received for this hardware key.
- Assign license types (Professional, Limited, Indirect Access, and so on) to each user.
Common Installation Problems
- "Cannot connect to the database server": check that the SQL Server name, instance name and TCP/IP protocol are correct, and that the Windows Firewall allows port 1433 (or your instance port).
- SLD login fails: confirm the SLD service is running and that you are using the
B1SiteUserpassword set during installation. - License shows 0 licenses: the hardware key changed. Re-check the key in the License Manager and request a new license file.
Once the client opens your company and shows the main menu, the installation is complete. The next step is configuring the company: posting periods, chart of accounts, and users.
The Ultimate SAP B1 SQL & HANA Query Cookbook
Instant-download PDF playbook plus ready-to-import .sql files for Financials, Inventory Audit, Sales Margin, and Approval Alerts.