web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Microsoft Dynamics CRM (Archived)

Unable to install an additional Back End server

(0) ShareShare
ReportReport
Posted on by

Hi everyone

I need urgent help - been struggling with this for hours and would appreciate if anyone has any ideas

I'm trying to add an additional back end server to an existing deployment which is a single full server CRM + SQL - the CRM is UR 8. I'm running the installation on the new server (updated the installation files) and choosing to connect to an existing deployment - during setup the installation crashes with the following error:

Install exception.System.Exception: Action Microsoft.Crm.Setup.Server.InstallConfigDatabaseAction failed. ---> Microsoft.Crm.CrmException: Upgrade failure: Cannot decrease data length,  [Column:'Cookie']

I'm using a domain admin for the installation and the CRM service account is also a domain admin (this is a DEV environment) i'm also SA on SQL. 

I have tried EVERYTHING i could think of but I end up with this error every time.

Any ideas? 

Thanks

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    Logan Profile Picture
    on at
    RE: Unable to install an additional Back End server

    Are you installing backend CRM server with DVD.  If yes, the this is resolved in UR 10.

    You can also try to Install CRM Backend at RTM version and then path it with URs.

    www.microsoft.com/.../details.aspx

    Let me know the results.

  • Suggested answer
    Community Member Profile Picture
    on at
    RE: Unable to install an additional Back End server

    Hi Nadeem

    I tried using all possible media - DVD, RTM , and the slipstreamed version with UR6 - nothing helped. Eventually one of our developers found the problem - there is an XML file inside the installation called ConfigurationMetadataXml - inside this XML you'll find:

    <Column Name="Cookie">

     <Description>The sync cookie</Description>

     <Type>nvarchar</Type>

     <Length>max</Length>

     <SchemaType>Base</SchemaType>

     <Locator>1</Locator>

     <Cached>1</Cached>

     <Nullable>1</Nullable>

    </Column>

    We changed the length value to 1024 - and the installation wen't through with no errors.

    TBH i have no idea what caused this - for me it looks like some kind of Microsoft bug when trying to add an additional server to an existing deployment with UR8.

    Hope this helps someone in the future

  • Logan Profile Picture
    on at
    RE: Unable to install an additional Back End server

    Thanks for the update Michael. Definitely this will help many of them in future.

  • jimmy_bleen Profile Picture
    5 on at
    RE: Unable to install an additional Back End server

    Hi Michael,

    So I've run into the exact same error message while trying to add a new web server to an existing CRM installation running UR11.

    I looked for a ConfigurationMetadataXml file inside the installation folder without success. I did however find a synccookiehistory.xml file and a synccookielock.xml file with the same content:

    <Column Name="Cookie">

    <Description>The sync cookie</Description>

    <Type>nvarchar</Type>

    <Length>max</Length>

    <SchemaType>Base</SchemaType>

    <Locator>1</Locator>

    <Cached>1</Cached>

    <Nullable>0</Nullable>

    </Column>

    Do these files sound familiar?

    Regards,

    James

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

Leaderboard > 🔒一 Microsoft Dynamics CRM (Archived)

#1
HR-09070029-0 Profile Picture

HR-09070029-0 2

#1
UllrSki Profile Picture

UllrSki 2

#3
ED-30091530-0 Profile Picture

ED-30091530-0 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans