{"id":911,"date":"2011-06-11T00:20:51","date_gmt":"2011-06-11T07:20:51","guid":{"rendered":"http:\/\/www.technosolutions.com\/kb\/?p=911"},"modified":"2023-11-19T21:33:33","modified_gmt":"2023-11-20T05:33:33","slug":"database-requirements-for-topteam-repository","status":"publish","type":"post","link":"http:\/\/www.technosolutions.com\/kb\/911\/database-requirements-for-topteam-repository\/","title":{"rendered":"Database Requirements for TopTeam Repository"},"content":{"rendered":"<h3><a id=\"post-911-Step1\"><\/a>Overview<\/h3>\n<p><em>TopTeam<\/em> application supports the following databases:<\/p>\n<ul>\n<li>Oracle<\/li>\n<li>Microsoft SQL Server<\/li>\n<li>Firebird<\/li>\n<\/ul>\n<p>This article explains the compatible database versions and requirements for connecting <em>TopTeam Application Server<\/em> and <em>TopTeam Web Server<\/em> with the databases listed above.<\/p>\n<h3><a id=\"post-911-Step2\"><\/a>Who should read this?<\/h3>\n<ul>\n<li>TopTeam Administrators<\/li>\n<li>IT Support<\/li>\n<\/ul>\n<h3><a id=\"post-911-Step3\"><\/a>Oracle Database<\/h3>\n<h4>1. Compatible Versions<\/h4>\n<p><em>TopTeam<\/em> is compatible with the following version of <em>Oracle Database<\/em> of any edition i.e. Standard, Enterprise, and Express editions:<\/p>\n<ol>\n<li>Oracle 19c<\/li>\n<li>Oracle 18c<\/li>\n<li>Oracle 12c<\/li>\n<li>Oracle 11g<\/li>\n<\/ol>\n<p>For <em>TopTeam Desktop App<\/em> and <em>Oracle Server<\/em> compatibility, refer to\u00a0<a href=\"http:\/\/www.technosolutions.com\/kb\/6776\/topteam-desktop-app-platform-compatibility-guide\/\" target=\"_blank\" rel=\"noopener\">TopTeam Desktop App Compatibility Guide<\/a>.<\/p>\n<h4>2. Connection Requirements<\/h4>\n<p>1. <em>TopTeam Application Server<\/em> and <em>TopTeam Web Server<\/em> can connect to <em>Oracle Server<\/em> in the following ways:<\/p>\n<ul>\n<li>When <em>Oracle Server<\/em> is running on the same computer on which <em>TopTeam Application Server <\/em>and\/or<em> TopTeam Web Server<\/em> is installed.<\/li>\n<li>When <em>Oracle Server <\/em>is running on a remote computer that is different from the one on which <em>TopTeam Application Server <\/em>and\/or<em> TopTeam Web Server <\/em>is installed.<\/li>\n<\/ul>\n<p>2. If <em>TopTeam Application Server\/TopTeam Web Server<\/em> is running on a computer on which <em>Oracle Server <\/em>is not installed, the <em>Oracle Client<\/em> libraries compatible with <em>Oracle Server<\/em> should be installed.<\/p>\n<p>3.<em> TopTeam Application Server\/TopTeam Web Server <\/em>and <em>TopTeam Database Schema<\/em> installer cannot connect to 64 bit <em>Oracle Server <\/em>using 64 bit <em>Oracle Client<\/em>. However, 32 bit <em>Oracle Client<\/em> can interface with 64 bit <em>Oracle Server<\/em>. In that case, you need to install 32 bit <em>Oracle Client<\/em> on the computer on which <em>TopTeam Application Server <\/em>for<em> Oracle <\/em>or<em> TopTeam Web Server <\/em>for<em> Oracle<\/em> is being installed.<\/p>\n<p>4. If <em>TopTeam Server<\/em> components are being installed on the same computer on which <em>Oracle<\/em> 64 bit Server is installed, you need to install <em>Oracle<\/em> 32 bit Client on it, however, in a separate <em>Oracle Home<\/em>. The 32 bit Client can co-exist with 64 bit <em>Oracle<\/em> installation when it is installed in a separate <em>Oracle<\/em> Home directory.<\/p>\n<p>5. Oracle Instant Client is not supported by <em>TopTeam<\/em>.<\/p>\n<h4>3. Configuration Requirements<\/h4>\n<p><em>TopTeam<\/em> does not support Multibyte\/Unicode Oracle character sets. \u201c<em>WE8MSWIN1252<\/em>\u201d is the recommended Oracle character set. You can choose any single-byte character set depending on your organization\u2019s standards.<\/p>\n<h3><a id=\"post-911-Step4\"><\/a>Microsoft SQL Server<\/h3>\n<h4>1. Compatible Versions<\/h4>\n<p><em>TopTeam<\/em> is compatible with the following versions of <em>SQL Server Database<\/em> of any edition .i.e. Standard, Workgroup, Enterprise, or Express editions:<\/p>\n<ol>\n<li>SQL Server 2022<\/li>\n<li>SQL Server 2019<\/li>\n<li>SQL Server 2017<\/li>\n<li>SQL Server 2016<\/li>\n<li>SQL Server 2014<\/li>\n<li>SQL Server 2012<\/li>\n<\/ol>\n<p>For <em>TopTeam Desktop App<\/em> and <em>SQL Server<\/em> compatibility, refer to\u00a0<a href=\"http:\/\/www.technosolutions.com\/kb\/6776\/topteam-desktop-app-platform-compatibility-guide\/\" target=\"_blank\" rel=\"noopener\">TopTeam Desktop App Compatibility Guide<\/a>.<\/p>\n<h4>2. Connection Requirements<\/h4>\n<p><em>TopTeam Application Server<\/em> and <em>TopTeam Web Server<\/em> can connect to <em>SQL Server<\/em> and requires:<\/p>\n<ol>\n<li>The computer on which <em>TopTeam Application Server<\/em> is installed should have <strong>MDAC (Microsoft Data Components) version 2.8 or higher<\/strong>. You can verify this by connecting to <em>TopTeam SQL Server<\/em> Database using <em>SQL Server Management Studio<\/em> from the computer on which <em>TopTeam Application Server<\/em> is being installed.<\/li>\n<li>The computer on which <em>TopTeam Web Server<\/em> is installed should have <em>SQL Server Native Client<\/em> component installed. For more information on <em>SQL Server Native Client<\/em>, refer to the article <a href=\"http:\/\/www.technosolutions.com\/kb\/2723\/requirement-for-topteam-web-access-server-for-sql-server-database\/\" target=\"_blank\" rel=\"noopener\">Requirements for TopTeam Web Server for SQL Server Database.<\/a><\/li>\n<li>When <em>TopTeam Application Server<\/em> is running as a <em>Windows Service<\/em> and is configured to connect to <em>SQL Server<\/em> using <em>Windows Authentication<\/em>, ensure that the credentials under which the <em>TopTeam Application Server service<\/em> is running have privileges to access <em>SQL Server<\/em>.<\/li>\n<li>Ensure that <em>SQL Server<\/em> user password which is used to connect to the database in <em>TopTeam Application Server<\/em> and <em>TopTeam Web Server<\/em>, will not expire or should not have an expiry. When a user connects <em>to TopTeam Server<\/em>, a database connection gets created on <em>TopTeam Server <\/em>for that user. If <em>SQL Server<\/em> user password has expired, the <em>TopTeam user<\/em> will not be able to connect to <em>TopTeam Servers<\/em>.<\/li>\n<\/ol>\n<h4>3. Configuration Requirements<\/h4>\n<ol>\n<li><em>TopTeam<\/em> requires that <em>row versioning <\/em>based isolation levels should be enabled.<\/li>\n<li>The &#8220;<em>Allow Triggers to Fire Others<\/em>&#8221; (Recursive Triggers) setting should be enabled, which is an <em>SQL Server<\/em> instance level setting.<\/li>\n<li>Default schema of the database user who is either installing or upgrading <em>TopTeam Database<\/em> should be &#8220;<em>dbo<\/em>&#8221; (Database Owner).<\/li>\n<li><em>TopTeam Database<\/em> should not be a Contained Database. Contained Database is one of the <em>SQL Servers<\/em> features which isolates a database with other databases in the same <em>SQL Server<\/em> instance.<\/li>\n<\/ol>\n<h3><a id=\"post-911-Step5\"><\/a>Firebird Database<\/h3>\n<p><strong>NOTE: <em>TopTeam<\/em> version 11 or higher does not support <em>Firebird Database.<\/em> If you use <em>Firebird<\/em> as your database and wish to upgrade to version 11 or higher of <em>TopTeam, <\/em>you need to migrate your database to <em>Oracle <\/em>or<em> Microsoft SQL Server. <\/em>Please contact <\/strong><a href=\"http:\/\/www.support-technosolutions.com\/index.php?pg=request\" target=\"_blank\" rel=\"noopener\"><strong>TechnoSolutions Support<\/strong><\/a><strong> who will provide you with the utility to perform this migration.<\/strong><\/p>\n<h4>1. Compatible Versions<\/h4>\n<p><em>TopTeam<\/em> is compatible with the following version of <em>Firebird Database<\/em>:<\/p>\n<ol>\n<li>Firebird 1.5.5<\/li>\n<\/ol>\n<h4>2. Connection Requirements<\/h4>\n<p><em>TopTeam<\/em> requires <em>Firebird Database<\/em> version <strong>1.5.5<\/strong>. You can install this version of <em>Firebird Database<\/em> using the installer for <em>TopTeam Application Server for Firebird<\/em>.<\/p>\n<h3><a id=\"post-911-Step9\"><\/a>See Also<\/h3>\n<p><a href=\"http:\/\/www.technosolutions.com\/kb\/14337\/system-requirements-for-topteam-components\/\" target=\"_blank\" rel=\"noopener\">System Requirements for TopTeam Components<\/a><\/p>\n<p><a href=\"http:\/\/www.technosolutions.com\/kb\/33808\/how-to-establish-a-connection-with-sql-server-instance-configured-to-listen-on-non-standard-port\/\" target=\"_blank\" rel=\"noopener\">How to establish a connection with SQL Server instance configured to listen on non-standard port<\/a><\/p>\n<p>Revised: November 20th, 2023<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Overview TopTeam application supports the following databases: Oracle Microsoft SQL Server Firebird This article explains the compatible database versions and requirements for connecting TopTeam Application Server and TopTeam Web Server with the databases listed above. Who should read this? TopTeam Administrators IT Support Oracle Database 1. Compatible Versions TopTeam is compatible with the following version of Oracle Database of any edition i.e. Standard, Enterprise, and Express editions: Oracle 19c Oracle 18c Oracle 12c Oracle 11g For TopTeam Desktop App and Oracle Server compatibility, refer to\u00a0TopTeam Desktop App Compatibility Guide. 2. Connection Requirements 1. TopTeam Application Server and TopTeam Web Server <\/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":[281,8,7,9,72],"class_list":["post-911","post","type-post","status-publish","format-standard","hentry","category-installation","tag-database","tag-firebird","tag-oracle","tag-sql-server","tag-system-requirements"],"jetpack_featured_media_url":"","jetpack_shortlink":"https:\/\/wp.me\/paoaNA-eH","_links":{"self":[{"href":"http:\/\/www.technosolutions.com\/kb\/wp-json\/wp\/v2\/posts\/911","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=911"}],"version-history":[{"count":79,"href":"http:\/\/www.technosolutions.com\/kb\/wp-json\/wp\/v2\/posts\/911\/revisions"}],"predecessor-version":[{"id":51510,"href":"http:\/\/www.technosolutions.com\/kb\/wp-json\/wp\/v2\/posts\/911\/revisions\/51510"}],"wp:attachment":[{"href":"http:\/\/www.technosolutions.com\/kb\/wp-json\/wp\/v2\/media?parent=911"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.technosolutions.com\/kb\/wp-json\/wp\/v2\/categories?post=911"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.technosolutions.com\/kb\/wp-json\/wp\/v2\/tags?post=911"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}