cancel
Showing results for 
Search instead for 
Did you mean: 

what is the password for user CONTROL?

Former Member
0 Kudos

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

Accepted Solutions (0)

Answers (3)

Answers (3)

Former Member
0 Kudos

thanks to all

former_member229109
Active Contributor
0 Kudos

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

lbreddemann
Active Contributor
0 Kudos

>

> 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