Welcome!

Identity Management Tips, Thoughts and Opinions

Matthew Pollicove

Subscribe to Matthew Pollicove : eMailAlertsEmail Alerts
Get Matthew Pollicove via: homepageHomepage mobileMobile rssRSS facebookFacebook twitterTwitter linkedinLinkedIn


Blog Feed Post

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.




Read the original blog entry...

More Stories By Matthew Pollicove

Matt Pollicove is an Identity Management architect, engineer, trainer, project manager, author and blogger with experience in user account provisioning, data synchronization, virtual directory and password management solutions. As a MaXware Technical Consultant and later as a System Engineer, he worked extensively with MaXware (now SAP) software products in large customer environments. In the past Matt has worked with several leading national and international consulting firms and is currently a Sr. Principal Consultant for Commercium Technologies. He is currently the Practice Lead for SAP NetWeaver Identity Management and SailPoint IIQ.