BlueCielo Meridian GCF/Project Portal 2017 Administrator's Guide

Defining SQL Server security

The GCF Remote Access Web Service (described in Installing the GCF Remote Access Web Service) requires security permissions to access the SQL Server database. For example, on Windows Server 2008 R2 with both SQL Server and the GCF Remote Access Web Service installed there, the application pool that is assigned to the web service will be the application pool that you specified during the setup of the web service. You must add the account that is specified for the Identity option of the application pool as a login in SQL Server.

If SQL Server runs on a different computer than IIS and the GCF Remote Access Web Service, then you must change the application pool identity to a domain account that has access to SQL Server.