Your install and instructions (especially in the pdf files) leave a lot to be desired. Rather that bitch about it
I decided to figure out how to do it and write a set of DETAILED CLEAR instructions (of course, clairity and detail,
like beauty, are in the eyes of the beholder <grin!>). These follow as inline text. A word document is available on request.
I decided it was best to make the instructions as complete as possible, rather than asbrief as possible
-- figuring that too much information is better than not enough.
If any one would like the word document, just drop me a note here at [EMAIL PROTECTED]. I will be happy to send it to you.
Installation instructions (which worked for me) follow:
Installation instructions:
Note: These were written 12/01/02 and reference the www.sapdb.org as of that date.
I 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
a) There are two windows clients: Data Base Manater GUI and SQL Studio GUI
b) For the DBM GUI hunt around for this (in small print) on the source page referenced above: Here you can download the Database Manager GUI (6 MB)
c) For SQL Studio hunt around for this (in small print) on the same source page: Here you can download the SQL Studio (8.5 MB)
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:
| User Name | User Password | Description |
| DBM | DBM | Identification for controlling, monitoring and backup functions, even in database modeADMIN |
| DBA | DBA | Sets up the system, owns the system tables, defines users and other administrators |
| TEST | TEST | Normal user of the database functions |
| DOMAIN | DOMAIN | Owner of the catalog tables |
11. These users are important. Not all users can do all things. If something dosent work, you may be logged in as the wrong type of user.
12. Install the windows clients.
(a) Install SQL Studio by clicking on sqlstudio74-setup.exe in your windows clients download directory. Follow the install shield directions. Restart windows. In the process the system will add an ODBC driver.
(b) Set up a system data source for the TST database in your odbc driver manager I did this by using the following
- Data Source Name TSTDS
- Description (whatever you want)
- Database: TST
- Server: localhost
14. Hit the key button (connect)
15. Fill in the following:
- Server: localhost
- Database: TST
- User: TEST
- Password: TEST
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. I 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 (like me) the command window only accepts directory names of 8 char or less, so name the directory accordingly.
29. Open a command window and change directory to the directory you inziped 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. To start the web database manager: http://localhost:85/webdbm
36. Log in as
- Server: localhost
- Database: TST
- User: DBM
- PW: DBM
38. To start websql open a new browser window. Type in this address: : http://localhost:85/websql
39. Log in as:
- Server: localhost
- Database: TST
- User: DBM
- PW: DBM
Best wishes!
Bob Acker
Timberpass Technology Group
Mead, Colorado
970-535-4228
