I have installed NetWeaver/WAS 6.40. Can anybody inform me about:
- the passwords of the database users CONTROL, SUPERDBA and DOMAIN, who are shown in the Web DBM page of SAPMMC
- the password for the Administrator account that NetWeaver hands to the deployment manager, when the developer wants to deploy an application
Why doi you want to know them? They are only needed by the system.
Regards,
Benny
Hello,
the user CONTROL is the Database Manager User ( DBM ).
It is the user which created the database. It is used to administrate the database from the outside which means:
- bring it into offline, admin or online mode,
- doing backups and recoveries,
- doing verifies
etc..
The SAP Standard for the DBM user is "control" with the password "control".
The user SUPERDBA is the Database Administrator (DBA) user. It is the administrator inside of the database.
That means he can create other SQL user such as sapr3 etc..
So he is the highest user on SQL level.
The standard at SAP for this user is "SUPERDBA" with the password "admin".
The user domain is a special user which owns most of the Systemtables of the database. It is only used when these systemtables are reloaded. Its password is "domain" or "admin".
All mentioned passwords are default passwords. You are free to change the passwords of these users.
Unfortunately there is a bug inside of the webdbm. So it is not possible to change passwords or create further DBM users via WEBDBM. But you can always use the Database Manager GUI ( DBMGUI ).
You can download the latest version of MaxDB tools from
the SAP Service Marketplace:
http://service.sap.com/~form/sapnet?_SHORTKEY=00200797470000059278&
Best regards, Stefan Seemann
For questions about MaxDB please browse to
the new SDN MaxDB forum: SAP MaxDB
@Stefan: thank you; I can now use SqlStudio. I found out that I have to fill in "localhost" for the server in the Connect dialog; if I enter the name of my PC instead then the message returned is "Unable to connect to data source". This is strange.
@Benny: I need passwords, not only for SqlStudio, but also because I have problems deploying NetWeaver applications.
At first I was able to deploy NetWeaver applications. Then the Administrator user was locked out. I followed the procedure of your web log, but I also changed the password of the Administrator. I should not have done so, because since then I cannot deploy anything anymore: NetWeaver reports "ERROR: Cannot connect to Host: [...] with UserName: [Administrator] Check your Login Info".
I have changed the Administrator's account to "sap", and even made it empty (as suggested by some config files of the Eclipse plugins), but nothing helped.
So what should the Administrator password be, so that NetWeaver can deploy applications?
Add a comment