Documentation Center

Configuring the Content Manager SQL Server database for Windows Authentication

Here is how you execute the script that allows the server's computer account to access a SQL Server database.

Before you begin

The task applies for SQL Server database when the connection string used integrated authentication.

The task requires sysadmin rights on the SQL Server.

Procedure

  1. Locate the script GrantComputerAccountPermissions.sql in the \InfoShare\App\Database\InfoShareCM\Common\ folder. Depending on your version of SQL Server:
    • For SQL Server 2019, the script path is \InfoShare\AppPROJECTSUFFIX\Database\InfoShareCM\Common\SQLServer2019\Tools\GrantComputerAccountPermissions.sql
    • For SQL Server 2017, the script path is \InfoShare\AppPROJECTSUFFIX\Database\InfoShareCM\Common\SQLServer2017\Tools\GrantComputerAccountPermissions.sql

    where PROJECTSUFFIX is a suffix string.

  2. Execute the script on the target SQL server instance.

SQL Server script that grants necessary permissions

If the target database is INFOSHAREDB and the computer account is TESTDOMAIN\SERVER01$ then the script looks like this:
USE [master] 
GO 
CREATE LOGIN [TESTDOMAIN\SERVER01$] FROM WINDOWS WITH DEFAULT_DATABASE=[INFOSHAREDB] 
GO 
USE [INFOSHAREDB] 
GO 
CREATE USER [GLOBAL\MEDEVASARAFIA01$] FOR LOGIN [TESTDOMAIN\SERVER01$] 
GO 
USE [INFOSHAREDB] 
GO 
GRANT SELECT TO [TESTDOMAIN\SERVER01$] 
GO