How can I find the username and password for the read only database account created during installation of the Storage Scope repository ?

Hi Francois,

For ControlCneter 6.1 UB7 to recreate the defined user account do the following

On the Storagescope DSS Server from command line run %%\ECC\Repository\admin\emcsts_scripts\emcsts_create_defuser.bat [Defined-User Account] [Defined-User Password]

FOR EXAMPLE: emcsts_create_defuser.bat ecctester 8lun4fun

Will then get a message

Defined-User Account
------------------------------
stsadmin

The defined-user account is already existing, please enter Y to re-create it . . .

Enter Y to Proceed or N to Abort [Y,N]Y

This will create a new read-only database account created during installation of the StorageScope Repository.

See Page 42 to 45 of the EMC ControlCenter® 6.1 StorageScope™ API AND REPOSITORY REFERENCE GUIDE for more information.

Connecting to the StorageScope Repository

The instructions below explain how to connect to the StorageScope Repository using an ODBC connection or a JDBC connection. Before connecting to the StorageScope Repository, you must meet the prerequisites outlined under “Prerequisites” on page 43.

Note: If your StorageScope installation utilizes a stand-alone StorageScope Repository, or if SSL has been disabled, the port number may differ from what is shown below.

ODBC Connection Use the following values when you connect Net8 and OBDC to the

StorageScope Repository.

◆ Service Name: EMCSTSDB

◆ Host Name: Name or IP address of the ControlCenter Repository

host

◆ Port Number: 1575

◆ Username: Enter the username for the read-only database

account created during installation of the StorageScope

Repository.

◆ Password: Use the password for the user account specified above.

JDBC Connection Use the following values when connecting to the StorageScope

Repository with a JDBC connection:

◆ Host Name: Host Name of the StorageScope Repository

◆ Port: 1575

◆ SID: EMCSTSDB

◆ Username: Enter the username for the read-only database account created during installation of the StorageScope

Repository.

◆ Password: Use the password for the user account specified above.

Connecting to the Repository and API 45

Regards

Conor Lawlor

Hello Conor,

that worked fine for emcstsdb service but for the rambdb service I've got a ORA-01017: invalid  username/password; logon denied message.

Are there two users to configure? Documentation said it's should be the same.

François

Forget the above question. I retried it exactly as documented on page 45 and I can access RAMBDB.

Thanks for the help!

Regards,

François Eustache

Has this location changed in bundle 8.

I tried to find this bat file but it doesnt seem to exist under that path anymore in Bundle 8.

Hi,

The emcsts_create_defuser.bat is sill in the same location with UB8 within  %%\ECC\Repository\admin\emcsts_scripts\ on the the Storage Scope repository server.

If this file is missing open an SR with support. Attach a directory output of %%\ECC\Repository\admin\emcsts_scripts\ to the SR

Regards

Conor Lawlor