Getting error while running mxmc-install to Install IDM 8.0 database

[Former Member]

Hi Experts,

Need you help!

I am trying to install SAP IDM 8.0 in Domain and while running the file mxmc-install to create IDM database and It asked for sa user password.

I entered the correct sa user password but still got following error.

'sqlcmd' is not recognised as an internal or external command, operable program or batch file.

I have modified the MC_PREFIX of the mxmc-install.cmd file to create the IDM database with different name.

Is this causing the error? I have changed the MC_PREFIX value to default one (mxmc) and still got same error .

Please suggest the fix.

Regards,

Chandan Kumar

[jrondorf · Accepted solution]

Hi Chandan,

why aren't you using mxmc-xinstall command instead? There you are able to specify the prefix separately.

Cheers, Jannis

[jaisuryan]

Hi Chandan,

Did you maintain the env variable "PATH"?

Kind regards,

Jai

[jaisuryan]

Ahhhh.. I dint refresh the page before posting.. glad you found out.. Cheers

[Former Member]

Hi All,

Thanks for your quick reply and suggestions!

Actually issue was with the PATH. I have set the PATH as path of sqlmcd.exe

To set the PATH

Control Panel > System > Advanced > Environment Variables->PATH

Then I run the mxmc-xinstall.cmd (by passing all the parameters) to create IDM database with specific prefix.

Helpful URL-

1. Installing the Identity Management Database with a Given Prefix - SAP Identity Management Installati...

Regards,

Chandan

[ChrisPS]

Hi Chandan - that's great news. Please mark the thread as answered and mark any posts you thought were helpful from other members.

Regards

Chris

IdM Space Moderation team

[ChrisPS]

Hello Chanan - not sure if you are running the scripts on the same host as the database ? You probably are missing some db tools on the same host in order to be able to run the scripts.

Please see the Microsoft website for the Microsoft Command Line Utilities  for SQL Server which once installed should allow you to run the scripts.

I believe this also requires the SQL Server Native Client to be installed in the same host in order to work. This is also available to download from the Microsoft website.

Thanks

Chris

[former_member222441]

Which OS version are you using?

We have had a similar issue on Win 2012 R2. We solved it with

cscript.exe //H:WScript

But in our mxmc_xinstall.bat the command osql is used instead of sqlcmd. Maybe you try to change to osql in the install batches.

Kindly,

Andi

[Former Member]

Hi Andreas,

I am using Windows server 2008 R2.

Regards,

Chandan

[Former Member]

Hi Christopher,

Thanks for reply!

I am running the script on the same host as the database.

Regards,

Chandan

[former_member222441]

Again, you can try to use osql instead of sqlcmd. Just change it in the batch files.

[Former Member]

Hi Andreas,

Could you please tell me how to change it.

Do i just need to replace sqlcmd by osql or i need to do something else.

Regards,

Chandan

[former_member222441]

in your mxmc-xinstall.cmd file replace all sqlcmd with osql. The sysntax for both commands are the same. If you get an error like "VBA engine not found", try the command

cscript.exe //H:WScript before you run the install batch.

Kindly,

Andi

[Former Member]

Hi Andi,

I have replaced the sqlcmd by osql but again got the same error.

Regards,

Chandan

[ChrisPS]

Then I think it is some issue with the sqlcmd utility on the host as you should not need to switch to osql. Did you check the utility I already mentioned or have a DB admin take a look ?

Thanks,

Chris