Error 11505 or 11506: Unable to create the database for Symantec Endpoint Protection Manager

Products

• Endpoint Protection

Issue/Introduction

You install Symantec Endpoint Protection Manager and configure it to use a Microsoft SQL database. When you try to create the database in the Management Server Configuration Wizard, you see the message, "Error 11505" or "Error 11506," followed by "Unable to create the database for Symantec Endpoint Protection Manager."

 

Resolution

The solution to this problem depends on the version of Symantec Endpoint Protection.

Version	Error message	Troubleshooting
12.1.5	Error 11505	If Microsoft SQL Server 2008 is using Windows authentication mode, this happens if you select SQL authentication in the Mangagement Server Configuration Wizard. To solve this problem, select Windows authentication. If Microsoft SQL Server is using mixed authentication mode, this occurs if the credentials supplied for database authentication are incorrect. To solve the problem, make sure that the DBA user and DBA password are entered correctly in the Management Server Configuration Wizard
12.1.4 and earlier	Error 11505	This problem occurs if the credentials supplied for database authentication are incorrect. This applies when Microsoft SQL Server is using mixed authentication mode. To solve the problem, make sure that the DBA user and DBA password are entered correctly in the Management Server Configuration Wizard.
	Error 11506	There are several reasons that this error can occur.   If Microsoft SQL Server 2008 is using Windows authentication mode, this happens if you select SQL authentication in the Mangagement Server Configuration Wizard. To solve this problem, select Windows authentication. If Microsoft SQL Server 2008 is using Mixed authentication mode, this happens if you enter the DBA user or DBA password incorrectly in the Management Server Configuration Wizard. To solve this problem, make sure that the user and password are correct.