locked
CRM 2011 on SQL 2012 / Denali? RRS feed

  • Question

  • 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!

    Wednesday, March 7, 2012 2:52 AM

Answers

  • I had success by downloading the latest 90-day demo and running the SRS connector application as part of that package.  I think it was re-packaged with UR6 and I was able to get past the "Unable to validate SQL Server Reporting Services" error you mentioned trying to use SQL 2012.

    http://www.microsoft.com/download/en/details.aspx?id=27822 

    Monday, March 12, 2012 1:54 AM
  • Here's the answer:

    http://support.microsoft.com/kb/2686619

    Microsoft Dynamics CRM 4.0 (Update Rollup 21) and Microsoft Dynamics CRM 2011 (Update Rollup 6) are compatible with Microsoft SQL Server 2012. 

    Note Microsoft Dynamics CRM supports installing and running Dynamics CRM on Microsoft SQL Server 2012. Microsoft SQL 2012 has a new feature called Always On. Always On has not been fully tested with Microsoft Dynamics CRM at this point. Testing will be done and a whitepaper with setup recommendation is planned to be released.

    Wednesday, March 7, 2012 10:17 PM
  • Hello Abenton,

    I've just finished my install of CRM2011 on Windows 2008R2 and SQL 2012.

    Here are the operations:
    - install of SQL 2012 (DBEngine + Reports + FullText + SQL Server Data tools (for BIDS))
    - uninstall of VisualC++ Redistributable x64 AND x86
    - install of CRM2011 Server and SRS, as Chris Eakin said, use the link below, it already contains the UR6 (required for SRS)
       http://www.microsoft.com/download/en/details.aspx?id=27822 
    - install of Server and SRS UR7
       http://www.microsoft.com/download/en/details.aspx?id=29221
    - install of CRM EmailRouter UR6 version + UR7
       http://www.microsoft.com/download/en/details.aspx?id=28712
       http://www.microsoft.com/download/en/details.aspx?id=27823

    I could not install BIDS (could not find SQL BI)

    My next step is importing my CRM 4.0 data.

    Thursday, March 29, 2012 12:13 PM
  • Hi Farhan,

    Here is my installation step to install CRM2011 and SQL2012 on multi-server before.  Hope it can help you to trouble the problem

    1. Install MSSQL 2012 (Database Engine Services + Full-text search) on ServerA
    2. Install MSSQL 2012 (Reporting Services) on Server B
    3. Download CRM2011 Server with RU6 from this link
      http://www.microsoft.com/download/en/details.aspx?id=27822
    4. Extract and Install MSCRM2011 on Server C
    5. On Extract folder, search ‘SrsDataConnector’ folder and copy to Server B
    6. On Server B, run ‘SetupSrsDataConnector’ install SRSS connector

    Tuesday, June 19, 2012 8:20 AM

All replies

  • I've seen anecdotal evidence of CRM 2011 running on SQL 2012, however:

    1. I haven't actually observed it
    2. Official support does not arrive until the Q2 2012 release of CRM 2011

    --pogo (pat) @ pogo69.wordpress.com

    Wednesday, March 7, 2012 3:14 AM
  • Thanks, Pogo.  That's pretty well what I was expecting.  I would love to hear from one of those users who are running on that config!

    Seems like I'm going to need to run with SQL 2008 R2 and upgrade later, as much as I don't want to do that.

    Wednesday, March 7, 2012 3:58 AM
  • Here's the answer:

    http://support.microsoft.com/kb/2686619

    Microsoft Dynamics CRM 4.0 (Update Rollup 21) and Microsoft Dynamics CRM 2011 (Update Rollup 6) are compatible with Microsoft SQL Server 2012. 

    Note Microsoft Dynamics CRM supports installing and running Dynamics CRM on Microsoft SQL Server 2012. Microsoft SQL 2012 has a new feature called Always On. Always On has not been fully tested with Microsoft Dynamics CRM at this point. Testing will be done and a whitepaper with setup recommendation is planned to be released.

    Wednesday, March 7, 2012 10:17 PM
  • Hi abenton,

    It would be great to know your experience after installing CRM 2011 on top of SQL 2012directly, instead of upgrade.

    Thanks.



    View Kevin Dan's LinkedIn profileView Kevin Dan's profile Please click "Mark As Answer" on the post if this post answers the question or "Vote as Helpful" when it helps.


    • Edited by Kevin Dan Wednesday, March 7, 2012 10:52 PM
    Wednesday, March 7, 2012 10:52 PM
  • OK, Kevin.  Once that's in place I'll update this here.
    Wednesday, March 7, 2012 10:55 PM
  • The first part of the install seems to go OK, but I'm having problems with installing the SSRS connector.  

    The error message is "Unable to validate SQL Server Reporting Services Report Server installation. Please check that it is correctly installed on the local machine."  There are reports of that with other versions of CRM and other versions of SQL, so I'm playing around with some suggestions for those.

    Friday, March 9, 2012 1:28 AM
  • I had success by downloading the latest 90-day demo and running the SRS connector application as part of that package.  I think it was re-packaged with UR6 and I was able to get past the "Unable to validate SQL Server Reporting Services" error you mentioned trying to use SQL 2012.

    http://www.microsoft.com/download/en/details.aspx?id=27822 

    Monday, March 12, 2012 1:54 AM
  • Thanks, Chris.  I'll try that, installing UR6 before attempting to get the reporting services install to work.  That will be my last-ditch attempt before I give up and wait for UR8 to be released.

    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 http://support.microsoft.com/kb/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).

    Let's see how that works, with a fresh install of SQL 2012, then CRM 2011, then making sure UR6 is installed, then installing the reporting connector.  Fingers crossed.

    Tuesday, March 13, 2012 12:14 AM
  • I"m giving up with SQL 2012 for now.  On this latest install (on a fresh new machine) it wouldn't install all of the services properly, even though the accounts have the same permissions as earlier installs.  I uninstalled the 3 features with the problem services, reinstalling them, and 2 out of the 2 work, but the 3rd still doesn't.  I can't spend any more time fiddling with this, and need to go with something that works, so it's the SQL 2008 R2 / CRM 2011 combo for now.

    Thanks, all, for your help.

    Tuesday, March 13, 2012 4:48 AM
  • Thanks for trying and sharing your experience.

    View Kevin Dan's LinkedIn profileView Kevin Dan's profile Please click "Mark As Answer" on the post if this post answers the question or "Vote as Helpful" when it helps.

    Tuesday, March 13, 2012 4:37 PM
  • Hello Abenton,

    I've just finished my install of CRM2011 on Windows 2008R2 and SQL 2012.

    Here are the operations:
    - install of SQL 2012 (DBEngine + Reports + FullText + SQL Server Data tools (for BIDS))
    - uninstall of VisualC++ Redistributable x64 AND x86
    - install of CRM2011 Server and SRS, as Chris Eakin said, use the link below, it already contains the UR6 (required for SRS)
       http://www.microsoft.com/download/en/details.aspx?id=27822 
    - install of Server and SRS UR7
       http://www.microsoft.com/download/en/details.aspx?id=29221
    - install of CRM EmailRouter UR6 version + UR7
       http://www.microsoft.com/download/en/details.aspx?id=28712
       http://www.microsoft.com/download/en/details.aspx?id=27823

    I could not install BIDS (could not find SQL BI)

    My next step is importing my CRM 4.0 data.

    Thursday, March 29, 2012 12:13 PM
  • I had good success with Chris' suggestion (for an upgrade scenario).

    I upgraded a CRM 2011 UR6/SQL Server 2008 R2 SP1 system.

    Thanks all for posting in this thread.

    Sunday, April 1, 2012 6:41 PM
  • Hello Guys,

    As we have a new version SQL Server 2012, Microsoft removes the distribution of SQL Server 2008 in the market.

    I have searched and I found that CRM 2011 works on SQL 2008 Standard Edition but I would like to know if SQL 2012 Standard Edition is also supported.

    Refer: http://social.microsoft.com/Forums/eu/crmdeployment/thread/17b79f1d-9a37-4b4c-b143-102573bb227a

    Thanks,

    Widmeyer

    Thursday, April 5, 2012 9:06 PM
  • The first part of the install seems to go OK, but I'm having problems with installing the SSRS connector.  

    The error message is "Unable to validate SQL Server Reporting Services Report Server installation. Please check that it is correctly installed on the local machine."  There are reports of that with other versions of CRM and other versions of SQL, so I'm playing around with some suggestions for those.

    Hi Abenton, 

    I got the same message.

    Farhan

    Tuesday, June 19, 2012 7:06 AM
  • Hi Farhan,

    Here is my installation step to install CRM2011 and SQL2012 on multi-server before.  Hope it can help you to trouble the problem

    1. Install MSSQL 2012 (Database Engine Services + Full-text search) on ServerA
    2. Install MSSQL 2012 (Reporting Services) on Server B
    3. Download CRM2011 Server with RU6 from this link
      http://www.microsoft.com/download/en/details.aspx?id=27822
    4. Extract and Install MSCRM2011 on Server C
    5. On Extract folder, search ‘SrsDataConnector’ folder and copy to Server B
    6. On Server B, run ‘SetupSrsDataConnector’ install SRSS connector

    Tuesday, June 19, 2012 8:20 AM
  • Hi Vincent, 

    Thanks for the reply and the steps.

    What I am trying to do is to install all of them in one box with UR8 and SQL 2012 with CU1 ( since Microsoft claims to have fix issues related to reporting services and the time involved in database upgrades.)  It did work initially with UR6 and could create accounts.. cases.. charts.. (the works).. but the reporting wizard would work. ( It would say that the reporting extension need be installed.. when it already was with UR6 and showed in the programs as well). Uninstalling the reporting extension (not the report authoring) lead to havoc....

    Another issue what I came across is that the libraries installed by SQL 2012 were not supported by CRM 2011 SRS. (This was resolved earlier.. but see what happened next) After uninstalling them and restarting the server.. and re installing the SRS the DLL's of SQL 2012 vanished. As a result had to repair the SQL Install.

    Once that was resolved and the srs connector installation was initiated... I again started getting the same error, " Microsoft Dynamics CRM Reporting Extensions must be installed on SQL Server Reporting Services for reports to work".

    After this what I did was to run a repair via the CRM Server install... when I did that.. it says, "another version already exist". Eventually it got installed... after multiple tries. :)

    Was back to repairing the application binaries.. still the report wizard wouldnt work..

    Now after running the repair for CRM reporting extensions repair got a new error, "Publishing CRM Reports failed" after ignoring the message the install was done and UR's were applied... (UR8)

    Game on! Any idea when is Microsoft releasing the non-beta UR9 ?

    Farhan


    Farhan Syed

    Tuesday, July 3, 2012 1:52 PM
  • Hi Vincent,

    How would you go about Server B if you wanted a separate set of data from the CRM database to be used for reporting? Would you replicate the organization_mscrm database or would you cluster two sql servers and only one would have the reporting services installed or some other method?

    Hopefully I explained the above clear enough,

    Rob Seidel


    • Edited by Rob Seidel Tuesday, July 31, 2012 8:42 PM
    Tuesday, July 31, 2012 8:41 PM