This Setup guide is for a basic new Ouvvi Instance on a Single Server using Windows Integrated Security and mostly default settings.
Install the latest version of Data Sync from the Simego website https://www.simego.com/install/data-synchronisation-studio
The default IIS configuration can be installed via PowerShell, either run the PowerShell script that is installed with Data Sync or run the script directly below to install the IIS pre-requisite components.
The PowerShell IIS Install script can be found in the following path
%ProgramFiles%\Simego\Data Synchronisation Studio 3.0\PowerShell\IIs-Setup.ps1
#Install .NET Framework 4.6 Add-WindowsFeature NET-Framework-45-ASPNET $features = ("IIS-WebServerRole", "IIS-WebServer", "IIS-CommonHttpFeatures", "IIS-HttpErrors", "IIS-ApplicationDevelopment", "IIS-NetFxExtensibility45", "IIS-WindowsAuthentication", "IIS-ISAPIExtensions", "IIS-ISAPIFilter", "IIS-ASPNET45", "Windows-Identity-Foundation") # Enable IIS Features Enable-WindowsOptionalFeature -Online -FeatureName $features
Ouvvi can run on all editions of Microsoft SQL Server from LocalDB through to Enterprise Edition.
LocalDB is the simplest low footprint version suitable for small deployments managing a small number of projects.
Download SQL Server Express and LocalDB from https://www.microsoft.com/en-us/sql-server/sql-server-editions-express
To Install LocalDB run the above installer for SQL Server Express and choose Download Media and select LocalDB. Then run SqlLocalDB.msi
The SQL Server can be on a different machine to Ouvvi there is no requirement for SQL Server to be running on the Ouvvi Server. (except for LocalDB option)
To install a new Instance of Ouvvi requires IIS WebSite, Windows Service and SQL Database to be configured.
Run the PowerShell Script below to install a new Instance of Ouvvi using the default settings for a SQL Express DB.
#Import Ouvvi PowerShell Module Import-Module OuvviAdministration #Install Ouvvi Instance Install-OuvviSqlExpress
If you wish to change the settings from the default, the full install script can be found below. Please change this as is required for your system.
#Import Ouvvi PowerShell Module Import-Module OuvviAdministration #Install Ouvvi Instance Install-Ouvvi -targetPath C:\OuvviTenants\Default -iisAppName OuvviDefault -iisAppPoolName OuvviDefault -iisPortNumber 8080 -instanceName Default
For LocalDB you do not need to make any changes to continue with the setup.
For SQL Express, Standard, Azure etc. you will need to create a new Empty SQL Database on your Database Server and update the connection string in the
<TENANTPATH>\Web\Web.config file to match.
Note: Integrated Security is preferred here so you will need to set the Ouvvi Web AppPool to a Windows Account that has permmission to connect with the database you created.
Ouvvi requires Database Admin permission to create the Tables and setup the Database so grant the user account DBO rights on the new database. After setup is complete you can relax these permissions to db_datareader and db_datawriter roles.
Open your web browser to the Ouvvi Setup URL
http://localhost:8080/setup to complete the Database Setup.
Verify the Setup configuration, select your Regional Settings and Time zone and then press Create Database for LocalDB or Setup for SQL Server.
Verify the Ouvvi URL is correct for the Windows Service open the configuration file
<TENANTPATH>\Service\Simego.Console.Service.exe.config in a text editor and update the OuvviServiceUrl value if necessary. (default value is http://localhost:8080)
Next the Ouvvi Windows Service should be configured to run under a network domain account and started (this account will be used as the security context to run the steps) to do this open the services control panel (services.msc) and configure the Ouvvi Processing Service for your tenant and set the Startup type to Automatic (Delayed Start).
The Ouvvi Service can run under NETWORK SERVICE if you only need to connect to internet and local machine resources.
Verify that your services are all running under
Services->System Services green flags indicate that the service is running OK.
By default the service are configured to start on the local machine you can add new Service Agents here and define the machines that they should run on.
If you are logging into Ouvvi from the same machine it is being run from and you are finding the services do not start you most likely are getting a Windows Authentication Error due to Loopback Protection.
You may get an error message in the log of
Loopback Protection is enabled on the Server OS by default, and disables authenticating against local Windows accounts through HTTP and a Web browser.
To fix this issue you can disable Loopback check through any of the following methods:
Run the following script from Powershell
New-ItemProperty HKLM:\System\CurrentControlSet\Control\Lsa -Name "DisableLoopbackCheck" -Value "1" -PropertyType dword
Find the following key in the registry on the server
and edit or add a new key
then set the value to
1 to disable the looback check (local auth works), or to
0 (local auth is not allowed)
Ouvvi uses the same Data Synchronisation Studio Server license key as Data Sync.
Ouvvi will not run any projects and steps without a valid license key installed.
To register your license key go to
Settings -> Register License and then enter your license key into the specified box and click 'Activate'.
If you do not have an internet connection and need to activate your key, please see our page on Manual License Key Activation.
This is an optional setting whereby you can change the instance name. To do this go to
Settings > User Settings and change the name.
This is an optional setting that can be used to differentiate between development, production and testing environments at a quick glance.
To change the theme go to
Settings > User Settings and pick a user theme from the drop down.
The current preset choices are:
Save at the bottom of the page to set the changes you have made.