How to correctly execute CM Tool script known as ManualDBInstall_Script3-CreateMap_Logins.sql

Issue
This procedure, if not executed correctly, may be the source of many login, encryption, and/or installation errors experienced by Power Monitoring Experts users

Product Line
Power Monitoring Expert 8.2
Power Monitoring Expert 9.0
Power Monitoring Expert 2020
Power Monitoring Expert 2021
Power Monitoring Expert 2022
Power Monitoring Expert 2023
Power Monitoring Expert 2024

Environment
SQL

SSMS
Database Connection String (PME SQL Server Address and Instance names)
PowerShell (x86)

Cause
Database access via PME is centralized and encrypted

Resolution
The steps below will display the correct process when working with a PME system in which users have selected the option to Use SQL Server Authentication during their initial installation of the Power Monitoring Expert software

1. Remote desktop to the PME Server.
   1. This process will only work on the PME server itself.
2. Launch the 32 bit version of PowerShell "Windows PowerShell (x86)" as an administrator.
3. At the PowerShell prompt, enter the following and press enter:
   

   $pi = new-object -com ProductInfo.ProductInfo

   
   
   1. If you see an error message, the most likely cause is that you have accidentally run the 'normal' (64) bit version of PowerShell.  Be sure that the title bar on the window says "PowerShell (x86)". Otherwise it should appear as if nothing happened.
4. If it appears that nothing happened in the PowerShell prompt, type the following and press enter:
   

   $pi.IONConnectionString

5. Copy the password.
   An example of the above process is shown below:
   
   
   
   The password copied/recorded from the above steps will be used in the following steps:
6. Open the file named ManualDBInstall_Script3-CreateMap_Logins.sql using SSMS
   1. ensure that the SSMS application connects to the SQL Instance in which PME has been installed
   2. ensure that the account used to login to the SQL instance via SSMS has "sysadmin" to the instance
7. The file can be found in the file directory of the Configuration Manager Tool > i.e. "Configuration Manager PME Version\bin\Scripts\Migration"
8. Uncomment lines 4 and 5 of the script
9. Add the password copied from the above instruction to line 16 of the script
10. Execute the script
11. The proper output of the script should look similar or equal to the following example

The number of orphaned users fixed by updating users was 0.
The number of orphaned users fixed by adding new logins and then updating users was 0.
The number of orphaned users fixed by updating users was 0.
The number of orphaned users fixed by adding new logins and then updating users was 0.

게시 대상: 슈나이더 일렉트릭 Korea