SQL Server and MIM 8.5.2 on Windows

Martin Cardinal · October 25, 2011

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 · October 25, 2011

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

Ethan Beisher · October 25, 2011

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 · October 26, 2011

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'?>

   1
   1
   18456
   2403
   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'.
   XMO Class
   C:\PROGRA~2\METAST~1\MIM\install\LoadDatabase.xms

      151
      var lCc=pXmdb->connect(); \} catch(ex) \{ print("exception caught:"+ex); return(-1); \} print("\[INFO\] Loading data..."); v

VM terminated with rc = -1

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

<? xml version="1.0" ?>

-

- < 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 · October 26, 2011

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

Martin Cardinal · October 26, 2011

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 · October 26, 2011

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

SQL Server and MIM 8.5.2 on Windows

Comments

Categories