Installation Manual TecLocal 4.0.9
Contents
1. cceccccccceccceceseeeceeeseeeseeeseeeees 28 Dee OC COM ICIS Sl aE E A E E 29 2015 TecAlliance GmbH Page 3 of 29 1 Purpose of the document 1 Purpose of the document TecLocal 4 0 is part of the TecOrder solution which automates the business processes between manufacturers and wholesalers TecLocal 4 0 can run in different modes fulfilling different tasks During the installation it needs to be specified in which mode TecLocal should run The following document provides detailed instructions on how to install the server for TecLocal 4 0 in multi user buyer mode If TecLocal4 0O is run in mutli user mode the software s client is installed on more than one ma chine whereas a centrally used MS SQL Express database containing application data is stored on a server This mode is marked orange in the graphic below Buyer Mode Single User z TecLocal 4 0 2 automatically incl MS Access database Client E TecLocal 4 0 a MS SQL 2012 Express database ri TecLocal MultiUser Database Administration Tool Optional TecLocal 4 0 es Client Server Supplier Mode Single or E E Multi User TecLocal 4 0 Oracle Server gt 11 2 3 MS SQL 2012 Express Standard Z Client TecConnect 4 0 22 Server Picture Overview of the different modes in which TecLocal can run including the required components See separate installation manual Installation Manual TecLocal 4 0 9 Buyer SingleUser2. Advanced Installer lt Back Cancel Use the Browse buttons to select the path to MS Access Database file and MS Access Workgroup file and click Next Please double check that the path to the MS Access Workgroup file is correct B noo Select TecLocal Database Path Select path to TecLocal TecData database and the workgroup file Path to MS Acces Database file c Teccom Client Database TecData mdb Browse Path to MS Access Workgroup file c Teccom Client Database Teccom mdwy Browse Advanced Installer Cancel Note If there is no TecCom mdw MS Access Workgroup file and TecData mdb MS Access Da tabase file on the server copy it from a machine where TecLocal 3 0 is running installation folder Client Database on the server Click Install to start the installation process 2015 TecAlliance GmbH Page 23 of 29 3 TecLocal 4 0 MultiUser Database Installation x ig TecLocal 4 0 Multiuser Database Setup L Ready to Install The Setup Wizard is ready to begin the TecLocal 4 0 Multiuser Database installation Click Install to begin the installation IF you want to review or change any of your installation settings click Back Click Cancel to exit the wizard Advanced Installer Click on Finish after the installation is complete ji TecLocal 4 0 Multiuser Database Setup Ea Completing the TecLocal 4 0 Multiuser Database Setup Wizar
3. Client See separate installation manual Installation Manual TecLocal 4 0 9 Buyer MultiUser Part Il Client See separate installation manual Installation Manual Supplier Mode Client If TecLocal 4 0 runs in buyer mode as multi user installation it means that it is used by several users of one company on the buyer side wholesale dealer and other replacement part buyers to check a product s availability clarify delivery dates order replacement parts confirm orders notify of deliveries and receive invoices Note In former TecLocal versions it was possible to store the application data in this multi user scenario in an MS Access database Due to occurring problems this is not supported anymore In stead of the MS Access database a preinstalled MS SQL 2012 Express database server free of charge database size limited to 10 GB is used 2015 TecAlliance GmbH Page 4 of 29 2 Installation Prerequisites Please note that in order to successfully install the TecLocal 4 0 client a connection to the SQL server instance with administrator credentials is required see INS_TecLocal_Installation Manu al_Buyer_Multi User_Part_Il_Client_v4 0_en pdf for more details 2 Installation Prerequisites In order to successfully install and use TecLocal 4 0 MultiUser Database the following software has to be installed on the target machine Microsoft NET Framework 4 0 Microsoft SQL Server 2012 Express with Tools The Install
4. for developers to create Web based applications _ HTTP Redirection i C WebDA Publishing E Application Development Installed ASP NET V NET Extensibility C ASP C cer ISAPI Extensions Installed _ ISAPI Filters Server Side Includes B Health and Diagnostics Installed HTTP Logging Installed Logging Tools Request Monitor Installed Tracina fad More about role services lt Previous next gt Install Cancel Click Install 2015 TecAlliance GmbH Page 8 of 29 2 Installation Prerequisites Add Features Wizard Ea qe Confirm Installation Selections Features Web Server IIS To install the Following roles role services or features click Install 2 informational messages below Role Services Confirmation This server might need to be restarted after the installation completes Progress Web Server IIS Results Find out more about Windows System Resource Manager WSRM and how it can help optimize CPU usage Web Server Application Development NET Extensibility l NET Framework 3 5 1 Features NET Framework 3 5 1 WCF Activation HTTP Activation Non HTTP Activation l Windows Process Activation Service Process Model NET Environment Configuration APIs Print e mail or save this information lt Previous Next gt L msta Cancel Click Close Add Features Wizard pa amp or I
5. mode and administrators For the Database Engine Authentication Mode Windows authentication mode Mixed Mode SQL Server authentication and Windows authentication Specify the password For the SQL Server system administrator sa account Enter password femenee O Confirm password ase Specify SQL Server administrators QOS W2K8_ TECCONN Administrator Administrator SQL Server administrators have unrestricted access to the Database Engine Add Current User Add Remove Note To add more users click on Add in the main dialog A sub dialog is displayed Select the users you want to add To return to the main dialog click OK then Next lt Back Next gt Cancel Help Select Users Computers or Groups 2 xi Select this object type Users Groups or Built in security principals Object Types From this location Entire Directory Locations Enter the object names to select examples Advanced Check Names Click Next R SQL Server 2008 R2 Setup Error Reporting Bm E Help Microsoft improve SQL Server features and services Setup Support Rules Feature Selection Installation Rules Instance Configuration Disk Space Requirements Server Configuration Database Engine Configuration Error Reporting Installation Configuration Rules Installation Progress Complete Specify the information that you would like to automaticall
6. one of its affiliates and you Please read them They apply to the software named above which includes the media on which you i C IDo Not Agree Agree Print Next gt Cancel Select Agree then Next Software Update Installation Wizard Completing the Hotfix for Windows XP KB942288 v3 Installation Wizard You have successfully completed the KB942288 y3 Setup Wizard To apply the changes the wizard has to restart Windows To restart Windows automatically click Finish If you want to restart later select the Do not restart now check box and then click Finish lt Back Cancel 2015 TecAlliance GmbH Page 10 of 29 2 Installation Prerequisites 2 3 Microsoft SQL Server 2012 Express with Tools installation 2 3 1 Download Download Microsoft SQL Server 2012 Express with Tools from httos www microsoft com en us download details aspx id 29062 Microsoit SQL Server 2012 Express Microsoft SQL Server 2012 Express is a powerful and reliable free data management system that delivers a rich and reliable data store for lightweight Web Sites and desktop applications Details Note There are multiple files available for this download Once you click on the Download button you will be prompted to select the files you need Version Date Published 11 0 2100 60 5 14 2012 Fle Name Fle Size ENU x64 S5QLEXPR_x64 ENU exe 132 3 MB ENU xb4 5QLEXPRADV_x64_ENU exe 1 3 GB ENU x64 SQ
7. 526 then click OK Select updates to install Iof x Ov ye E Control Panel System and Security Windows Update Select updates to install X Search Control Panel 2 Select the updates you want to install Name ef Site Microsoft NET Framework 3 5 SP1 Update for Windows Server 2008 R2 1 E Windows 7 and Windows Server 2008 R2 for Important 1 x64 based Systems KB982526 Microsoft NET Framework 3 5 SP1 Update for Windows 7 and Windows Server 2008 R2 for x64 based Syst 5 5 MB This update addresses a set of known issues of the Microsoft NET Framework 3 5 Service Pack 1 After you install this item you may have to restart your computer Published 4 20 2011 i i You may need to restart your computer after OP installing this update Update has finished downloading and is ready for install More information Support information Total selected 1 important update OK Cancel Click Install Updates Windows Update Install your selected updates D 1 important update is available 1 important update selected 5 5 MB Install updates Software Update Installation Wizard Eq License Agreement Please read the following license agreement To continue with setup you must accept the agreement MICROSOFT SOFTWARE LICENSE TERMS MICROSOFT WINDOWS INSTALLER VERSION 4 5 These license terms are an agreement between Microsoft Corporation or based on where you live
8. Help 9 Aloisi O 0o SQL Server Configuration Manager Local Name State Start Mode SQL Server Services SQL Server SQLEXPRESS Running Automatic 4 SQL Server Network Configuration 32bit Fy SOL Server Agent SQLEXPRESS Stopped Other Boot System SQL Native Client 10 0 Configuration 32bit PSOL server Browser Running Automatic E 2 SQL Server Network Configuration i Protocols For SQLEXPRESS 8 SQL Native Client 10 0 Configuration 5 Click to restart the service 6 Select SQL Server Browser in the right panel F Sql Server Configuration Manager File Action Yiew Help 9 F o sib BOO SQL Server Configuration Manager Local Name stae sd Start Mode SQL Server Services ESOL Server SQLEXPRESS Running Automatic _ SQL Server Network Configuration 32bit Fay SOL Server Agent SQLEXPRESS Stopped Other Boot System SOL Native Client 10 0 Configuration 32bit E 2 SQL Server Network Configuration i Protocols For SQLEXPRESS 8 SQL Native Client 10 0 Configuration SQL Server Browser Running Automatic Click e to restart the service 2015 TecAlliance GmbH Page 17 of 29 3 TecLocal 4 0 MultiUser Database Installation 3 TecLocal 4 0 MultiUser Database Installation The MultiUser Database must be installed on the same machine where the SQL express database was installed previously Maintenance application and automation services should preferably run on the same machine Backup pat
9. IS 7 0 also features Confirmation enhanced security simplified diagnostics and delegated administration Progress Things to Note Results z i Using Windows System Resource Manager WSRM can help ensure equitable servicing of Web server traffic especially when there are multiple roles on this computer i The default installation for the Web Server ITS role includes the installation of role services that enable you to serve static content make minor customizations such as default documents and HTTP errors monitor and log server activity and configure static content compression Additional Information Overview of Web Server 11S Overview of Available Role Services in IIS 7 0 IIS Checklists Common Administrative Tasks in IIS Overview of WSRM lt Previous next gt Install Cancel Click Next Add Features Wizard xi an Select Role Services Features Select the role services to install for Web Server IIS Web Server IIS Role services Description Web Server provides support for Role Services O Web Server Installed HTML Web sites and optional support Confirmation E Common HTTP Features Installed for ASP NET ASP and Web server Progress Static Content Installed extensions You can use the Web Default Document Installed Server to host an internal or external Results Directory Browsing Installed Web site or to provide an environment HTTP Et l ors Installed
10. License Terms The following components are required for SQL Server Setup Setup Support Files Feature Name Status Setup Support Files In Progress ExecuteStandardTimings Workflow E lt Back Install Cancel In the Feature Selection dialog tab activate the checkboxes Database Engine Services and Management Tools Basic then click Next ta SOL Server 2008 R2 Setup Efel xi Feature Selection Select the Express with Advanced Services features to install Setup Support Rules Features Description Feature Selection Server features are instance Installation Rules Database Engine Services aware and have their own C SQL Server Replication registry hives They support Shared Features multiple instances on a computer Management Tools Basic Server Configuration C SQL Client Connectivity SDK Database Engine Configuration Redistributable Features Instance Configuration Disk Space Requirements Error Reporting Installation Configuration Rules Installation Progress Complete Select All Unselect All Shared feature directory C Program Files Microsoft SQL Server ap Shared feature directory x86 c Program Files x86 Microsoft SQL Server ae lt Back Next gt Cancel Help Click Next 2015 TecAlliance GmbH Page 13 of 29 2 Installation Prerequisites 8 SOL Server 2008 R2 Setup Ot x Instance Configuration Specify the name and i
11. OLEXPRWT_x64_ENU exe 669 9 MB ENU x64 SqlLocalDB MSI 33 0 MB ENU x64 5OLManagementStudio_x64_ ENU exe 600 2 MB More Select the appropriate version depending on your OS and download e g SQLEX PRWT_x64_ ENU exe for 64 bit operating systems 2015 TecAlliance GmbH Page 11 of 29 2 Installation Prerequisites 2 3 2 Installation on 64 bit Operating Systems To install Microsoft SQL Server 2012 Express Edition with tools on 64 bit operating systems dou ble right click SQLEXPRWT_x64_ENU exe and select Execute as administrator If the following message is shown click OK gt SOL Server 2008 R2 setup requires Microsoft NET Framework and an updated Windows Installer to be installed To enable the NET Framework Core role click OK To exit Setup click Cancel i Cancel After a while the following window will be shown Click New installation or add features to an ex isting installation we SQL Server Installation Center OF x Planning New installation or add Features to an existing installation Installation Launch a wizard to install SQL Server 2008 R2 in a non clustered environment or to add features to an existing SQL Server 2008 R2 instance Maintenance P gt Upgrade from SQL Server 2000 SQL Server 2005 or SQL Server 2008 oals Launch a wizard to upgrade SQL Server 2000 SQL Server 2005 or SQL Server 2008 to SQL Server Resources 2008 R2 Advanced Search for product updates Options p Search Micros
12. Tec Local 4 0 Installation Manual Byer Mode amp Multi User Server TecCom TecOrder 32 gt Solutions for all Order Processes gg nts o v he O K TecCom Enquire Orger Confim Administration Multiuser Database aintenance ye jTecLocal 4 0 MultiUser Databa r Maintenance se Maintenance ministration Maintenance Size Alerts Scheduling V Outbound Journal Process Headers IV Received Documents Received Notifications Remove documents older than C Date Age 12 8 month s Perform Maintenance Immediately Backup Database backup location rowse V Perform backup before each maintenance Perform Backup Immediately TecLocal 4 0 009 MultiUser Database Installation Manual Buyer Mode amp Multi User Part Server Version 1 1 Author TecCom Solution Management AJO Date 02 11 2015 In compiling these texts and figures the greatest care was taken However it is not possible to exclude errors completely in the user manual The publisher and authors are grateful for suggestions for improvement and for information about errors The companies other names and dates used in the examples are purely fictitious All the hardware and software names used are trade names and or trademarks of the respective manufac turer 2015 TecAlliance GmbH Content Content 1 Purpose of the document sixestrninnatennseeassanetantnoriaied
13. aintenance Size Alerts Scheduling Tectom Maintenance Administration iM Outbound Journal Process Headers Multiuser Database MV Received Documents Received Notifications Maintenance Size Alerts Remove documents older than Scheduling Date lo1 o1 2013 fs Age 12 month s Perform Maintenance Immediately Backup Database backup location Browse iV Perform backup before each maintenance Perform Backup Immediately Area Maintenance Outbound Journal Process Headers check this option if you want the administration tool to remove documents contained in the Outbound Journal Received Documents Received Notifications check select this option if you want the ad ministrator to remove the documents contained in Received Documents Remove documents based on according to o Date select this option if you want to remove documents by date all documents created before the specified date will be removed 2015 TecAlliance GmbH Page 25 of 29 4 TecLocal 4 0 MultiUser Database Maintenance Administration o Age select this option if you want to remove documents by age the document with an age older than the value in months set in this option will be removed Perform Backup Immediately click this button to manually remove documents Area Backup Database backup location use the Browse button to select the folder where the backup files will be
14. anteeerant aa eiotinrass eons 4 2 instalaton FORO GUIS le S arisen kaaa a aa asa ae i aaa a aaa 5 2 1 Installing Microsoft NET Framework 4 0 ccccccccecceecceeeceeeceeeceusceueceusceueseusseesseesseeseeeseesseeees 5 2 2 Microsoft NET Framework 3 5 SP1 Installation ccccccccseecseeeeeeeeseeeseeeneeeseeeeeteneteeeteneeeeeteeees 7 2 3 Microsoft SQL Server 2012 Express with Tools installation ccccccssseeceeeeeeeeeeeeeeeeaeeeenees 11 Aa OW IO AG caste rsztos tsepiesavoveannaet wate cena neausnaa E N 11 2 3 2 Installation on 64 bit Operating SYStEMS ccccceecccseeeeceeeesseeeeseceseeeeeseeeesseessaeeesaaess 12 2 3 3 Completing the SQL Server 2012 Express Edition Installation cccccseeeeseeeneeeeees 16 3 TecLocal 4 0 MultiUser Database Installation 0 ccccecececeeeeeeeeceeeeeeeeceeeeueueeeeeseeueueeeeeaeenes 18 3 1 Installation with a new empty Database ccccccccecccceeceseeeceeeeseeeseeeseeeeseeeseeeeseeeeseeesaeeesseeeaes 18 3 2 Installation using an existing MS Access Database cccccccccseeeeceeeeeseeeeeeeeeeseeeeseneesseeeesees 21 4 TecLocal 4 0 MultiUser Database Maintenance Administration 2 c0scssesscseeeeeeseesesensensenseesesensenseneoees 25 41 Tab WAAC GUNG Sek ancuestatinnaieaetcarceeitatos E E SAS 25 Bee OAE E E 26 AS CNC 9 wrea an EE E 27 SOUNE NOS MN a EE A A E reseed 28 5 1 Open Ports to connect TecLocal client with SQL databases
15. ation of Microsoft SQL Server 2012 Express with Tools requires Windows Installer 4 5 Microsoft NET Framework 3 5 SP1 Windows PowerShell If Microsoft SQL Server 2012 Express with Tools is already installed on your machine please skip to chapter 3 TecLocal 4 0 MultiUser Database Installation If Microsoft NET Framework 4 0 is already installed on your machine please skip to chapter 2 2 Microsoft NET Framework 3 5 SP1 installation Note If you want to migrate application data from an existing TecLocal installation the TecLocal version 3 0 Patch D needs to be preinstalled 2 1 Installing Microsoft NET Framework 4 0 After downloading Microsoft Framework 4 0 from the following link start the setup http www microsoft com download en details aspx id 17851 In the dialog Security Warning click Run Open File Security Warning Do you want to run this file 7 i Mame ministratoriDownoadsidotNetFx40 Full setup exe Publisher Microsoft Corporation Type Application From Ci Users administrator Downloads dotWetFx40_Fu M Always ask before opening this file While files from the Internet can be useful this file type can potentially harm your computer Only run software from publishers wou trust What s the risk I I K i Activate the checkbox I have read and accept the license terms and click Install 2015 TecAlliance GmbH Page 5 of 29 2 Installation Prerequisites Ox Microso
16. d Click the Finish button to exit the Setup Wizard An icon Multiuser database maintenance administration is automatically created on the desktop of the server falccom Multiuser database maintenance administration If you click with the right mouse button on this icon and select Run as administrator the Te cLocal 4 0 MultiUser Database Administration Tool is started which allows you to administrate and maintain the new Microsoft SQL Express database used for TecLocal 4 0 Details about this administration tool can be found in the next chapter 2015 TecAlliance GmbH Page 24 of 29 4 TecLocal 4 0 MultiUser Database Maintenance Administration 4 TecLocal 4 0 MultiUser Database Maintenance Administration The following chapter will give you an overview of the MultiUser Database Maintenance Admin istration tool s main functionality Since this new database used for TecLocal 4 0 is a free Microsoft SQL Express database storage is limited to 10 GB requiring regular maintenance and administra tion efforts The MultiUser Database Administration tool represents an user friendly and conven ient means to achieve this Click with the right mouse button on the Multiuser database maintenance administration icon on the server s desktop and select Run as administrator Multiuser database maintenance administration 66 53 4 1 Tab Maintenance tectocal 4 0 MultiUser Database Maintenance Administration F M
17. d a notification email SMTP server enter your SMTP server used to send the notification email Port type the port used to send the notification email o Uses authentication check this option if the SMTP server requires authentication User name enter the user name for the SMTP server o Password enter the corresponding password 2015 TecAlliance GmbH Page 26 of 29 4 TecLocal 4 0 MultiUser Database Maintenance Administration Requires SSL connection check this option if a SSL connection is required to send the no tification email Send notification to the following e mail address enter the e mail address where the notifi cation email from noreplay tecalliance net will be send to Send Test Message click this button to test the notification information the application will send a test email to the email address provided Check database size every set a specific time period in days in which the application will check the database size Note If you don t know your SMTP server s access data it is also possible to configure your Win dows Server 2008 OS to work as a SMTP server For details contact your IT administrator 4 3 Scheduling i tectocal 4 0 MultiUser Database Maintenance Administration Maintenance Size Alerts Scheduling Tectom Run maintenance automatically Administration Info amp settings Multiuser Database Last maintenance 13 10 2011 13 02 52 Maintenance Last size chec
18. ft NET Framework 4 Setup lel X NET Framework 4 Setup IW Please accept the license terms to continue Microsoft NET MICROSOFT SOFTWARE zl M Thave read and accept the license terms S id Download size estimate 54 MB Download time estimates Dial Up 132 minutes Broadband 9 minutes cme Click on Finish to complete the installation process Reboot your maschine if required E Microsoft NET Framework 4 Setup fel E Installation Is Complete IW NET Framework 4 has been installed Microsoft Ga etescencsscncccecsscccssdacssecnesesse 2015 TecAlliance GmbH Page 6 of 29 2 2 Microsoft NET Framework 3 5 SP1 installation To install Microsoft NET Framework 3 5 SP1 in Windows Server 2008 R2 or Windows Server 2012 go to Start Administrative Tools gt Server Manager di Remote Desktop Services gt Component Services Computer Management Data Sources ODBC Event viewer cS Internet Information Services IIS Manager iSCSI Initiator Local Security Policy Administrator Performance Monitor za Security Configuration Wizard Documents gt Server Manager Internet Explorer Makes Command Prompt wall Notepad ra 4 4 ii Ca Services Computer Se Share and Storage Management t Storage Explorer System Configuration Task Scheduler P Windows Firewall with Advanced Security Devices and Printers fae Windows Memory Diagnostic EA W
19. ft SQL Server 2012 gt Configuration Tools 2 Inthe left panel of the SQL Server Configuration Manager expand the node SQL Server Network Configuration then select Protocols for SQLEXPRESS and in the right panel se lect TCP IP 2015 TecAlliance GmbH Page 16 of 29 2 Installation Prerequisites TecCom F Sql Server Configuration Manager File Action View Help 9 2 i SOL Server Configuration Manager Local Protocol Name Status oo SQL Server Services Y Shared Memory Enabled _ SQL Server Network Configuration 32bit Y Named Pipes Disabled amp SQL Native Client 10 0 Configuration 32bit TCP IP E 4 SQL Server Network Configuration i He Protocols for SQLEXPRESS 3 SQL Native Client 10 0 Configuration Disabled Disabled 3 Right click on TCP IP and select Enable F Sql Server Configuration Manager OF x File Action View Help 9 2 G s SQL Server Configuration Manager Local Protocol Name f Status lt SQL Server Services Y Shared Memory Enabled a SQL Server Network Configuration 32bit Y Named Pipes Disabled SQL Native Client 10 0 Configuration 32bit E 2 SQL Server Network Configuration Yvia Disabled Enable H Protocols for SQLEXPRESS Disable gt SQL Native Client 10 0 Configuration E 3 Q 9 Properties Help 4 Select SQL Server Services in the left panel and SQL Server SQLEXPRESS in the right panel Sql Server Configuration Manager allel ES File Action view
20. hs always refer to paths on the machine where SQL server is in stalled 3 1 Installation with a new empty Database If you don t have an existing TecLocal version or if you don t want to migrate the application data from your existing TecLocal version you will have to create a new empty database To do so please follow the steps detailed below Note To migrate application data from an existing TecLocal version to the new database please follow the instructions as described in chapter 3 2 Installation using an existing MS Access Da tabase Double click the TecLocal 4 0 MultiUser Database setup file TecLocalMultiUserDatabase exe then click Next ji TecLocal 4 0 Multiuser Database Setup Welcome to the TecLocal 4 0 Multiuser Database Setup Wizard The Setup Wizard will install TecLocal 4 0 Multiuser Database on your computer Click Next to continue or Cancel to exit the Setup Wizard i TecLocal 4 0 Multiuser Database Setup f Select Installation Folder This is the folder where TecLocal 4 0 Multiuser Database will be installed To install in this folder click Next To install to a different Folder enter it below or click Browse Folder c Teccom TecLocalMultiserDatabase Browse Advanced Installer Cancel 2015 TecAlliance GmbH Page 18 of 29 3 TecLocal 4 0 MultiUser Database Installation Select a Server and login method If Windows Trusted C
21. indows PowerShell Modules O Windows Server Backup Network Control Panel Administrative Tools Help and Support Run Windows Security gt All Programs Search programs and files H Log off In the Server Manager panel click on Features then Add Features Add Features Wizard x ae Select Features ie Features Select one or more features to install on this server Confirmation Features Description oper PE Microsoft NET Framework 3 5 1 Progress NET Framework 3 5 1 Features combines the power of the NET Results Background Intelligent Transfer Service BITS Framework 2 0 APIs with new BitLocker Drive Encryption technologies for building applications BranchCache that offer appealing user interfaces Connection Manager Administration Kit protect your customers personal Desktop Experience identity information enable seamless and secure communication and DirectAccess Management Console provide the ability to model a range of Group Policy Management business processes Ink and Handwriting Services Internet Printing Client Internet Storage Name Server LPR Port Monitor Message Queuing Multipath 1 0 Network Load Balancing Peer Name Resolution Protocol Quality Windows Audio video Experience Remote Assistance Remote Differential Compression Remote Server Administration Tools Installed Fa El E BOOOOODOOOOOOO000000 More about feat
22. ipes Disabled b 8 SQL Native Client 10 0 Configuration 32H y Tcpyip Enabled 4 g SQL Server Network Configuration 3 VIA Disabled He Protocols for SQLEXPRESS gt SQL Native Client 10 0 Configuration IP Address 2001 0 9d38 90d7 2314 1fe f535 TCP Dynamic Ports 0 Yes Enabled No IP Address fe80 2814 1fe f535 fe77 23 TCP Dynamic Ports 0 TCP Port ipa TCP Dynamic Ports TCP Port 1433 TCP Dynamic Ports Blank if dynamic ports are not enabled To use dynamic ports set to 0 o Apply 5 Restart the SQL Server service by clicking SQL Server Services gt SQL Server SQLEX PRESS gt right click gt Restart 6 Close the SQL Server Configuration Manager 7 Open command line cmd exe on the server 8 Enter the following command netsh firewall set portopening TCP 1433 SQL Server Port 9 Close the command line and restart the TecLocal 4 0 client on the client machine 5 2 TecCom Helpdesk In case of problems using TecCom please turn to the TecCom Helpdesk Monday Friday 8 a m 6 p m CET Phone 49 0 180 2 TECCOM 49 0 180 2 83 22 66 49 0 89 321216 127 Fax 49 0 89 321 216 100 Email support muc tecalliance net Visit us on the Internet at www teccom eu and www tecalliance net 0 06 per call from a Germany based landline 2015 TecAlliance GmbH Page 29 of 29
23. k never Maintenance interval TE month s Size Alerts Note Emails will only be sent when Scheduling is enabled Run maintenance automatically check this option if you want maintenance to be performed automatically Info amp settings o Last maintenance displays the date and time when the last maintenance was per formed o Last size check shows the date and time when the last size check was performed o Maintenance interval set the period of time in months when the automatic maintenance should be performed 2015 TecAlliance GmbH Page 27 of 29 5 Trouble Shooting 5 Trouble Shooting 5 1 Open Ports to connect TecLocal client with SQL databases Even if access to the multiuser database has been configured correctly you might still receive the following database error message when you start TecLocal 4 0 ersion Check Ea Incorrect or defective database This may be due to an active firewall between the TecLocal 4 0 client and the server with the SQL Express database containing the TecLocal application data You might need to open TCP IP ports on the server side to allow the connection For details see http support microsoft com kb 968872 de The default UDP port for SQL Browser is 1434 To open this port on the server you have to do the following 1 Open the command line cmd exe on the server where the SQL Express database is run ning 2 Enter the following command net
24. lMultiUserDatabase exe If a security warning appears click on Run The publisher could not be verified Are you sure you want to run this software a Name Local4 0 001 SWiTecLocalMultilserDatabase exe Publisher Unknown Publisher Type Application From jtsclient T Solution_Development Quality_Release Run Cancel publisher You should only run software from publishers you trust x This file does not have a valid digital signature that verifies its w How can decide what software to run The Welcome Screen of the setup appears Click Next ie TecLocal 4 0 Multiuser Database Setup xi Welcome to the TecLocal 4 0 Multiuser Database Setup Wizard The Setup Wizard will install TecLocal 4 0 Multiuser Database on your computer Click Next to continue or Cancel to exit the Setup Wizard Cancel Select the installation folder and then click Next to continue 2015 TecAlliance GmbH Page 21 of 29 3 TecLocal 4 0 MultiUser Database Installation ji TecLocal 4 0 Multiuser Database Setup Select Installation Folder This is the Folder where TecLocal 4 0 Multiuser Database will be installed To install in this Folder click Next To install to a different Folder enter it below or click Browse Folder C Teccom TecLocalMultiUserDatabase Browse Advanced Installer Cancel Select the Server in the drop down list which is filled automatical
25. ly Note If an ODBC Connect timeout occurs it can be ignored Select SQL Server Login as login method enter the username e g sa and the password you provided for the installation of SQL 2012 EXPRESS Click Next ie TecLocal 4 0 Multiuser Database Setup SQL Server Select the SOL server available on the network Server MG_POC_BT52010 5QLEXPRESS C Windows Trusted Connection ss se Enter a database name and click on Next Important note Make sure to memorize the server and database name when installing TecLocal 4 0 clients ji TecLocal 4 0 Multiuser Database Setup SQL Server Provide the name of the new database to be created Database name TecDatasqu Advanced Installer lt Back Cancel 2015 TecAlliance GmbH Page 22 of 29 3 TecLocal 4 0 MultiUser Database Installation If the database name is already taken click on OK to close the following warning This database already exists please choose a different database name Select Migrate existing MS Access Database and click Next ji TecLocal 4 0 Multiuser Database Setup xi Database creation Please select whether you want to create an empty database or migrate existing MS ACCESS database Create new empty database peteneeeesesscesseeeeceeseseeeeesceesesssesssesseessesscesanssseesseesesesseesenesenes NeceeMeosccessecesscesesecsescssedPeeccssccssseessnsscensccsssessceescenssesessneesneees
26. nstallation Results Features The Following roles role services or features were installed successfully Web Server IIS Role Services Web Server IIS Installation succeeded Confirmation The Following role services were installed Web Server Progress Application Development Results NET Extensibility NET Framework 3 5 1 Features iv Installation succeeded The following features were installed NET Framework 3 5 1 WCF Activation HTTP Activation Non HTTP Activation Windows Process Activation Service Installation succeeded The Following Features were installed Process Model NET Environment Configuration APIs Print e mail or save the installation report Next gt Gancel Previous You are now ready to install the Microsoft NET Framework 3 5 SP1 Go to Start gt All Programs gt Windows Update Internet Explorer 64 bit Internet Explorer E Mozilla Firefox m Accessories d Administrative Tools Administrator d Maintenance Documents d Notepad di Startup Computer d Total Commander Network Control Panel Devices and Printers Administrative Tools b Help and Support Run 4 Back Windows Security Search programs and files 2 Log off 2015 TecAlliance GmbH Page 9 of 29 Select Microsoft _NET Framework 3 5 SP1 Update for Windows 7 or Windows 8 1 and Win dows Server 2008 R2 or Windows 2015 R2 for x64 based Systems KB982
27. nstance ID for the instance of SQL Server Instance ID becomes part of the installation path Setup Support Rules Feature Selection Installation Rules Instance Configuration Disk Space Requirements Server Configuration Database Engine Configuration Error Reporting Installation Configuration Rules Installation Progress Complete Default instance Named instance SQLExpress Instance ID SQLExpress Instance root directory c Program Files Microsoft SQL Server 000 SQL Server directory C Program Files Microsoft SQL Server MS5QL10_50 SQLExpress Installed instances Instance Name Instance ID Features Edition version lt Back Next gt Cancel Help Select NT AUTHORITY SYSTEM as the account name for the SQL Server Database Engine Se lect Automatic as the Startup Type for your SQL Server Browser then click on Next 8 SOL Server 2008 R2 Setup lel E3 Server Configuration Specify the service accounts and collation configuration Setup Support Rules Feature Selection Installation Rules Instance Configuration Disk Space Requirements Server Configuration Database Engine Configuration Error Reporting Installation Configuration Rules Service Accounts Collation Microsoft recommends that you use a separate account for each SOL Server service Startup Type NTAUTHORITY SYSTEM Automatic gt NT AUTHORITYILOCAL S Automatic Service Acc
28. oft Update for SQL Server 2008 R2 product updates a SOL Server 2008R2 Activate the checkbox I accept the license terms and click Next We SQL Server 2008 R2 Setup Eifel Ea License Terms To install SQL Server 2008 R2 you must accept the Microsoft Software License Terms License Terms MICROSOFT SOFTWARE LICENSE TERMS Setup Support Files MICROSOFT SQL SERVER 2008 R2 EXPRESS WITH TOOLS MICROSOFT SQL SERVER 2008 R2 EXPRESS WITH ADVANCED SERVICES These license terms are an agreement between Microsoft Corporation or based on where you live one of its affiliates and you Please read them They apply to the software named above which includes the media on which you received it if any The terms also apply to any Microsoft e updates e supplements e Internet based services and e support services v I 1 accept the license terms B Send feature usage data to Microsoft Feature usage data includes information about your hardware configuration and how you use SQL Server and its components See the SOL Server 2008 R2 Privacy Statement for more information lt Back Next gt Cancel 2015 TecAlliance GmbH Page 12 of 29 2 Installation Prerequisites All required support files are installed automatically ee SQL Server 2008 R2 Setup Setup Support Files Click Install to install Setup Support files To install or update SQL Server 2008 R2 these files are required
29. onfiguration Disk Space Requirements Summary log file has been saved to the Following location C Program Files Microsoft SOL Server 100 Setup Bootstrap Log 20121214 113846 Summary FrontEnd 0 20121214 113846 txt Information about the Setup operation or possible next steps Your SQL Server 2008 R2 installation completed successfully Server Configuration Database Engine Configuration Error Reporting Installation Configuration Rules Installation Progress Complete Supplemental Information The Following notes apply to this release of SQL Server only Microsoft Update For information about how to use Microsoft Update to identify updates for SQL Server 2008 R2 see the Microsoft Update Web site at http go microsoft com Fwlink LinkId 108409 Samples By default sample databases and sample code are not installed as part of SQL Server Setup To install sample databases and sample code for non Express editions of SQL Server 2008 R2 see the CodePlex Web site at http igo microsoft comsFwlink LinkId 87843 To read about support For SQL Server sample databases and x Close Help A Finally close the SQL Server Installation Center 2 3 3 Completing the SQL Server 2012 Express Edition Installation In order to install the TecLocal 4 0 Multiuser Database TCP IP for SQL Express must be enabled To do this carry out the following steps 1 Open the SQL Server Configuration Manager via Start gt Microso
30. onnection is selected no further input is needed If you select SQL Server Login enter the username and provide the password you se lected during the installation of SQL 2012 EXPRESS Click Next after completing the above steps i TecLocal 4 0 Multiuser Database Setup SQL Server Select the SQL server available on the network Server MG_POC_BT52010 5QLEXPRESS Windows Trusted Connection SOL Server Login User name fsa Password oo Advanced Installer lt Back Cancel Enter a database name and click on Next Important note Please make sure you memorize both server and database name when for Te cLocal 4 0 clients SQL Server Provide the name of the new database to be created Database name TecDatasqu Advanced Installer lt Back Cancel If the database name already exists is taken the following warning will be displayed Click OK This database already exists please choose a different database name Select Create new empty database and then click Next 2015 TecAlliance GmbH Page 19 of 29 3 TecLocal 4 0 MultiUser Database Installation i TecLocal 4 0 Multiuser Database Setup Database creation Please select whether you want to create an empty database or migrate existing MS ACCESS database Create new empty database Migrate existing MS Access Database Advanced Installer Ready to Install The Setup Wizard i
31. ount Name Password SQL Server Database Engine SQL Server Browser Use the same account for all SQL Server services Installation Progress Complete lt Back Next gt Cancel Help 4 select Mixed Mode SQL Server authentication and Windows authentication Enter a secure password for the SQL Server system administrator sa and make sure that you remember it later Add at least one user in Specify SQL Server administrators If you want to add the current user click Add Current User Afterwards click Next Note These users will be able to login to the SQL Server where the can create a database con nection to the TecLocal 4 0 MultiUser Database and fulfill administrative task In addition these us ers are needed for the TecLocal 4 0 MultiUser Database Installation details see 3 TecLocal 4 0 MultiUser Database Installation 2015 TecAlliance GmbH Page 14 of 29 2 Installation Prerequisites te SQL Server 2008 R2 Setup Biel Es Database Engine Configuration Specify Database Engine authentication security mode administrators and data directories Setup Support Rules Feature Selection Installation Rules Instance Configuration Disk Space Requirements Server Configuration Database Engine Configuration Error Reporting Installation Configuration Rules Installation Progress Complete Account Provisioning Data Directories FILESTREAM Specify the authentication
32. s ready to begin the TecLocal 4 0 Multiuser Database installation Click Install to begin the installation IF you want to review or change any of your installation settings click Back Click Cancel to exit the wizard Advanced Installer Click on Finish after the installation is complete i TecLocal 4 0 Multiuser Database Setup Completing the TecLocal 4 0 Multiuser Database Setup Wizard Click the Finish button to exit the Setup Wizard Gancel An icon Multiuser database maintenance administration is automatically created on the desktop of the server 2015 TecAlliance GmbH Page 20 of 29 3 TecLocal 4 0 MultiUser Database Installation Multiuser database maintenance administration When you double click this icon the TecLocal 4 0 MultiUser Database Administration Tool starts up which allows you to administrate and maintain the new Microsoft SQL Express database used for TecLocal 4 0 Details about this administration tool can be found in the next chapter 3 2 Installation using an existing MS Access Database If you want to migrate application data of an existing TecLocal version installation which can also be located on another machine you need to use the existing MS Access Database for your installation To do so follow the steps described in this chapter Please note that the TecLocal version 3 0 Patch D needs to be preinstalled Double click the TecLocal 4 0 MultiUser Database setup file TecLoca
33. sh firewall set portopening UDP 1434 SQL Browser 3 Close the command line and restart the TecLocal 4 0 client on the other machine The default TCP port for SQLEXPRESS is 1433 If the TecLocal 4 0 client is still not able to connect to the SQL Express database you need to check if SQL Express uses a different TCP IP port and open this port on your server as well We recommend to use port 1433 for the SQL Server Express connections There must be a rule for in coming traffic on this port if a Windows firewall is active To do so carry out the following steps 1 On the server launch the SQL Server Configuration Manager via Start gt Microsoft SQL Server 2012 gt Configuration Tools 2 Inthe left panel of the SQL Server Configuration Manager expand the node SQL Server Network Configuration then select Protocols for SQLEXPRESS and in the right panel se lect TCP IP 3 Right click on TCP IP and select Properties 4 Inthe TCP IP properties window scroll down to IP All and blank the port number listed in TCP Dynamic Ports This will disable the dynamic port usage In the textfield below enter 1433 as the TCP Port Click OK 2015 TecAlliance GmbH Page 28 of 29 5 Trouble Shooting D Sql Server Configuration Manager File Action View Help e9 2 EB H SQL Server Configuration Manager Local Protocol Name Status E SOL Server Services Y Shared Memory Enabled 4 SQL Server Network Configuration 32bit Named P
34. stored If no directory is selected in this field backups will be stored in the fol lowing path MS SQL Backup Folder TecLocalMultiUserDB_xxxxxxxxxxxxx bak Perform Backup before each maintenance if this option is checked selected every time that maintenance is performed the application will make a backup of the database Perform Backup Immediately click this button select this option to manually backup your database 4 2 Size Alerts i TecLocal 4 0 MultiUser Database Maintenance Administration Ls Maintenance Size Alerts Scheduling Actual database size 374 00 MB Administration Send Email Notification when database size reaches a limit Multiuser Database Note Emails will only be sent when Scheduling is enabled Maintenance Notification information Database size limit 100 MB SMTP server Port Uses authentication Scheduling User name Password l Requires SSL connection Send notification to the following e mail address Check database size every 1 day s Actual database size displays actual size of the database in megabytes MB Send Email Notification when database size reaches a limit check this option if you want to be notified when the database reaches a certain size when it is checked the notification in formation form gets active Notification information Database size limit when the database reaches the size specified in this option the appli cation will sen
35. ures Previous Next gt Install Select NET Framework 3 5 1 Features if you need to add new roles and or features The Add features wizard will display the following Add Features Wizard xi Add role services and features required for NET Framework 3 5 1 Features You cannot install NET Framework 3 5 1 Features unless the required role services and features are also installed Role Services Description E Web Server IIS Web Server IIS provides a reliable Web Server manageable and scalable Web application lt 6 infrastructure E Application Development NET Extensibility E Windows Process Activation Service Process Model NET Environment Configuration APIs Add Required Role Services Cancel Why are these role services and features required 2015 TecAlliance GmbH Page 7 of 29 2 Installation Prerequisites First click on Add Required Role Services and then click on Next an Web Server IIS Features Introduction to Web Server IIS Web Server 115 Web servers are computers that have specific software that allows them to accept requests From client computers and return responses to those requests Web servers let you share information over the Internet or Role Services through intranets and extranets The Web Server role includes Internet Information Services IIS 7 0 a unified Ree Web platform that integrates IIS 7 0 ASP NET and Windows Communication Foundation I
36. y send to Microsoft to improve future releases of SQL Server These settings are optional Microsoft treats this information as confidential Microsoft may provide updates through Microsoft Update to modify feature usage data These updates might be downloaded and installed on your machine automatically depending on your Automatic Update settings See the SOL Server 2008 R2 Privacy Statement for more information Read more about Microsoft Update and Automatic Update Send Windows and SQL Server Error Reports to Microsoft or your corporate report server This setting only applies to services that run without user interaction lt Back Next gt Cancel Help 4 The installation process continues automatically 2015 TecAlliance GmbH Page 15 of 29 2 Installation Prerequisites te SQL Server 2008 R2 Setup olx Installation Progress Setup Support Rules Feature Selection Installation Rules Instance Configuration Disk Space Requirements Server Configuration Database Engine Configuration Error Reporting Installation Configuration Rules Installation Progress Complete U Install_sql_engine_core_shared_Cpu64_Action InstallFinalize Next gt Cancel Help Click Close to finish the installation Ye SQL Server 2008 R2 Setup Complete Bme Es Your SQL Server 2008 R2 installation completed successfully Setup Support Rules Feature Selection Installation Rules Instance C
Download Pdf Manuals
Related Search