MaxDB Studio - SQL sessions are not possible !!!

[birgit_malik]

Dear Experts,

I need to import a few objects in a freshly installed MaxDB database 7.9 SP08 patch 40.
When I select the corresponding menu in Database Studio (Right click on the database -> Export / Import -> Import),
it gives me the following error:

Import is only possible with a valid SQL Login

I somehow painfully discovered, that the user CONTROL is meant only to perform DBA tasks, but has no rights
to mess with the data.

I killed the next 3-4 hours to figure out how to create a SQL user. Finally I managed to do this via sqlcli and I have
created a DBADMIN user. This user is legible and I can login with it via sqlcli and do stuff like select * from tables.

Nevertheless, when I try to login with this user in the SQL Editor in Database Studio, it keeps saying:

SQL sessions are not possible

or

Could not connect SQL due to: [-4008]: Unknown user name/password combination

PLEASE kindly help! This literally killed my whole day 😞 I am not able to proceed further 😞

[birgit_malik]

Hi Symon Braunbaer, you use really old software. In this software version there were some problem with the password handling we solved in further software versions. So, the best idea is to update database software and use the current database studio.

Try again to create database user:

https://wiki.scn.sap.com/wiki/display/MaxDB/SAP+MaxDB+User+Concept#SAPMaxDBUserConcept-DatabaseUser

Creating Database Users - SAP Help Portal

For changing passwords for database system administrator if you know CONTROL user/password proceed as described in note

• 25591 - Password change for DBM and DBA users

Further information you find in note 2541562 - Resetting passwords as of SAP MaxDB 7.9.09.06

In case of an error, please check the log files for more information about your error - for SAP customers we suggest for example note 826037. If information in the log files does not help to understand the problem the best way is to open a message and attach all log files for support.

Regards Birgit Malik IMS SAP MaxDB

Note 2120775 Overview user/password changes

[S_Sriram]

Hi Symon

Check this SCN thread and max link

https://answers.sap.com/questions/11127348/-4008-unknown-user-namepassword-combination.html

https://maxdb.sap.com/doc/7_7/e0/792b3141bd42eda0027ecdce4e5dbd/content.htm

Regard

SS