Question Status

Verified
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.

Thanks!

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

I used the version, availale on the Microsoft Download link

www.microsoft.com/.../details.aspx

The download is the build : 05.00.9690.1992

The SRS installation is in the folder SrsDataConnector

Reply
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?

Reply
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.

Reply
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?

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

A picture tells everything...

Reply
XCNFNK responded on 18 May 2012 12:51 AM

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

Reply
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.

BR,

Jari L

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

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.

Gus Gonzalez

Dad, Husband, Engineer, 3-time Microsoft MVP, Solution Architect,  Subject Matter Expert, Speaker, Columnist  Georgia Chapter Chairman. Follow me @GusGonzalez2.

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

Just out!

support.microsoft.com/.../2686619

Gus Gonzalez

Dad, Husband, Engineer, 3-time Microsoft MVP, Solution Architect,  Subject Matter Expert, Speaker, Columnist  Georgia Chapter Chairman. Follow me @GusGonzalez2.

Reply