Access Denied in DMF in ax 2012 R3 While sharing folder

Problem:

When installing DIXF on multiple computers or when changing the user account of the DIXF service sometimes there is a inconsistency the configured user rights.


In your startmenu go to "local users and groups"(lusrmgr.msc)

Check for the existence of a group called "Microsoft Dynamics AX Data Import Export Framework Service Users"

It if does not exist just create it with this exact name.

Make sure your DIXF account and AOS account are members (usually this is the same)

A reboot is required (really it is!) for the changes to take effect.

Have a Nice Day!!!
Regards,
Mr. 221

Access Denied in DMF in ax 2012 R3 While sharing folder

Problem:

When installing DIXF on multiple computers or when changing the user account of the DIXF service sometimes there is a inconsistency the configured user rights.


In your startmenu go to "local users and groups"(lusrmgr.msc)

Check for the existence of a group called "Microsoft Dynamics AX Data Import Export Framework Service Users"

It if does not exist just create it with this exact name.

Make sure your DIXF account and AOS account are members (usually this is the same)

A reboot is required (really it is!) for the changes to take effect.

Have a Nice Day!!!
Regards,
Mr. 221

Hi,

If you need to show all the triggers attached with a SQL Database, this is the one way as use the query as follows,

SELECT

     sysobjects.name AS trigger_name

    ,USER_NAME(sysobjects.uid) AS trigger_owner

    ,s.name AS table_schema

    ,OBJECT_NAME(parent_obj) AS table_name

    ,OBJECTPROPERTY( id, 'ExecIsUpdateTrigger')    AS isUpdate

    ,OBJECTPROPERTY( id, 'ExecIsDeleteTrigger')    AS isDelete

    ,OBJECTPROPERTY( id, 'ExecIsInsertTrigger')    AS isInsert

    ,OBJECTPROPERTY( id, 'ExecIsAfterTrigger')     AS isAfter

    ,OBJECTPROPERTY( id, 'ExecIsInsteadOfTrigger') AS isInsteadof

    ,OBJECTPROPERTY(id, 'ExecIsTriggerDisabled')   AS [Disabled]

FROM sysobjects

INNER JOIN sysusers

    ON sysobjects.uid = sysusers.uid

INNER JOIN sys.tables t

    ON sysobjects.parent_obj = t.object_id

INNER JOIN sys.schemas s

    ON t.schema_id = s.schema_id

WHERE sysobjects.type = 'TR'

Thanking you &

Have a nice day!!!

Mr. 221