Databases

The Database component is a Microsoft SQL Server that services the Main database for requests from Client, Business Administrator, and Database Administrator. The Main database is attached to the Microsoft SQL Server when the Database component is installed.

Note: The Database component was referred to as "Talisma Server" or "Talisma Main Database" in previous versions.

Preinstallation Tasks

Identify and install the prerequisite software. See Software Requirements by Component — Database.

Important: While installing the Main database of multiple customers on a single SQL Server instance, ensure to specify unique license keys for each customer database. You can specify the license key when installing the database in the Global Settings screen of Installation Manager or while running the setup.exe of the Database component.

• Uninstall and reinstall MSDTC service on the computer where you plan to install the Database component. To do so:

  1. Log in as the administrator of the computer.

  2. Open the command prompt and run the MSDTC -uninstall command.

  3. Restart the computer.

  4. Type Services.msc in the Run dialog box. The Services screen is displayed.

  5. Ensure that the Distributed Transaction Coordinator service is removed from the list.

  6. Open the command prompt and run the MSDTC -install command.

  7. Open the Services.msc and set the Startup type for the Distributed Transaction Coordinator service to Automatic.

• In a distributed server scenario, ensure that the SQL Server Agent service is stopped on all the servers.

• In an environment where the Main database and Subscriber database have to be installed, ensure that you complete the installation of the Main database followed by the Subscriber database.

 

Preinstallation Tasks in a Distributed Environment

• Before installing a Subscriber database (Analytics, Archive, Media, or WebTrak), ensure that the Require distributed transactions for server-to-server communication option in MS SQL Server Management Studio is cleared.

• Ensure that the Windows user who installs the Database component has a corresponding SQL Login with sysadmin role.

   

Installation in a Cluster Server Environment

• Configure and install the Main database, Distributor database, and all Subscriber databases on the Primary Node (Active) of the MS Cluster Server.

• Provide the path of the Cluster Disk for the target and backup folders of the Database component during installation.

Note: It is not mandatory to install Distributor and Subscriber databases in a clustered environment. The Destination directory should be on a shared drive.

On the Database screen in Installation Manager, use the following options for the Main database, Distributor database, and all Subscriber databases:

• Specify the SQL Cluster Name in the SQL Server field.
• Select the Cluster check box.
• Enter the name of the Active cluster node in the Cluster Node field.

For more details, see Cluster Server Environment.

 

Support for Multiple Databases on a Single Server

In previous versions, multiple versions of the Database component could not be installed on a single SQL Server instance. In this release, CampusNexus CRM provides the ability to install multiple versions of the Database component on a single SQL server instance. On a single Database, databases of multiple customers can be installed and hosted simultaneously.

This enhancement has the following impact on CampusNexus CRM:

• Services – In previous releases, Health Check Service, Job Service, and Offline Sync Service were created by the Database installer. In this release, you can create these services using Database Administrator on any computer.

  Note: In this release, Offline Service is renamed to Webform Sync Services.

  In addition, Scheduled Report (TLRptXL.exe) will also be removed. You can create this service using Database Administrator on any computer.

• Database folders – While installing the Database component, you must specify the name of the Main databases of multiple customers being installed. For example, if you are hosting databases of WorldWaves University and Global Education Society, you can specify the database names as WorldWaves_tlmain and Global_tlmain during the installation process. When the installation is complete, the following folders are created on the computer where the Database component is installed:

  For WorldWaves-tlmain

  <Drive name>:\Program Files\Common Files\Talisma Shared\WorldWaves_tlMain\

  <Drive name>:\Program Files(x86)\Common Files\Talisma Shared\WorldWaves_tlMain\

  <Drive name>:\TalismaServer\WorldWaves_tlmain

  For Global-tlmain

  <Drive name>:\Program Files\Common Files\Talisma Shared\Global_tlMain\

  <Drive name>:\Program Files(x86)\Common Files\Talisma Shared\Global_tlMain\

  <Drive name>:\TalismaServer\Global_tlmain

• Setup Logs – Log folders are suffixed with the database name. For example, if the name of the WorldWaves database is WorldWaves-tlmain, log files of the WorldWaves database will be stored in the <Drive name>:\Program Files\Common Files\Talisma Shared\SetupLog\WorldWaves-tlmain folder.

• Registry keys – Registry key folder suffixed by the database name is created in the HKEY_ LOCAL_MACHINE\SOFTWARE\Talisma\Talisma Server\<database name> path. For example, if the database name specified during the installation of Database is WorldWaves- DB, the registry keys are created in the HKEY_ LOCAL_MACHINE\SOFTWARE\Talisma\TalismaServer\WorldWaves-tlmain path.

• The TLSchExport.exe will now be copied in the <Drive name>:\Program Files (x86) \Common Files\Talisma Shared\<database name> path. Hence, if you have multiple versions of database installed on a single SQL server instances, TLSchExport.exe will be available for every database.

 

Set Up Databases

1. In the Installation menu, click Database. The Database Settings screen is displayed.

   

   The Database screen contains configurable fields that users can change to add, delete, copy, and test databases being used in an installation. The elements of this screen are unique to the CampusNexus CRM installation.

   Note: Ensure that the default SQL Server settings are appropriate.

   • Installation Manager supports multiple databases (listed in the Database Type column), but only one type of database is allowed to be installed at a time on one machine.

   • Multiple databases cannot be installed on the same SQL Server at the same time.

   • Different Database Types can be installed on different SQL servers at the same time.

   • To install multiple Main databases on a same server, one must be set to Install, but the other Main database must be set to None.

   • A Main database must be present on this screen with action set to None, even if the Main database is not going to be installed.

   • All Subscriber databases must be pointed to a Main database.

2. Click Add to add a line to the Settings screen.

3. Select an appropriate Action. The following Action values are available:

   • None – Performs no action.

   • Install – Performs a fresh installation or upgrade of a component. You can install or upgrade multiple components at the same time.

   • Detach – Detaches one Subscriber database at a time per machine. Action can be set to Detach on multiple Subscriber databases on multiple servers at the same time.

   • Uninstall – Removes all subcomponents on that machine and uninstalls the component from Programs and Features. Select Uninstall from the Action menu to Uninstall all databases on the SQL Server.

     Important: Main and Subscriber databases attached to the Main database on the same machine will be uninstalled.

   • Reinstall – Retries to install a subcomponent.

   • InstallFailover - Installs a cluster failover component.

   • AttachFailover - Attaches a cluster failover component.

   • DetachFailover - Detaches a cluster failover component.

   • ReinstallFailover - Reinstalls a cluster failover component.

   • UninstallFailover - Uninstalls a cluster failover component.

   Optional: Click Select All to set the Action field to Install for all components listed on this screen. Click Unselect All to set the Action field to None.

4. Specify the name of the SQL Server on which the database resides. User credentials from the Global Settings screen are used to access this server.

   If CampusNexus CRM is installed in an SQL cluster environment, specify the SQL cluster name (not the node name) in the SQL Server field.

5. Specify the Database Name of a valid CampusNexus CRM database. User credentials supplied in the Global Settings screen are also valid for this database.

6. Select the Database Type. The following Database Types are available:

   • Main
   • Analytics
   • Distributor
   • Media
   • WebTrak
   • Archive

7. If CampusNexus CRM is installed in an SQL cluster environment, select the Cluster check box and specify the name of the Active  cluster node in the Cluster Node field for the Main database, Distributor database, and all Subscriber databases.

   If a failover cluster is deployed, enter Failover Node name in the Cluster Node field and select an appropriate failover action in the Action field.

   Refer to Cluster Server Environment for additional instructions.

8. Click to copy a line. Edit the copied line as needed.

   Copy as many lines as needed to create the Database / Database Type combinations required for the installation.

9. Click to view and edit the Options form for each Database / Database Type combination. Options forms include the following:

   • Main Database Options
   • Analytics Database Options
   • Distributor Database Options (Note: Distributor databases can only be run with SQL Integrated Authorization turned. See Global Settings.)
   • Media Database Options
   • WebTrak Database Options
   • Archive Database Options

             

   Database Options Fields

   Field	Description
   Instance Name	SQL Server instance name where server will be installed.
   Database Name	Machine Name on the Database Settings screen. To connect to an existing Main database, users must select Connect to existing Main database and add the remote file path for the MDF.
   Connect to existing <Database Type> database	Select to connect to the named Database Type.
   Remote File Path	The Universal Naming Convention (UNC) path of the share where the Main Database File (MDF) exists. Becomes active when Connect to existing Main database is selected. The MDF can exist on the local machine. Click Browse to open a File Dialog to browse to the UNC path of the share where the MDF exists. The Installer converts the UNC path to a local path on the remote machine.
   Backup Directory	Use this field to specify the backup directory for the database.
   Database Identifier	This field is displayed for the Main database only. Unique database identifier consisting of 3-10 characters. The Database Identifier appears in the Subject line of outgoing messages, therefore identifying from which server the email message was sent. This line only appears if the interaction ID in the Subject Threading Model is selected when configuring an Alias. All database installation is done using integrated authentication only.  Note: Use only supported characters as part of the Database Identifier. Do not use the following characters: Unsupported Characters for Database Identifier Character Description [ ] square brackets \ backslash & CR ampersand followed by carriage return (CR) & including LWS ampersand including linear white space (LWS), i.e., any number of spaces, horizontal tabs, or newlines
   Main Database	This field is displayed in the Options screens for databases other than Main. Select the Main database from the drop-down list. Note: The Database Options forms must point to the proper Main database. Database Types with the same name can point to different Main databases. Some users might have a different Instance Name for the default SQL server; this name would be changed in the Options form.

10. Click OK to save changes on the Options form. The form is closed.

11. Click to delete a selected line.

12. Accept the default Destination Directory or select a directory where the information for this component is stored. Changing this directory will apply across all machines in the Machine Name column.

    To install a Database to a custom path, type the path in the Destination Directory text box. This appends the directory location with Main database name at the time of install.

    For example for Main database called ASUMainDB, the default destination directory would be C:\TalismaServer\ASUMainDB and a Subscriber database attaching to this Main database would go under ASUMainDB directory.

13. Click Test to ensure the setup for the corresponding line is correct. If a test on a particular line fails, check all associated fields and click Test again.

14. If all tests pass, click .

     

Postinstallation Tasks

• After installing the Database component, it is mandatory to restart the computer.

  In a scenario where multiple customer Main databases are installed, you must restart the computer after installing the Main database of the first customer. Restarting the computer after subsequent installations of other customer databases is optional.

• Start the SQL Server Agent service manually. Ensure that the service is running in a domain user account which has administrative privileges.

• In a distributed server scenario, ensure that the value of the Data Access option is True in the Linked Servers Properties dialog box for all the computers where CampusNexus CRM databases are installed. To do so:

  1. Open SQL Server Management Studio.

  2. Navigate to the Server Objects\Linked Servers folder.

  3. Right-click on the server name and select Properties from the shortcut menu. The Linked Server Properties screen is displayed.

  4. Click the Server Options in the left pane.

  5. In the right pane, ensure that the value of the Data Access option is set to True.

• Ensure that the Talisma-CreatePreDefObjects job has already run. To do so:

  1. Start Microsoft SQL Server Management Studio.

  2. Navigate to the Jobs node under the SQL Server Agent node.

  3. Locate the Talisma-CreatePreDefObjects job, and confirm that the Enable option is dimmed.

• Check the Replication Monitor settings. To do so:

  1. Start Microsoft SQL Server Management Studio.

  2. Navigate to the Replication node. Right-click on the Replication node and select Launch Replication Monitor.

  3. In the Replication Monitor, check whether the Snapshot Agent, Distributor Agent, and Subscriber Agent are created, and whether the Initial Snapshot has been generated.

• If errors are encountered during the setup of the Main database, check all log files in the <Drive name>:\Program Files\Common Files\Talisma Shared\Setuplog\<database name>\ path.

• When the Database component is installed afresh, by default the value of the Recovery model option for Database is set to Simple. Perform the following step for Distributor Server, Analytics Server, Media Server, and WebTrak Server:

  1. Start Microsoft Server Management Studio.

  2. Navigate to <Server name>, <Database name for which the Recovery model has to be set>.

  3. Right-click and select Properties from the shortcut menu.

  4. Select Options and set the Recovery model option to Full.

• In a distributed server environment, on the computer where Main database is installed, navigate to the Securities tab of the Linked Server Properties dialog box, and set the login name (format: Talisma<Main database name>) and password details for subscriber database servers.

  Ensure that the login name is set in the Local Login and Remote User fields, and the password must be identical to the value set in the Talismaadmin Password field of the CRM Global Settings screen.

  Perform the same step on computers where subscriber databases are installed, i.e., set the same login name and password details for the linked server of Main database server.

• To create non-clustered indexes for ReportMailer and CampaignTarget, run the following script on the computer where the Main database is installed:

  
  If Not Exists(Select Top 1 1 From sys.indexes Where name = 'IDX_tblOBMReportMailer_nCustomerID_nBaseObjectType' And Object_ID = OBJECT_ID('tblOBMReportMailer'))
  Begin
  CREATE NONCLUSTERED INDEX IDX_tblOBMReportMailer_nCustomerID_nBaseObjectType
  ON [tblOBMReportMailer] ([nCustomerID],[nBaseObjectType])
  End
  GO
  If Not Exists(Select Top 1 1 From sys.indexes Where name = 'IDX_tblCampaignTarget_nCustomerID_nBaseObjectType' And Object_ID = OBJECT_ID('tblCampaignTarget'))
  Begin
  CREATE NONCLUSTERED INDEX IDX_tblCampaignTarget_nCustomerID_nBaseObjectType
  ON [tblCampaignTarget] ([nCustomerID],[nBaseObjectType])
  End
  GO

• For scheduled export configurations to run in the current version, perform the following steps on the Main database computer:

  1. In the Properties dialog of the scheduled export job, navigate to Steps, Export Step, Edit.

  2. Specify the full path of the tlschexport.exe in the following format

     ’“<Drive name>:\<path>\tlschexport.exe”. . . . .other details’

     Ensure that the double quotation marks are specified at the beginning (after the single quotation mark) and after tlschexport.exe. The single quotation marks must continue to be specified at the beginning and at the end.

Database Version in Control Panel

When the Database component is installed, an entry is recorded in the Programs and Features screen of Control Panel. If a single version of Database is installed on a SQL Server instance, the version number of the installed Database is displayed in the Version column. If multiple versions of Database are installed on a single SQL Server instance, the value "Multiple versions" is displayed in the Version column.

Note: You cannot uninstall Database through Control Panel. To uninstall Database, use the Uninstall option in Installation Manager.