Pull Dynamics CRM 4 customizations without the web UI

grendel777 used Ask the Experts™
Hello Experts,

I seem to have hosed my on-premise dynamics crm application.  The database is fine, but when anyone tries to log in they get the error message below.  I was trying to install and configure the email router, which might have something to do with it.  After fighting it for 24 hours, I want to give up and rebuild the server, but I don't have a recent export of my customizations.  Again, the database is fine, but I don't know how to pull the customization XML export without going through the UI.

1.  Any insight into fixing the server as-is will be awesome.
2.  If not that, can I pull the customizations in such a way that I can restore the server?
Error Description:
Column 'ShowAuthenticationErrors' does not exist on Table 'ServerSettings'
Error Details:
Column 'ShowAuthenticationErrors' does not exist on Table 'ServerSettings'
Full Stack:
[CrmException: Column 'ShowAuthenticationErrors' does not exist on Table 'ServerSettings']
   at Microsoft.Crm.ServerLocatorService.HasOnlyCachedColumns(Table table, String[] columns)
   at Microsoft.Crm.ServerLocatorService.RetrieveById(String tableName, Object primaryKey, String[] columns)
   at Microsoft.Crm.ServerLocatorService.GetSiteSetting(String settingName)
   at Microsoft.Crm.LocatorService.GetSiteSetting(String settingName)
   at Microsoft.Crm.Authentication.AuthenticationEngine.Execute(Object sender, EventArgs e)
   at System.Web.HttpApplication.SyncEventExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()
   at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)
Other Message:
Error Number:

Open in new window

Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Principal Consultant
I can't explain your error. My CRM database doesn't have a ShowAuthenticationErrors' error in the Serversettings table.

The customizations for your CRM organization are contained in the orgname_MSCRM database (where orgname is the name of your CRM organization). I'm afraid that I think there is no way to get the customization XML out of CRM without logging in.

If we optimistically hope that the server install is broken rather than the database then try uninstalling CRM (the database will remain), reinstall CRM creating a new organization, then use deployment manager to import the existing database. The new organization database created during installation can then be deleted. This might work if the problem is not due to the database itself.

I'd be very surprised if installing the E-mail router was the reason - but then you never know.

The option that may well save time is log a call with Microsoft Product Support.
Hi grendel777

Please try below url to reach export customizations page directly, without navigating from first page.

http://<server name>/<organization name>/tools/systemcustomization/ExportCustomizations/exportCustomizations.aspx

<server name> : server name with port
<organization name> : organization name of the CRM

Hope this one helps.
Hi grendel777
Just curious to know if my suggestion worked for you?



It turned out to be that I installed the wrong version of the email router.  We had to call MS support and have them walk through some files that had gotten corrupted.  Many thanks!

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial