Passwords please

[Former Member]

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

[Former Member]

@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?

[Benny]

Oh, oh!

This is bad. Let me explain why:

At installation time your IDE is installed to login into SDM (software deployment manager) which in turn has to log in to the server to deploy. Guess what account SDM is using?

So if you change passwords then of course SDM is not able to login again. Unfortunately I don't know where this can be changed.

Hopefully I can find out, as I always wanted to know the details about this. Maybe it's worth another weblog....

Regards,

Benny

[former_member122641]

Hi,

SDM reads the administrator user and password to connect to J2EE engine from secure store.

After you have changed the administrator password in the described way you also have to change it in secure store using configtool.

Regards,

Svetlana

[Former Member]

Is this true also for J2EE 630 SP4? I have changed the password for j2ee_admin using transaction SU01 as indicated in Note 669848 which lets me get in with Visual Admin. But my EP60 install fails with a login error. Should I change the secure store to the same password using configtool?

Many thanks,

Jake

[Former Member]

Hi Jake,

yes, please change it there and retry.

Hope that helps.

Regards

Stefan

[Benny]

Thie works? We're better then I thought!

[Former Member]

Hi,

so I have made sure that the password is the same in 3 systems:

1) Oracle

2) ABAP WAS

3) Secure Store via config tool

But my EP install still fails with:

com.sap.engine.deploy.manager.DeployManagerException: ERROR: Cannot perform action deploy on component library /sap/usr/sap/NW1/DVEBMGS01/SDM/root/origin/sap.com/com.sapportals.datadirect/S

AP AG/2.0.20040223182344.0000/com.sapportals.datadirect.sda, because:

com.sap.engine.deploy.manager.DeployManagerException: ERROR: Cannot connect to Host: [manolito] with UserName: [J2EE_ADMIN]

Check your Login Info.

Any ideas?

Many thanks,

Jake

[Former Member]

Problem solved; my mistake, I was using the JDBC password instead of the j2ee_admin in the secure store. Thanks to all for the help.

Jake

[stefan_seemann]

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:

[Benny]

Why doi you want to know them? They are only needed by the system.

Regards,

Benny