{}

Our Brands

Impact-Company-Logo-English Black-01-177x54

Welcome to the Schneider Electric Website

Welcome to our website.
Search FAQs
PME4DC installer fails on "Create Data Collector Login"
Issue
PME4DC installer fails on step "Create Data Collector Login" with error "Error encountered running CreateProductLogin hm.ExecuteMethod return null"

installer

The installer log has the below description:

error

Product Line
PME4DC
PME4HC with EPSS

Environment
PME4DC installer
PME4HC with EPSS installer

Cause
SQL permissions are not allowing the installer to create the EPSS_DataCollector and apply appropriate database mappings.

Resolution
*Warning: Irreparable database damage can occur. This procedure should only be performed by users familiar with SQL Server Management Studio. Databases should be backed up prior to performing this procedure.*


If the SQL policies are blocking the creation of SQL user EPSS_DataCollector, the user can be created manually by logging into SQL server management studio and following the below steps:
  • Open SQL Server Management Studio, and connect to the appropriate Power Monitoring Expert SQL instance.
  • Open security-->right click on "Logins" and select "New Login".
  • Under the general page, create a login where login name is <computer name>\EPSS_DataCollector. Make sure SQL Server authentication is selected.
  • Under "Server Roles", select "Public".
  • Under "User Mapping" make sure the user is mapped to the databases;
    • ION_Data, with User "EPSS_DataCollector" (do not map <computername>\EPSS_DataCollector) and Default Schema set to "dbo". Make sure the database role membership is set for "db_datareader", "EPSS_DataCollectorAccess" and "Public"sql1
    • ION_Network, with User "EPSS_DataCollector" (do not map <computername>\EPSS_DataCollector) and Default Schema set to "dbo". Make sure the database role membership is set for "db_datareader" and "Public"
    • sql2
    • ApplicationModules, with User "EPSS_DataCollector" (do not map <computername>\EPSS_DataCollector) and Default Schema set to "dbo". Make sure the database role membership is set for "AMApplicationRole" and "Public"
      sql3
  • After the login is created, close SQL server management studio and rerun the installer.

Schneider Electric South Africa

Explore more
Product:
Articles that might be helpful Users group

Discuss this topic with experts

Visit our Community for first-hand insights from experts and peers on this topic and more.
Explore more
Product: