Endpoint Protection Manager Upgrade to version 14.3 RU5 failed

Products

• Endpoint Protection

Issue/Introduction

While upgrading Symantec Endpoint Protection Manager (SEPM) to version 14.3 RU5, an error occurred "The Symantec Endpoint Protection Manager reporting account does not connect to the Microsoft SQL Server database. You must recreate or modify the reporting account in SQL Server Management Studio. Then run the Management Server Configuration Wizard again".

Try the workaround proposed in Resolving Microsoft SQL Server database connection errors after 14.3 RU5 or later installation or upgrade (broadcom.com), however it did not work.

Environment

SEPM installed and connected to a Remote SQL server.

Cause

This issue happens only on SEPMs connected to a remote SQL server (authentication method: windows authentication).

When OS user logged in with different domain account than the domain account which used to install fresh SEPM.

Resolution

This issue was rectified from version 14.3 RU6 and above.

As a workaround either:

• Add the logged on SEPM OS user to the SEPM DB admin users, then Run Management server configuration wizard.

• Change the authentication method within SQL from Windows authentication to SQL authentication and run the Upgrade again.