{"id":50926,"date":"2021-07-16T06:02:45","date_gmt":"2021-07-16T13:02:45","guid":{"rendered":"http:\/\/www.technosolutions.com\/kb\/?p=50926"},"modified":"2021-07-16T06:02:45","modified_gmt":"2021-07-16T13:02:45","slug":"how-to-connect-topteam-servers-to-azure-sql-using-activedirectorypassword-authentication","status":"publish","type":"post","link":"http:\/\/www.technosolutions.com\/kb\/50926\/how-to-connect-topteam-servers-to-azure-sql-using-activedirectorypassword-authentication\/","title":{"rendered":"How to connect TopTeam Servers to Azure SQL using ActiveDirectoryPassword Authentication"},"content":{"rendered":"<h3>Overview<\/h3>\n<p>This article will guide you in setting up <em>TopTeam Application Server<\/em> and <em>TopTeam Web Server<\/em> to connect to Azure SQL using <em>ActiveDirectoryPassword<\/em> authentication.<\/p>\n<h3>Who should read this?<\/h3>\n<ul>\n<li>TopTeam Administrators<\/li>\n<li>System Administrators<\/li>\n<li>Database Administrators<\/li>\n<li>IT Support<\/li>\n<\/ul>\n<h3>Prerequisites<\/h3>\n<ol>\n<li>Windows computer on which <em>TopTeam Servers<\/em> will be installed should be connected to Azure Active Directory.<\/li>\n<li>Azure Active Directory users should have the required permissions to connect to the TopTeam database on Azure SQL.<\/li>\n<li>Ensure that you have downloaded <em>TopTeam Servers<\/em> which supports Azure authentication.<\/li>\n<\/ol>\n<h3>1. Installing Microsoft OLE DB driver for SQL server<\/h3>\n<p><a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/connect\/oledb\/download-oledb-driver-for-sql-server\">Download the Microsoft OLE DB driver<\/a> for the SQL server and install it on both <em>TopTeam Application Server and TopTeam Web server<\/em>.<\/p>\n<p>On installing this driver if you get the option to <em>Modify<\/em> or <em>Repair<\/em>, please skip the installation. This ensures that the required Microsoft OLE DB driver for SQL Server is already installed.<\/p>\n<h3>2. Configuring TopTeam Application Server<\/h3>\n<p>1. Download <em>TopTeam Application Server<\/em> provided by <em>TechnoSolutions Support<\/em>.<\/p>\n<p>2. Stop <em>TopTeam Application Server<\/em> service. To learn how to stop the service, click <a href=\"http:\/\/www.technosolutions.com\/kb\/342\/how-to-start-and-stop-topteam-application-server-service-using-management-console\/\" target=\"_blank\" rel=\"noopener\">here<\/a>.<\/p>\n<p>3. Locate the installation folder of <em>TopTeam Application Server.<\/em>To learn how to locate the folder, click <a href=\"http:\/\/www.technosolutions.com\/kb\/336\/how-to-locate-topteam-application-servers-installation-folder\/\" target=\"_blank\" rel=\"noopener\">here<\/a>.<\/p>\n<p>4. Open the <strong>TopTeamAppServer.ini<\/strong> file (in Notepad).<\/p>\n<p>5. Locate the following text in this file:<\/p>\n<p>[DataBaseSettings]<\/p>\n<p>6. For Azure authentication, use the following connect string:<\/p>\n<p>[DataBaseSettings]<\/p>\n<p>ExtSQLSrvConnectString=Provider=MSOLEDBSQL;Use Encryption for Data=True;Authentication=ActiveDirectoryPassword<\/p>\n<p>7. Save and close this file.<\/p>\n<p>8. Open <em>Management console for TopTeam Application Server<\/em>. To learn how to open it, click <a href=\"http:\/\/www.technosolutions.com\/kb\/529\/how-to-run-topteam-application-server-management-console\/\" target=\"_blank\" rel=\"noopener\">here<\/a>.<\/p>\n<p>9. Configure database settings. Enter Azure Active Directory username and password for the database connection. To learn how to configure database settings, click <a href=\"http:\/\/www.technosolutions.com\/kb\/12518\/configuring-database-settings-using-management-console-for-topteam-application-server\/\" target=\"_blank\" rel=\"noopener\">here<\/a>.<\/p>\n<p>10. Restart <em>TopTeam Application Server<\/em> service. To learn how to start the service, click <a href=\"http:\/\/www.technosolutions.com\/kb\/342\/how-to-start-and-stop-topteam-application-server-service-using-management-console\/\" target=\"_blank\" rel=\"noopener\">here<\/a>.<\/p>\n<h3>3. Configuring TopTeam Web Server<\/h3>\n<p>1. Download <em>TopTeam Web Server<\/em> provided by <em>TechnoSolutions Support<\/em>.<\/p>\n<p>2. Stop <em>TopTeam Web Server<\/em> website. To learn how to stop the website, click <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\">here<\/a>.<\/p>\n<p>3. Locate the installation folder of <em>TopTeam Web Server<\/em>. To learn how to locate the folder, click <a href=\"http:\/\/www.technosolutions.com\/kb\/6689\/how-to-locate-the-topteam-web-server-installation-folder-version-8-x\/\" target=\"_blank\" rel=\"noopener\">here<\/a>.<\/p>\n<p>4. Open the Config.ini file (in Notepad) that is present under the \u201crest\u201d folder of the installation folder of <em>TopTeam Web Server.<\/em><\/p>\n<p>5. Locate the following text in this file:<\/p>\n<p>[SQLDatabaseSettings]<\/p>\n<p>6. For Azure authentication, use the following connect string:<\/p>\n<p>[SQLDatabaseSettings]<\/p>\n<p>ExtSQLSrvConnectString= Provider=MSOLEDBSQL;Use Encryption for Data=True;Authentication=ActiveDirectoryPassword<\/p>\n<p>7. Save and close this file.<\/p>\n<p>8. Open <em>Management console for TopTeam Web Server<\/em>. To learn how to open it, click <a href=\"http:\/\/www.technosolutions.com\/kb\/767\/how-to-run-management-console-for-topteam-web-server-isapi-edition-2\/\" target=\"_blank\" rel=\"noopener\">here<\/a>.<\/p>\n<p>9. Configure database settings. Enter Azure Active Directory username and password for database connection.<\/p>\n<p>10. Restart <em>TopTeam Web Server<\/em> website and application pools for both <em>TopTeam Web<\/em> and <em>Rest<\/em>. To learn how to start the website, click <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\">here<\/a>.<\/p>\n<p>Revised: July 16th, 2021<\/p>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Overview This article will guide you in setting up TopTeam Application Server and TopTeam Web Server to connect to Azure SQL using ActiveDirectoryPassword authentication. Who should read this? TopTeam Administrators System Administrators Database Administrators IT Support Prerequisites Windows computer on which TopTeam Servers will be installed should be connected to Azure Active Directory. Azure Active Directory users should have the required permissions to connect to the TopTeam database on Azure SQL. Ensure that you have downloaded TopTeam Servers which supports Azure authentication. 1. Installing Microsoft OLE DB driver for SQL server Download the Microsoft OLE DB driver for the SQL <\/p>\n","protected":false},"author":6,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[58],"tags":[237,283,361,280,363,9,362],"class_list":["post-50926","post","type-post","status-publish","format-standard","hentry","category-connectors","tag-active-directory","tag-application-server","tag-azure","tag-installation","tag-oledb","tag-sql-server","tag-tls-1-2"],"jetpack_featured_media_url":"","jetpack_shortlink":"https:\/\/wp.me\/paoaNA-dfo","_links":{"self":[{"href":"http:\/\/www.technosolutions.com\/kb\/wp-json\/wp\/v2\/posts\/50926","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=50926"}],"version-history":[{"count":1,"href":"http:\/\/www.technosolutions.com\/kb\/wp-json\/wp\/v2\/posts\/50926\/revisions"}],"predecessor-version":[{"id":50927,"href":"http:\/\/www.technosolutions.com\/kb\/wp-json\/wp\/v2\/posts\/50926\/revisions\/50927"}],"wp:attachment":[{"href":"http:\/\/www.technosolutions.com\/kb\/wp-json\/wp\/v2\/media?parent=50926"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.technosolutions.com\/kb\/wp-json\/wp\/v2\/categories?post=50926"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.technosolutions.com\/kb\/wp-json\/wp\/v2\/tags?post=50926"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}