search cancel

Error: "The procedure 'sys.sp_addrolemember' cannot be executed within a transaction." while running the Symantec Endpoint Protection Manager Management Server Configuration Wizard.

book

Article ID: 151518

calendar_today

Updated On:

Products

Endpoint Protection

Issue/Introduction

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.


Cause

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)

Resolution

Install SP1 (or higher) to the SQL Server 2005 instance being used for SEPM.


References
Microsoft SQL Server 2005 Books Online - "sp_addrolemember" article: http://msdn2.microsoft.com/en-us/library/ms187750.aspx (see the Remarks section)