Need MAXDB port, dafault database username and password to connect

[Former Member]

Hi,

I am new to MAXDB and installed SAP system on Windows XP on local machine.

I have installed SAP Netweaver and while connecting to MAXDB via MAXDB Database Manager facing issue.

I am getting error as -2 ERR_USRFAIL:User authorization failed. Please check attached screenshot for more details.

I tried to connect via credentials provided in this thread http://scn.sap.com/thread/95219  but failed to do so.

I used following ports for connection:

           7200

           7210

           7269

           7270

           7575

Can anyone provide port, default username and password.?

Feedback appreciated.

[Former Member]

Hi,

I tested with following DB users and there respective passwords:

- superdba

- control

- SAP<SID>

it is an JDBC driver issue.

Can you please tell me following for HANA STUDIO:

  -  How to check for JDBC drivers? whether it is installed properly/not.

  -  How to installed JDBC drivers. As I am unable to assign CLASSPATH.

Feedback appreciated.

[former_member229109]

Hello,

this forum for MAXDB database users.

And you tested the default SAP installation MAXDB DB users.

If you have questions about HANA DB studio and HANA DB administration => post the question on HANA DB forum:

http://scn.sap.com/community/hana-in-memory

Regards, Natatalia Khlopina

[Former Member]

In error log getting following error.

I am using

               HANA Studio Version: 1.0.48

                JAVA (JRE7) : 7

I have gone into the administration panel within windows and didn't found HDBODBC32 driver under Data Source ODBC.

com.sap.ndb.studio.jdbc.JDBCConnectionStatus: Database connection is not available. See error log for more details.

    at com.sap.ndb.studio.jdbc.JDBCPlugin.createConnection(JDBCPlugin.java:314)

    at com.sap.ndb.studio.navigator.operations.SAPSystemObjectUpdate.executeTryJDBC(SAPSystemObjectUpdate.java:203)

    at com.sap.ndb.studio.navigator.operations.SAPSystemObjectUpdate.execute(SAPSystemObjectUpdate.java:69)

    at com.sap.ndb.studio.navigator.operations.UpdateSAPSystemOperation.execute(UpdateSAPSystemOperation.java:76)

    at com.sap.ndb.studio.datamodel.controler.DataModelOperationJob.run(DataModelOperationJob.java:70)

    at org.eclipse.core.internal.jobs.Worker.run(Worker.java:54)

Caused by: com.sap.db.jdbc.exceptions.JDBCDriverException: SAP DBTech JDBC: Cannot connect to jdbc:sap://tmsap:30015 [Cannot connect to host localhost:30015 [Connection refused: connect], -813.].

    at com.sap.db.jdbc.exceptions.SQLExceptionSapDB.createException(SQLExceptionSapDB.java:219)

    at com.sap.db.jdbc.exceptions.SQLExceptionSapDB.createException(SQLExceptionSapDB.java:203)

    at com.sap.db.jdbc.exceptions.SQLExceptionSapDB.generateDatabaseException(SQLExceptionSapDB.java:186)

    at com.sap.db.jdbc.Driver.connect(Driver.java:239)

    at com.sap.ndb.studio.jdbc.JDBCPlugin$5.run(JDBCPlugin.java:655)

[former_member229109]

Hello,

Why you are using HANA DBstudio?

Did you install HANA DB?

< By default, the port number of a Hana instance is 3<instance number>15, so port 30015 is the default port of the default instance. >

Tool for managing SAP MaxDB databases is MAXDB Database studio:

http://maxdb.sap.com/doc/7_8/default.htm ->

Database Studio

Regards, Natalia Khlopina

[Former Member]

Hi Rajendra,

First you need to add the database you intend to connect underneath the server (tmsap in your case). when you add the database you should be able to see it in the tree structure.

To connect to the db you need to define at least a login using a database user.

You can connect to db using: CONTROL, SAP<SID> and SUPERDBA

The password is the same as the master installation password.

Regards,

Shahab

[Former Member]

I gone through above provided links, but still unable to connect.

I tried with provided ports.

Can anyone assist on this?

[former_member229109]

MAXDB_error.JPG checked, according the error you are using the wrond dbm user or wrong password of the dbm user.

< As I already wrote to you >

Check on the database server first using dbmcli tool:

< the default SAP dbm user is control. Test with master password you used during installation>

dbmcli -d <DB-name> -u control,<password> show version

dbmcli -d <DB-name> -u control,<password> db_offline

dbmcli -d <DB-name> -u control,<password> db_online

dbmcli -d <DB-name> -u control,<password> db_enum

Are you SAP customer & used SAP software installation DVDs? 

    What is the version of your database?

     Do you know the master installation passwords?

     Is it longer ar 9 characters?

Regards, Natalia Khlopina

[Former Member]

Hi ,

Thanks for your reply.

However still I am not able to connect to MAXDB > NSP database on local machine via HANA studio.

I am not an SAP customer, I have installed SAP Netweaver trail version which I have downloaded from SAP website.

I have master installation password and its length is 8 characters.

Following are the screenshots from the DBACOCKPIT for reference, please have a look and provide necessary feedback on this.

Waiting for reply.

Thanks

[former_member229109]

Hello,

Why you are using HANA DBstudio?

Did you install HANA DB?

Tool for managing SAP MaxDB databases is MAXDB Database studio:

http://maxdb.sap.com/doc/7_8/default.htm ->

Database Studio

Regards, Natalia Khlopina

[former_member229109]

Hello,

please check the document at:

http://maxdb.sap.com/doc/7_8/44/bbddac91407006e10000000a155369/frameset.htm

you will find Ports and Protocols of the SAP MaxDB X Servers list & more details.

MAXDB_error.JPG checked, according the error you are using the wrond dbm user or wrong password of the dbm user.

Check on the database server first using dbmcli tool:

< the default SAP dbm user is control. Test with master password you used during installation>

dbmcli -d <DB-name> -u control,<password> show version

dbmcli -d <DB-name> -u control,<password> db_offline

dbmcli -d <DB-name> -u control,<password> db_online

dbmcli -d <DB-name> -u control,<password> db_enum

-> Check "Tools" documentation at

http://maxdb.sap.com/doc/7_8/44/bbddac91407006e10000000a155369/frameset.htm

   I recommend to install DB studio.

-> Review "Managing Users" at

http://maxdb.sap.com/doc/7_8/44/bbddac91407006e10000000a155369/frameset.htm

you could find there the standard DB user/pasword combinations.

-> Are you SAP customer & used SAP software installation DVDs?

    What is the version of your database?

     Do you know the master installation passwords?

     Is it longer ar 9 characters?

Regards, Natalia Khlopina

[Former Member]

Hi Rajendra,

Regarding default port used by Max db, for your specific confiuration, you can check which port is being used by this process -

Go to Run -> drivers, Go to etc folder and check for services file.

As per Max DB documentation, different ports used for Max DB are -

http://maxdb.sap.com/doc/7_7/44/bbddac91407006e10000000a155369/content.htm

For username/password thing, here is the answer for that -

http://maxdb.sap.com/doc/7_7/44/bbddac91407006e10000000a155369/frameset.htm

Hope this helps,

Regards,

Ashutosh