Set Encrypt and TrustServerCertificate Flag

This is a step-by-step tutorial on how to set Encrypt and TrustServerCertificate flag for Repository and Project connection in Visual Expert.

For Repository Connection

  • Open the file menu and click on [Connect VE Repository].
    Connect VE Repository
  • In the connect repository dialog, click on [Edit Connection].
    Connect to SQL Server
  • In Repository Connection Settings, select the appropriate flags for Encrypt and TrustServerCertificate based on server configuration.
  • Click on [Test Connection].
    Test Repository Connection
  • If successfully connected, click on [Save].
    SQL Server Connection Successful
  • Follow the wizard and connect to the appropriate repository.

For Project Connection

  • Click on Open Project button through the File Menu or the Main View.
    Open Visual Expert Project
  • Select a project and click on the [Edit] button.
    Edit VE Project Settings
  • In the Edit Project dialog, click on [Change connection].
    Change Project Connection
  • In the Project Connection Settings, update the project connection string.
    Select the appropriate flags for Encrypt and TrustServerCertificate based on server configuration.
    Click on [Test Connection].
    Test Project Connection
  • Save the connection string changes as shown below:
    Save Connection String Changes
  • Open your project once the project connection string is updated. Perform similar exercise for other projects.

 

More from Visual Expert Configuration

 

Visual Expert, Configuration, Support, Settings, Repository Connection, Project Connection