Sign in

Microsoft.com

Microsoft

Remove From My Forums

MSCRMAsyncService Error Event ID: 17418

Question
0

Sign in to vote

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

1

Sign in to vote
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
0

Sign in to vote
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

1

Sign in to vote
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
0

Sign in to vote
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