Verify Microsoft SQL Server instance prerequisites - Perceptive Content Database Install Guide - Foundation 24.1 - Foundation 24.1 - Ready - Perceptive Content - external - Perceptive-Content/Perceptive-Content-Database-Install-Guide/Foundation-24.1/Perceptive-Content-Database-Install-Guide/Perceptive-Content-Database-prerequisites/Verify-Microsoft-SQL-Server-instance-prerequisites - 2024-04-02

Perceptive Content Database Install Guide

Platform
Perceptive Content
Product
Perceptive Content Database Install Guide
Release
Foundation 24.1
License
ft:locale
en-US

To verify Microsoft SQL Server instance prerequisites, complete the following steps.

  1. In SQL Server ManagementStudio, in the Object Explorer pane, right-click your server, and then click Properties. Typically, your server is the first item listed in the tree.
  2. In the Server Properties dialog box, under Select a Page, click Security.
  3. Under Server authentication, select SQL Server and Windows Authentication Mode, and click OK.
  4. If prompted, click Yes to restart the server.
    Note: Restarting the server shuts down and starts up all databases on this instance.
  5. In SQL Server Configuration Manager, ensure the TCP/IP Protocol is enabled for the IP address and port you intend to use for your configuration.
    Note:
    • For more information on configuring your instance of SQL Server and INOW database for optimal performance, refer to the Microsoft SQL Server Best Practices Guide.
    • For more information on configuring encrypted communication using SSL between the database and Perceptive Content Server, refer to the Perceptive Content Server Installation and Setup Guide.