Configuring an existing narrowcast system with a new domain account or user/Mustafa Ali Khan(NALGAN)

Scenario:

When ever there is a change in windows domain of the ncs server machine.

When ever there is a domain name change of administrator user.

If the user account is deleted or disabled.

Scripts are for oracle db

Steps:

1. Take a back up of the existing NCS repository (safe side J ) .
2. Create a new TEST narrowcast system with the new user account .
Run the query to find DOMAIN/user and SID of the new user account from new test NCS repository

SELECT * FROM TESTMSTROBJDEFN
WHERE MR_OBJECT_TYPE = 22

Get the <DOMAIN/user> and <SID> in MR_DEFINITION column for the new user

3. Get the <OBJECT ID> of the old domain user of the existing NCS repository.

SELECT MR_OBJECT_ID FROM MSTROBJDEFN
WHERE MR_OBJECT_TYPE = 22

4. Update the existing MR_DEFINITION column with new < DOMAIN/user > and <SID> that you got from step 2

UPDATE MSTROBJDEFN

SET MR_DEFINITION = ‘[<mstr_item mstr_item=”R0″ en=”1″><information><object_info id=”R0″ mstr_id=”<OBJECT ID>” mstr_type=”22″/></information><account_definition ntlogin=” < DOMAIN/user >” groups=”15″ sid=”<SID>”/><emobjs/></mstr_item>]’
WHERE MR_OBJECT_TYPE = 22
AND MR_OBJECT_ID='<OBJECT ID>’

5. Run the following SQL statements to update the user name in MR_OBJECT_NAME and MR_OBJECT_UPNAME columns where the MR_OBJECT_ID is the same as the one in Step 3

SELECT * FROM MSTROBJNAMES
WHERE MR_OBJECT_TYPE = 22
AND MR_OBJECT_ID = ‘<OBJECT ID>’

UPDATE MSTROBJNAMES
SET MR_OBJECT_NAME = ‘user’, MR_OBJECT_UPNAME = ‘USER’
WHERE MR_OBJECT_ID = ‘<OBJECT ID>’

6. Change the existing narrowcast services to run on the new domain account or as local system account if they are running on the old user name.