Error executing stored procedure or method GetComputerIDFromActiveDirectory
说明
Error executing stored procedure or method GetComputerIDFromActiveDirectory: there is no such object on the server (0x80072030). Error fills up the event logs, hundred+ per minute.
原因
This can happen due a specific setup where a one-way trust account is used as the service account. The service account domain is queried where the domain where the GPOADmin server exists in should be queried. This causes this error to fill the logs, there is one functionality limitation caused by this.
If multiple servers exist on the same database, however, this will cause issues, as we cannot determine which server is calling the database service options table. Therefore, it will always use the "Default" set of settings.