In this article
CATI Multimode relies on Linked Server to access, attach and use survey databases. The linked servers used by CATI Multimode must be created prior to the installation start.
Important
A Linked Server entry must exist for all SQL instances used with Forsta Plus.
Two scripts must be run to create linked servers; one script must be run on the Forsta Plus SQL instance to establish a link with the Multimode SQL instance, and another must be run on the Multimode SQL instance to establish a link with the Forsta Plus SQL instance. The image below shows an example of the PowerShell script that must be run on the Forsta Plus SQL instance.
In the script, replace <Multimode SQL Instance> with the Multimode SQL Server name, then run this script on all Forsta Plus SQL Instances.
In the event SQL 2012 server version is used, the following server option must have the following value: @provider=N'SQLNCLI11'. All server options shown in the script example must retain their default values except for the 'rpc' and 'rpc out' options - these must be set to "true".
Figure 1 - Creating a linked server on the Forsta Plus SQL instance
The image below shows an example of the PowerShell script that must be run on the CATI Multimode SQL instance. In the script replace <Confirmit SQL Instance> with the Forsta Plus SQL Server name, then run the script on all CATI Multimode SQL instances.
In the event the SQL 2012 server version is used, the server option must have the following value: @provider=N'SQLNCLI11'. All server options shown in the script example should retain their default values except for the 'rpc' and 'rpc out' options - these should be set to "true".
Figure 2 - Creating a linked server on the Multimode SQL instance