Failed to get GMT offset Errors in WVLOG on a CRA server

[Scot_Clark]

In the WVLOG of a Prognosis server that has Call REcording Assurance (CRA) configured you may see many instances of the following error:

2020-05-10 03:24:20 F-05542057 SQL9Inst 00571 IRMSSQL  11.7.0       003952 - Unknown error.                                                                         CSQLInstance::RefreshDataBaseList(00000043CF609CB0:V15L-WHDB01) Failed to get GMT offset

Cause of this error:
The < irmssql user> does not have enough privilege to execute the following SQL statement:
select NodeName from sys.dm_os_cluster_nodes with (nolock)

(The < irmssql user> is the user that is configured in the Prognosis Passwords configuration which is used to make the SQL connection and run the queries)

To test to see if this is the problem:

1. Log on with MS SQL Server management Studio using the credentials for the <irmssql user>
2. Run the following query:

select NodeName from sys.dm_os_cluster_nodes with (nolock)

To Resolve:

1. Login into MSSQL from MS SQL Management studio with enough privilege, then execute the following SQL statement:

GRANT VIEW SERVER STATE TO <user login name for irmssql>