{"id":511,"date":"2011-05-31T01:41:45","date_gmt":"2011-05-31T08:41:45","guid":{"rendered":"http:\/\/www.technosolutions.com\/kb\/511\/installing-topteam-application-server-for-sql-server\/"},"modified":"2018-12-28T04:36:36","modified_gmt":"2018-12-28T12:36:36","slug":"installing-topteam-application-server-for-sql-server-database","status":"publish","type":"post","link":"http:\/\/www.technosolutions.com\/kb\/511\/installing-topteam-application-server-for-sql-server-database\/","title":{"rendered":"Installing TopTeam Application Server for SQL Server Database"},"content":{"rendered":"<p><!-- Start ScreenSteps Content --><\/p>\n<div class=\"LessonContent\">\n<div class=\"LessonStep top\">\n<h3 class=\"StepTitle\" style=\"font-size: 20px;\">Overview<\/h3>\n<div class=\"StepInstructions\">\n<p>This article describes how to install <i>TopTeam Application Server for SQL Server Database<\/i>.<\/p>\n<p><strong>If you want to install <i>TopTeam Application Server <\/i>for another database, refer to the article <a href=\"http:\/\/www.technosolutions.com\/kb\/43262\/installing-topteam-application-server\/\" target=\"_blank\" rel=\"noopener\">Installing TopTeam Application Server<\/a><\/strong><strong>.<\/strong><\/p>\n<\/div>\n<\/div>\n<div class=\"LessonStep top\">\n<h3 class=\"StepTitle\" style=\"font-size: 20px;\">Who should read this?<\/h3>\n<div class=\"StepInstructions\">\n<ul>\n<li>TopTeam Administrators<\/li>\n<li>System Administrators<\/li>\n<li>IT Support<\/li>\n<li>Database Administrators<\/li>\n<\/ul>\n<\/div>\n<\/div>\n<div class=\"LessonStep top\">\n<h3 class=\"StepTitle\" style=\"font-size: 20px;\">Where TopTeam Application Server should be installed?<\/h3>\n<div class=\"StepInstructions\">\n<p><i>TopTeam Application Server<\/i> can be installed on a personal computer or a Windows Server computer. When evaluating <i>TopTeam<\/i>, you can even install <i>TopTeam Application Server<\/i> on a laptop, however, for production usage you should use a desktop or a server class computer.<\/p>\n<p>We recommend you to install <i>TopTeam Application Server<\/i> on the latest Windows Server computer.<\/p>\n<\/div>\n<\/div>\n<div class=\"LessonStep top\">\n<h3 class=\"StepTitle\" style=\"font-size: 20px;\">Do you need to have Windows Administrator privileges to install TopTeam Application Server?<\/h3>\n<div class=\"StepInstructions\">\n<p>To install <i>TopTeam Application Server<\/i> as a <i>Windows Service<\/i>, you should log into the computer as a Windows Administrator. You do not require Windows Administrator privileges if you want to run <i>TopTeam Application Server<\/i> as a <i>Windows Application<\/i>.<\/p>\n<p>We recommend that you install <i>TopTeam Application Server<\/i> as a Windows Service for production usage.<\/p>\n<\/div>\n<\/div>\n<div class=\"LessonStep top\">\n<h3 class=\"StepTitle\" style=\"font-size: 20px;\">Does one need to purchase a license to install and use TopTeam Application Server?<\/h3>\n<div class=\"StepInstructions\">\n<p>You do not need to purchase a license upfront to install and evaluate TopTeam. By default, <i>TopTeam Application Server<\/i> will start in an evaluation mode if you do not provide a valid license key.<br \/>\nUpon expiration of the evaluation period,<i>TopTeam Application Server<\/i> will stop running.<\/p>\n<p>To continue using <i>TopTeam<\/i>, you need to purchase a permanent license key or contact a TechnoSolutions sales representative for an extension key.<\/p>\n<\/div>\n<\/div>\n<div class=\"LessonStep top\">\n<h3 class=\"StepTitle\" style=\"font-size: 20px;\">Preparations<\/h3>\n<div class=\"StepInstructions\">\n<p>1. Download the latest <i>TopTeam Application Server<\/i> installer from the <a href=\"https:\/\/customerportal.technosolutions.com\" target=\"_blank\" rel=\"noopener\">TechnoSolutions Customer Portal<\/a> (access to Customer Portal is available only to licensed customers) or use the download link provided by TechnoSolutions.<\/p>\n<p>The installer file name format is:<br \/>\n<i>TopTeamSQLServerLic_Installer_<strong>&lt;TopTeam SQL Server Version&gt;<\/strong>_DB_<strong>&lt;TopTeam Database Schema Version Required&gt;<\/strong>_<strong>&lt;Release Date&gt;<\/strong>.exe<\/i><\/p>\n<p>E.g. <strong>TopTeamSQLServerLic_Installer_5.0_Db_8.0_31Jul14.exe<\/strong><\/p>\n<p>In the example above:<br \/>\n<strong>5.0<\/strong> &#8211; is the version number of <i>TopTeam Application Server<\/i><br \/>\n<strong>8.0<\/strong> &#8211; is the TopTeam database version which will be installed by this installer<br \/>\n<strong>31Jul14<\/strong> &#8211; is the release date of this <i>TopTeam Application Server<\/i><\/p>\n<p>2. Ensure that SQL Server client libraries, needed for <i>TopTeam Application Server<\/i> to connect to SQL Server database, are installed.<br \/>\nFor more details, refer to the article <a href=\"http:\/\/www.technosolutions.com\/kb\/911\/database-requirements-for-topteam\/\" target=\"_blank\" rel=\"noopener\">Database Requirements for TopTeam Repository.<\/a><\/p>\n<p>3. If you want to install and run <i>TopTeam Application Server <\/i>as a Windows Service, ensure that you have logged into the computer as a <strong>Windows Administrator<\/strong>.<\/p>\n<p>4. Ensure that you have a <strong>valid user name and password of a SQL Server User that has the privileges to create a database on SQL Server.<\/strong> This is required to install the TopTeam database schema on SQL Server.<\/p>\n<\/div>\n<\/div>\n<div class=\"LessonStep top\">\n<h3 class=\"StepTitle\" style=\"font-size: 20px;\">Prerequisites<\/h3>\n<div class=\"StepInstructions\">\n<ul>\n<li>Ensure that the computer on which you will install <i>TopTeam Application Server<\/i>, meets the <a href=\"http:\/\/www.technosolutions.com\/kb\/524\/system-requirements-for-topteam-application-server\/\" target=\"_blank\" rel=\"noopener\">System Requirements for TopTeam Application Server.<\/a><\/li>\n<\/ul>\n<\/div>\n<\/div>\n<div class=\"LessonStep top\">\n<h3 class=\"StepTitle\" style=\"font-size: 20px;\">Step 1. Run the TopTeam Application Server Installer<\/h3>\n<div class=\"StepImage\" style=\"margin: 10px 0px;\"><img loading=\"lazy\" decoding=\"async\" style=\"padding: 3px; border: 1px solid #ccc;\" src=\"data:image\/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==\" data-layzr=\"http:\/\/www.technosolutions.com\/kb\/wp-content\/uploads\/2018\/07\/wpid33585-media_1421047090675.png\" alt=\"wpid33585-media_1421047090675.png\" width=\"277\" height=\"95\" \/><\/div>\n<div class=\"StepInstructions\">\n<p><span style=\"color: #000000;\">Double-click the <i>TopTeam Application Server<\/i> installation file.<\/span><\/p>\n<\/div>\n<\/div>\n<div class=\"LessonStep top\">\n<h3 class=\"StepTitle\" style=\"font-size: 20px;\">Step 2. &#8216;TopTeam Application Server for SQL Server&#8217; Setup Wizard opens<\/h3>\n<div class=\"StepImage\" style=\"margin: 10px 0px;\"><img loading=\"lazy\" decoding=\"async\" style=\"padding: 3px; border: 1px solid #ccc;\" src=\"data:image\/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==\" data-layzr=\"http:\/\/www.technosolutions.com\/kb\/wp-content\/uploads\/2018\/07\/wpid33566-media_1420634947087.png\" alt=\"wpid33566-media_1420634947087.png\" width=\"511\" height=\"394\" \/><\/div>\n<\/div>\n<div class=\"LessonStep top\">\n<h3 class=\"StepTitle\" style=\"font-size: 20px;\">Step 3. Read and accept the License Agreement for TopTeam Application Server<\/h3>\n<div class=\"StepImage\" style=\"margin: 10px 0px;\"><img loading=\"lazy\" decoding=\"async\" style=\"padding: 3px; border: 1px solid #ccc;\" src=\"data:image\/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==\" data-layzr=\"http:\/\/www.technosolutions.com\/kb\/wp-content\/uploads\/2018\/07\/wpid33567-media_1420635090092.png\" alt=\"wpid33567-media_1420635090092.png\" width=\"511\" height=\"394\" \/><\/div>\n<\/div>\n<div class=\"LessonStep top\">\n<h3 class=\"StepTitle\" style=\"font-size: 20px;\">Step 4. Choose Setup Type<\/h3>\n<div class=\"StepImage\" style=\"margin: 10px 0px;\"><img loading=\"lazy\" decoding=\"async\" style=\"padding: 3px; border: 1px solid #ccc;\" src=\"data:image\/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==\" data-layzr=\"http:\/\/www.technosolutions.com\/kb\/wp-content\/uploads\/2018\/07\/wpid33568-media_1420635151198.png\" alt=\"wpid33568-media_1420635151198.png\" width=\"511\" height=\"394\" \/><\/div>\n<div class=\"StepInstructions\">\n<ul>\n<li>Choose option 1 <strong>(TopTeam Server for SQL Server and SQL Server DB)<\/strong> if you want to install <i>TopTeam Application Server<\/i> as well as <i>TopTeam Database Schema<\/i>.<\/li>\n<li>Choose option 2 <strong>(TopTeam Server for SQL Server)<\/strong> to install only <i>TopTeam Application Server.<\/i> Choose this option if <i>TopTeam Database Schema<\/i> has already been installed.<\/li>\n<li>Choose option 3 <strong>(TopTeam SQL Server DB Schema)<\/strong> if you have already installed <i>TopTeam Application Server<\/i> and now want to install <i>TopTeam Database Schema on SQL Server<\/i>.<\/li>\n<\/ul>\n<p>This article describes the steps for the first option. The steps for options 2 and 3 are a sub-set of the steps for option 1.<\/p>\n<\/div>\n<\/div>\n<div class=\"LessonStep top\">\n<h3 class=\"StepTitle\" style=\"font-size: 20px;\">Step 5. Specify the installation folder for TopTeam Application Server<\/h3>\n<div class=\"StepImage\" style=\"margin: 10px 0px;\"><img loading=\"lazy\" decoding=\"async\" style=\"padding: 3px; border: 1px solid #ccc;\" src=\"data:image\/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==\" data-layzr=\"http:\/\/www.technosolutions.com\/kb\/wp-content\/uploads\/2018\/07\/wpid33569-media_1420635316856.png\" alt=\"wpid33569-media_1420635316856.png\" width=\"511\" height=\"394\" \/><\/div>\n<div class=\"StepInstructions\">\n<p>Choose the folder where you want to install <i>TopTeam Application Server for SQL Server<\/i> on your computer. Ensure that you have READ and WRITE permission on this folder. We recommend you to keep at least 2 GB of free disk space on the drive where you install <i>TopTeam Application Server<\/i> for log files that are created while the application is running.<\/p>\n<p>Default folder: C:\\Program Files\\TechnoSolutions TopTeam\\Application Server for SQL Server<\/p>\n<\/div>\n<\/div>\n<div class=\"LessonStep top\">\n<h3 class=\"StepTitle\" style=\"font-size: 20px;\">Step 6. Specify in which mode TopTeam Application Server should run<\/h3>\n<div class=\"StepImage\" style=\"margin: 10px 0px;\"><img loading=\"lazy\" decoding=\"async\" style=\"padding: 3px; border: 1px solid #ccc;\" src=\"data:image\/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==\" data-layzr=\"http:\/\/www.technosolutions.com\/kb\/wp-content\/uploads\/2018\/07\/wpid33570-media_1420635447771.png\" alt=\"wpid33570-media_1420635447771.png\" width=\"511\" height=\"394\" \/><\/div>\n<div class=\"StepInstructions\">\n<p><i>TopTeam Application Server<\/i> can be installed in one of these two modes:<\/p>\n<p><strong>1. Install as Windows Service (Recommended)<\/strong><br \/>\nChoose this option to install <i>TopTeam Application Server<\/i> as a Windows Service. You must log in as a Windows Administrator to install <i>TopTeam Application Server<\/i> as a Windows Service.<\/p>\n<p><strong>2. Install as Application<\/strong><br \/>\nChoose this option to install <i>TopTeam Application Server<\/i> as a Windows Application. Use this option if you do not have <i>Windows Administrator<\/i> privileges on the computer and want to evaluate TopTeam.<\/p>\n<p>We recommend you to go with option 1 unless you don\u2019t have Windows Administrator privileges on this computer.<\/p>\n<p><strong>You can always change this configuration setting later.<\/strong><\/p>\n<\/div>\n<\/div>\n<div class=\"LessonStep top\">\n<h3 class=\"StepTitle\" style=\"font-size: 20px;\">Step 7. Review the installation summary<\/h3>\n<div class=\"StepImage\" style=\"margin: 10px 0px;\"><img loading=\"lazy\" decoding=\"async\" style=\"padding: 3px; border: 1px solid #ccc;\" src=\"data:image\/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==\" data-layzr=\"http:\/\/www.technosolutions.com\/kb\/wp-content\/uploads\/2018\/07\/wpid33571-media_1420635540730.png\" alt=\"wpid33571-media_1420635540730.png\" width=\"511\" height=\"394\" \/><\/div>\n<div class=\"StepInstructions\">\n<p><span style=\"color: #000000;\">Review the installation summary for <i>TopTeam Application Server for SQL Server<\/i>.<\/span><br \/>\nClick <i><strong>Install<\/strong><\/i> to proceed with the installation.<\/p>\n<\/div>\n<\/div>\n<div class=\"LessonStep top\">\n<h3 class=\"StepTitle\" style=\"font-size: 20px;\">Step 8. Install TopTeam Database Schema for User Data<\/h3>\n<div class=\"StepImage\" style=\"margin: 10px 0px;\"><img loading=\"lazy\" decoding=\"async\" style=\"padding: 3px; border: 1px solid #ccc;\" src=\"data:image\/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==\" data-layzr=\"http:\/\/www.technosolutions.com\/kb\/wp-content\/uploads\/2018\/07\/wpid33572-media_1420635606112.png\" alt=\"wpid33572-media_1420635606112.png\" width=\"511\" height=\"394\" \/><\/div>\n<div class=\"StepInstructions\">\n<p>Choose <i><strong>Yes<\/strong><\/i> to run <i>TopTeam Database Schema<\/i> installer. <i>TopTeam<\/i> stores all your project data in this database schema.<\/p>\n<\/div>\n<\/div>\n<div class=\"LessonStep top\">\n<h3 class=\"StepTitle\" style=\"font-size: 20px;\">Step 9. Final confirmation before launching the TopTeam Database Schema installation wizard<\/h3>\n<div class=\"StepImage\" style=\"margin: 10px 0px;\"><img loading=\"lazy\" decoding=\"async\" style=\"padding: 3px; border: 1px solid #ccc;\" src=\"data:image\/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==\" data-layzr=\"http:\/\/www.technosolutions.com\/kb\/wp-content\/uploads\/2018\/07\/wpid33573-media_1420635654475.png\" alt=\"wpid33573-media_1420635654475.png\" width=\"511\" height=\"394\" \/><\/div>\n<div class=\"StepInstructions\">\n<p>This will run <i>TopTeam Database Schema installer for SQL Server.<\/i><\/p>\n<\/div>\n<\/div>\n<div class=\"LessonStep top\">\n<h3 class=\"StepTitle\" style=\"font-size: 20px;\">Step 10. Welcome Screen of the TopTeam Database Schema installation wizard<\/h3>\n<div class=\"StepImage\" style=\"margin: 10px 0px;\"><img loading=\"lazy\" decoding=\"async\" style=\"padding: 3px; border: 1px solid #ccc;\" src=\"data:image\/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==\" data-layzr=\"http:\/\/www.technosolutions.com\/kb\/wp-content\/uploads\/2018\/07\/wpid33574-media_1420635704293.png\" alt=\"wpid33574-media_1420635704293.png\" width=\"749\" height=\"522\" \/><\/div>\n<\/div>\n<div class=\"LessonStep top\">\n<h3 class=\"StepTitle\" style=\"font-size: 20px;\">Step 11. Connect to the SQL Server where you want to install the TopTeam database<\/h3>\n<div class=\"StepImage\" style=\"margin: 10px 0px;\"><img loading=\"lazy\" decoding=\"async\" style=\"padding: 3px; border: 1px solid #ccc;\" src=\"data:image\/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==\" data-layzr=\"http:\/\/www.technosolutions.com\/kb\/wp-content\/uploads\/2018\/07\/wpid33575-media_1420635748384.png\" alt=\"wpid33575-media_1420635748384.png\" width=\"749\" height=\"522\" \/><\/div>\n<div class=\"StepInstructions\">\n<p>Enter the<i> <strong>Database Username<\/strong><\/i> and <i><strong>Password<\/strong><\/i> and the SQL Server instance name that should be used to connect to the SQL Server.<br \/>\nUse <i><strong>Windows Authentication<\/strong><\/i> if you want the installer to connect to SQL Server using credentials of current logged in Windows User.<\/p>\n<p>NOTE: The database user, who is being used to connect to the SQL Server must have privileges to create a new database and\/or create tables, triggers, etc. in an existing database.<\/p>\n<\/div>\n<\/div>\n<div class=\"LessonStep top\">\n<h3 class=\"StepTitle\" style=\"font-size: 20px;\">Step 12. Specify where you want to install TopTeam Database Schema<\/h3>\n<div class=\"StepImage\" style=\"margin: 10px 0px;\"><img loading=\"lazy\" decoding=\"async\" style=\"padding: 3px; border: 1px solid #ccc;\" src=\"data:image\/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==\" data-layzr=\"http:\/\/www.technosolutions.com\/kb\/wp-content\/uploads\/2018\/07\/wpid33576-media_1420697527951.png\" alt=\"wpid33576-media_1420697527951.png\" width=\"750\" height=\"523\" \/><\/div>\n<div class=\"StepInstructions\">\n<p>Choose option 1 <strong>(In a new database)<\/strong> to install <i>TopTeam repository<\/i> by creating a new database Schema.<br \/>\nChoose option 2 <strong>(In an existing database)<\/strong> to install <i>TopTeam repository<\/i> in an existing empty database schema.<\/p>\n<p>This article describes the steps with option 1.<\/p>\n<\/div>\n<\/div>\n<div class=\"LessonStep top\">\n<h3 class=\"StepTitle\" style=\"font-size: 20px;\">Step 13. Create a new database for TopTeam<\/h3>\n<div class=\"StepImage\" style=\"margin: 10px 0px;\"><img loading=\"lazy\" decoding=\"async\" style=\"padding: 3px; border: 1px solid #ccc;\" src=\"data:image\/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==\" data-layzr=\"http:\/\/www.technosolutions.com\/kb\/wp-content\/uploads\/2018\/07\/wpid33586-media_1421133544302.png\" alt=\"wpid33586-media_1421133544302.png\" width=\"750\" height=\"523\" \/><\/div>\n<div class=\"StepInstructions\">\n<p>Enter Database name for the new <i>TopTeam Database Schema<\/i> (<i>new database will be created if it does not already exist<\/i>). For a new database, you must also specify the location of the data file and the log file.<\/p>\n<p>NOTE: This folder must already exist on the computer where SQL Server is installed.<\/p>\n<p><strong><span style=\"color: #0000a0;\">IMPORTANT:<\/span><\/strong><br \/>\nIf you are carrying out this installation from another computer, the file that you have specified on this page will be created on the computer on which the SQL Server is installed.<br \/>\nIt has been observed that some enterprises have a security policy in their SQL Server which doesn&#8217;t allow creating database files in &#8220;Program Files&#8221; folder. Consult your Database Administrator if you are not able to create a database due to security constraints.<\/p>\n<p>You can also create the database files in the installation folder of the SQL Server being connected to.<\/p>\n<p>Click <i><strong>Create Database<\/strong><\/i> to create the database and proceed.<\/p>\n<\/div>\n<\/div>\n<div class=\"LessonStep top\">\n<h3 class=\"StepTitle\" style=\"font-size: 20px;\">Step 14. View SQL Scripts (Optional)<\/h3>\n<div class=\"StepImage\" style=\"margin: 10px 0px;\"><img loading=\"lazy\" decoding=\"async\" style=\"padding: 3px; border: 1px solid #ccc;\" src=\"data:image\/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==\" data-layzr=\"http:\/\/www.technosolutions.com\/kb\/wp-content\/uploads\/2018\/07\/wpid33577-media_1420698649305.png\" alt=\"wpid33577-media_1420698649305.png\" width=\"750\" height=\"523\" \/><\/div>\n<div class=\"StepInstructions\">\n<p>If you wish to review the SQL commands being used to install <i>TopTeam Database Schema<\/i>, you can view them in this step.<\/p>\n<\/div>\n<\/div>\n<div class=\"LessonStep top\">\n<h3 class=\"StepTitle\" style=\"font-size: 20px;\">Step 15. TopTeam Database Schema Installation Summary<\/h3>\n<div class=\"StepImage\" style=\"margin: 10px 0px;\"><img loading=\"lazy\" decoding=\"async\" style=\"padding: 3px; border: 1px solid #ccc;\" src=\"data:image\/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==\" data-layzr=\"http:\/\/www.technosolutions.com\/kb\/wp-content\/uploads\/2018\/07\/wpid33587-media_1421133686539.png\" alt=\"wpid33587-media_1421133686539.png\" width=\"750\" height=\"523\" \/><\/div>\n<\/div>\n<div class=\"LessonStep top\">\n<h3 class=\"StepTitle\" style=\"font-size: 20px;\">Step 16. TopTeam Database Schema for User Data has been installed<\/h3>\n<div class=\"StepImage\" style=\"margin: 10px 0px;\"><img loading=\"lazy\" decoding=\"async\" style=\"padding: 3px; border: 1px solid #ccc;\" src=\"data:image\/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==\" data-layzr=\"http:\/\/www.technosolutions.com\/kb\/wp-content\/uploads\/2018\/07\/wpid33588-media_1421134186173.png\" alt=\"wpid33588-media_1421134186173.png\" width=\"750\" height=\"523\" \/><\/div>\n<div class=\"StepInstructions\">\n<p>You have successfully installed <i>TopTeam Database Schema<\/i>.<\/p>\n<p>Click <i><strong>Finish<\/strong><\/i> to exit the wizard and continue with the installation of <i>TopTeam Application Server<\/i>.<\/p>\n<p>In case you encounter any error during installation, you can send the log file to <i>TechnoSolutions support<\/i> for analysis.<\/p>\n<\/div>\n<\/div>\n<div class=\"LessonStep top\">\n<h3 class=\"StepTitle\" style=\"font-size: 20px;\">Step 17. TopTeam Database Schema installation Log file<\/h3>\n<div class=\"StepImage\" style=\"margin: 10px 0px;\"><img loading=\"lazy\" decoding=\"async\" style=\"padding: 3px; border: 1px solid #ccc;\" src=\"data:image\/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==\" data-layzr=\"http:\/\/www.technosolutions.com\/kb\/wp-content\/uploads\/2018\/07\/wpid33589-media_1421134375568.png\" alt=\"wpid33589-media_1421134375568.png\" width=\"635\" height=\"501\" \/><\/div>\n<div class=\"StepInstructions\">\n<p>Log file is created on the computer where the Database Schema installer was run.<\/p>\n<p>The log file is created in the following folder &#8211;<br \/>\n<i><strong>C:\\&#8230;\\My Documents\\TechnoSolutions\\DB Schema Installer<\/strong><\/i><\/p>\n<p>In case you face any difficulty in installing <i>TopTeam<\/i> database or any error is reported by the installer, TechnoSolutions support will need this log file to analyze the problem.<br \/>\nKeep a backup of this file for future reference.<\/p>\n<\/div>\n<\/div>\n<div class=\"LessonStep top\">\n<h3 class=\"StepTitle\" style=\"font-size: 20px;\">Step 18. Install TopTeam Database Schema for Sample Data (Optional, but highly recommended)<\/h3>\n<div class=\"StepImage\" style=\"margin: 10px 0px;\"><img loading=\"lazy\" decoding=\"async\" style=\"padding: 3px; border: 1px solid #ccc;\" src=\"data:image\/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==\" data-layzr=\"http:\/\/www.technosolutions.com\/kb\/wp-content\/uploads\/2018\/07\/wpid33578-media_1420700012272.png\" alt=\"wpid33578-media_1420700012272.png\" width=\"511\" height=\"394\" \/><\/div>\n<div class=\"StepInstructions\">\n<p>Installation of <i><strong>Sample Database<\/strong><\/i> schema is optional.<i> Sample database schema<\/i> can be used as a sandbox for training and evaluation purposes.<\/p>\n<p>Choose <i><strong>Yes<\/strong><\/i> if you wish to run the <i>TopTeam Database Schema Installer <\/i>for installing Sample Data.<\/p>\n<p>Sample Data will be installed using the TopTeam SQL Server DB Schema Installer.<\/p>\n<p>Refer to the earlier steps in this article for installing <i>TopTeam Database Schema<\/i> to install the <i>Sample database schema.<\/i><\/p>\n<\/div>\n<\/div>\n<div class=\"LessonStep top\">\n<h3 class=\"StepTitle\" style=\"font-size: 20px;\">Step 19. Click Next to install the Sample database schema<\/h3>\n<div class=\"StepImage\" style=\"margin: 10px 0px;\"><img loading=\"lazy\" decoding=\"async\" style=\"padding: 3px; border: 1px solid #ccc;\" src=\"data:image\/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==\" data-layzr=\"http:\/\/www.technosolutions.com\/kb\/wp-content\/uploads\/2018\/07\/wpid33579-media_1420700123971.png\" alt=\"wpid33579-media_1420700123971.png\" width=\"511\" height=\"394\" \/><\/div>\n<\/div>\n<div class=\"LessonStep top\">\n<h3 class=\"StepTitle\" style=\"font-size: 20px;\">Step 20. TopTeam Application Server for SQL Server has been installed<\/h3>\n<div class=\"StepImage\" style=\"margin: 10px 0px;\"><img loading=\"lazy\" decoding=\"async\" style=\"padding: 3px; border: 1px solid #ccc;\" src=\"data:image\/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==\" data-layzr=\"http:\/\/www.technosolutions.com\/kb\/wp-content\/uploads\/2018\/07\/wpid33580-media_1420700498181.png\" alt=\"wpid33580-media_1420700498181.png\" width=\"510\" height=\"393\" \/><\/div>\n<div class=\"StepInstructions\">\n<p>Check option to create a <i><strong>shortcut<\/strong><\/i> on the desktop for <i>TopTeam Application Server<\/i>.<\/p>\n<p>Click <i><strong>Finish<\/strong><\/i> to exit the installation wizard.<\/p>\n<\/div>\n<\/div>\n<div class=\"LessonStep top\">\n<h3 class=\"StepTitle\" style=\"font-size: 20px;\">Shortcut placed on the Windows Desktop when installed as a Windows Service<\/h3>\n<div class=\"StepImage\" style=\"margin: 10px 0px;\"><img loading=\"lazy\" decoding=\"async\" style=\"padding: 3px; border: 1px solid #ccc;\" src=\"data:image\/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==\" data-layzr=\"http:\/\/www.technosolutions.com\/kb\/wp-content\/uploads\/2018\/07\/wpid33581-media_1420700666017.png\" alt=\"wpid33581-media_1420700666017.png\" width=\"128\" height=\"137\" \/><\/div>\n<\/div>\n<div class=\"LessonStep top\">\n<h3 class=\"StepTitle\" style=\"font-size: 20px;\">Shortcut placed on the Windows Desktop when installed as a Windows Application<\/h3>\n<div class=\"StepImage\" style=\"margin: 10px 0px;\"><img loading=\"lazy\" decoding=\"async\" style=\"padding: 3px; border: 1px solid #ccc;\" src=\"data:image\/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==\" data-layzr=\"http:\/\/www.technosolutions.com\/kb\/wp-content\/uploads\/2018\/07\/wpid33582-media_1420700908991.png\" alt=\"wpid33582-media_1420700908991.png\" width=\"128\" height=\"137\" \/><\/div>\n<\/div>\n<div class=\"LessonStep top\">\n<h3 class=\"StepTitle\" style=\"font-size: 20px;\">Entries in the Windows Start Menu for TopTeam Application Server when installed as a Windows Service<\/h3>\n<div class=\"StepImage\" style=\"margin: 10px 0px;\"><img loading=\"lazy\" decoding=\"async\" style=\"padding: 3px; border: 1px solid #ccc;\" src=\"data:image\/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==\" data-layzr=\"http:\/\/www.technosolutions.com\/kb\/wp-content\/uploads\/2018\/07\/wpid33583-media_1420701143144.png\" alt=\"wpid33583-media_1420701143144.png\" width=\"410\" height=\"182\" \/><\/div>\n<\/div>\n<div class=\"LessonStep top\">\n<h3 class=\"StepTitle\" style=\"font-size: 20px;\">Verify installation of the TopTeam Database(s)<\/h3>\n<div class=\"StepImage\" style=\"margin: 10px 0px;\"><img loading=\"lazy\" decoding=\"async\" style=\"padding: 3px; border: 1px solid #ccc;\" src=\"data:image\/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==\" data-layzr=\"http:\/\/www.technosolutions.com\/kb\/wp-content\/uploads\/2018\/07\/wpid33584-media_1420706746197.png\" alt=\"wpid33584-media_1420706746197.png\" width=\"773\" height=\"610\" \/><\/div>\n<div class=\"StepInstructions\">\n<p>Log into the SQL Server using <i>SQL Server Management Studio<\/i> to verify successful installation of the TopTeam databases.<\/p>\n<\/div>\n<\/div>\n<div class=\"LessonStep top\">\n<h3 class=\"StepTitle\" style=\"font-size: 20px;\">Configure TopTeam Application Server<\/h3>\n<div class=\"StepInstructions\">\n<p>After successful completion of installation, <i>Management Console for the TopTeam Application Server<\/i> will be launched automatically, if you have installed <i>TopTeam Application Server<\/i> as a Windows Service.<\/p>\n<p>If you have installed <i>TopTeam Application Server<\/i> as a Windows Application, it will start in Application Mode and the Server Configuration Wizard will be launched automatically.<\/p>\n<p>Refer to the article <a href=\"http:\/\/www.technosolutions.com\/kb\/302\/configuring-topteam-application-server-using-configuration-wizard\/\" target=\"_blank\" rel=\"noopener\">Configuring TopTeam Application Server using Configuration Wizard<\/a>.<\/p>\n<\/div>\n<\/div>\n<div class=\"LessonStep top\">\n<div class=\"StepInstructions\">\n<p>Revised: July 23rd, 2018<\/p>\n<\/div>\n<\/div>\n<\/div>\n<p><!-- End ScreenSteps Content --><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Overview This article describes how to install TopTeam Application Server for SQL Server Database. If you want to install TopTeam Application Server for another database, refer to the article Installing TopTeam Application Server. Who should read this? TopTeam Administrators System Administrators IT Support Database Administrators Where TopTeam Application Server should be installed? TopTeam Application Server can be installed on a personal computer or a Windows Server computer. When evaluating TopTeam, you can even install TopTeam Application Server on a laptop, however, for production usage you should use a desktop or a server class computer. We recommend you to install TopTeam <\/p>\n","protected":false},"author":3,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[4],"tags":[283,281,280,9],"class_list":["post-511","post","type-post","status-publish","format-standard","hentry","category-installation","tag-application-server","tag-database","tag-installation","tag-sql-server"],"jetpack_featured_media_url":"","jetpack_shortlink":"https:\/\/wp.me\/paoaNA-8f","_links":{"self":[{"href":"http:\/\/www.technosolutions.com\/kb\/wp-json\/wp\/v2\/posts\/511","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/www.technosolutions.com\/kb\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.technosolutions.com\/kb\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.technosolutions.com\/kb\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"http:\/\/www.technosolutions.com\/kb\/wp-json\/wp\/v2\/comments?post=511"}],"version-history":[{"count":34,"href":"http:\/\/www.technosolutions.com\/kb\/wp-json\/wp\/v2\/posts\/511\/revisions"}],"predecessor-version":[{"id":46829,"href":"http:\/\/www.technosolutions.com\/kb\/wp-json\/wp\/v2\/posts\/511\/revisions\/46829"}],"wp:attachment":[{"href":"http:\/\/www.technosolutions.com\/kb\/wp-json\/wp\/v2\/media?parent=511"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.technosolutions.com\/kb\/wp-json\/wp\/v2\/categories?post=511"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.technosolutions.com\/kb\/wp-json\/wp\/v2\/tags?post=511"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}