A remote PowerQuality Database in Same Domain

You have a centralized server and want to create a PowerQuality database in different system than Powermanager system.

  1. Powermanager system and database system are in domain.
  2. You have created two users in domain server with administrative rights.
    For example: PM1 is domain user Powermanger system and PM2 is domain user for PowerQuality database system.
  1. Open system where you wish to host PowerQuality database.
    For example: Login using PM2 user.
  2. 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.
  3. Open SQL Server Management Studio, and connect to server.
  4. Under Object Explorer navigate to [SQL Server] > Security > Logins.
  5. Add windows user of Powermanager system, and assign Server Roles as sysadmin.
    For example: add PM1 Powermanager system user.
  6. Navigate to Start > Windows Administrative Tools > Computer Management.
  7. Computer Management window appears.
  8. Navigate to Services and Applications > SQL Server Configuration Manager > SQL Server Network Configuration > Protocol for [SQL name].
  9. Ensure Shared Memory, Named Pipes and TCP\IP are enabled.

  10. Navigate to Start and search for Allow an app through Windows Firewall.
  11. Allow apps to communicate through Windows Defender Firewall window appears.
  12. Click Change Settings.
    NOTE: Database system administrative rights are required to perform this step.
  13. Click Allow another app.
  14. Add an app window appears.
  15. Click Browse.
  16. 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.
  17. Click Add and select Domain checkbox for both the files.
  18. Click OK.
  19. Create an Inbound-outbound rule. For more information, see Creating Inbound and Outbound Rule for Remote Database.
  20. Navigate to drive where you wish to host database and create a new folder named GMSDatabases.
  21. Open GMSDatabases and create another new folder named Backups.
  22. Open Backups and create another new folder named RecoveryLog.
  23. Open Powermanager system.
    For example: Login using PM1 user.
  24. Navigate to Start > Windows Administrative Tools > Local Security Policy.
  25. Local Security Policy window opens.
  26. Navigate to Security Settings > Local Policies > User Rights Assignment > Log on as a service.
  27. Open Log on as a service and select Add User or Group.
  28. Enter the database user name and click on Check Names.
    For example: enter PowerQuality database (PM2) credentials.
  29. Click OK.

  30. Open SMC, and select Database Infrastructure.
  31. Click Scan Network and select SQL server installed at step 2.
  32. Click Link .
  33. Select System node.
  34. Navigate to Settings > System Account, select Specific account.
  35. Click Browse.
  36. Select User window appears.
  37. Click Other Domains, select domain and search for windows user of database system, and click OK.
    For example: Select PM2 user of database system.
  38. Enter Password for select user.
  39. Navigate to Services expander and select Siemens GMS PQDB Service.
  40. Under Service Account expander, select Specific account.
  41. Click Browse.
  42. Select User window appears.
  43. Click Other Domains and select domain and search for windows user of database system.
    For example: Select PM2 user of database system.
  44. Enter Password for the login user of database.
  45. Click Apply.
  46. Click Save .
  47. Navigate to Database Infrastructure > [SQL Server from database system].
  48. Click Create and select Create Powermanager PowerQuality Database.
  49. Enter DB name, and select Database size.
    NOTE    : Ensure DB Owner and DB User are not same.
  50. Click Save .
  1. Remote PowerQuality Database created successfully.