The Symantec Endpoint Protection Manager (SEPM) 14 upgrade fails during the Upgrade Wizard because the provided SQL user doesn't have system administrator (sa) privileges.
The user name and password that you entered are for a user who does not have system administrator privileges for the SQL server. Change the privileges and re-enter the credentials, or enter the credentials of a different user with system administrator privileges.
The SEPM 14 installation/upgrade creates a new SQL login, user, and database role with limited permissions. This new user allows the SEPM reporting Web site to access only the portions of the SEPM database that are necessary for its operation. The user is not able to read or write data except from tables and views necessary for its operation. Creating a new SQL login and database role requires sa equivalent privileges in SQL server.
note: After the migration completes, the SEPM service uses the same SQL login and account used by previous to the migration.
To upgrade a 12.x SEPM to SEPM 14, do one of the following:
Use a SQL user with sa equivalent privileges during the migration
Temporarily add the sysadmin server role to the SEPM SQL login (sem5 by default)
Subscribing will provide email updates when this Article is updated. Login is required.