Skip to Content
avatar image
Former Member

SAP IDM 8.0 INSTALLATION Identity Center database SQL Server

Hi Experts,

I am trying to install IDM 8.0 Identity Center Database on SQL Server 2012, looking the docs of idm installation, on step (Install Identity Center  DataBase) show this message using the command "mxmc-install" on prompt.

Note: I've installed NW 7.40 Abap Instance and Java Instance.

"Not able to connect" ????

There is a file "create-db.sql" but i dont altered

---------------------------------------------------------------------------------------

---------------------------------------------------------------------------------------

-- SAP NetWeaver Identity Center

--

-- Database : Microsoft SQL-Server

-- Operation : Create database

-- Run as : DB Administrator

-- FileName : 1-create-db.sql

--

-- Copyright 2007-2010 SAP AG. All rights reserved.

-- http://www.sap.com

---------------------------------------------------------------------------------------

---------------------------------------------------------------------------------------

use master

-- Create database

create database $(MC_PREFIX)_db

-- Force collation on database in case MS SQL is installed as case sensitive server

alter database [$(MC_PREFIX)_db] COLLATE SQL_Latin1_General_CP1_CI_AS

-- Create database users, turn off password check policy

print substring(@@VERSION,1,25)

exec ('CREATE LOGIN $(MC_PREFIX)_oper  WITH PASSWORD = ''$(MC_OPERPWD)'',  DEFAULT_DATABASE = $(MC_PREFIX)_db, CHECK_POLICY = OFF')

exec ('CREATE LOGIN $(MC_PREFIX)_admin WITH PASSWORD = ''$(MC_ADMINPWD)'', DEFAULT_DATABASE = $(MC_PREFIX)_db, CHECK_POLICY = OFF')

exec ('CREATE LOGIN $(MC_PREFIX)_user  WITH PASSWORD = ''$(MC_USERPWD)'',  DEFAULT_DATABASE = $(MC_PREFIX)_db, CHECK_POLICY = OFF')

exec ('CREATE LOGIN $(MC_PREFIX)_rt    WITH PASSWORD = ''$(MC_RTPWD)'',    DEFAULT_DATABASE = $(MC_PREFIX)_db, CHECK_POLICY = OFF')

exec ('CREATE LOGIN $(MC_PREFIX)_prov  WITH PASSWORD = ''$(MC_PROVPWD)'',  DEFAULT_DATABASE = $(MC_PREFIX)_db, CHECK_POLICY = OFF')

go

use $(MC_PREFIX)_db

-- Give owner access to mxmc_oper

exec sp_adduser '$(MC_PREFIX)_oper','$(MC_PREFIX)_oper_u'

exec sp_addrolemember 'db_owner','$(MC_PREFIX)_oper_u'

exec sp_addrolemember 'db_accessadmin','$(MC_PREFIX)_oper_u'

exec sp_addrolemember 'db_securityadmin','$(MC_PREFIX)_oper_u'

-- Create other database users

exec sp_adduser '$(MC_PREFIX)_admin','$(MC_PREFIX)_admin_u'

exec sp_adduser '$(MC_PREFIX)_user','$(MC_PREFIX)_user_u'

exec sp_adduser '$(MC_PREFIX)_rt','$(MC_PREFIX)_rt_u'

exec sp_adduser '$(MC_PREFIX)_prov','$(MC_PREFIX)_prov_u'

go

-- Add roles

exec sp_addrole '$(MC_PREFIX)_admin_role'

exec sp_addrole '$(MC_PREFIX)_user_role'

exec sp_addrole '$(MC_PREFIX)_rt_role'

exec sp_addrole '$(MC_PREFIX)_delta_rw_role'

exec sp_addrole '$(MC_PREFIX)_delta_r_role'

exec sp_addrole '$(MC_PREFIX)_prov_role'

-- Connect users to roles

exec sp_addrolemember '$(MC_PREFIX)_admin_role','$(MC_PREFIX)_oper_u'

exec sp_addrolemember '$(MC_PREFIX)_admin_role','$(MC_PREFIX)_admin_u'

exec sp_addrolemember '$(MC_PREFIX)_user_role','$(MC_PREFIX)_oper_u'

exec sp_addrolemember '$(MC_PREFIX)_user_role','$(MC_PREFIX)_user_u'

exec sp_addrolemember '$(MC_PREFIX)_rt_role','$(MC_PREFIX)_oper_u'

exec sp_addrolemember '$(MC_PREFIX)_rt_role','$(MC_PREFIX)_rt_u'

exec sp_addrolemember '$(MC_PREFIX)_delta_rw_role','$(MC_PREFIX)_rt_role'

exec sp_addrolemember '$(MC_PREFIX)_delta_rw_role','$(MC_PREFIX)_admin_role'

exec sp_addrolemember '$(MC_PREFIX)_delta_r_role','$(MC_PREFIX)_user_role'

exec sp_addrolemember '$(MC_PREFIX)_prov_role','$(MC_PREFIX)_prov_u'

-- Specific grants

GRANT CREATE TABLE TO $(MC_PREFIX)_rt_role

go

Thanks

JM

Error.png (21.2 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    Jul 24, 2015 at 09:08 PM

    HI Juilano,

    You need to be able to connect to the database instance at this step.  You are not connecting to NetWeaver.  Please speak with your DBA about making sure that you have SA type access to the SQL Server DB. Also this script is typically run on the database server itself which might also be a part of your issues.

    Regards,

    Matt

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi Matt,


      Exactly , the SA user was need access the database full.


      As always thanks so much!

      Hug


      JM

  • Jul 28, 2015 at 12:14 PM

    Hi Juliano,

    Matt is correct with the SA user might have issues in terms of access. Next step is to check in the SQLServer the SQL Server Network Configuration the IP's and ports defined for TCP/IP connection. Important is that 1433 is being used by your server or much better is to connect with a DBA specialist with your issue as Matt proposed.

    All the best,

    Santi

    Add comment
    10|10000 characters needed characters exceeded