Microsoft cloud engineer - SharePoint, Office 365, Azure, DotNet, Angular, JavaScript.
Microsoft cloud engineer - SharePoint, Office 365, Azure, DotNet, Angular, JavaScript.

July 2012

New Version of SSRS add-in released for SharePoint 2010

Today a new download showed up on my RSS feeds and I wanted to take a minute to compare this new MSI file against the trusty old MSI I’ve used for so long now.   As you know, the SharePoint 2010 Prerequisites installer requires “rsSharePoint.msi” to be loaded before you can install SharePoint 2010.   Below is the OLD link for SSRS which most people use today for cool stuff like a PowerShell script to download all Prerequisites for offline install. as well as the NEW link.   The release of Service Pack 2 for SQL 2008 R2 seems to be triggering lots of new downloads so it might be worthwhile to make sure you’re SharePoint front end binaries match the backend SQL server version.   If patching SQL to SP2, then it’s probably a good idea to update the web front end components and look for the “4000” version number.

 

NEW –
SP2
http://www.microsoft.com/en-us/download/details.aspx?id=62210.50.4000.07/27/201236.9 MB
OLD –
SP1
http://www.microsoft.com/en-us/download/details.aspx?id=2813210.50.2500.0011/3/201136.9 MB

 

It might be a good idea to download the most recent add-in for any new server installs.  There appear to be updates to most all files, but “sqlserverspatial.dll” grew more than most possibly hinting at better geographic data support.

 

image

 

Old Package – File Version Detail

image

 

New Package – File Version Detail

image

 

\Program Files\Common File\Mmicrosoft Shared Web\Server Extensions\14\Template\Admin\ReportServer\reportserverproperties.aspx
\Program Files\Common File\Mmicrosoft Shared Web\Server Extensions\14\Template\Admin\ReportServer\reportserversitesettings.aspx
\Program Files\Common File\Mmicrosoft Shared Web\Server Extensions\14\Template\Layouts\reportserverrsaction.aspx
\Program Files\Common File\Mmicrosoft Shared Web\Server Extensions\14\Template\Layouts\reportserverrsintegrationresults.aspx
\Program Files\Common File\Mmicrosoft Shared Web\Server Extensions\14\Template\Layouts\reportserverrsviewerpage.aspx
\Program Files\Common File\Mmicrosoft Shared Web\Server Extensions\14\Template\Layouts\reportserversitelevelsettings.aspx
\Program Files\Common File\Mmicrosoft Shared Web\Server Extensions\14\Template\Layouts\reportserverstyles1025sqlrvdefault.css
\Program Files\Common File\Mmicrosoft Shared Web\Server Extensions\14\Template\Layouts\reportserverstyles1026sqlrvdefault.css
\Program Files\Common File\Mmicrosoft Shared Web\Server Extensions\14\Template\Layouts\reportserverstyles1027sqlrvdefault.css
\Program Files\Common File\Mmicrosoft Shared Web\Server Extensions\14\Template\Layouts\reportserverstyles1028sqlrvdefault.css
\Program Files\Common File\Mmicrosoft Shared Web\Server Extensions\14\Template\Layouts\reportserverstyles1029sqlrvdefault.css
\Program Files\Common File\Mmicrosoft Shared Web\Server Extensions\14\Template\Layouts\reportserverstyles1030sqlrvdefault.css
\Program Files\Common File\Mmicrosoft Shared Web\Server Extensions\14\Template\Layouts\reportserverstyles1031sqlrvdefault.css
\Program Files\Common File\Mmicrosoft Shared Web\Server Extensions\14\Template\Layouts\reportserverstyles1032sqlrvdefault.css
\Program Files\Common File\Mmicrosoft Shared Web\Server Extensions\14\Template\Layouts\reportserverstyles1033sqlrvdefault.css
\Program Files\Common File\Mmicrosoft Shared Web\Server Extensions\14\Template\Layouts\reportserverstyles1035sqlrvdefault.css
\Program Files\Common File\Mmicrosoft Shared Web\Server Extensions\14\Template\Layouts\reportserverstyles1036sqlrvdefault.css
\Program Files\Common File\Mmicrosoft Shared Web\Server Extensions\14\Template\Layouts\reportserverstyles1037sqlrvdefault.css
\Program Files\Common File\Mmicrosoft Shared Web\Server Extensions\14\Template\Layouts\reportserverstyles1038sqlrvdefault.css
\Program Files\Common File\Mmicrosoft Shared Web\Server Extensions\14\Template\Layouts\reportserverstyles1040sqlrvdefault.css
\Program Files\Common File\Mmicrosoft Shared Web\Server Extensions\14\Template\Layouts\reportserverstyles1041sqlrvdefault.css
\Program Files\Common File\Mmicrosoft Shared Web\Server Extensions\14\Template\Layouts\reportserverstyles1042sqlrvdefault.css
\Program Files\Common File\Mmicrosoft Shared Web\Server Extensions\14\Template\Layouts\reportserverstyles1043sqlrvdefault.css
\Program Files\Common File\Mmicrosoft Shared Web\Server Extensions\14\Template\Layouts\reportserverstyles1044sqlrvdefault.css
\Program Files\Common File\Mmicrosoft Shared Web\Server Extensions\14\Template\Layouts\reportserverstyles1045sqlrvdefault.css
\Program Files\Common File\Mmicrosoft Shared Web\Server Extensions\14\Template\Layouts\reportserverstyles1046sqlrvdefault.css
\Program Files\Common File\Mmicrosoft Shared Web\Server Extensions\14\Template\Layouts\reportserverstyles1048sqlrvdefault.css
\Program Files\Common File\Mmicrosoft Shared Web\Server Extensions\14\Template\Layouts\reportserverstyles1049sqlrvdefault.css
\Program Files\Common File\Mmicrosoft Shared Web\Server Extensions\14\Template\Layouts\reportserverstyles1050sqlrvdefault.css
\Program Files\Common File\Mmicrosoft Shared Web\Server Extensions\14\Template\Layouts\reportserverstyles1051sqlrvdefault.css
\Program Files\Common File\Mmicrosoft Shared Web\Server Extensions\14\Template\Layouts\reportserverstyles1053sqlrvdefault.css
\Program Files\Common File\Mmicrosoft Shared Web\Server Extensions\14\Template\Layouts\reportserverstyles1054sqlrvdefault.css
\Program Files\Common File\Mmicrosoft Shared Web\Server Extensions\14\Template\Layouts\reportserverstyles1055sqlrvdefault.css
\Program Files\Common File\Mmicrosoft Shared Web\Server Extensions\14\Template\Layouts\reportserverstyles1058sqlrvdefault.css
\Program Files\Common File\Mmicrosoft Shared Web\Server Extensions\14\Template\Layouts\reportserverstyles1060sqlrvdefault.css
\Program Files\Common File\Mmicrosoft Shared Web\Server Extensions\14\Template\Layouts\reportserverstyles1061sqlrvdefault.css
\Program Files\Common File\Mmicrosoft Shared Web\Server Extensions\14\Template\Layouts\reportserverstyles1062sqlrvdefault.css
\Program Files\Common File\Mmicrosoft Shared Web\Server Extensions\14\Template\Layouts\reportserverstyles1063sqlrvdefault.css
\Program Files\Common File\Mmicrosoft Shared Web\Server Extensions\14\Template\Layouts\reportserverstyles1087sqlrvdefault.css
\Program Files\Common File\Mmicrosoft Shared Web\Server Extensions\14\Template\Layouts\reportserverstyles2052sqlrvdefault.css
\Program Files\Common File\Mmicrosoft Shared Web\Server Extensions\14\Template\Layouts\reportserverstyles2070sqlrvdefault.css
\Program Files\Common File\Mmicrosoft Shared Web\Server Extensions\14\Template\Layouts\reportserverstyles2074sqlrvdefault.css
\Program Files\Common File\Mmicrosoft Shared Web\Server Extensions\14\Template\Layouts\reportserverstyles3082sqlrvdefault.css
\Program files\Microsoft SQL Server\100\keyfile1033rssharepoint_keyfile.dll
\Windows\GAC\microsoft.reportingservices.sharepoint.ui.serverpages.dll
\Windows\GAC\microsoft.reportingservices.sharepoint.ui.webparts.dll
\Windows\GAC\microsoft.sqlserver.types.dll
\Windows\GAC\rssharepointsoapproxy.dll
\Windows\GAC\_32microsoft.sqlserver.types.dll
\Windows\System32\sqlserverspatial.dll
\Windows\SysWOW64\sqlserverspatial.dll

FIXED – SharePoint 2013 rule “SharePoint installation requirements for PowerPivot for SharePoint” failed

While attempting to install PowerPivot SQL2012 for a new SharePoint 2013 farm I came across this interesting error.  Basically, PowerPivot checks for SharePoint 2010 because that’s what existed when the SQL2012 product shipped.  However, we now have SharePoint 2013 version 15.0 to think about.  The workaround detailed below adds a few placeholder registry keys in order bypass the SQL rule check and keep moving forward.

Rule “SharePoint installation requirements for PowerPivot for SharePoint” failed.  SharePoint Server 2010 is not installed on this computer.  Please install SharePoint before you install PowerPivot for SharePoint.

Just save the below text as a .REG file and double click.  Hope that helps! 

Smile
Windows Registry Editor Version 5.00
[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Shared Tools\Web Server Extensions\14.0]
"SharePoint"="Installed"
[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Shared Tools\Web Server Extensions\14.0\InstalledLanguages]
"1033"="15.0.4420.1017"
[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Shared Tools\Web Server Extensions\14.0\Secure]
[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Shared Tools\Web Server Extensions\14.0\Secure\ConfigDB]
"dsn"="OK"
[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Shared Tools\Web Server Extensions\14.0\WSS]
[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Shared Tools\Web Server Extensions\14.0\WSS\InstalledProducts]
"{90140000-1014-0000-1000-0000000FF1CE}"="BEED1F75-C398-4447-AEF1-E66E1F0DF91E"
"{90140000-110D-0000-1000-0000000FF1CE}"="D5595F62-449B-4061-B0B2-0CBAD410BB51"
"{90140000-112D-0000-1000-0000000FF1CE}"="926E4E17-087B-47D1-8BD7-91A394BC6196"

 

image
image
image

FIXED – SharePoint 2013 Setup Error – Appfabric is not correctly configured

When trying to install SharePoint Server 2013, I saw the below error.  This was caused by manually double clicking the file “WindowsServerAppFabricSetup_x64.exe” instead of allowing the SharePoint Prerequisite Installer to run this.

The resolution was to run “prerequisiteinstaller.exe” with command line parameters to directly specify the filename for each prerequisite.   Just like with SharePoint 2010, when installing offline we must tell the installer where to locate each file.   Running the various components manually doesn’t work well.   Apparently there is an install sequence or extra parameters which “prerequisiteinstaller.exe”  must perform for the prerequisites to install correctly.

Below is the correct command line to use offline.  I saved this as “prereq.cmd” on my install folder.  Hope that helps! 

Smile

 

prerequisiteinstaller.exe
/SQLNCLi:prerequisiteinstallerfiles\sqlncli.msi
/PowerShell:prerequisiteinstallerfiles\Windows6.1-KB2506143-x64.msu
/NETFX:prerequisiteinstallerfiles\dotNetFx45_Full_x86_x64.exe
/IDFX:prerequisiteinstallerfiles\Windows6.1-KB974405-x64.msu
/Sync:prerequisiteinstallerfiles\Synchronization.msi
/AppFabric:prerequisiteinstallerfiles\WindowsServerAppFabricSetup_x64.exe
/IDFX11:prerequisiteinstallerfiles\MicrosoftIdentityExtensions-64.msi
/MSIPCClient:prerequisiteinstallerfiles\setup_msipc_x64.msi
/WCFDataServices:prerequisiteinstallerfiles\WcfDataServices.exe /quiet 
/KB2671763:prerequisiteinstallerfiles\AppFabric1.1-RTM-KB2671763-x64-ENU.exe

 

image

 

image

 

image
image

 

image

Download SharePoint 2013 preview (with PowerShell)

Today a number of new Microsoft Downloads went live for SharePoint 2013 Preview.  I wrote a quick PowerShell script to download everything all at once. Enjoy! 

Smile

Get the PowerShell Script

image

  download-SharePoint2013-Preview.ps1

 

PowerShell Code

Import-Module BitsTransfer
New-Item C:\temp -Type Directory -Force
 
Function DownloadFile ($url)
{
    $file = $url.Substring($url.LastIndexOf("/") + 1, $url.Length - $url.LastIndexOf("/") - 1)
    Try {
        Write-Host "Downloading $file..."
        Start-BitsTransfer -Source $url -Destination "c:\temp\$destinationFile" -DisplayName "Downloading $file to c:\temp\$destinationFile" -Priority High -Description "From $url..." -ErrorVariable err
    }
    Catch
    {
        Write-Warning " - An error occurred downloading $file"
        break
    }
}
$source = @("http://download.microsoft.com/download/D/E/0/DE02CCED-5209-49FC-9F1B-0F86D3269D4C/sharepointclientcomponents_x64.msi",
"http://download.microsoft.com/download/D/E/0/DE02CCED-5209-49FC-9F1B-0F86D3269D4C/sharepointclientcomponents_x86.msi",
"http://download.microsoft.com/download/7/E/D/7EDC5BE7-811C-4854-8502-EAFDEBB981B0/sharepointdesigner_en-us_x64.exe",
"http://download.microsoft.com/download/7/E/D/7EDC5BE7-811C-4854-8502-EAFDEBB981B0/sharepointdesigner_en-us_x86.exe",
"http://download.microsoft.com/download/7/7/3/773CA2C2-579B-408C-808E-A6F561194E20/Ig15_SP_IT_training.zip",
"http://download.microsoft.com/download/8/C/8/8C8FB472-2B18-42CE-9055-4022145350C8/SharePointFoundation_en-us_x64.img",
"http://download.microsoft.com/download/5/6/8/568E0DFE-E5A9-4B6E-9BD6-71537A736C1C/SharePointFoundationLP_en-us_x64.exe",
"http://download.microsoft.com/download/C/5/8/C58AC1BB-C483-4572-92C6-84060E204EA7/serverlanguagepack_en-us_x64.exe")
$source | ForEach-Object {DownloadFile $_}

© Copyright 2016
@ SPJeff

Return to Top ▲Return to Top ▲