locked
MSCRMAsyncService Error Event ID: 17418 RRS feed

  • Question

  • Dear Team,


             Now, I'm facing with "MSCRMAsyncService Error Event ID: 17418". Event Log show below error.

    Host CRM.MSCRMAsyncService.exxxxxxx : a config database error occured Exception: System.Data.SqlClient.SqlException:
    Cannot opetn database "CRM_XX_MSCRM" request by login. The login failed Login failed for user "domain\CRM$"

            I checked the "CRM_XX_MSCRM" is no longer in SQL. But inside connection string is stay remaining in the MSCRM_Config.Organization and can be see in Deployment Manager. I disable the the Organizatin and restart Service but i got stay error. Why MSCRMAsyncService try to open the this database after disable the organization? How can i stop "MSCRMAsyncService" open the "CRM_XX_MSCRM" database. Because of error is always write in Event log.

           Kindly, please advice to me. Is it possiable or not?

    Note: I'm using CRM4.0

    Regards,
    Yukon


    Make Simple & Easy

    Wednesday, July 4, 2012 4:05 AM

Answers

  • Hi Yukonn,

                    You could also try deleting the organization from the CRM Deployment manager, that should remove the reference you have in MSCRM_Config.Organization.


    Regards,
    Damian Sinay

    • Marked as answer by Yukonn Thursday, July 12, 2012 2:03 AM
    Wednesday, July 4, 2012 11:56 PM
  • Dear Damian Sinay,

             Thanks for your suggestion. I try this way.

    1st Delete from Deployment Manager.

    2nd

    DELETE FROM SystemUserOrganizations] WHERE [OrganizationId] = 'xxx'
    DELETE FROM ScaleGroupOrganizationMaintenanceJobs WHERE [OrganizationId] = 'xxx'
    DELETE FROM dbo.Organization WHERE Id='xxx'

    After delete all i restart the service. Everythings is look like ok. But i don't know other effect if i do this way. Do have any idea on this?

    Noted: I didn't delete other related table records.

    Regards,

    Yukon


    Make Simple & Easy

    • Marked as answer by Yukonn Thursday, July 12, 2012 2:02 AM
    Thursday, July 5, 2012 6:48 AM

All replies

  • Hi Yukonn,

                    You could also try deleting the organization from the CRM Deployment manager, that should remove the reference you have in MSCRM_Config.Organization.


    Regards,
    Damian Sinay

    • Marked as answer by Yukonn Thursday, July 12, 2012 2:03 AM
    Wednesday, July 4, 2012 11:56 PM
  • Dear Damian Sinay,

             Thanks for your suggestion. I try this way.

    1st Delete from Deployment Manager.

    2nd

    DELETE FROM SystemUserOrganizations] WHERE [OrganizationId] = 'xxx'
    DELETE FROM ScaleGroupOrganizationMaintenanceJobs WHERE [OrganizationId] = 'xxx'
    DELETE FROM dbo.Organization WHERE Id='xxx'

    After delete all i restart the service. Everythings is look like ok. But i don't know other effect if i do this way. Do have any idea on this?

    Noted: I didn't delete other related table records.

    Regards,

    Yukon


    Make Simple & Easy

    • Marked as answer by Yukonn Thursday, July 12, 2012 2:02 AM
    Thursday, July 5, 2012 6:48 AM