Setting up Viewpoint Access via VPN

Setting up Vista Access via an SSL connection

Introduction

Synchronizing data to Anterra from Viewpoint is extremely fast and easy via an SSL connection to your TrimbleOne SQL database. To provide the information needed to start the process of getting SSL connectivity setup between Anterra and your company, please have your IT or 3rd party hosting provider (TrimbleOne / VFC) provide the information in this form.

Prerequisites

You will need to verify the following:
  1. You have identified the server the SQL Server runs on which contains your Viewpoint database and have its IP address or URL available
  2. You have identified the individual who is the Vista Administrator who has administrative access to the SQL Server

Configuring the SSL Connection

  1. Once confirming your environment is already isolated, open a support ticket with TrimbleOne support requesting an SSL connection be setup with Anterra Technology.
  2. Once the SSL prerequisites have been configured is configured Anterra will contact the primary contact we have on file for your company and we can proceed to Configuring SQL Server

Configuring SQL Server

Determining SQL Server Address

If you don't know the address of your SQL Server you can find out by opening Vista by Trimble and looking in the  Vista Server  box:


Create Credentials for Anterra

  1. Make sure you are connected to your Vista environment (usually via Remote Desktop)
  2. Open SQL Server Management Studio (SSMS)
  3. Connect to your Viewpoint database (this is the same server shown as Vista Server during login)
  4. Click  File > New > Query with Current Connection  or press CTRL + N
  5. Use the query below to create a service account with a secure password for Anterra, be sure to:
    1. Update the {ComplexPasswordHere} with a complex password containing upper case, lower case, digits, and symbols and having a minimum length of 10 characters.
    2. If your main Viewpoint database is not called Viewpoint, be sure to update that in the first USE statement

T-SQL to create Anterra Service Account on Vista SQL Server

USE [master]
GO
CREATE LOGIN [svcAnterra] WITH PASSWORD=N'{ComplexPasswordHere}', DEFAULT_DATABASE=[Viewpoint], CHECK_EXPIRATION=OFF, CHECK_POLICY=OFF;
GO
USE [Viewpoint]
GO
CREATE USER [svcAnterra] FOR LOGIN [svcAnterra];
ALTER ROLE [db_datareader] ADD MEMBER [svcAnterra];
GRANT VIEW DEFINITION TO [svcAnterra];