Table of contents 1 Before you begin the upgrade, conversion or installation 1.1 Client Software 1.2 Preconditions 2 New installation 2.1 Install the SQL Server 2.2 Configure the SQL Server 2.3 Install the ODBC client 2.4 Install SuperOffice 4.0 for Microsoft SQL Server 2.5 User administration 3 Converting from C-tree to Microsoft SQL Server 3.1 Install the Microsoft SQL Server 3.2 Configure the SQL Server 3.3 Install the ODBC client 3.4 Reinstall SuperOffice 4.0 for Microsoft SQL Server 3.5 User administration 4 Upgrading from SuperOffice 3.x or 2.5 C-tree to SuperOffice 4.0 for Microsoft SQL Server 4.1 Upgrade SuperOffice 3.x or 2.5 C-tree to SuperOffice 4.02 C-tree 4.2 Install the SQL Server 4.3 Configure the SQL Server 4.4 Install the ODBC client 4.5 Convert from C-tree to SQL Server 5 Setting up Travel on SQL Anywhere as the local database 5.1 Prepare SuperOffice to use Travel 5.2 Install and generating a update prototype 5.3 Install SuperOffice Travel on the clients 6 Setting up Travel on C-tree as the local database 6.1 Chech the sentral database 6.2 Prepare SuperOffice to use Travel 6.3 Setting up the area file 6.4 Install SuperOffice Travel on the clients Appendix A - Install the Microsoft SQL Server Appendix B - Configure the SQL Server B.1 Register server B.2 Add new data devices B.3 Add new database B.4 Add the SO user Appendix C - Install the ODBC client C.1 How to install the ODBC client C.2 How to add a new ODBC data source Appendix D - Install SuperOffice 4.0 Appendix E - User administration E.1 How to manually create a new user E.2 How to create a user from within SuperOffice when logged in as SA