CM Tool log has following error "SQL Server login failed for the current Windows user"

Issue
CM Tool fails and the log file shows "SQL Server login failed for the current Windows user"

Product Line
Power Monitoring Expert 7.2.2
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
CM Tool

SQL Server

SQL Server management Studios (SSMS)

Resolution
Follow the steps below
Step 1:

1. Add the windows account used for the installation purpose in sys admin access.

   USE master;
   GO
   EXEC sp_addsrvrolemember @loginame = 'DOMAIN\USER', @rolename = 'sysadmin';
   GO

2. Run the CM Tool manually in command prompt administrator mode as same as previous method.
   1. 

If the above step doesn't succeed, then proceed with step 2.

Step 2:

1. Please ensure that step1 is completed so that the user account has sys admin access.
2. Change the SQL\ION service to run on the logged in account.
   1. Right-click the windows button
   2. Select "Computer Management"
   3. When opened, select "Services and Applications"
   4. Select "Services"
   5. Navigate to the service named "SQL Server (ION)"
      1. In some cases, there may be a different name inside the parentheses.
   6. Right-click the service
   7. Select "Properties"
   8. Select the "Log On" tab
   9. Check the circular button labeled "This account"
   10. Enter the account information, Username (including domain) and password
   11. Select "OK"
   12. Acknowledge the message that will popup and adhere to its conditions
3. Allow the current user the ability to log on to the server as a service.
   1. Right-click the Windows button
   2. Select "File Explorer"
   3. Select the file directory to navigate to the "control panel"
   4. Select "System and Security"
   5. Select "Administrative Tools"
   6. Select "Local Security Policy"
   7. Expand "Local Policies" by selecting the carrot symbol on the left of the icon
   8. Select "User Rights Assignment"
   9. Right-click "Log on as a service"
   10. Select "Properties"
   11. Select "Add User or Group..."
   12. type the current user information (both domain and username)
   13. Select "Check Names"
   14. Select "OK"
   15. Select "OK"

發佈於: 施耐德電機Taiwan