Unable to install or upgrade Archive Manager 4.6 in a clustered SQL environment. When entering in the SQL cluster name in the database portion of the installer, it is reverting to the active SQL node in the cluster and the installation/upgrade fails.
When attempting to verify the SQL server's hostname AM uses the response from a WMI query to obtain the full server name as seen by WMI. This typically works with the exception of a clustered SQL server. When the SQL cluster's address is entered, the call is made and the first avaialble SQL server in the cluster will answer. The problem is it answers with its own hostname and not that of the cluster's. It then provides that hostname for the database installer and fails because the machine needs to be accessed via the cluster address.
Update the hosts file, redirecting the virtual cluster IP to the physical SQL node.
In this example the environmental information is as follows:
# This is an example of the hosts file
127.0.0.1 localhost loopback
Run AfterMail.Setup.DatabaseInstaller.exe manually then rerun the installer and choose the Upgrade option.
AfterMail.Setup.DatabaseInstaller.exe -u -server=SQLServer -database=ArchiveManager
In cases where the SQL database on the cluster has already been upgraded and the requirement is to install another component of the product, for example Archive Manager web services on a dedicated web server, the option would be to proceed as follows:
Copy the encrypted connection string from the real Archive Manager Services Server and overwrite the one in the registry on the web server, then open the Archive Manager Configuration Editor, if it connects and you see the proper configuration values, you are now running on against the correct database.
a) On the AM server, click Start | Run, type Regedit and navigate to the correct part of the registry based on OS type:
b) Export the entire branch to a .REG file as a backup.
c) Modify the key called ConnectionString (copy from the original AM services server and paste it into the Archive Manager Web server registry).