Browse by Tags

Tagged Content List
  • Blog Post: Released: Management Pack for SQL Server Analysis Services 2008 and 2012

    This week, we released Management Packs for SQL Server 2008 and 2012 Analysis Services. The corresponding downloads are available at: System Center Management Pack for SQL Server 2012 Analysis Services System Center Management Pack for SQL Server 2008 Analysis Services These Management...
  • Blog Post: Released: Kerberos Configuration Manager for SQL Server

    Kerberos Configuration Manager for SQL Server (KerberosConfigMgr) was released on May 15 th 2013, and is available for download at the Microsoft Download Center at http://www.microsoft.com/en-us/download/details.aspx?id=39046 . This diagnostic tool can help to troubleshoot Kerberos-related configuration...
  • Blog Post: Refreshing PowerPivot Data in SharePoint 2013

    In SharePoint 2013, Excel Services comes with numerous improvements. One of the most significant for PowerPivot is the ability to refresh data models interactively all the way from the original data sources. Unlike Excel Services in SharePoint 2010, which only queries data models but doesn’t refresh...
  • Blog Post: Setting Up an Administrative Server for BI in SharePoint 2013

    SharePoint has practically always relied on a Central Administration Web site to provide a centralized administrative user interface for configuring and controlling servers and services in a farm. PowerPivot for SharePoint adds several components to this site to cover common PowerPivot administration...
  • Blog Post: Understanding Analysis Services Deployment Modes

    SQL Server 2012 Analysis Services (SSAS) supports three different deployment modes: Multidimensional, Tabular, and SharePoint. You can choose the deployment mode during Setup, as the following figure illustrates. The SharePoint deployment mode is implicitly chosen on the Setup Role page when you install...
  • Blog Post: Troubleshooting PowerPivot for SharePoint Solution Deployments

    The configuration of PowerPivot for SharePoint entails a critical phase concerning the deployment of multiple solution packages (.wsp files) on all servers in the farm. If you run the PowerPivot Configuration Tool for the first time in a farm, you can see the various steps this phase includes under Add...
  • Blog Post: Verifying the SharePoint 2013 Configuration for Accessing Workbooks as a Data Source from Within the Farm

    My previous blog post, “ Verifying the Excel Services Configuration for PowerPivot in SharePoint 2013 ,” discussed steps to verify that Excel Services can load workbook data models on an out-of-farm PowerPivot server running SQL Server 2012 SP1 CTP3 Analysis Services (SSAS) in SharePoint...
  • Blog Post: Verifying the Excel Services Configuration for PowerPivot in SharePoint 2013

    In SharePoint 2013, Excel Services natively supports core PowerPivot functionality. This is an important improvement over previous releases. Without requiring an extra installation of PowerPivot components in the farm, users can interact with workbook data models in the browser. You only need to register...
  • Blog Post: Supporting Multiple PowerPivot Versions

    Since the release of SQL Server 2012, users can choose between two different versions of PowerPivot for Excel: SQL Server 2008 R2 and SQL Server 2012. Both PowerPivot versions are free of charge, but the 2012 add-in includes more features than its predecessor and offers several improvements to the user...
  • Blog Post: Exploring the PowerPivot for SharePoint Configuration Tool

    The PowerPivot Configuration Tool included in SQL Server Code Name “Denali” CTP3 is undoubtedly a great new utility for SharePoint administrators. This tool doesn’t just enable you to configure or upgrade PowerPivot in a SharePoint farm. It takes PowerPivot configuration to a whole...
Page 1 of 1 (10 items)