A remote PowerQuality Database in Same Workgroup

  1. Powermanager system and database system are in same workgroup.
  2. You have created two workgroup users with administrative rights.
    For example: PM3 user is Powermanager system user and PM4 user is database system user.
  1. Open system where you wish to host PowerQuality database.
    For example: Log in using PM4 user.
  2. Navigate to Start > Windows Administrative Tools > Computer Management.
  3. Computer Management window appears.
  4. Navigate to System Tools > Local Users and Groups > Users.
  5. Create a new user with same credentials as Powermanager system user.
    For example: PM3 is user created for Powermanager system, add same PM3 user into database System.
  6. Install SQL Server, and SQL Server Management Studio (SSMS).
    NOTE 1: Database system administrative rights are required to install applications.
    NOTE 2    : SQL Server Express 2019 edition is provided with the Powermanager setup and located at [setup folder] > DCC > GMS > Prerequisites > SQL 2019. For other supported SQL Servers, you need to download manually. See Microsoft SQL Server.
    NOTE 3: Ensure Startup type for SQL Server Browser is selected as Automatic. See Enable the SQL Server Browser
    NOTE 4: SQL authentication is not supported.
  7. Open SQL Server Management Studio, and connect to server.
  8. Under Object Explorer navigate to [SQL Server] > Security > Logins.
  9. Add windows user of Powermanager system, and assign Server Roles as sysadmin.
    For example: add PM3 Powermanager system user.
  10. Navigate to Start > Windows Administrative Tools > Computer Management.
  11. Computer Management window appears.
  12. Navigate to Services and Applications > SQL Server Configuration Manager > SQL Server Network Configuration > Protocol for [SQL name].
  13. Ensure Shared Memory, Named Pipes and TCP\IP are enabled.
  14. Navigate to Start and search for Allow an app through Windows Firewall.
  15. Allow apps to communicate through Windows Defender Firewall window appears.
  16. Click Change Settings.
    NOTE: Database system administrative rights are required to perform this step.
  17. Click Allow another app.
  18. Add an app window appears.
  19. Click Browse.
  20. Select below mentioned files one after another.

    - Select the file C:\ProgramFiles\MicrosoftSQLServer\<version_InstanceName>\MSSQL\Binn\sqlservr.exe.

    - Select the file C:\ProgramFiles(x86)\MicrosoftSQLServer\90\Shared\sqlbrowser.exe.
  21. Click Add and select Domain checkbox for both the files.
  22. Click OK.

  23. Create an Inbound-outbound rule. For more information, refer Creating Inbound and Outbound Rule for Remote Database.
  24. Navigate to drive where you wish to host database and create a new folder named GMSDatabases.
  25. Open GMSDatabases folder and create another new folder named Backups.
  26. Open Backups and create another new folder named RecoveryLog.
  27. Open Powermanager system.
    For example: Login using PM3 user.
  28. Navigate to Start > Windows Administrative Tools > Computer Management.
  29. Computer Management window appears.
  30. Navigate to System Tools > Local Users and Groups > Users.
  31. Create a new user with same credentials as database system user.
    For example: PM4 is user created for database system, add same PM4 user into Powermanager System.
  32. Navigate to Start > Windows Administrative Tools > Local Security Policy.
  33. Local Security Policy window appears.
  34. Navigate to Security Settings > Local Policies > User Rights Assignment > Log on as a service.
  35. Open Log on as a service and select Add User or Group.
  36. Enter the database user name and click on Check Names.
    For example: enter PowerQuality database (PM4) credentials.
  37. Click OK.

  38. Open SMC, and select Database Infrastructure.
  39. Click Scan Network and select SQL server from database system.
  40. Click Link .
  41. Select System node.
  42. Navigate to Settings > System Account, select Specific account.
  43. Click Browse.
  44. Select User window appears.
  45. Click Other Domains, select domain and search for windows user of database system, and click OK.
    For example: select PM4 user of database system.
  46. Enter Password for the selected user.
  47. Navigate to Services expander and select Siemens GMS PQDB Service.
  48. Under Service Account expander, select Specific account.
  49. Click Browse.
  50. Select User window appears.
  51. Click Other Domains and select domain and search for windows user of database system.
    For example: Select PM4 user of database system.
  52. Enter Password for the database user.
  53. Click Apply.
  54. Navigate to Database Infrastructure > [SQL Server from database system].
  55. Click Create and select Create Powermanager PowerQuality Database.
  56. Enter DB name, and select Database size.
    NOTE    : Ensure DB Owner and DB User are not same.
  57. Click Save .
  1. Remote PowerQuality Database created successfully.