SQL Server and MIM 8.5.2 on Windows

[Martin Cardinal]

I'm currently testing this install and I'm not able to make MIM work with SQL Server using Windows authentication instead of SQL authentication.

Is there a way to make it choose one or the other? It's not mentionned in any way in your configuration and planning or install documentation.

Is there somethign I have to add or modify frmo the database.xml before launching loaddatabase.cmd?

I'm able to use the domain account to connect to the database and it works fine.

[Martin Cardinal]

I forgot to mentionned that i have tryed authenticationMethod="ntlm" in the jdbcDatasource tag.

[Ethan Beisher]

What ID is the Metastorm Integration Manager starting under? Is it starting under an ID that has appropriate permissions to the database? Did you also update the System DSN definition to select NT authentication?

Please post the error message you are receiving.

You may want to consider contacting Metastorm support (the big button on the top right).

[Martin Cardinal]

LoadDatabae

*************

     MIM XMScript Version: 8.5.2.0.20110506
 Copyright (c) 1997 - 2011 Metastorm Inc. All Rights Reserved.
[INFO] Executing script to load a database
[INFO] Reading configuration and data files...
[INFO] Connecting to database...
exception caught:<?xml version='1.0'?>
<!--Metastorm V8.5.2.0.20110506-->
<XMDBErrorException>
   <exceptionTextCount>1</exceptionTextCount>
   <locationCount>1</locationCount>
   <errorCode>18456</errorCode>
   <exceptionCode>2403</exceptionCode>
   <exceptionText>A Database Error with SQLSTATE '28000' occured:ERROR occurred during Connecting to ODBC: SQLCODE=18456,SQLSTATE=28000,MSG=[Metastorm][ODBC SQL Server Driver][SQL Server]Login failed for user 'Stcmqadmin'.</exceptionText>
   <errorCodeGroup>XMO Class</errorCodeGroup>
   <scriptName>C:\PROGRA~2\METAST~1\MIM\install\LoadDatabase.xms</scriptName>
   <XMScriptException>
      <lineNo>151</lineNo>
      <script>var lCc=pXmdb->connect();
}
 catch(ex)
{
 print("exception caught:"+ex);
 return(-1);
}

 print("[INFO] Loading data...");

 v</script>
   </XMScriptException>
</XMDBErrorException>

VM terminated with rc = -1

************************************************************************************

  <?xml version="1.0" ?>

- <!--

Metastorm V8.5.2.0.20110506

  --> <script type="text/javascript"></script>

- <DatabaseDriver key="NodeInfo/HSABTESTA/Database/Database.xml" xmlns:dd="http://commercequest.com/ccat">

  <xmdbService>od3</xmdbService>

  <schema>ITSD_MIM</schema>

  <user>Stcmqadmin</user>

  <password dd:compat="1">YAHOOPWD=</password>

  <type>sqlserverdd</type>

  <jdbcDataSource authenticationMethod="ntlm" dataSourceName="MIMDB" portNumber="1433" serverName="SQL-DB-P1" databaseName="ITSD_MIM">com.metastorm.jdbcx.sqlserver.SQLServerDataSource</jdbcDataSource>

  <server>HSABTESTA</server>

  <import location="Databases/TableList.xml" />

  </DatabaseDriver>

***********************************************************************************

The account STCMQADMIN has access to the database, but it is a domain account and MIM is always trying to log on the database using SQL authentication, (local to SQL).

[Ethan Beisher]

It appears you have the Database.xml configured correctly. Please contact the Help Desk.

[Martin Cardinal]

Ok I did open a ticket and here is the solution.

Install MIM as usual, and get the error about the database.

Change the MIM Windows Service to start under the domain credential ( to me it's the same as the database logon)

run  ..\Bin\xmdbconfig.xms

Choose option carefully, and you will have to get another name for the DSN as this doesn't overwrite it if it was already created. When asked about using Windows Credential say yes.

LoadDatabase worked. Started service and logged into Process Manager.

The new XML that it generates is different that the one Install shield is creating, even if the helpdesk told me otherwise.

[Ethan Beisher]

Thanks so much for following up, and I am glad the Help Desk was able to help you.