Installing TopTeam Database Schema for SQL Server

This article illustrates the step-by-step process for installing TopTeam Database Schema for SQL Server on your computer.

• TopTeam Administrators
• IT Support

1. Download the TopTeam Application Server installer from the TechnoSolutions Customer Portal (access to Customer Portal is available only to licensed customers) or the download link provided by TechnoSolutions sales/support team.

The installer file name format is:
TopTeamSQLServerLic_Installer_<TopTeam SQL Server Version>_DB_<TopTeam Database Schema Version Required>_<Release Date>.exe

E.g. TopTeamSQLServerLic_Installer_3.0_Db_5.0_25Jan10.exe

In the above example:
3.0 – is the version number of TopTeam Application Server.
5.0 – is the TopTeam Database version that will be installed by this installer.
25Jan10 – is the release date of this TopTeam Application Server.

2. Ensure that the SQL Server client libraries needed for TopTeam Application Server to connect to SQL Server Database, are installed.
For more detail, refer to the article Database Requirements for TopTeam Repository.

3. Ensure that you have a valid Username and Password ready for connecting to SQL Server.

Double-click the TopTeam Application Server installation file.

Choose the option TopTeam SQL Server DB Schema, if you have already installed TopTeam Application Server and now want to install TopTeam Database Schema on SQL Server.

Choose Yes to run the TopTeam Database Schema installer.

This will run the TopTeam Database Schema installer for SQL Server.

This installer will create database schema to store your Project Data.

Enter the Username and Password for connecting to SQL Server.
You must have enough permissions to create a new database and/or create tables, triggers, etc. in an existing database.

Choose In a new database to install TopTeam repository by creating a new database schema.
Choose In an existing database to install TopTeam repository in an existing empty database schema.

* This article describes the steps using option 1.

Enter New Database Name where schema has to be installed (a new database will be created if it does not already exist). For a new database you must also specify the location of the db file and the log file.

NOTE:This folder must already exist on the computer on which SQL Server is installed.

IMPORTANT:

If you are installing from another computer, file path that you have specified will be created on the computer on which SQL Server is installed.
It has been observed that some enterprises have a security policy specified in SQL Server which doesn’t allow creating database files in the “Program Files” folder, consult your Database Administrator if you are not able to create the database due to security constraints.

It should not create any problem if you create database files in the SQL Server installation folder which is created for SQL Server Databases at the time of installation of SQL Server.

Click Create Database to create the database and proceed.

Script Files contain all the SQL statements that will be fired on Oracle Database to install TopTeam Schema.

Click Install to proceed.

Click Finish to exit TopTeam Database installation.

Log file is created on the computer on which the Database Schema installer has run.

The Log file is created in the following folder:
C:\…\My Documents\TechnoSolutions\DB Schema Installer

In case you face any difficulty in installing TopTeam Database or any error is reported by the installer, TechnoSolutions Support will need this Log file to analyze the problem.

On successful completion, TopTeam Database for User Data (Live Data) is installed.
Now the installer will install the TopTeam Sample Data Database.

Installation of Sample Data is optional. Sample Data is to be used only for training and evaluation purposes.

Choose Yes if you wish to run the TopTeam Database Schema installer for installing Sample Data.
Click Next to continue.

Sample Data will be installed using the TopTeam SQL Server DB Schema installer.
You can refer to the earlier steps in this article for installing TopTeam Database Schema to install TopTeam Sample Database Schema.

Click Finish to exit the installation wizard

Log into SQL Server using SQL Server Management Studio to verify successful installation of TopTeam Databases.

SQL Server Roles and Permissions required for day-to-day working with TopTeam

Revised: September 4th, 2016