Personalized Community is here!
Quickly customize your community to find the content you seek.
Have questions on moving to the cloud? Visit the Dynamics 365 Migration Community today! Microsoft’s extensive network of Dynamics AX and Dynamics CRM experts can help.
2023 Release Wave 1Check out the latest updates and new features of Dynamics 365 released from April 2023 through September 2023
The FastTrack program is designed to help you accelerate your Dynamics 365 deployment with confidence.
FastTrack Community | FastTrack Program | Finance and Operations TechTalks | Customer Engagement TechTalks | All TechTalks | Architecture Insights
I can't use my serial key of CRM Workgroup on my older database of CRM 4.0 professional.
I made a restore of the older database 4.0 in a new SQL Server and the try install a new CRM application but without success.
The license code is not compatible with the installed version of Microsoft Dynamics CRM or the Product Key is not compatible with the installed Version Of Microsoft Dynamics CRM are errors that i have receive when inserting the license key of workgroup (trial or action pack serial).
I install successfully only using the Trials Edition, but never with the trial workgroup serial neither my new license of Action Pack workgroup.
Is there any way i can use the older data of CRM 4.0 professional? By upgrading the database and usung the same company? Or in the worst option create a new installation and get the data (Opportunities, Queues, Accounts, Contacts, Propositions, Invoices, Emails attached...)
The productions Servers doesn't not exist anymore, just have the backups of database.
Have you tried importing the backup into the the workgroup edition using the deployment manager? You will need to disable the default organisation first since you are only allowed one enabled org at a time.
How did you get on?
Sorry but i can't answer because i have some troubles enter the site to login.
You try to told me to install my CRM Workgroup with a fresh install using a new database and a new organization? If i do this can i have the older databases restored (MSCRM_CONFIG and EADCRM_MSCRM) since i will use the same database server?
Don't restore the MSCRM_CONFIG - just import the EADCRM_MSCRM using the import organization in the deployment manager - you must first deactive the current org first.
OK , but i can't deactivate the organization since i don' have the older servers on CRM 4.0 working, just have the backups of database (.bak)
So i guess first step is install the CRM 2015 workgroup with a new organization. Then, can i restore the EADCRM_MSCRM database?
If you are upgrading from CRM 4 you must go via CRM2011-2013-2015
Yes - sorry, first install CRM2011, deactivate the default org that's created during install - then restore the EADCRM_MSCRM database and then use the import organization in deployment manager.
Then you can do an inplace upgrade to CRM2013 then to 2015.
Thanks, i guess you recommendation is right and will work. Unfortunately i have to cancel the import because it hangs our database server when deleting data from the EADCRM_MSCRM database.
And i guess the trick here is using the workgroup trial insteead of the professional trial, these step i could do on my first atemp because i use the restored database directly.
If i can logon on this site again tomorrow i will report. there is something odd in my account because i sign in and them force me to sign creating a new user...
The trick is not close the browser.
Well, importing the company isn't very easy, because the database changing are giving errors:
Cannot find the object 'fn_GetFormatStrings', because it does not exist or you do not have permission.
I already look the permissions and try to put the functions on the database manually, but perhaps i need to insert new columns in some tables of the older database.
You shouldn't need to do this. Does the function actually exist already? Are you sure you have dbo permissions on the database?
Yes, i already give permissions to all AD users of CRM on dbo (on the old database and the new). I can't put yet these function on the older database because give error on some tables i can't find.
Interesting - can you try importing the database into a CRM 4 Server?
I think in these case it is need to install on Win 2003 environment...
I look on the log and see maybe these is the cause:
15:18:41| Info| Import Organization Wizard completed
15:18:41| Info| Starting organization import
15:18:41| Info| Setting IsOnline = False
15:18:41|Verbose| Retrieving database version Provider=SQLOLEDB;Data Source=MINI;Integrated Security=True;Initial Catalog=EADCRM_MSCRM;Connect Timeout=60 ...
15:18:41| Info| Database version: 4.0.7333.2644.
15:18:41| Info| Organization must be upgraded and imported
15:18:41| Info| Retrieved organization ID a0990135-0164-4763-94cb-6a7db2dc7270.
15:18:41| Info| multipleTenancy for the deployment is False
15:18:41|Verbose| Checking Organization Id Data Source=MINI;Initial Catalog=MSCRM_CONFIG;Integrated Security=True;Connect Timeout=60 ...
15:18:41| Info| Organization Id is unique
15:18:42| Info| UpdateOUGroupsInDatabase started
15:18:42| Info| PrivilegedUserGroupName = <GUID=7655a831-ab6a-4c77-b9e6-331932b037c4>, SqlAccessGroupName = <GUID=01c86521-95ff-49df-b3d7-f4279adabe0a>, ReportingGroupName = <GUID=e3cc3aeb-64f5-4347-bbc2-3ffa393dae4f>, PrivilegedReportingGroupName = <GUID=f8e78f39-9423-423c-a442-57dbbd23d9d3>
15:18:42| Info| Granting access to CRM security groups for the deployment
15:18:42| Error| An error occurred when trying import and upgrade organization database MINI.EADCRM_MSCRM:
System.Data.SqlClient.SqlException (0x80131904): Cannot find the object 'fn_GetFormatStrings', because it does not exist or you do not have permission.
I have 9 users on my AD:
but no one matches with the line PrivilegedUserGroupName = <GUID=7655a831-ab6a-4c77-b9e6-331932b037c4>, SqlAccessGroupName = <GUID=01c86521-95ff-49df-b3d7-f4279adabe0a>, ReportingGroupName = <GUID=e3cc3aeb-64f5-4347-bbc2-3ffa393dae4f>, PrivilegedReportingGroupName = <GUID=f8e78f39-9423-423c-a442-57dbbd23d9d3>.
Can these the cause of the issue? On the setup import i only select the database server and the database.
If the fn_GetFormatStrings function is not in your database - I suspect that your database is too old to upgrade. You'll need to import it into a CRM 4 environment and then apply all the Update Rollups - then upgrade from there.
I already create a new environment in CRM4 and then successfully import the older database (EADCRM). Then apply the early rollup (21 for CRM 4.0) and i have the fn_GetFormatStrings function. I install a new CRM 2011 with the workgroup key trial and later i'll try to import the EADCRM and hope these works... If successfully import then i install the CRM 2013 on the same server with the trial workgroup key, and finally install the CRM 2015 with our workgroup key on the desired production server.
That sounds like a good plan!
I would run the SQL table size report on your database and find what is using the data.
I suspect that it will be the Principle Object Access table - in which case you can run a script to clean this up - see the script in dev03/.../multiEntityQuickFind.aspx;sitemappath=SFA%7cMyWork%7cnav_dashboards&text=smith
It's been a long journey - but I'm pleased you got there!!
I'd appreciate it if you could mark the thread as answered.
Business Applications communities