Unable to connect to database server : MDM 7.1

[Former Member]

Hello All,

I installed MDM 7.1 and I am unable to create/mount/unarchieve repository : Error message I am getting is :

Unable to connect to Database

I installed MSDE : Light version of SQL server... On command prompt I used: setup.exe sapwd=abcd SECURITYMODE=SQL

Its an mixed mode..

Dont know MSDE is okey to use for MDM 7.1? Any one faced such issue?

Thanks in advance

Rajeev

[Former Member]

Hello rajeev raj

SAP MDM 7.1 Installation guide:

"DBMS client software must be installed on the machine that runs the MDS. Make sure that the

MDM user SAPService<SID> has the necessary rights for accessing the database client.

􀁸 The DBMS user that MDM uses to connect to a DBMS must have access rights equivalent to the

system user. You can use the system account or create a user with equivalent rights. The built-in

system accounts are as follows:

- MS SQL u2013 sa (reserved)

- Oracle u2013 system (reserved)

- DB2 u2013 db2admin (configurable installation option)

- MaxDB - dbm (configurable installation option)"

Suppose, that copy-past help you.

Regards

Kanstantsin