After installing Symantec Endpoint Protection Manager (SEPM) the Management Server Configuration Wizard is run. A SQL Server 2005 instance is chosen for the database. While the wizard is configuring the database the following error appears: "The procedure 'sys.sp_addrolemember' cannot be executed within a transaction." The error box is entitled "Error - Preparing Database".
Symptoms The SEPM database is being created in a SQL Server 2005 instance with no Service Packs installed.
Builds of SQL Server 2005 before Service Pack 1 (SP1) could not execute the query "sp_addrolemember" inside of a transaction. (see the References section for more information)
Install SP1 (or higher) to the SQL Server 2005 instance being used for SEPM.