Beware the SQL Server 2012 Repair
I recently ran a repair on my SQL Server 2012 instance and discovered about midway through that I needed BOTH the SQL Server 2012 installation media AND the Visual Studio 2010 installation media. In my development environment I have a single server installation of SharePoint 2010 along with Visual Studio 2010. The integration between the two is very tight but I was nevertheless surprised to see the prompt for the Visual Studio discs!
SQL 2012 Gotcha
When installing SQL Server 2012 we’re given the option to install SSAS in either Tabular or Multidimensional mode. I opted for tabular. If you plan on doing anything with multidimensional modeling you’re going to have to go back and add a new instance of SQL Server, selecting only Analysis Services (although you could select the SQL Engine as well) and selecting Multidimensional. If you attempt to deploy a multidimensional project to a tabular instance of SSAS you’ll get the error “You cannot deploy the model because the localhost deployment server is not running in multidimensional mode.” Once added right click your project and select Properties. Click ‘Deployment’ under Configuration Properties and add the server\instance name of your new multidimensional installation and redeploy. Voila! It works!!
Sharepoint 2007 Build numbers
For those of you unfortunate enough to not be on 2010 …
12.0.0.6550 – MOSS2007/WSSv3 December ’10 Cumulative Update
12.0.0.6548 – MOSS2007/WSSv3 October ’10 Cumulative Update
12.0.0.6545 – MOSS2007/WSSv3 August ’10 Cumulative Update
12.0.0.6539 – MOSS2007/WSSv3 June ’10 Cumulative Update
12.0.0.6535 – MOSS2007/WSSv3 April ’10 Cumulative Update
12.0.0.6529 – MOSS2007/WSSv3 February ’10 Cumulative Update
12.0.0.6524 – MOSS2007/WSSv3 December ’09 Cumulative Update
12.0.0.6520 – MOSS2007/WSSv3 October ’09 Cumulative Update
12.0.0.6514.5004 – (Corrected) MOSS2007/WSSv3 August ’09 Cumulative Update
12.0.0.6514.5000 – MOSS2007/WSSv3 August ’09 Cumulative Update
12.0.0.6510 – MOSS2007/WSSv3 June ’09 Cumulative update
12.0.0.6504 – MOSS2007/WSSv3 April ’09 Cumulative update
12.0.0.6421 – MOSS2007/WSSv3 SP2
12.0.0.6341 – MOSS2007/WSSv3 February ’09 Cumulative update
12.0.0.6335 – MOSS2007/WSSv3 December ’08 Cumulative update
12.0.0.6327 – MOSS2007/WSSv3 August ’08 Cumulative update
12.0.0.6318 – MOSS2007/WSSv3 Infrastructure Update
12.0.0.6300 – MOSS2007/WSSv3 post-SP1 hotfix
12.0.0.6219 – MOSS2007/WSSv3 SP1
12.0.0.6039 – MOSS2007/WSSv3 October ’07 public update
12.0.0.6036 – MOSS2007/WSSv3 August 24 ’07 hotfix package
12.0.0.4518 – MOSS2007/WSSv3 RTM