Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics GP (Archived)

GP2015 Installation Issue

Posted on by Microsoft Employee

Recently downloaded GP2015 Version : 14.00.0524 and installed it successfully. While creating dynamics database on SQL 2012 or SQL 2014(both above version 11.0), system throws an error -

The following SQL statement produced an error:  EXEC wfDeployClrAssemblies  

ERROR [Microsoft][SQL Server Native Client 11.0][SQL Server]CREATE ASSEMBLY for assembly 'System.IdentityModel' failed because assembly 'System.IdentityModel' failed verification. Check if the referenced assemblies are up-to-date and trusted.

However, system database gets created with specified errors and in the same manner, company database also gets created with error but doesn't allow to login.

 

I tried on a fresh machine where workflow is not installed.

*This post is locked for comments

  • Richard Wheeler Profile Picture
    Richard Wheeler 75,730 on at
    RE: GP2015 Installation Issue

    OK, what do you do when .Net FW 4.5.1 is installed? Ran into this on a W2012 server that for a long time has been running GP 2010 and trying to upgrade to GP 2015 14.00.1100.

  • Arunsh Profile Picture
    Arunsh 606 on at
    RE: GP2015 Installation Issue

    You are right chrystal, that's the scenario most of the time for this issue. After any important windows update or component installation a restart is a must for the changes to take effect.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: GP2015 Installation Issue

    In my case, when installing GP 2015 I saw it run the .NET update.  It prompted to reboot, but I chose to do that later.  Utilities was ran to upgrade from GP 2013 to 2015 BEFORE I rebooted.  To get rid of the error I just had to simply reboot.  Based on my experience, I believe this issue is caused by not rebooting after the update of .NET.  

  • Arunsh Profile Picture
    Arunsh 606 on at
    RE: GP2015 Installation Issue

    Thanks guys. your reply was very valuable. I got the same pbm and tried every solution found across the community but , simple machine restart solved my pbm. :)

  • Robyn Profile Picture
    Robyn 1,745 on at
    RE: GP2015 Installation Issue

    You saved my night as well.  Thanks for posting and helping others.

  • Suggested answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: GP2015 Installation Issue

    Thanks Brian. I have done several install on GP 2015 and haven;t had issues but was coming up with the error on this particular fresh install today. The SQL Server did not have .Net Framework 4.5.1 (it had 4.5) so I upgrade the framework version and it worked perfect after that. Thanks for the help. Saved me hours of troubleshooting.

  • Suggested answer
    Mike Lupro Profile Picture
    Mike Lupro 50 on at
    RE: GP2015 Installation Issue

    Brian:  You are this weeks HERO.  Your suggestion, and excellent instructions correctly diagnosed the problem.  Our server DID NOT have .Net 4.5.1 and, once it was updated, GP 2015 sailed on to a full and complete installation for Fabrikam.

    THANK YOU VERY MUCH.

    Mike

  • Mike Lupro Profile Picture
    Mike Lupro 50 on at
    RE: GP2015 Installation Issue

    Great tip Brian.  Hope it works.  Here's what I found.

    Directory C:\Windows\Microsoft.NET\Framework64\v4.0.30319\18408

    09/11/2013

    I'm working with our hosting partner to see if they can get .Net 4.5.1 installed.

    Thank you for this tip and the GREAT instructions on how to locate this information.

    Mike

  • Verified answer
    RE: GP2015 Installation Issue

    Verify that .NET 4.5.1 is installed on the SQL Server machine.

    You can query the sys.dm_clr_properties (select * from sys.dm_clr_properties) to identify the directory where the system assemblies will be pulled from when being registered in the SQL CLR.  Navigate to the directory in File Explorer and determine the file version for the System.IdentityModel.dll: Right-click > Properties > Details.  It appears that anything greater than or equal to a File Version of 4.0.3019.19001 will be .NET 4.5.1.

  • Suggested answer
    Ian Grieve Profile Picture
    Ian Grieve 22,782 on at
    RE: GP2015 Installation Issue

    I've seen this error when GP Utilities was being run on a client other than the SQL Server.

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,214 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans