Skip to main content

Installation Preparation\ 4.7 SP1

Check Requirements​

Before proceeding with the installation:

  • Verify hardware requirements (hyperlink to above section)
  • Make sure to have all the required software (hyperlink to above section)
  • Download the SF SQL Access Server installation kit

Open the required TCP port​

Verify with your IT Administrator that port 4433 is open and accessible. Your Sigmafine SQL Access Server uses this port to communicate with all the SQL Access Client Applications.

Server Roles and Features​

Before installing SQL Access Server, we recommend that you install server roles, features, and role services on the Application Server. For more information, see the Microsoft article "Roles, Role Services, and Features".

Note: The 'Web Server' role must be enabled prior to running the SQL Access Server installation kit.

  1. In Microsoft Server Manager, click Add roles and features to open the wizard and choose Role-based or feature-based installation as the installation type.

  2. On the Select server roles page of the wizard, select the roles appropriate for your operating system:

    Operating SystemRoles
    Windows Server 2008 R2, Windows Server 2012, Windows Server 2012 R2Basic Authentication and Web Server (IIS) Ensure that WCF Services are selected (.NET 4.5)
    Windows Server 2016Basic Authentication and Web Server Ensure that WCF Services are selected (.NET 4.5)

  3. On the Select features page, choose the following required server features:

  • Windows Process Activation Service
  • Process Model
  • Configuration APIs

  1. On the 'Select role services' page for Web Server Role (IIS), select at least the minimum role services listed below:

    Role ServiceRequiredRecommended
    Common HTTP FeaturesStatic Content Default DocumentHTTP Errors HTTP Activation
    Health and DiagnosticNoneHTTP LoggingLogging ToolsRequest MonitorTracing
    PerformanceStatic Content Compression Dynamic Content CompressionNone
    SecurityWindows Authentication Request FilteringIP and Domain Restriction
    Application DevelopmentWindows Server 2012 and later:.NET Extensibility 4.5/4.6ASP .NET 4.5/4.6Windows Server 2008 R2:.NET Extensibility 3.5ASP .NET 3.5ISAPI ExtensionISAPI Filters
    Management ToolsNoneIIS Management Console (Not applicable for the Server Core minimal installation option in Windows 2012 and later).IIS Management Scripts and Tools Management Service.

  2. On the Confirmation page, click Install.

Windows PowerShell Script​

Pimsoft provides a Windows PowerShell script (Install_IIS.ps1) that installs all the required IIS prerequisites for all the servers that support PowerShell scripting.

To run the prerequisites installation script:

  1. Open the Windows PowerShell window using Administrative credentials.

  2. On the command line, change to the directory in which the script is located on the file system.

    cd *\<the installation path\>*

  3. On the command line, run the script.

    .\Install_IIS.ps1

  4. Once the installation finishes, close the PowerShell window.

SSL (Secure Socket Layer) Access​

We strongly recommend that you enable Secure Sockets Layer (SSL) for the SQL Access Server REST Services, to encrypt your communications over HTTPS.

You can use a digital certificate obtained from a trusted third-party registrar or the self-signed certificate created during the installation.

Create a Service Account for SQL Access Server​

The Sigmafine RESTful Services and the SQL Publisher Service require a dedicated service account (domain account). Create this account on the domain controller with Active Directory.

The Name of the service account should be SFSQAService.

Note: In order to successfully manage the SQL Access databases creation and data publishing, the service account must have Admin privileges over the selected SQL Server instance.

Note: The service account must have Admin privileges over the Sigmafine Servers (PI AF) where the Sigmafine databases to be published are hosted.