dba cockpit configuration wizard

[Former Member]

We have Solman 7 EHP1 stack 19 running on windows 64bit and SQL 2005. I'm using the dba cockpit configuration wizard to connect to a portal system and I'm haveing problems finding a user that works. If I use the SAP adm account user I get the following errors-

SQL error 1-: Login failed for user 'nppadm'.

Database connection %_NPP_HBSSAP12 could not be established

Is this the wrong user or do I need to do something else?

The portal is also running SQL 2005.

[Former Member]

Followed steps in note 1388700 for SQL remote monitoring

[rolfc_weber]

Hi,

As it is SQL Server, try look at SAP Note [1027512|https://service.sap.com/sap/support/notes/1027512] , in special the attached sqldba_cockpit.pdf document.

Hope this helps

Rolf

[Former Member]

Hello,

About user SAP<SID>,you can refer to note 562863.

In note 562863,it says :

The SAPR3 user was always used for older R/3 releases.

However, since several R/3 systems may be present in the same

database within MCOD with current releases, you can replace the

SAPR3 user with a system-specific SAP<sid> user here. You can

define this during the installation.

If user SAP<sid> does not exsit,would you like to try to use user SAPSR3 ?

For reference about user SAP<sid>,you can also refer to note 1028624.

Best regards

Pascal Cuennet

[Former Member]

Hi,

Login failed for user is an error with authentication.

Please check the Authenticatin mode for SQL. also,Sometimes, if you fail to save your settings, the Instance/pwd will not be picked up and may lead to this error.

Thanks,

Jagan

[Former Member]

Hope the below steps help..

Hints for a successful DBACOCKPIT

Always install appropriate database client software Always use the latest kernel patch available.

Setup DBACOCKPIT in Solution Manager 7.0 SP 12 or higher.

Install Solution Manager 7.01 for the RCA work center.

Set up a central SLD and connect to Solution Manager

Mandatory OSS note reading

1028624 u2013 DBACOCKPIT notes and comprehensive PDF file

1027146 u2013 DBACOCKPIT pre-requisites

1261329 - DBACOCKPIT remote database hints

706927 - DBMON Installation script for DBACOCKPIT

1025707 - DBACOCKPIT remote Oracle databases

1028068 - Required Oracle options for the DBACOCKPIT

1250596 - Extra Oracle features in the DBACOCKPIT

Thanks

Suresh