Missing Privileg to create User with Password * in Netweaver 7.5 on MaxDB

[SBE_FALK]

Hello,

in the Moment, i am trying to install a Netweaver AS Java System on a MaxDB in Windows 11. I already reinstalled the Server, but there is the same Mistake every Time. As you can see in the Image, the Problem is the Creation of the SAPMDADB user (SAP SID is MDA), with the Password "*". Interestingly, when i try to do it with the DBADMIN in the MaxDB Studio, than it do not work either. If i change the Password to [for example] Abcd0123 it has no Problem. Do i have to change the Password Policy or what can i change?

It is a Test System and our only one running Windows because we only need to test Scripts, i can change everything possible. Thanks in advance!

[rsnit]

hello, maxdb does not support such cases, please check out https://maxdb.sap.com/doc/7_6/09/ab35406ee32e34e10000000a155106/content.htm Database Manager Operator (DBM Operator) The user name and password are automatically converted into uppercase letters by the database system. The following characters are permitted: ● First character: A...Z, a...z, $, #, @ ● Other characters: A...Z, a...z, $, #, @, 0...9, _ Language-specific characters, such as ä, are not allowed.

[SBE_FALK]

Thank you very much, i also found this article but the Installation from the NW 750 wants to do so, even that I had to select MaxDB as the database at the beginning. How can I bypass this Problem?

[rsnit · Accepted solution]

unfortunately i can not get your point. i think you should use another password then "*" , this is no sufficient passwords. why you do not use your ABC123d password?  there should no problem with your os password restrictions sap<sid>db Schema User is in the database. 

you mentioned, that you deinstalled/reinstalled it on the same host, sometimes there are some old obsolet reginfos in windows leftover, check out 

SAPNOTE 572836

but i think you just need a maxdb confirm password

br 

robert

[rsnit · Accepted solution]

furthermore superdba and control are also affected from the mentioned password restrictions in maxdb.

swpm should ask you at first for superdba and control password. does this work on your side? after that the swpm asks you for schema user password. at this point there is no user created at all. creation takes place when swpm will begin to execute the installation. at first it creates the db instance with user CONTROL after that SUPERDBA User activates it. so you should be able to login with superdba or control, even when swpm is not able to create schema user. can you login with database studio to your db instance using superdba or control?

[SBE_FALK · Accepted solution]

I know, but I can't change the password, I didn't assign it either, the command noted as shown in the screenshot above is issued by the SWPM and creating the user with a different password doesn't work either, because the SWPM then just says it can't create the user...

[rsnit · Accepted solution]

i can not understand. swpm creates users in maxdb with the passwords, which you have given in swpm dialoge. furthermore you can do the following and create db instance on your own by hand (this are exact the steps, which swpm will trigger in installation) 

create new DB instance:
-----------------------------
dbmcli db_create <SID> control,******

connect to new instance:
------------------------------
dbmcli -u control,******-d <SID>

set parameter:
------------------
param_startsession
param_init
param_put SESSION_TIMEOUT 0
param_put _UNICODE YES
param_put _SERVERDB_FOR_SAP YES
param_put MAXDATAVOLUMES 64
param_put MAXUSERTASKS 150
param_checkall
param_commitsession

1211150
720896
param_addvolume 1 DATA F:\sapdb\<SID>\sapdata\DISKD0001 F 2883584 // 25GB a 8kb Blöcke
param_addvolume 1 LOG L:\sapdb\<SID>\saplog\DISKL0001 F 1048576 // 8GB a 8kb Blöcke

activate
-----------
db_admin
db_activate SUPERDBA,*******
load_systab

further data files if needed
-----------------------------------------------------------------------------------------------------
param_addvolume 1 DATA F:\sapdb\<SID>\sapdata\DISKD0002 F 2883584 // 25GB a 8kb Blöcke
param_addvolume 1 DATA F:\sapdb\<SID>\sapdata\DISKD0003 F 2883584 // 25GB a 8kb Blöcke
param_addvolume 1 DATA F:\sapdb\<SID>\sapdata\DISKD0004 F 2883584 // 25GB a 8kb Blöcke
param_addvolume 1 DATA F:\sapdb\<SID>\sapdata\DISKD0005 F 2883584 // 25GB a 8kb Blöcke
param_addvolume 1 DATA F:\sapdb\<SID>\sapdata\DISKD0006 F 2883584 // 25GB a 8kb Blöcke
param_addvolume 1 DATA F:\sapdb\<SID>\sapdata\DISKD0007 F 2883584 // 25GB a 8kb Blöcke
param_addvolume 1 DATA F:\sapdb\<SID>\sapdata\DISKD0008 F 2883584 // 25GB a 8kb Blöcke
param_addvolume 1 DATA F:\sapdb\<SID>\sapdata\DISKD0009 F 2883584 // 25GB a 8kb Blöcke
param_addvolume 1 DATA F:\sapdb\<SID>\sapdata\DISKD0010 F 2883584 // 25GB a 8kb Blöcke
param_addvolume 1 DATA F:\sapdb\<SID>\sapdata\DISKD0011 F 2883584 // 25GB a 8kb Blöcke

param_addvolume 1 LOG L:\sapdb\<SID>\saplog\DISKL0002 F 2197152 // 8GB a 8kb Blöcke
param_addvolume 1 LOG M:\sapdb\<SID>\saplog\LOG_M_002 F 2197152 // 8GB a 8kb Blöcke

dbmcli -d <SID> -u control,control db_addvolume DATA F:\sapdb\<SID>\sapdata\DISKD0002 F 2883584
dbmcli -d <SID> -u control,control db_addvolume DATA F:\sapdb\<SID>\sapdata\DISKD0003 F 2883584

dbmcli -d <SID> -u control,xxxxxx db_addvolume LOG L:\sapdb\<SID>\saplog\ DISKL0001 F2228224

[SBE_FALK · Accepted solution]

I would give the User a compliant Password, but in the SWPM Dialog, i get not asked for this User. In this Installation i give all users i get asked for from the SWPM Dialog a Password like abcd1234 (as initial password) but i cant set or change the password of this user.

[rsnit · Accepted solution]

if you say that swpm does not ask for this user , which user do you mean? swpm asks for every single user, otherwise it does not work, like you can see in the mentioned manual steps which are done by swpm automatically. swpm always asks for this users even if you do a systemcopy, otherwise swpm does not know how to connect to your database. i think this should be relatable?

[SBE_FALK · Accepted solution]

Okay, with going through the CUSTOM Setup, i really get prompted for this Schema User, and after using a newly downloaded J2EE Package, it worked. Thank you for your help!

[rsnit · Accepted solution]

your welcome bro 😉 as a hint please only use custom setup in installation routine, br