Monday, April 16, 2012

SharePoint and SQL 2012

Now that SQL 2012 has come out I though I’d give it a whirl with SharePoint Foundation. Firstly I installed SQL 2012 Express with Advanced features onto the machine. There are a few changes but nothing major. I them attempted to install SharePoint Foundation and was going along swimmingly until I received an error like:

 

An exception or type System.Data.SqlClient.SqlException was thrown. Additional information: Coudl not find stored procedure ‘sp_adoption’.

 

 

As http://msdn.microsoft.com/en-us/library/hh231665.aspx points out you need SharePoint Service Pack 1 prior to using SQL 2012.

 

Now that’s all well and good but there is currently no download of SharePoint Foundation 2010 WITH Service Pack 1. So how do you go about doing a clean install of SharePoint Foundation onto SQL 2012?

 

Bottom line is, at the moment you can’t really. The best bet is to get SharePoint Foundation 2010 working on SQL 2008 R2 Express. Then you need to apply SharePoint Foundation Service Pack 1 and THEN you need to upgrade SQL to SQL Express 2012 using an in place method.

 

I also suppose that it is possible to install SharePoint Foundation 2010 and not run the configuration wizard, install SharePoint Foundation 2010 Service Pack 1 and then proceed but that is very, very messy.

 

Bottom line? It looks like we have to wait until SharePoint Foundation 2010 with Service Pack 1 is released before there is a clean installation option with SQL 2012.

 

So what advantages does SQL 2012 Express provide over SQL 2008 R2 Express? Not much I can see.

 

http://msdn.microsoft.com/en-us/library/cc645993(v=SQL.110).aspx

 

It still has a 10GB database and 1GB RAM limit. So, if it was me, I wouldn’t be rushing to upgrade SharePoint Foundation 2010 to SQL 2012 Express just yet.