on 11-30-2010 6:01 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......
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
thanks to all
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
>
> 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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
88 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.