Office Web Apps 2013 RTM

Office Web Apps 2013 RTM

The following post describes the installation process for Office Web Apps 2013 RTM

  1. Turn on the required Server side roles which are required for the installation of Office Web Apps 2013.

On Windows 2012 Server

1
2
3
cls
Import-Module ServerManager
Add-WindowsFeature Web-Server,Web-Mgmt-Tools,Web-Mgmt-Console,Web-WebServer,Web-Common-Http,Web-Default-Doc,Web-Static-Content,Web-Performance,Web-Stat-Compression,Web-Dyn-Compression,Web-Security,Web-Filtering,Web-Windows-Auth,Web-App-Dev,Web-Net-Ext45,Web-Asp-Net45,Web-ISAPI-Ext,Web-ISAPI-Filter,Web-Includes,InkandHandwritingServices

On Windows 2008 R2 Sp1 (Remember to bring the server to have all latest patches and updates installed verify previous post http://wellytonian.com/2012/08/sharepoint-2013-and-office-web-apps/ )

    1. Once the above mentioned Pre requisites are installed browse to Office Web Apps 2013 RTM Installer and run through the binary installation
    2. Enabling HTTP for the WAC Server
1
2
Import-Module OfficeWebApps
New-OfficeWebAppsFarm –InternalURL http://$WACServer –AllowHttp -EditingEnabled


1
2
3
New-SPWOPIBinding -ServerName $OffWebAppSrv -AllowHttp
"Setting Zone"
Set-SPWopiZone Internal-HTTP

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Log onto your SharePoint site and browse to Documents Library and click on New Document

 

 

 

And there you go..

 

 

SharePoint 2013 Pre Requisites Downloader

SharePoint 2013 Pre Requisites Downloader

Update:

SharePoint 2013 has RTM’d. If you are still working off Public Beta bits please check the section of Public Beta as the Pre reqs that get downloaded are different.

RTM Edition

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
###############SharePoint 2013 Pre Requisite Software Downloader############
############################################################################
###Author: Aben Samuel####Date:27/10/2012###################################
##########Version:2#########################################################

#####URL#####EDIT IF Microsoft Makes Changes to the URL#####################
$UrlList = ("http://download.microsoft.com/download/1/E/3/1E3220BD-1D17-4EE7-8D7F-333422D1BA4B/enu_netfx/x64/netfx_full_x64.msi", # Microsoft .NET Framework 4.5
"http://download.microsoft.com/download/5/2/B/52B59966-3009-4F39-A99E-3732717BBE2A/Windows6.1-KB2506143-x64.msu", # Windows Management Framework 3.0 (CTP2)
"http://download.microsoft.com/download/9/1/3/9138773A-505D-43E2-AC08-9A77E1E0490B/1033/x64/sqlncli.msi", #Microsoft SQL Server 2008 r2 Native Client
"http://download.microsoft.com/download/D/7/2/D72FD747-69B6-40B7-875B-C2B40A6B2BDD/Windows6.1-KB974405-x64.msu", #Windows Identity Foundation (KB974405)
"http://download.microsoft.com/download/E/0/0/E0060D8F-2354-4871-9596-DC78538799CC/Synchronization.msi", # Microsoft Sync Framework Runtime v1.0 SP1 (x64)
"http://download.microsoft.com/download/A/6/7/A678AB47-496B-4907-B3D4-0A2D280A13C0/WindowsServerAppFabricSetup_x64.exe", #Windows Server AppFabric
"http://download.microsoft.com/download/0/1/D/01D06854-CA0C-46F1-ADBA-EBF86010DCC6/r2/MicrosoftIdentityExtensions-64.msi", # Windows Identity Extensions
"http://download.microsoft.com/download/9/1/D/91DA8796-BE1D-46AF-8489-663AB7811517/setup_msipc_x64.msi", # Microsoft Information Protection and Control Client
"http://download.microsoft.com/download/8/F/9/8F93DBBD-896B-4760-AC81-646F61363A6D/WcfDataServices.exe", # Microsoft WCF Data Services 5.0
"http://download.microsoft.com/download/7/B/5/7B51D8D1-20FD-4BF0-87C7-4714F5A1C313/AppFabric1.1-RTM-KB2671763-x64-ENU.exe" # CU Package 1 for Microsoft AppFabric 1.1 for Windows Server (KB2671763)
)
####Destination Directory for the files to be downloaded######################
$DestPath = "C:\SP2013B2"

######################################DO NOT EDIT BELOW THIS LINE##################################################
###################################################################################################################

Write-Warning "Executing Script"
##Importing Bits Module######
Import-Module BitsTransfer
Write-Host

######HouseKeeping#################################################################################################
###################################################################################################################
Remove-Item $DestPath -recurse -erroraction SilentlyContinue
New-Item $DestPath -type directory -erroraction SilentlyContinue
"Folder Created"
Write-Host
## Check that the path entered is valid
If (Test-Path "$DestPath" -Verbose)
{
## If destination path is valid, create folder if it doesn't already exist
$DestFolder = "$DestPath\PrerequisiteInstallerFiles"
New-Item -ItemType Directory $DestFolder -ErrorAction SilentlyContinue
}
Else
{
Write-Warning " - Destination path appears to be invalid."
## Pause
Write-Host " - Please check the path, and try running the script again."
Write-Host "- Press any key to exit..."
$null = $host.UI.RawUI.ReadKey("NoEcho,IncludeKeyDown")
break
}

#########Downloading#################################################################################################
#####################################################################################################################

ForEach ($Url in $UrlList)
{

$DestFileName = $Url.Split('/')[-1]
Try
{

If (!(Test-Path "$DestFolder\$DestFileName"))
{
## Start the download process
Start-BitsTransfer -Source $Url -Destination $DestFolder\$DestFileName -DisplayName "Downloading `'$DestFileName`' to $DestFolder" -Priority High -Description "From $Url..." -ErrorVariable err
If ($err) {Throw ""}
}
Else
{
Write-Host " - File $DestFileName already exists, skipping..."
}
}
Catch
{
Write-Warning " - An error occurred downloading `'$DestFileName`'. Check whether Internet connectivity is enabled on this device"
break
}
}

Write-Host "- Downloads completed"
Invoke-Item $DestFolder
Write-Warning "Press any key to exit"
$null = $host.UI.RawUI.ReadKey("NoEcho,IncludeKeyDown")

Public Beta

SharePoint 2013 Public Beta has been released and we are rushing to getting new VM’s provisioned and getting our hands dirty. Since a lot of us might have started scripting, this is my first release for SharePoint 2013 Pre Requisite Offline Installation Downloader

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
###############SharePoint 2013 Pre Requisite Software Downloader############
############################################################################
###Author: Aben Samuel####Date:20/07/2012###################################
##########Version:1#########################################################

#####URL#####EDIT IF Microsoft Makes Changes to the URL#####################
$UrlList = ("http://download.microsoft.com/download/D/3/0/D30186E3-C7E0-4FD2-8775-FC3B90062B49/dotNetFx45_Full_x86_x64.exe", # Microsoft .NET Framework 4.5
"http://download.microsoft.com/download/5/2/B/52B59966-3009-4F39-A99E-3732717BBE2A/Windows6.1-KB2506143-x64.msu", # Windows Management Framework 3.0 (CTP2)
"http://download.microsoft.com/download/9/1/3/9138773A-505D-43E2-AC08-9A77E1E0490B/1033/x64/sqlncli.msi", #Microsoft SQL Server 2008 r2 Native Client
"http://download.microsoft.com/download/D/7/2/D72FD747-69B6-40B7-875B-C2B40A6B2BDD/Windows6.1-KB974405-x64.msu", #Windows Identity Foundation (KB974405)
"http://download.microsoft.com/download/E/0/0/E0060D8F-2354-4871-9596-DC78538799CC/Synchronization.msi", # Microsoft Sync Framework Runtime v1.0 SP1 (x64)
"http://download.microsoft.com/download/A/6/7/A678AB47-496B-4907-B3D4-0A2D280A13C0/WindowsServerAppFabricSetup_x64.exe", #Windows Server AppFabric
"http://download.microsoft.com/download/0/1/D/01D06854-CA0C-46F1-ADBA-EBF86010DCC6/r2/MicrosoftIdentityExtensions-64.msi", # Windows Identity Extensions
"http://download.microsoft.com/download/9/1/D/91DA8796-BE1D-46AF-8489-663AB7811517/setup_msipc_x64.msi", # Microsoft Information Protection and Control Client
"http://download.microsoft.com/download/8/F/9/8F93DBBD-896B-4760-AC81-646F61363A6D/WcfDataServices.exe", # Microsoft WCF Data Services 5.0
"http://download.microsoft.com/download/7/B/5/7B51D8D1-20FD-4BF0-87C7-4714F5A1C313/AppFabric1.1-RTM-KB2671763-x64-ENU.exe" # CU Package 1 for Microsoft AppFabric 1.1 for Windows Server (KB2671763)
)
####Destination Directory for the files to be downloaded######################
$DestPath = "C:\SP2013B2"

######################################DO NOT EDIT BELOW THIS LINE##################################################
###################################################################################################################

Write-Warning "Executing Script"
##Importing Bits Module######
Import-Module BitsTransfer
Write-Host

######HouseKeeping#################################################################################################
###################################################################################################################
Remove-Item $DestPath -recurse -erroraction SilentlyContinue
New-Item $DestPath -type directory -erroraction SilentlyContinue
"Folder Created"
Write-Host
## Check that the path entered is valid
If (Test-Path "$DestPath" -Verbose)
{
## If destination path is valid, create folder if it doesn't already exist
$DestFolder = "$DestPath\PrerequisiteInstallerFiles"
New-Item -ItemType Directory $DestFolder -ErrorAction SilentlyContinue
}
Else
{
Write-Warning " - Destination path appears to be invalid."
## Pause
Write-Host " - Please check the path, and try running the script again."
Write-Host "- Press any key to exit..."
$null = $host.UI.RawUI.ReadKey("NoEcho,IncludeKeyDown")
break
}

#########Downloading#################################################################################################
#####################################################################################################################

ForEach ($Url in $UrlList)
{

$DestFileName = $Url.Split('/')[-1]
Try
{

If (!(Test-Path "$DestFolder\$DestFileName"))
{
## Start the download process
Start-BitsTransfer -Source $Url -Destination $DestFolder\$DestFileName -DisplayName "Downloading `'$DestFileName`' to $DestFolder" -Priority High -Description "From $Url..." -ErrorVariable err
If ($err) {Throw ""}
}
Else
{
Write-Host " - File $DestFileName already exists, skipping..."
}
}
Catch
{
Write-Warning " - An error occurred downloading `'$DestFileName`'. Check whether Internet connectivity is enabled on this device"
break
}
}

Write-Host "- Downloads completed"
Invoke-Item $DestFolder
Write-Warning "Press any key to exit"
$null = $host.UI.RawUI.ReadKey("NoEcho,IncludeKeyDown")

 

Updated : 29/07/2012

You may have issues with Search if you do not have the following installed as well. This has been found to be an issue at least on Windows 2008 R2 Sp1 machines.

http://support.microsoft.com/kb/2554876

http://support.microsoft.com/kb/2708075

http://support.microsoft.com/kb/2472264

Cheeri0

SQL Server 2008 R2 Service Pack 1

…. And it’s finally available for Download. Actually it’s been pretty exciting couple of weeks , SharePoint 2010 Service Pack1 and now SQL 2008 R2 SP1 .

Download Links for Service Pack for SQL are available here http://www.microsoft.com/download/en/details.aspx?id=26727&utm_source=feedburner&utm_medium=feed&utm_campaign=Feed%3A+MicrosoftDownloadCenter+%28Microsoft+Download+Center%29

The KB article might be your preferred first place of hunting for Bugs or issues you might have been facing and to check if they have been rectified or addressed http://support.microsoft.com/kb/2463333

So our playground for this post is

  1. Windows 2008 R2 Sp1
  2. SQL 2008 R2

 

Before You Install Service Pack 1

For a list of the bugs that are fixed in SQL Server 2008 R2 Service Pack 1, see the master KB article.

Recommended Disk Space Requirements to Download, Extract, and Install SQL Server 2008 R2 Service Pack 1

The recommended disk space requirements to download, extract, and install SP1 are approximately 2.5 times the size of the specific package.

The SQL Server Service Cannot Start after You Uninstall SP1 for SQL Server 2008 R2 if a UCP Exists in the Instance of SQL Server

Symptoms

Consider the following scenario:

  • You have an instance of Microsoft SQL Server 2008 R2 that hosts a utility control point (UCP).
  • You have installed SP1 for SQL Server 2008 R2 on the instance and later decide to uninstall it.

In this scenario, the uninstall action succeeds. However, the SQL Server service cannot start.

Cause

This problem occurs because the Agent XPs option is not enabled when SQL Server 2008 R2 runs the upgrade script for the msdb database.

The upgrade script runs when the SQL Server service starts. The script runs a stored procedure that is related to the UCP. The stored procedure requires that the Agent XPs option be enabled.

Resolution

If you experience this behaviour after removing SP1, follow these steps to work around the problem. To avoid the problem, perform these steps before removing SP1.

1) If SQL Server is running, stop the SQL Server service.

2) Enable trace flag 902 on the instance of SQL Server 2008 R2. To do this, follow these steps:

  • Open SQL Server Configuration Manager.
  • In SQL Server Configuration Manager, click SQL Server Services.
  • Double-click the SQL Server service.
  • In the SQL Server Properties dialog box, click the advanced tab.
  • On the Advanced tab, locate the Startup Parameters item.
  • Add ;–T902 to the end of the existing string value, and then click OK.

3) Right-click the SQL Server service, and then click Start.

4) If the SQL Server Agent service is running, right-click the SQL Server Agent service, and then click Stop. Set the Agent service start mode to Manual.

5) Open SQL Server Management Studio, and then connect to the instance of SQL Server 2008 R2.

6) Run the following statements:

EXEC sp_configure ‘show advanced’, 1;
RECONFIGURE;
EXEC sp_configure ‘allow updates’, 0;
RECONFIGURE;
EXEC sp_configure ‘Agent XPs’, 1;
RECONFIGURE;
GO

7) Modify the extended property of the sysutility_mdw database back to the SQL Server 2008 R2 version. To do this, follow these steps:

  • In SQL Server Management Studio, right-click the sysutility_mdw database and then click Properties.
  • In the property dialog box, click Extended Properties.
  • Update the value to 10.50.1600.1 for the “Microsoft_DataCollector_MDW_Version” property.

8) If you have not yet uninstalled the service pack, uninstall it now. If you have already uninstalled it, continue to step 9.

9) In SQL Server Configuration Manager, right-click the SQL Server service, and then click Stop.

10) Remove trace flag 902 on the instance of SQL Server 2008 R2. To do this, delete ;–T902 from the string value that you updated in step 2.

11) Right-click the SQL Server service, and then click Start.

12) Right-click the SQL Server Agent service, view properties, and set the service start mode back to its original value. Then click Start to start the Agent service.

13) In SQL Server Management Studio, reconnect to the instance of SQL Server 2008 R2.

14) In Object Explorer, expand Management, right-click Data Collection, and then click Enable Data Collection.

Note: If data collection is already enabled, the Enable Data Collection item is unavailable.

 

Download Size

 

Installing SP1













Updating Management Studio






And then continue the installation to update your SQL Management Studio. If you have applied SP1 earlier you wouldn’t need to run the Update SQL Management Studio after that.

SQL 2008 R2 SP1.

As always do this several times within a TEST ENVIRONMENT before trying it anywhere closer than 2km’s from your Production Datacentre J

Cheers