X-ERP Help

03. Install MS SQL Server 2025

Install the central X-ERP data platform with appropriate instance, collation, service accounts, storage structure and FILESTREAM activated.

The shared truth of the enterprise lives in SQL Server. That's exactly why performance doesn't start with tuning, but rather with a consciously installed instance.

Why this station counts

X-ERP uses a named SQL instance – “X” in the documented standard – and requires a collation that matches the solution. FILESTREAM enables the intended storage of large attachments in conjunction with the database.

The resilient process

  1. Start the setup with the released SQL Server version and only install the required components.
  2. Assign the planned instance name and separate service accounts.
  3. Select the collation and authentication strategy specified for X-ERP.
  4. Configure data, log, TempDB and backup paths on appropriate volumes.
  5. Activate and check FILESTREAM according to X-ERP specifications.
  6. Install current updates and document build and configuration.

Functional test - only then continue

  • SQL service starts after restart.
  • Connection via the planned server/instance name works.
  • Collation and FILESTREAM correspond to the specifications.
  • Data, log and backup paths are in the planned location.
  • A backup and restore test is possible.

If the result is not correct

  • An incorrect collation is often only noticed during sorting or comparison.
  • SQL data and backups on the same volume share a point of failure.
  • Continuous use of a highly privileged setup account violates the minimal principle.

This is what you take with you

The data platform is reproducibly configured and ready for XLD and company databases.

Video

Install MS SQL Server 2025

Further information / source

Related topics

  1. For system administrators – set up servers and create company databases › 06. Install X-ERP-LandscapeDirectory-Creator and create XLD database
  2. For system administrators – set up servers and create company databases › 07. X-ERP-Company-Creator (create company database/client)
  3. For system administrators – setting up servers and creating company databases › 13. Backup, monitoring and recovery

Frequently asked questions

**Why is collation important?**

Among other things, it determines the comparison, sorting and capitalization of text values. Use the released X-ERP default.

**What is FILESTREAM used for?**

It combines large binary content with SQL transactions and stores them in a file system area configured for this purpose.