Jira Align Enterprise Insights Self-Hosted: Invoke-Sqlcmd A parameter cannot be found that matches parameter name 'Credential'

Summary

When running the installation for Enterprise Insights Self-Hosted, it will fail with the error message Invoke-Sqlcmd A parameter cannot be found that matches the parameter name 'Credential'

Environment

Jira Align Self-Hosted

Diagnosis

You are attempting to install EI Self-Hosted and are running .\Install.ps1 as per step 3 of the Installation Instructions (found: Jira Align Self-Hosted Enterprise Insights installation – Jira Align)

Cause

The version of Invoke-SqlCmd does not have the Credential Parameter

Solution

Install a more recent version of the SqlServer Module