Which Database Connection Type Do I Chose?

The uPerform Administration manual does a great job of providing step-by-step instructions on installing the uPerform server, but we’ve noticed that the Vignette Collaboration database options can cause a little confusion to our server administrators! That’s why we decided to shed a little light on what these options mean.

During the Vignette Collaboration installation, you will be presented with 3 options, as shown in the screenshot below:

The options, broken down…

Option 1 – Connect to create a new Vignette Collaboration database: This option applies if you are performing a new installation.

Option 2 – Connect to existing Vignette Collaboration database: This option applies if you are connecting to an existing, pre-populated database during an upgrade, have migrated your database, or if you are changing a current uPerform server installation to a new server and wish to connect to your existing database.

Option 3 – I will configure my database later: Only use this option if you are instructed to do so by ANCILE in special cases.

So where do folks run into trouble? Generally mistakes occur during a first-time installation, as server administrators read over the options and go with Option 2 (Connect to existing Vignette Collaboration database).  During the server installation pre-requisites, the server administrator was instructed to create a new Vignette Collaboration database. Therefore, Option 2 seems like the favorable choice, to have the server to connect to the existing (newly created) Vignette Collaboration database.

Unfortunately, this is not correct!

The correct selection during a first-time installation is Option 1 (Connect to create a new Vignette Collaboration database). Although the database was created during the server installation pre-requisite exercise, the database is considered a new creation since it has not yet been populated with data. Therefore, selecting Option 1 will ensure that Vignette Collaboration can successfully establish a connection to the new Collaboration database.