Unable to connect to SQL database fromMDM5.5SP5 console

[Former Member]

Hi

Can anybody tell me what are the steps in connecting from MDM Console to the SQL Database. I have installed MDM5.5 SP5 . I am not able to connect to the database from the console. I have created a User MDM like SA ,no password. Is there any changes need to be done in MDS.ini file and the User rights.

Thanks

Prashanta

[Former Member · Accepted solution]

Hi Prashanta,

I too faced the same problem and get rid of it by installing

SQL Server 2000 Driver for JDBC Service Pack 3

which you can download from

http://www.microsoft.com/downloads/details.aspx?FamilyId=07287B11-0502-461A-B138-2AA54BFDC03A&displa...

and i installed Microsoft SQL Server 2000 Desktop Engine (MSDE 2000) Release A

which you can download from

http://www.microsoft.com/downloads/details.aspx?FamilyID=413744D1-A0BC-479F-BAFA-E4B278EB9147&displa...

Install setup as setup.exe SAPWD="YourPassword"

I connected MDM Console wiht DBMS with Login credentials as

UserName sa

Password YourPassword

Hope this help to solve your problem.

Regards,

Santosh.

[Former Member]

Hi

Thanks every one for the helpful answer . Appreciate it. I have updated the points.

Regards

Prashanta

[Former Member]

Hi Prashanta,

In SP05 to use Windows authentication, leave the Login empty requires the<i> SQL SRVR Allow Windows Authentication Mode</i> parameter to be added in the MDM Server Settings file (mds.ini)and it is to be set to <b>True</b>

Try this out.

Thanks and Regards,

<b>Sagar Sonje

Mark Helpful Answers</b>

[Former Member]

Prashanta,

Was the SQL database set up with named instances or default instance?

Were you able to connect to this SQL database with a previous version of MDM?

Thanks,

Tim

[Former Member]

Hi Prashanta,

Do you have the correct SQL Server Client software installed on the machine on which MDS is running? The Console isn't really connecting to the database -- it's actually just asking MDS to connect to the database. You could also look in the server logs to get more information about the nature of the error.

Hope this helps,

-Cleopatra