VERIFIED SOLUTION i

Portrait Dialogue v6.1 scripted installation with Portrait HQ fails to install Dialogue database

Product Feature: Installation
 

Issue

Attempting to install Portrait Dialogue v6.1 and Portrait HQ on a non-supported platform is never encouraged by Technical Support and we cannot guarantee that the implementation will work. However, we appreciate that some customers may want to attempt to install a development version of the software on their local machines that do not match the certified operating systems.

The creation of the Portrait HQ databases on Windows 7 or Windows Server 2008 R2 will usually fail when following the existing instructions in the Portrait Suite Installation Guide.

Cause

The installation guide for Portrait Suite v6.1 states that it should be installed on either Windows 2012 or 2012 R2. In this situation, you will always be OK. (Windows 8 and 8.1 would theoretically also be fine for a development environment.) The install guide says that you need a minimum of PowerShell 2.0. This is a typo as the acceptable operating systems above all come with PowerShell 3.0 pre-installed.

Problems start to happen if you try to install on Windows Server 2008 R2 or Windows 7 operating systems. (Because PowerShell v2.0 is installed on those operating systems, users may believe that the PowerShell version is more important that the operating system.)

PowerShell 3.0 will automatically load the correct SQL module (SqlPs) when it starts up, so that the scripts can perform SQL tasks on the database server, but PowerShell 2.0 does not load the module automatically. Within the Portrait PowerShell command window - which attempts to load any modules necessary for the installation and configuration, there is a bug which means that it is looking to load the wrong version of the SQL module (for SQL Server 2008).

Resolution

UPDATED: March 29, 2017
Here are the recommendations:
  • Use the correct Server 2012 or 2012 R2 (or Windows 8 or 8.1) operating systems,
  • If you want to try to use Windows 7 or Windows 2008 R2 (which are unsupported platforms and not recommended), then you will either have to manually install PowerShell 3.0 / 4.0, or
  • When you start the Portrait PowerShell window, you must manually load the correct module by typing
  Import-Module SqlPs
before doing anything else.