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) / SQL 2012 and CRM 2011?
Microsoft Dynamics CRM (Archived)

SQL 2012 and CRM 2011?

(0) ShareShare
ReportReport
Posted on by abenton 385

I'm about to do an install of CRM 2011.  Now that SQL Server 2012 is official, and the RTM version is available for download, I'd rather use the latest version of SQL rather than install 2008 and upgrade somewhere down the road.

I was wondering what experiences people have had with running CRM 2011 on SQL 2012?  

I know that SQL 2012 is only just official, but it has been under test for some time.

I don't care if CRM 2011 doesn't fully take advantage of all of the wonders of SQL 2012, just that it runs on there.

Thanks!

*This post is locked for comments

I have the same question (0)
  • Verified answer
    Gus Gonzalez Profile Picture
    Gus Gonzalez 27,113 on at

    Hello,

    The support for CRM 2011 with SQL 2012 is coming at the end of April with the R8 release.

    Can you wait a few weeks to deply CRM 2011.

  • abenton Profile Picture
    abenton 385 on at

    Thanks, Gus.  I know that's the official line, but I'm sure there are people who've tested / experimented with that combo, and was hoping to hear about some of those scenarios.  

    I can't wait  for CRM 2011 R8, so unless I hear about some concrete scenarios of CRM 2011 working on SQL 2012, then I guess I'll have to go with SQL 2008 R2, as much as I don't want to (so as to not have to go through an upgrade later).

  • Gus Gonzalez Profile Picture
    Gus Gonzalez 27,113 on at

    I haven't seen any posts out there regarding CRM 2011 and SQL 2012 but I will check in the morning to see if I find something.

  • abenton Profile Picture
    abenton 385 on at

    Thanks, Gus.  It's looking more and more like we'll need to go with SQL 2008 R2.

  • Gus Gonzalez Profile Picture
    Gus Gonzalez 27,113 on at

    Well, that's a pretty safe bet...you won't go wrong with SQL Server 2008 R2.

    Good Luck!

  • Verified answer
    Gus Gonzalez Profile Picture
    Gus Gonzalez 27,113 on at

    Just out!

    support.microsoft.com/.../2686619

  • abenton Profile Picture
    abenton 385 on at

    Wahoooooo!!!! Thanks so much, Gus, for bringing that to my attention *does a little happy dance*

  • Gus Gonzalez Profile Picture
    Gus Gonzalez 27,113 on at

    haha - I'm glad the timing was perfect!

  • abenton Profile Picture
    abenton 385 on at

    Yes, in under half an hour I'm about to install SQL Server.  Now I know I can install the latest, my preference!

  • abenton Profile Picture
    abenton 385 on at

    I've tried:

    • Installing SQL 2012 with some customizations on install (just changing location of data, setting up services using specific accounts), then installing CRM 2011.  As noted above, the CRM install went well, and CRM appeared to be working well, but I couldn't get the report connector working
    • Repeated the same but with keeping all the SQL 2012 install defaults, and no more success with the report connector
    • Installing SQL 2008 R2, then CRM 2011, then report connector.  The aim was then to upgrade to SQL 2012 and reinstall report connector as noted in support.microsoft.com/.../2686619, but it wouldn't let me upgrade from a SQL 2008 R2 production version to a SQL 2012 evaluation version (it would seem there's a way around that, getting a PID via MS support).
    • A fresh install of SQL 2012, then CRM 2011, then making sure UR6 is installed, then installing the reporting connector.  With this, even with a fresh machine, the SQL 2012 install failed, with 3 services not starting.  Removing and re-installing those features got 2 out of the 3 services working.

     

    I'm now giving up on SQL 2012 for with CRM 2011 for now.  I need something that works, so will use SQL 2008 R2.  Later, when the upgrade release for CRM 2011 is released for SQL 2012 I'll experiment again.  I've spent a lot of time on this already and can't spend any more time on this. A shame - I would have liked to use SQL 2012 now.

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