WEBfactory 2010

The Feature Selection window allows the user to select which of the SQL Server 2014 features are installed. By default, all the features are selected.

The features are listed in the left side of the main section and can be selected or deselected for installation by checking the corresponding boxes. SQL Server 2014 provides three types of features:

• Instance Features (Database Engine Services, Reporting Services).

• Shared Features (Business Intelligence Development Studio Management Tools - Basic, SQL Client Connectivity SDK, Microsoft Sync Framework).

• Redistributable Features.

A short description of each feature is available on the right side of the main section. Select a feature by clicking on it and the corresponding description will be displayed on the right side of the main window.

Select all and Unselect All options are available in the bottom-left side of the main section, below the features.

• Clicking on the Select All button will automatically select all the features available.

• Clicking on the Unselect All button will automatically unselect all the features available.

The Shared Feature Directory option at the bottom of the main section allows the user to select the folder in which the shared features of SQL Server 2014 will be installed. This is helpful when more SQL Server distributions on the local machine have the same shared features. By default, the shared features will be installed in the Microsoft SQL Server directory.

• Select the folder for Shared Features by typing the complete path into the text field or by clicking the … (browse) button next to the text field.

Remember that you can always check the progress of SQL Server 2014 installation in the status section, in the left side of the setup window.

Minimal SQL Server 2014 feature installation

If desired, a minimal features installation of the SQL Server 2014 can be achieved by marking for installation only the Database Engine Services feature, which is absolutely required by WEBfactory 2010. The SQL Client Connectivity SDK is also required but this feature is installed by default and cannot be left out of the initial installation.

Feature Selection

The Instance Configuration window allows the user to create an instance of SQL Server 2014 deployment.

This options should not be changed, as WEBfactory 2010 Setup already configured this SQL Server 2014 instance.

The instance options can be selected in the main section of the setup window:

• Default instance - installs SQL Server 2014 with the default names and locations.

• Named instance - allows the user to create a new instance name. This option is important when setting up SQL Server 2014 to interact with other software. This option should not be changed!

• Instance ID - allows the user to assign and id to the named instance. This option should not be changed!

• Instance root directory - allows the user to select the directory in which the instance will be deployed. This option should not be changed!

• SQL Server directory - displays the directory of the SQL Server for this instance setup.

• Reporting Services directory - displays the directory of the Reporting Services for this instance setup.

• Installed instances - displays the instances that are already installed on the machine.

IMPORTANT

Unless a specific setting is required, the collation of the database engine should be left default, to avoid any further script errors.

The Database Engine Configuration window enables the user to specify the database engine authentication security mode, the administrators and the data directories.

Server Configuration tab located in the top-left part of the main section lists the following options:

Authentication Mode

• Windows Authentication mode - uses the Windows credentials to authenticate in the database;

• Mixed Mode - uses both SQL Server authentication and Windows authentication;

Specify the password for the SQL Server system administrator (sa) account

• Enter password - use the text field to enter the SQL Server system administrator password;

• Confirm password - use the text field to confirm the SQL Server system administrator password;

Specify SQL Server administrators - lists the SQL Server administrators.

• Add Current User - adds the user that is logged on in this running session as SQL Server administrator;

• Add... - enables the user to select other user accounts and add them as SQL Server administrators;

• Remove - removes an user from the SQL Server administrators list;

NOTE

SQL Server administrators have unrestricted access to the Database Engine.

The Data Directories tab enables the user to select the directories for:

• Data root directory

• User database directory

• User database log directory

• Temp DB directory

• Temp DB log directory

• Backup directory

To change any of the above directories, click on the ... (browse) button and navigate to the desired directory.

The System database directory is also displayed below the Data rood directory.

The User Instances tab allows the user to select whether the users are or not allowed to run separate instances of the Database Engine.

The Reporting Services Configuration window allows the user to setup the reporting services of SQL Server 2014. There are three options for configuring the reporting services:

• Install the native mode default configuration - the report server will be configured in the Native mode, using default values. This native report server is usable without further setup.

• Install the SharePoint integrated mode default configuration - created the report server database in SharePoint and configure the report server with the default values. By choosing this method, the reporting server will not be available until SharePoint is installed on the machine, and the Reporting Services add-in for SharePoint Technologies is installed and configured in SharePoint.

• Install but not configure the report server - the report server will be available only after the user sets the options for the reporting server using the Reporting Services Configuration tool.