Answered by:
MSCRMAsyncService Error Event ID: 17418

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