Install multiple meta-databases on a single SQL instance

Prerequisite

Complete installation of same CDP version must be performed on the SQL Server instance. Refer to Quick Start for details.

Steps

1. Double-click the setup.exe to launch the CipherTrust Database Protection for MS SQL Server InstallShield Wizard and click Next.

   

   Note

   If the installer detects that CDP is already installed on some instance of SQL Server, the installer prompts you to install CDP on other instances of SQL Server or to update/maintain the existing installation.

2. Select Install a new instance of this application and click Next.

   Note

   If the installer does not detect CDP, then the above prompt does not appear.

3. On the License Agreement screen of the InstallShield Wizard, select the I accept the terms of the license agreement option and click Next.

   

4. On the Setup Type screen of the InstallShield Wizard, select MetaData- Installs Meta Data ** and click Next**.

   

5. On the Instance ID screen of the InstallShield Wizard, confirm the Instance ID for this installation and click Next.

   

   It is recommended that you accept the default Instance ID. Once you accept the Instance ID, you should not change it. If you change your Instance ID, you must drop and recreate any existing user mappings for this SQL Server instance from the CipherTrust Manager UI.

   If you receive the following error message: Unable to open OLE32.DLL. Can’t find file!

   Note

   You might change the default Instance ID if the database is involved in replication activities such as log shipping. In that case, the Instance ID should be modified so that all databases in the replication group have the same Instance ID.

6. On the Database Connection screen of the InstallShield Wizard, enter the database connection parameters and click Next.

   

   The following table lists the parameters that are required when creating database connection.

   Parameter	Description
   Server Hostname or IP Address	The hostname or IP address of the machine where SQL Server is installed. The default is local. In case of SQL Cluster setup, the IP address of the virtual server should be specified here.
   Instance Name	The default instance name is MSSQLSERVER. It might be the case that there are multiple instances of the database installed on your local machine.
   SQL Server Authentication or Windows Authentication	Type of authentication to install CDP. When the Windows Authentication option is selected, the logged in user’s Windows authentication is used to connect to the database.
   Database User Name	Specify the database user name when using SQL Server authentication. In case of Windows authentication, the logged in user’s name is displayed. The user name used for the database connection must be a member of the sysadmin fixed server role to permit the creation of extended stored procedures.
   Database Password	The password for the database user specified above. For Windows authentication, it is not editable as the logged in Windows user’s password is used.

7. On the Select Database screen of the InstallShield Wizard, select the Database Name where you want to install the metadata and click Next.

   Note

   The Database Name used during the MetaData installtion must be different form the one used in the full installation.

   

8. On the Ready to Install the Program screen of the Installation Wizard, click Install.

   

   The installer displays the progress of the installation.

9. After the files are installed, click Finish to complete the installation.