MDM not connecting to the DB

[Former Member]

Hi ,

I installed MDM 7.1 SP02 and applied patch SP06.

When i try to connect to Database from MDM Console MDM Servers -> DBMS Settings i am getting "Unable to connect with Database Server " error and i am not able to create a repository from MDM console with this error. Am i missing any configuration ? Please help me to solve the issue.

Thanks in advance ....

Thanks,

Srini K

[Former Member · Accepted solution]

Have you mounted the repository properly,

MDM COnsole --> DBMS Settings or Configuration --> DBMS what do you see under it?

Also check the logs in this Host Directory

http://help.sap.com/saphelp_mdm71/helpdata/en/49/bcad6ac9e359cce10000000a42189c/content.htm

Thanks

SM

[Former Member · Accepted solution]

Hi ,

Thanks for your reply.

I am able to connect to DB now but the repository status is disconnected ...How to connect to the Repository ?When i try with MDM server user name and pwd i get Repositroy connect failed error.

What user name should i use to connect to repository ?

Thanks in advance...

Reagrds,

Srini K

[Former Member · Accepted solution]

You'll need to first MDM at the OS level using the below command:

4.Start SAP Service. You may use SAP MMC or sapcontrol command:

sapcontrol -nr <Instance Number> -function StartService <SID>

5.Start MDM Server. You may use SAP MMC or sapcontrol command:

sapcontrol -nr <Instance Number> -function Start

An example for stopping MDM Server and SAP service at /usr/sap/P16/MDS00:

• Stop Server: sapcontrol -nr 0 -function Stop

• Stop SAP Service: sapcontrol -nr 0 -function StopService P16

Refer to Note: 1499138.

Then use Console to Mount the Repository.

Thanks

SM

[Former Member · Accepted solution]

Hi,

Try with user Admin with no password ..

Thanks,

Deepthi

[Former Member · Accepted solution]

Thanks Deepthi!!!

I am able to connect with the credentials you provided, working on creating respository now.

Thanks,

Srini K

[Former Member]

Hi Srini,

For MDM 7.1 Repositories, you should be able to connect to the Repository via default UID/PW:

UID: Admin

PW: sapmdm

If this does not work you will need to reset the Admin user password at DB level.

Let us know if default login works first. Hope this helps!