SQL Server Analysis service (MSOlap) service fails to come online with "invalid context of address" error

The SQL Server Analysis service (MSOlap) service may fail to come online and an "invalid context of address" error may be logged in the Event Viewer.

This issue occurs if there are multiple IP addresses mapped to a single virtual server in a DNS server.

In a SQL Server service group, the Lanman resource comes online in the specified virtual server name context and the OLAP resource inherits the virtual server context and communicates with the DNS server to resolve the corresponding virtual IP address.

If there are multiple IP addresses mapped to a single virtual server, then the DNS Server may provide any of these IP addresses. If the resolved IP address is other than the one specified during the service group configuration, then the resource faults and the service group fails to come online.

Workaround: Set the value of the "DNSOption" attribute of the Lanman agent to "PurgeDuplicate".

This removes the duplicate DNS entries from the DNS servers.