Creating a SQL Server User in Vista is an essential step in installing the Trimble App Xchange On-Prem Agent.

1. In Vista, configure the Vista Application User.
   1. Navigate to Viewpoint Administration > Programs > VA User Profile.
   2. Select the New Record icon.
   3. Enter XChangeServiceUser in the User Name field.
   4. Set the User Type to User Application.
   5. Enter XChange Service User in the Full Name field.
   6. Enter any email, real or fake, in the Email Address field. The integration does not use it, but the Vista form requires it.
   7. Select the Save icon. An error message that no SQL login matches that username displays. Select Close.
   8. Create a strong password. Do not use special characters aside from the exclamation point (!).
      Note: If you see an error message like the one below, disregard it. Your new SQL user will still be created and tied to the appropriate Vista user.

      
2. In Vista, assign the proper datatype security groups to XChangeServiceUser for each company you want to integrate.
   This step is essential if any companies leverage Vista datatype security, as your integration will be unable to move data with an improper data security setup. For more information, see Datatype Security.

   Note: App Xchange only pulls data from the companies you have specified. It ignores companies that are not listed in the connector configuration.
   1. In Vista, navigate to Viewpoint Administration > Programs > VA Data Security Setup. If any datatypes are checked on the Secured column, then you must complete this step or else the integration cannot move your data. Otherwise, skip to step 3.
   2. Navigate to Viewpoint Administration > Programs > VA User Profile.
   3. Press F4 in the User Name field and select XChangeServiceUser. Select the Security Groups tab.
   4. Choose one to proceed.

      • If you are configuring a productized integration owned by App Xchange, contact your Vista administrator to reference the integration’s datatype security requirements.

      • If you are configuring a productized integration owned by an external partner, consult the integration’s documentation to reference its datatype security requirements. If these requirements are not listed, contact the integration owner directly.

   5. Grant XChangeServiceUser security group access to the integration’s required datatypes.
   6. Select OK and close Vista.
3. In an SQL manager, create an XChangeServiceUser SQL User.
   1. Create a new user with the login name XChangeServiceUser.
   2. Select SQL Server authentication as its authentication method.
   3. Enter the password you created for XChangeServiceUser in step 1h when prompted.
   4. Disable the option to enforce password policy.
   5. Ensure its default database is set to your Viewpoint database.
   6. Grant the user db_datareader, public, and VCSUsers roles.
      Note: Granting db_datareader is optional but highly recommended. This permission allows App Xchange support to troubleshoot more effectively. If you do not grant db_datareader, you may encounter troubleshooting issues. Granting db_datareader is required for Procore and Concur integrations.
   7. Save the new settings.
4. Optional: Authorize the XChangeServiceUser SQL User for the Vista Attachments database.
   Note: This step is only necessary if you have a separate Vista Attachments database. To determine if your company has a separate Attachments database, open Vista and navigate to Document Management > Programs > DM Attachment Options. If the Database option is selected under Attachment Storage Location and the database name is not a standard Vista database (usually Viewpoint), then you must complete this step.
   1. In an SQL manager, execute the following SQL script:

   USE [master]
   
   GO
   
   CREATE LOGIN XChangeServiceUser WITH PASSWORD='Your Password', DEFAULT_DATABASE=[Your Attachment 
   Storage Locations Database name], DEFAULT_LANGUAGE=[us_english], CHECK_EXPIRATION=OFF, CHECK_POLICY=OFF
   
   GO
   
   USE Your Attachment Storage Locations Database name;
   
   GO
   
   CREATE USER XChangeServiceUser FOR LOGIN XChangeServiceUser;
   
   GO
   
   GRANT SELECT, INSERT, UPDATE, EXECUTE TO [XChangeServiceUser]
   
   GO

5. Send your App Xchange Customer Success Manager the following information:

   • Server name

   • Database name

   • Vista Attachments database name (if applicable)

   • XChangeServiceUser password

   Important: Passwords must be securely shared via your preferred method.