How to Setup Your Viewpoint Vista SQL User for Ryvit's Integration between Procore and Viewpoint Vista

Only for Procore <> Vista integration subscriptions.

If you're not working on connectivity specifically for Procore <> Vista, then please click here to view a more comprehensive RyvitAgent setup guide.

Creating a Ryvit Service User SQL User 

  1. Within Microsoft SQL Management Studio, expand the Security menu and right-click Logins to expose the “New Login…” menu option. Select “New Login”.

    Screen Shot 2021-05-04 at 2.47.06 PM
  2. Create a new login name
    • Create a login name such as ‘RyvitServiceUser’
    • Select “SQL Server authentication”
    • Establish a password that is:
      • contains at least 16 alpha-numeric characters
      • contains at least one exclamation point ( ! )
      • Please do not use any other special characters.
    • Uncheck “Enforce password policy”
      • Note: if this is not done, your integration will be at risk of having a broken sync due to changing credentials over time.
    • Ensure that the Default database is your Viewpoint database

      Screen Shot 2021-05-04 at 2.48.16 PM
  3. Navigate to the User Mapping page to grant the RyvitServiceUser with database Read/Write permissions for your Viewpoint database
    • Select your Viewpoint database
    • Grant the user the following permissions:
      • db_datareader
      • db_datawriter
      • public
      • VCSUsers

        Screen Shot 2021-05-04 at 2.49.28 PM
  4. Click OK.

    Once all steps are complete, please respond to your Ryvit representative with the following:

    • Server name
    • Database name
    • PW for the RyvitServiceUser

     

    If you need help, please contact support@ryvit.com.