on 07-24-2015 9:34 PM
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.
---------------------------------------------------------------------------------------
---------------------------------------------------------------------------------------
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
101 | |
13 | |
13 | |
11 | |
11 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.