PRM®
Database Connection FAQ

TRANSFERRING TEST DATA
Issue: When I transfer data, I get a "No Clients Connected" error message

  • On the PowerMaster, go to User Preferences.

    On page 11, verify the following parameters are set correctly:

    IP Address:
    169.254.85.157

    Default Gateway:
    169.254.85.1

    Subnet Mask:
    255.255.0.0

    UDP Port:
    8081

    TCP Port:
    8080

    Auto IP Mode:
    FALSE (unchecked)

    Server IP:
    169.254.85.5

  • In PRM®, go to Options > General Options > Analyzer Data Sync, and verify the following parameters are set correctly:

    Network Adapter IPv4:
    169.254.85.5

    UDP Broadcast Port:
    8081

    TCP DataSync Port:
    8080

    Use DataSync:
    TRUE (checked)

    1. Plug in an Ethernet to USB adapter to your Windows 10/11 laptop or tablet

    2. On the laptop or table, go to Control Panel

    3. Under Control Panel, go to Network and Internet > Network and Sharing Center > Change Adapter Settings

    4. Right-click adapter “ASIX AX88772B” and click on Properties

    5. Under Properties, double-click “Internet Protocol Version 4 (TCP/IPv4)”

    6. Verify the following parameters are set correctly:
      Use the following IP address:
      TRUE (checked)
      IP Address:
      169.254.85.5
      Subnet Mask:
      255.255.0.0
      Default Gateway:
      . . .

DATABASE
Issue: PRM® won’t connect to the Database

  • Download SQL Server Express

    1. On the laptop or tablet, open Microsoft SQL Server Management Studio

    2. Connect to desired database

    3. Select the Database under “Object Explorer”, then click Security

    4. Under Security, right-click Logins

    5. Find the user, then double click

    6. Go to User Mapping and select the desired Database

    7. Add the “db_owner” mapping to the user and click OK

    8. Restart PRM and point to the desired Database

  • Contact your IT team. The most likely culprit is Windows Defender Firewall. IT will need to allow PRM through to the SQL Server on whichever port the server was originally created (default is 1433).

    The port needs an inbound and outbound rule for the PRM application. If IT needs to do it by port, they will need to open whatever ports they have set up in PRM to be open for TCP/UDP Connection.

    Ports 8080 and 8081 are the default ports for the PowerMaster. If these need to be changed, both port settings have to be set in PRM and the PowerMaster (User Preferences, page 11).

    1. On the laptop or tablet, search for SQL Configuration Manager

    2. Once the application is opened, scroll down to “SQL Server Network Configuration” and expand it

    3. Once expanded, double-click “Protocols for [DATABASE NAME]”

    4. Double-click “TCP/IP”

    5. Under the Protocol tab, set Enabled to “Yes”.

    6. Click the IP Addresses tab and scroll down to “IPALL”

    7. Under “IPALL”, set the “TCP Dynamic Ports” to an available port (default is 1433)

    8. Next, set “TCP Port” to the same port (default is 1433)

    9. Click Apply, then OK to close

    10. Next, open PRM and click Database > Database Connection

    11. Set “Provider” to Microsoft SQL Server, then set “Database” that is located on the network using a Domain Name or IP address (default “Powermetrix”)

    12. Next, set the Default Port that was set in Step 7 (default 1433)

    13. Lastly, click the “Test” button to confirm connectivity. If the connection is successful, click “Save”.

DATABASE
Issue: When testing the Database connection in PRM®, I get a “Failure” message.

    1. On the laptop or tablet, open Microsoft SQL Server Management Studio

    2. Connect to desired database

    3. Select the database under “Object Explorer”, then click Security

    4. Under Security, right-click Logins

    5. Find the user, then double click

    6. Go to User Mapping and select the desired Database

    7. Add the “db_dataReader” and “db_dataWriter” mapping to the user and click OK

    8. Restart PRM and point to the desired Database