Authentication
Connecting to Cloud Versions of Vista
The below provides an overview of how to connect to cloud or hosted versions of Vista. It takes about 15-30 minutes to complete.
Step 1: Create an Agave User in Vista
The first step is to create a dedicated User to connect to Agave Sync. We recommend using a dedicated User for the integration, so you can track activity from your integration with your PM system.
To create a dedicated User, you can follow Trimble's guide. We recommend naming this user "Agave-User".
Your password must meet the following criteria:
- Be at least 8 characters long
- Contain at least one letter, one number, and one special character (e.g. !, @, #, $, etc.)
- Not be part of an online data leak
- We use Have I Been Pwned to securely check your password, without sending us your actual password to their servers. See here for more information.
Step 2: Create a Ticket with Viewpoint Support Requesting Permissions
If you are using a hosted (cloud) version of Viewpoint Vista, you will need to open a case with Viewpoint Customer Support to add Agave's static IP addresses to your Vista TLS Database Endpoint IP whitelist:
-
Log in to your Customer Support account.
-
Select My Resources, then Submit a Case.

- Select Support, then Systems/IT.

- Under Which product are you using?, input the following and select Search Knowledge Base:
- Product: select "Vista".
- Version: select the version of your Vista instance (e.g. 2022 R2).
- Module: select "Vista Server and IT Related".
- Brief Summary: input "TLS Database Endpoint IP Whitelist".

-
Scroll to the bottom of the page and press Continue to Case Creation.
-
Under Case Create, select a Priority. Under Description, add the following:
Hi - we are looking to whitelist our IPs for TLS Database Endpoint connectivity with our Vista instance. Here are our static IPs:
- 13.58.14.240
- 18.219.160.98
- 3.143.37.24
Could you also let us know what the database name and port are for our instance?
We are also looking to add the following permissions for the "Agave-User" in our Vista instance. Would it be possible to confirm that the following permissions have been added for the "Agave-User" to the Viewpoint and VPAttachments databases (see below screenshot from Microsoft SQL Server Management Studio)?
- db_datareader
- db_datawriter
- public
- VCSUsers

-
Press Submit.
-
After submitting a case, you should receive a response from Viewpoint Support within 24-48 hours confirming the connection the IP addresses have been whitelisted, the name of the database name and port, and that the permissions have been applied. Make a note of the hostname (e.g. {hostname}-sql.viewpointdata.cloud) and port number since you will need to use these to make the connection.