Error: "15023 Failed to create user REPORTER_sem5sem5:

Article Id: 170439
Status: Published
Updated On: 30-10-2018 15:28
Legacy Id: TECH248110
Products:
Endpoint Protection
Issue/Introduction:

Unable to re-create the account for webservice report using Symantec Endpoint Protection (SEP).

 

 

 

 

15023 User, group or role "REPORTER_sem5sem5"

 

 

 

 

 

 

Cause:

  • REPORTER_sem5sem5 in "security>logins" not found but it have a entry in sem5 > security > users
  • 15023 User, group or role "REPORTER_sem5sem5"  already exists in the current database

Environment:

SQL Database and SEP 14.x

Resolution:

  1. Login in SQL Studio
  2. Go to sem5 > Security > users > delete REPORTER_sem5sem5
    • Create a New REPORTER_sem5sem5
  3. Go to Security > Logins > new login
  4. In general tab, set Login name REPORTER_sem5sem5, set SQL Server authentication and default database sem5.db
  5. In User Mapping, select "sem5", "default schema" set dbo and "database role menbership for sem5"set REPORTER
  6. In Securables select the actual server then in "explicit permission" select Grant "connect SQL"