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
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