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

Only for Procore <> Vista integration subscriptions.

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”.
   
   
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
     
     
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
       
       
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.