Remove INUSER Schema sysadmin Server Role - Perceptive Content Update Guide - Foundation 24.1 - Foundation 24.1 - Ready - Perceptive Content - external

Perceptive Content Update Guide

Platform
Perceptive Content
Product
Perceptive Content Update Guide
Release
Foundation 24.1
License

Important Complete the steps in this section prior to updating the Perceptive Content Server.

In Perceptive Content Server 7.0 and higher, all Perceptive Content tables and indexes reside in the INUSER schema. You must ensure that the INUSER schema does not have the sysadmin server role granted to it. If the INUSER schema has the sysadmin server role, this role sets the default schema as the database owner instead of the INUSER schema. As a result, Perceptive Content Server might not start, and connections to the INOW6 database cannot query the Perceptive Content tables. To remove the INUSER schema sysadmin server role, complete the following steps.

  1. Open SQL Server Management Studio.
  2. Connect to the server hosting the SQL Server instance that contains the INOW6 database.
  3. In Object Explorer, expand Security, and then expand Logins.
  4. Right-click inuser, and then click Properties.
  5. On the Login Properties – inuser dialog box, click Server Roles.
  6. In the Server roles area, uncheck sysadmin.
  7. Click OK.
  8. Close SQL Server Management Studio.