Tuesday, October 18, 2011

Automating Database Installation in SP4

There's a known issue where the database does not install correctly from the mxmc-install batch file. There seems to be a problem with the vbscripts that transports the passwords the script to the database server.

I've taken the liberty here of editing a copy of mxmc-install that bypasses the vbscripts that move the passwords from the script to the database.

@echo off
:* ------------------------------------------------------------------------ 
:* ------------------------------------------------------------------------
:* -- SAP NetWeaver Identity Center
:* --
:* -- This script installs the Identity Center database
:* -- FileName: mxmc-install.cmd
:* -- Platform: MS-Windows
:* --
:* -- Copyright 2007 SAP AG. All rights reserved.
:* -- http://www.sap.com:*
:* ------------------------------------------------------------------------
:* ------------------------------------------------------------------------
echo *****************************************************
echo *** Install an Identity Center database mxmc_db for
echo *** NetWever Identity Management 7.1, SP5
echo *** Assumes MSSQL User: sa, database prefix "mxmc "
echo ***
echo *** This command will install a new Identity
echo *** Center database.
echo ***
echo ***To continue press ENTER, otherwise CTRL-C
echo *****************************************************
pause
SET MC_PREFIX=mxmc
SET MC_HOST=localhost
SET MC_SAUSER=sa
set MC_SAPWD= @dmin123
set PWDOPER= p@55word
set PWDADMIN= p@55word
set PWDUSER= p@55word
set PWDRT= p@55word
set PWDPROV= p@55wordcall mxmc-xinstall %MC_PREFIX% %MC_HOST% %MC_SAUSER% %MC_SAPWD% %PWDOPER% %PWDADMIN% %PWDUSER% %PWDRT% %PWDPROV%
pause

Nothing too complicated, just specifying the Prefix (by default MXMC) and then the passwords for SQL Server, MXMC_OPER, MXMC_ADMIN, MXMC_USER, MXMC_RT and MXMC_PROV.

Hope this helps you when working with NetWeaver IDM 7.1 Service Pack 4.




No comments: