ExecuteNonQuery requires the command to have a transaction when the connection assigned to the command is in a pending local transaction. The Transaction property of the command has not been initialized.

Issue:

I have import new organization from the Dynamics CRM 4.0 but getting this error

ExecuteNonQuery requires the command to have a transaction when the connection assigned to the command is in a pending local transaction. The Transaction property of the command has not been initialized.

Solution:
Above got us thinking and we found that the imported database came from a system that uses an alternative service account for CRM / Application Pool. Somehow the default user (network\service) was stripped on the ***_MSCRM database.
So opened the ORGANIZATION_MSCRM database in SQL Manager,
Tree viewedto Security -> Users
Then opened the database user NT AUTHORITY\NETWORK SERVICE and checked role member dbowner.
Reset the IIS and voila the problem is solved and we were able to access the imported CRM organization.

BE a part of My Network:

Microsoft Dynamics CRM, Dynamics AX

ExecuteNonQuery requires the command to have a transaction when the connection assigned to the command is in a pending local transaction. The Transaction property of the command has not been initialized.

Labels

Comments

Post a Comment