Spider Setup: System Requirements - SQL Server

[#1]

Summary

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

Current Spider version is 6.4.x.

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.

• Spider 6.4
  • Microsoft SQL Server 2012 or newer
• Spider 6.3
  • Microsoft SQL Server 2008 or newer
• Spider 6.2
  • Microsoft SQL Server 2008 or newer
• Spider 6.1
  • Microsoft SQL Server 2008 or newer
• Spider 6.0
  • Microsoft SQL Server 2005 or newer
• Recognition
  • Microsoft SQL Server 2008 or newer

• Recommended Version:
  • Microsoft SQL Server 2016 Standard (64bit)
• Supported Versions
  • Microsoft SQL Server 2019
  • Microsoft SQL Server 2016
  • Microsoft SQL Server 2014
  • Microsoft SQL Server 2012
  • Microsoft SQL Server 2008 / 2008 R2*
• Supported Editions**
  • Standard - for single Mandator environments
  • Enterprise - for multi Mandator environments
  • Express - for very small environments, please note some restrictions apply
• Required Settings
  • TCP/IP protocol has to be enabled
  • Named Pipes protocol has to be enabled
  • Installation requires "SQL Server and Windows Authentication mode" to be enabled, After the first installation you can switch the SQL Server to "Windows Authentication mode"

* Versions 2008 / 2008 R2 will no longer be supported by Spider 6.4 or better.
** Always On Availabilty Groups are not supported

Additional 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.
• The names of the databases can be chosen individually, the name may not exceed
  • 50 (Spider version older than 6.4.7 R3) characters.
  • 128 (Spider versions newer than 6.4.7 R2) characters.
• All databases have to have the same collation. It has to be a case insensitive (CI) collation, e.g. SQL_Latin1_General_CP1_CI_AS
• All databases for installation have to be completely empty
• The name for the Spider Core Temp database has to be <SpiderCoreDBName>_TempDB, e.g. SpiderCore_TempDB
• The name for the Spider Session State database has to be <SpiderCoreDBName>_SessionState, e.g. SpiderCore_SessionState