An instance of SQL Server is required. However, SQL Server version and edition requirements vary depending on the analytic engines that you want to use. The target computer must also meet the overall requirements for Predixion Insight™ 4.0. For more information, see Requirements.
During setup, you can choose a default or custom installation.
Default Installation
When you choose the default installation, Setup looks for SQL Server on the target computer. If an instance of SQL Server is found and Setup can connect to it, that instance is used. If no instance is found, Setup installs SQL Server 2012 Express SP1.
Custom Installation
When you choose the custom installation, you have three choices for creating the Predixion databases:
- Create Predixion databases on an existing instance of SQL Server. You can use the default instance or a named instance.
- Install SQL Server Express and create the databases on a new instance. You can use the default instance name, Predixion, or provide a different name.
- Use existing databases. The Predixion databases, Predixion and PredixionDB, were created before you ran Setup and you provide connection strings to them. Predixion is the controller database. Predixion and PredixionDB are the default database names.
Setup includes an option to test the database connection.
SQL Server Versions and Editions
The basic requirement for SQL Server is SQL Server 2008 R2 ; earlier versions are not supported. The supported versions and editions:
- SQL Server 2008 R2 Data Center Edition, SQL Server 2008 R2 Enterprise Edition, and SQL Server 2008 R2 Developer Edition. SP1must be installed to support the Microsoft clustering algorithms.
- SQL Server 2012 Enterprise Edition, SQL Server 2012 Business Intelligence Edition, or SQL Server 2012 Developer Edition. CCU4 or later or SP1 with CU2 or later must be installed to support Microsoft association algorithms.
- SQL Server 2014 Enterprise Edition, SQL Server 2014 Business Intelligence Edition, or SQL Server 2014 Developer Edition.
- SQL Server 2008 R2 Express with SP1 installed.
- SQL Server 2012 Express with SP1 installed. This is the version that Setup installs.
- SQL Server 2014 Express.
If you plan to use only R, you might be able to use any listed version and edition of SQL Server; however, only SQL Server 2012 Express SP1 and SQL Server 2014 Express are supported.
Predixion Databases
The following Predixion database are created on the SQL Server instance:
- PredixionDB with simple logging, 1 GB database, and 200 MB log file
- Predixion with simple logging, 1 GB database, 200 MB log file
Database Permissions
In addition the following permission requirements must be met:
- Ownership of all SQL Agent jobs by Predixion account
- Dbo ownership of the two Predixion databases by Predixion account
See Also
