{"id":49493,"date":"2020-03-31T23:17:04","date_gmt":"2020-04-01T06:17:04","guid":{"rendered":"http:\/\/www.technosolutions.com\/kb\/?p=49493"},"modified":"2020-03-31T23:18:46","modified_gmt":"2020-04-01T06:18:46","slug":"how-to-change-topteam-database-server-id-of-sql-server-database","status":"publish","type":"post","link":"http:\/\/www.technosolutions.com\/kb\/49493\/how-to-change-topteam-database-server-id-of-sql-server-database\/","title":{"rendered":"How to change TopTeam Database Server ID of SQL Server Database"},"content":{"rendered":"<h3>Overview<\/h3>\n<p>Every <em>TopTeam Database Schema <\/em>has a 4-digit numeric <em>Database Server ID<\/em>. <em>TopTeam<\/em> <em>Desktop App<\/em> uses this Identifier to uniquely identify the database. <em>TopTeam<\/em> <em>Desktop App<\/em> will cache information locally for each database to which it connects. For example, <em>User Data <\/em>and <em>Sample Data <\/em>are the two databases installed when you install <em>TopTeam<\/em>.<\/p>\n<p>This article explains the importance of <em>TopTeam Database Server Identifier<\/em> and how to change it.<\/p>\n<h3>Who should read this?<\/h3>\n<ul>\n<li>TopTeam Administrators<\/li>\n<li>IT Support<\/li>\n<\/ul>\n<h3>Problem Definition<\/h3>\n<p>When you copy a <em>TopTeam Database Schema<\/em> to create a test environment or otherwise, <em>TopTeam Database Server ID<\/em> also gets copied. If you connect <em>TopTeam<\/em> <em>Desktop App<\/em> to these two databases concurrently, <em>TopTeam<\/em> <em>Desktop App <\/em>considers these two databases as the same.<\/p>\n<p>At this time, you can use the information from one database while updating it into the other database. This, however, can cause data inconsistencies and also lead to data corruption.<\/p>\n<h3>Step 1. How to identify what is the TopTeam Database Server ID<\/h3>\n<p><img decoding=\"async\" class=\"wp-image-49494\" src=\"data:image\/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==\" data-layzr=\"http:\/\/www.technosolutions.com\/kb\/wp-content\/uploads\/2020\/03\/word-image-11.png\" \/><\/p>\n<p>1. First, connect <em>TopTeam<\/em> <em>Desktop App<\/em> to<em> TopTeam Application Server<\/em>.<\/p>\n<p>2. Open the <em>Connection Details<\/em> window from the <em>Help<\/em> drop-down menu.<\/p>\n<p><strong>Solution <\/strong><\/p>\n<p><em>TechnoSolutions <\/em>recommends that you do NOT make a copy of <em>TopTeam Database Schema<\/em>. Instead, install a new <em>TopTeam Database Schema<\/em>. If the situation demands to create a copy of the database, you must change <em>TopTeam Database Server ID<\/em>.<\/p>\n<p>Refer to the following steps on how to change <em>TopTeam Database Server ID<\/em>.<\/p>\n<h3>Step 2. Login to SQL Server where TopTeam Database is installed<\/h3>\n<p><img decoding=\"async\" class=\"wp-image-49495\" src=\"data:image\/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==\" data-layzr=\"http:\/\/www.technosolutions.com\/kb\/wp-content\/uploads\/2020\/03\/word-image-12.png\" \/><\/p>\n<p>The screenshot shows multiple <em>TopTeam Databases<\/em>. Here <em>TopTeam_Data<\/em> and <em>TopTeam_Sample_Data<\/em> are installed as parts of <em>TopTeam<\/em> installation.<\/p>\n<p>Other <em>TopTeam Schemas<\/em> such as <em>TopTeam_Dev<\/em> is a copy of <em>TopTeam_Data<\/em> which is the actual <em>User Data <\/em>or<em> Production Data. <\/em>Since this is created by copying <em>TopTeam_Data<\/em>, it has the same <em>TopTeam Database Server ID<\/em>.<\/p>\n<h3>Step 3. Change TopTeam Database Server ID of test database<\/h3>\n<p><img decoding=\"async\" class=\"wp-image-49496\" src=\"data:image\/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==\" data-layzr=\"http:\/\/www.technosolutions.com\/kb\/wp-content\/uploads\/2020\/03\/c-users-novate1-appdata-local-temp-snaghtml44403.png\" alt=\"C:\\Users\\NOVATE~1\\AppData\\Local\\Temp\\SNAGHTML44403162.PNG\" \/><\/p>\n<p>Select the test database and perform the steps described in the screenshot above.<\/p>\n<p>SQL: update UNF_SIR set SIR_DB_SERVER_ID = null<\/p>\n<h3>Step 4. Confirm that the update was successful<\/h3>\n<p><img decoding=\"async\" class=\"wp-image-49497\" src=\"data:image\/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==\" data-layzr=\"http:\/\/www.technosolutions.com\/kb\/wp-content\/uploads\/2020\/03\/c-users-novate1-appdata-local-temp-snaghtml44430.png\" alt=\"C:\\Users\\NOVATE~1\\AppData\\Local\\Temp\\SNAGHTML44430b8b.PNG\" \/><\/p>\n<h3>Step 5. Restart TopTeam Application Server and TopTeam Web Server<\/h3>\n<p>First, restart <em>TopTeam Application Server Service<\/em> connected to the test database(s). Refer to the article <a href=\"http:\/\/www.technosolutions.com\/kb\/342\/how-to-start-and-stop-topteam-application-server-service-using-management-console\/\" target=\"_blank\" rel=\"noopener\">How to start and stop TopTeam Application Server Service using Management Console<\/a>. <em>TopTeam Application Server<\/em> resets <em>TopTeam Database Server ID<\/em> to a random 4-digit number.<\/p>\n<p>Next, restart <em>TopTeam Web Server. <\/em>Refer to the article <a href=\"http:\/\/www.technosolutions.com\/kb\/6720\/how-to-start-and-stop-topteam-web-server-website-version-8-x-and-above\/\" target=\"_blank\" rel=\"noopener\">How to start and stop TopTeam Web Server Website (Version 8.x and above)<\/a>.<\/p>\n<p>Finally, connect <em>TopTeam<\/em> <em>Desktop App<\/em> to <em>TopTeam Application Server<\/em> and verify that <em>TopTeam Database Server ID<\/em> has been changed. Verify this from the <em>Connection Details<\/em> window as shown above in Step 1.<\/p>\n<h3>See Also<\/h3>\n<p>For information on clearing <em>TopTeam cache<\/em>, refer to the article <a href=\"http:\/\/www.technosolutions.com\/kb\/889\/how-to-clear-the-cache-of-topteam-desktop-app\/\" target=\"_blank\" rel=\"noopener\">How to clear the cache of TopTeam Desktop App<\/a>.<\/p>\n<p>Revised: April 1st, 2020<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Overview Every TopTeam Database Schema has a 4-digit numeric Database Server ID. TopTeam Desktop App uses this Identifier to uniquely identify the database. TopTeam Desktop App will cache information locally for each database to which it connects. For example, User Data and Sample Data are the two databases installed when you install TopTeam. This article explains the importance of TopTeam Database Server Identifier and how to change it. Who should read this? TopTeam Administrators IT Support Problem Definition When you copy a TopTeam Database Schema to create a test environment or otherwise, TopTeam Database Server ID also gets copied. If <\/p>\n","protected":false},"author":6,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[5],"tags":[9],"class_list":["post-49493","post","type-post","status-publish","format-standard","hentry","category-database","tag-sql-server"],"jetpack_featured_media_url":"","jetpack_shortlink":"https:\/\/wp.me\/paoaNA-cSh","_links":{"self":[{"href":"http:\/\/www.technosolutions.com\/kb\/wp-json\/wp\/v2\/posts\/49493","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\/6"}],"replies":[{"embeddable":true,"href":"http:\/\/www.technosolutions.com\/kb\/wp-json\/wp\/v2\/comments?post=49493"}],"version-history":[{"count":3,"href":"http:\/\/www.technosolutions.com\/kb\/wp-json\/wp\/v2\/posts\/49493\/revisions"}],"predecessor-version":[{"id":49500,"href":"http:\/\/www.technosolutions.com\/kb\/wp-json\/wp\/v2\/posts\/49493\/revisions\/49500"}],"wp:attachment":[{"href":"http:\/\/www.technosolutions.com\/kb\/wp-json\/wp\/v2\/media?parent=49493"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.technosolutions.com\/kb\/wp-json\/wp\/v2\/categories?post=49493"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.technosolutions.com\/kb\/wp-json\/wp\/v2\/tags?post=49493"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}