 |
 |
 |
 |
| White Paper
For Installing SAPDB database on Windows Installation instructions: Note: These were written 12/01/02 and reference the www.sapdb.org as of that date. We suggest downloading the files as described below rather than using any install cd you may have. 1. Download the SapDb server into a separate download directory of your choice on your local machine. Source: http://www.sapdb.org/sap_db_nt.htm File:sapdb-server-win-32bit-i386-7_3_0_29.zip 2. Download the SapDb web tools into a separate download directory of your choice on your local machine. Source: Same. File: sapdb-webtools-win-32bit-i386-7_3_0_29.zip 3. Download the windows client gui tools into into a separate download directory of your choice on your local machine. Source: http://www.sapdb.org/sap_db_tools.htm Files: dbmgui74-setup.exe and sqlstudio74-setup.exe There are two windows clients: Data Base Manager GUI and SQL Studio GUI 4. For installation instructions, avoid the PDF's. Use the online docs instead. To get to them, click on the Online Documentation link on the right side in the blue area of this page: http://www.sapdb.org/sap_db_nt.htm 5. Follow the documentation here to install the server: http://www.sapdb.org/htmhelp/75/d8f63af7cd2c14e10000000a11402f/frameset.htm 6. IMPORTANT: Accept the default path (subdirectory) names without changing them at all. Otherwise you may have to make undocumented registry changes. If everything installs successfully you will get the message: 'installation of SAP DB Server finished successfully [date][time]' You will also see a new service SAPDB: _CPROGRA under services in your control panel. It will not be running. Start it. 7. Go to the following directory in windows explorer: C:\Program Files\sapdb\depend\misc 8. Click on create_demo_db.cmd. This will create the demo database. 9. Close and open services on your control pannel. You will see a new service SAPDB: TST. This is the new database service. It should be running. 10. The following database users have been preconfigured:
11. These users are important. Not all users can do all things. If something does not work, you may be logged in as the wrong type of user. 12. Install the windows clients. We did this by using the following: Data Source Name: TSTDS Description: (whatever you want) Database: TST Server: localhost 13. Start SQL Studio by double clicking on the desktop icon. This is version 7.4 of the tool. Don't worry, that's ok. 14. Hit the key button (connect) 15. Fill in the following: Server: localhost Database: TST User: TEST Password: TEST 16. Sql studio opens. On the left menu tree, open Tables and highlight user TEST. The menu selections will change, and show Catalog Manager. 17. Create a table by selecting Catalog Manager -> New -> Table Definition. 18. Create a test table of your choice and insert data with the sql insert stmt. 19. Select * from tablename and verify you retrieve data. 20. Close SQLStudio. 21. Setup DBM GUI by double clicking on it in windows explorer. Reboot your windows session. 22. Start DBM GUI by clicking on the desktop icon. It is also version 7.4. 23. Click on the Register button (left most on toolbar below horizontal menu). 24. Your TST database should appear. Click on the check box. Press the Register button. 25. Give it a user name and password. we used DBM and DBM. 26. The TST database instance shows. Click on the TST database icon. Click on View -> Refresh to populate data if necessary. 27. Installing the web tools: 28. Use this page of the html documentation starting at item 3 to install the web tools: http://www.sapdb.org/htmhelp/03/399e3a85166506e10000000a114084/frameset.htm Another way to state item 3 is go to the web tools download directory you set up in item 2 above and unzip the file you find there to an install directory. The file to unzip is: sapdb-webtools-win-32bit-i386-7_3_0_29.zip. If you are using windows 2000 (as we are) the command window only accepts directory names of 8 char or less, so name the directory accordingly. 29. Open a command window. Change directory to the directory you unziped the web tools zip file to in step 28 above. 30. Run SDBINST from that directory. IMPORTANT: Accept the default path (subdirectory) names without changing them at all. Otherwise you may have to make undocumented registry changes. 31. If the install was successful you will get the following: 'installation of SAP DB Web Tools finished successfully [date][time].' 32. The SapDb web server automatically is installed and configures to port 85. 33. Reboot windows to allow the registry to be read. 34. After rebooting, make sure all your SAP services are running. You now have 3 of them (you may want to set them to automatically run when your machine starts up). They are: SAP DB WWW SAPDB: _CPROGRA SAPDB: TST 35. Configure your browser to Enable JavaScript, Enable Style Sheets and Accept all cookies. 36. To start the web database manager: http://localhost:85/webdbm 37. Log in as Server: localhost Database: TST User: DBM PW: DBM 38. If the database shows offline, click the online button. 39. To start websql open a new browser window. Type in this address: : http://localhost:85/websql 40. Log in as: Server: localhost Database: TST User: DBM PW: DBM Hopefully this will save some of you a bit of frustration, and allow you to examine, test and deploy an interesting product. Author Bob Acker |
Copyright
© 2002 Timberpass Technology Group