Jun 10, 2014 - Microsoft released SQL Server 2012 SP2
User Rating: / 0
PoorBest 
Wednesday, 11 June 2014 00:38

June 10, 2014 - Microsoft released SQL Server 2012 Service Pack 2 (SP2). List of bugs that are fixed in this release can be found here.

This release also contains following changes related to SSAS:

 

  • Add support to local cube creation scenario:
    • When you use SQL Server 2012 Analysis Services (SSAS 2012) SP2, you can create a local cube that connects to SSAS that is running on a static non-default port that has SQL browser turned off. This new feature is controlled by a new configuration setting in msmdsrv.ini: "ConfigurationSettings\LocalCubeServerPortInConnectionString." To enable this feature, set the value to 1. This setting will have no effect if SSAS 2012 is configured as a failover cluster or is running on the default port.
  • Add more logging:
    • This service pack adds more information to SSAS log file to help improve troubleshooting. This includes SSAS version, computer name, netbios name, number of CPUs, RAM size, IP, port, protocol type, deadlock, lock timeout, and some other information.

 You can also download PowerPivot for Excel 2010 update from SQL Server 2012 SP2 Feature Pack.

 
 

Pyramid Analytics