Browse FAQs

Devices do not show up in SPM/PME Web Applications

Published date: 23 June 2020

None or some of the meters do appear under Web Applications: Dashboards, Tables, and Alarms. Additionally, Trends might also not be visible (only in PME 7.2.3 and PME 8.x). 

Product Line
StruxureWare Power Monitoring 7.0.x
Power Monitoring Expert 7.2.x
Power Monitoring Expert 8.x

SPM/PME Web Applications
SQL Management Studio 

The "ION_DSD_Reader" SQL user account does not have the correct permissions settings for the databases.

*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.*

1. Open SQL Management Studio. Click on Start> All Programs> Microsoft SQL Server 20xx> SQL Server Management Studio.
2. On the left side of the panel, expand the "Security" folder then, expand the "Logins" folder
3. Right click on 'ionedsd' and click on Properties
4. Click on "User Mapping" then Check and highlight ION_Data, and make sure ION_DSD_Reader, and public are checked under Database Role membership
5. Check and highlight ION_Network, and make sure NOM_DSD_Reader, and public are checked under Database Role membership
6. Click ok, and open the web application and verify that all meters are showing up

Was this helpful?

What can we do to improve the information ?

Can't find what you are looking for?

Reach out to our customer care team to receive information on technical support, assistance for complaints and more.