SQL 2012 and CRM 2011?

Question Status

abenton asked a question on 6 Mar 2012 6:26 PM

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.


Tomaž Vodušek responded on 17 May 2012 3:21 AM

I used the version, availale on the Microsoft Download link


The download is the build : 05.00.9690.1992

The SRS installation is in the folder SrsDataConnector

XCNFNK responded on 17 May 2012 3:37 AM

Did you have to extract the .exe to get to the SRS installer? My SQL Server 2012 instance is on another server so the installer prevents me from running it because no CRM install is present? I can't find any trace of the SRSDataConnector installer on the CRM machine other than the one that came with the ISO.  Selecting "check for updates" when installing the SRSDataConnector from this older build doesn't seem to have any impact either?

Tomaž Vodušek responded on 17 May 2012 3:55 AM

You need to extract the setup in the desired folder on the SRS server , then start the SetupSrsDataConnector.exe in the folder SrsDataConnector.

Do not check for updates (there are no updates)  and proceed with the installation.

XCNFNK responded on 17 May 2012 4:15 AM

Hmm, strange? I've just extracted the CRM2011-Server-ENU-amd64.exe and there is no sign of the SRSDataConnector?

Tomaž Vodušek responded on 17 May 2012 4:22 AM

A picture tells everything...

XCNFNK responded on 18 May 2012 12:51 AM

.... and you've extracted the SRSDataConnector directory from the link to the .exe you posted?

Jari Loiri responded on 28 May 2012 4:15 AM

Hi Tomaž,

And thanks a lot! The solution seems to be just as simple as you said: I downloaded that exe and installed SRS Data Connector from there successfully. Now I updated both server and SRS Connector to UR 8 and the reports seem to be working fine.


Jari L

Verified Answer
Gus Gonzalez responded on 6 Mar 2012 6:32 PM


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.

Verified Answer
Gus Gonzalez responded on 7 Mar 2012 1:56 PM

Just out!