Creating a Read-only Account for the Arcserve SQL Database

Since the PowerON Protect report gathers information from the Arcserve SQL database, we recommend creating an account that will only have Read capabilities to the database.

Firstly, create a dedicated account either in Active Directory if your Arcserve deployment is domain joined, or a local account on the server if it is in a standalone Workgroup configuration.

Once you have the account details, open SQL Management Studio using the administrative account that was used for the Arcserve installation.

Connect to the Arcserve SQL Instance

Expand Databases > arcserveUDP > Security

Right click on Users and select New User…

Drop the selection for User type: down and select Windows user

Click the ellipsis button and find the user account setup to be used for the Read-only database access.

Select the Membership page and tick the option for db_datareader then click OK

Contine to Next Steps

Continue to the Power BI Data Gateway Installation:

https://www.poweronplatforms.com/ponprotect-bi-power-bi-gateway-installation

Return to Main Guide

Related resources

PowerON Logo

PowerON Protect BI Usage Videos

Welcome to the usage information for the PowerON Protect (Powered by Arcserve) BI Reporting solution. The following video guides have been split into logical sections

PowerON Logo

Troubleshooting Guidance

Required Outbound Firewall Endpoints Azure Arc and the Power BI Data Gateway requires access to the internet (Outbound only). The following table shows the main