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

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics CRM (Archived) / Upgrading sql standard...
Microsoft Dynamics CRM (Archived)

Upgrading sql standard to sql enterprise on dynamics machine

(0) ShareShare
ReportReport
Posted on by Community Member

Hello there, a collegue has installed the wrong version of sql server (standard ) while making 3 dynamics machines

*MS Dynamics 2011 IFD*

*MS Dynamics 2013 Active Directory*
*MS Dynamics 2013 IFD*
Would anyone be able to tell me how easy it is to install SQL enterprise on these instead.

Ive had mixed answers, would i need to completely start again or can these just be installed over?

Ive heard the other way around is a nightmare because of the extra partitions enterprise creats, any help would go down really well.

Many thanks in advance

Gareth

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    Ragnar Hilmarsson Profile Picture
    Ragnar Hilmarsson 3,427 on at

    Hi
    Here are steps to move database to new server

    1. Back up the MSCRM_CONFIG and OrganizationName_MSCRM databases that are on the existing SQL Server.

    2. Restore the MSCRM_CONFIG and OrganizationName_MSCRM databases to the  new SQL Server

    3. Update the configdb registry subkey on the computer that is running Microsoft Dynamics CRM Server 2013. To do this, follow these steps:

      • On the computer that is running the Microsoft Dynamics CRM web application, click Start, click Run, type regedit in the Open box, and then click OK.

      • Locate the following registry subkey:

        HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSCRM

      • Right-click configdb, and then click Modify.

      • In the Value data box, change the data source to the name of the new virtual SQL Server, and then click OK. For example, the string value in the Value data box should resemble the following:
        Data Source=NewSQLServer;Initial Catalog=MSCRM_CONFIG;Integrated Security=SSPI

    4. Configure Microsoft Dynamics CRM Server 2013 to connect with the new instance of SQL Server where the organization database is now located. To do this, follow these steps:

      1. On the computer that is running the Microsoft Dynamics CRM Server 2013 web application, start Deployment Manager. To do this, click Start, point to All Programs, point to Microsoft Dynamics CRM, and then click Deployment Manager.

      2. Expand the Deployment Manager node, and then click Organizations.

      3. If the organization is not already disabled, right-click the organization, and then click Disable.
        • Click Yes to disable the organization.

        • In the list of organizations, right-click the organization, and then click Edit Organization.

        • In the Edit Organization Wizard, in the SQL Server box, type the virtual SQL Server name for the SQL Server cluster that you created earlier, and then click Next.

        • On the System Requirements page, after a successful diagnostics check, click Next, and then click Apply.

        • Click Finish.

        • Enable the organization. To do this, right-click the organization, and then click Enable.

    5. Reset the IIS services on the computer that is running IIS where the Microsoft Dynamics CRM Server 2013 web application is installed
  • Suggested answer
    Community Member Profile Picture
    Community Member on at

    You can try inplace upgrade of sql i think.

    Read this.

    ask.sqlservercentral.com/.../in-place-upgrade-from-standard-edition-to-enterpri.html

    Mansoor

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…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics CRM (Archived)

#1
SA-08121319-0 Profile Picture

SA-08121319-0 4

#1
Calum MacFarlane Profile Picture

Calum MacFarlane 4

#3
Alex Fun Wei Jie Profile Picture

Alex Fun Wei Jie 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans