Skip to Content
author's profile photo Former Member
Former Member

How to create a database in SAP DB

hello sirs,

My name is Sudheesh and I am new to SAP WAS. I recently installed SAPNetWeaver04SneakPreviewSlimSP11. I have installed the Max DB also from the CD. But i don't know how to open the database Manager GUI for the same. I want to create a new database and want to create some table on it.

I tried to use dbmcli utility from the command prompt. -but it shows some error message as given below, "24941,ERR_NEEDLOGON: DBM Server logon required"

Is SQL Studio available with SAPNetWeaver04SneakPreviewSlimSP11. If yes how can i access it?

Kindly help,

Sudheesh K S

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • Posted on Dec 06, 2005 at 03:25 PM

    Hello Sudheesh,

    for creating a new Database you can use the DBM GUI.

    The setup for it is in the folder J2EE-CD\SAPDB\NT\SETUPS

    To create a new database, you can use the wizard of the DBM GUI. (Username and password for the GUI should be DBM).

    In the installation folder you can also find the setup for the SQL studio.

    In the SQL studio you can connect to the new database with the user DBA.

    To create a user which you can use to access the data from the server you have to execute the statement:


    Now you can create a dbpool in the server with the visual administrator. The url should be


    and the driver class

    In the tab 'Additional' you have to choose 'Native SQL' or 'Vendor SQL'.

    Hope this helps,


    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      Dear sir,

      Thankyou very much for your support. It works fine. But i have some other doubts also. I shall be highly obliged if you share your knowledge regarding them also.

      1. I have my current database database in MySQL 4. I would like to know whether any options are available to migrate the DB from MySQL to Max DB.

      2. While mapping the persistant fields in the EJB to the fields in the database table; how can i retrieve the database table?(while defining the dictionary in Netweaver)?

      3. How can i create a data source for my database?

      The entire scenario is needed just because i am migrating a J2ee application from JBoss to SAP WAS. I am planning to create the DB first and then configure for each Entity beans.

      Is this the right way?

      Your help and suggestions are solicited.

      Thank you,

      Sudheesh K S

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.