Skip to Content
avatar image
Former Member

what is the password for user CONTROL?

Hello experts,

I just installed MaxDB 7.8 64bit, but i can not login successfully.

I opened Command Prompt, enter sqlcli, and then /c -d MaxDB -u CONTROL,123abc

system told me authentication error, sqlstate 28000......

I feel strange that the password was specified by me during installation process, but why it can not be connect?

I also tried password CONTROL but also failed.

Could anyone help to give me some suggestions?

Thank you so much

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Nov 30, 2010 at 06:30 PM

    >

    > Hello experts,

    > I just installed MaxDB 7.8 64bit, but i can not login successfully.

    >

    > I opened Command Prompt, enter sqlcli, and then /c -d MaxDB -u CONTROL,123abc

    > system told me authentication error, sqlstate 28000......

    It doesn't work because CONTROL is not a sql-logon.

    It's a DBM (database manager operator) logon.

    This kind of user manages the database instance. Starting up, shutting down, taking backups - that kind of stuff.

    This is the user that moves the box.

    It doesn't have the option to look into the box.

    CONTROL cannot logon via SQL to the database.

    Either use dbmcli to connect to the DBMServer or use a different SQL user to logon.

    BTW: this stuff is well documented in... wait for it... wait... THE DOCUMENTATION.

    WOW.

    There you have it.

    regards,

    Lars

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Nov 30, 2010 at 07:45 PM

    Hello,

    1.

    Please review the document u201CManaging Usersu201D at

    http://maxdb.sap.com/doc/7_8/default.htm -> Database Administration -> Managing Users

    2.

    Please review the u201CSQLCLIu201D at

    http://maxdb.sap.com/doc/7_8/default.htm ->Tools -> sqlcli < or Database Manager CLI >

    u201CTo use the SQLCLI interactively (in session mode), you log on to the database as a database user. This opens a database sessionu2026 u201C

    3.

    If you planning to run the dbm commands < db_state, db_admin, db_online u2026 See the u201CDatabase Manager CLIu201D documentation

    In MAXDB library > => use the dbmcli tool:

    dbmcli -d MaxDB -u CONTROL,123abc

    <enter>

    dbmcli on MaxDB>help

    <enter>

    dbmcli on MaxDB>exit

    Thank you and best regards, Natalia Khlopina

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Dec 06, 2010 at 02:48 AM

    thanks to all

    Add comment
    10|10000 characters needed characters exceeded