System Requirements - SQL Server
  • KB ID: AA-00985
  • Created: 04/04/2017 4:27 PM
  • Updated: 04/10/2018 11:44 AM
  • Views: 2306
  • 0 Ratings

Symptoms

The Setup reported an error during the prerequisites check for the SQL server.

Cause

This can by caused by one of the following issues.

  1. SQL Server Version is not within the allowed range

Resolution

The SQL Server requirements are shown below.

  • Supported Versions
    • Microsoft SQL Server 2017
    • Microsoft SQL Server 2016 SP1 (Recommended)
    • Microsoft SQL Server 2014
  • Supported Editions**
    • Express (max Database-Size 10 GB, max RAM 1410 MB, max CPU 1 Socket or 4 Cores, max 1 Instance) 
    • Standard
    • Business Intelligence (only 2014)
    • Enterprise
  • Required Settings
    • Installation requires "SQL Server and Windows Authentication mode" to be enabled. 
    • The SQL Browser service must be running. 
    • TCP/IP protocol has to be enabled (Static Port recommended)
    • The Windows firewall must be configured for the network access of the SQL Server and the SQL Browser.

More Information

If you choose to provide databases and not let them be created through the setup, please note the following important points.

  • The names of the databases can be chosen individually, the name may not begin with a digit.
  • The names of the databases can be chosen individually, the name may not contain the following characters: - \ / " | <> : * ? ] [ + = ; , @ & .
  • The names of the databases can be chosen individually, the name may not contain unicode characters.
  • All databases have to have the same collation. It has to be a case insensitive (CI) collation, e.g. SQL_Latin1_General_CI_AS
  • Some special identifier columns will use: Latin1_General_BIN
  • All databases for installation have to be completely empty
  • The name for the Columbus Core database is <Columbus>
  • The name for the Columbus Audit database is <Audit>
  • The name for the Columbus EndPoint database is <EndPoint>

 

Keywords

SQL Server, Database, Collation

Products

C7

Feedback

Did you find this article helpful?

© 2000-2018 Brainware Consulting & Development AG     Impressum / Legal Notice  |  Datenschutz / Privacy Policy