PowerShell Script Create/Configure Access Service Application

function AccessSACreationScript()

{

$saAppPool=read-host "Enter the Application Pool Name for the Access Service Application Configuration" `r`n

write-host "Application Pool Name Entered is :" $saAppPool `r`n


$saApp = Get-SPServiceApplicationPool -Identity $saAppPool -EA 0


if($saApp -ne $null)

{

Write-Host "Valid Application Pool..." `r`n
$serviceName=read-host "Enter the Service Name for Access Service Application :" `r`n
write-host "Access Service Application Name Enterd is :" $serviceName `r`n
$TempServiceName = Get-SPAccessServiceApplication -identity $serviceName -EA 0
if($TempServiceName -ne $null)
{
write-host "Access Service Application Already exist with this Name :" $TempServiceName.Name `r`n
}
else
{
New-SPAccessServiceApplication -Name $serviceName -ApplicationPool $saAppPool -Default
write-host "Access Service Application Created successfully with Name :" $serviceName `r`n
}
}
else
{
Write-Host "Entered the In-Valid Application Pool Name/No Application Exist with this Name." `r`n
}
}
AccessSACreationScript

Steps to install the SharePoint 2010 Pre-Requisites in Off-line Mode

1. Extract your SharePoint Installer


• Go to the ‘C:’ drive of your SharePoint machine, and create a new folder. Let’s call this folder ‘SharePointFiles‘.

• Copy/Paste your downloaded exe in this folder.

• Open a command line prompt and navigate to this folder ‘cd c:SharePointFiles‘

• In the cmd, enter ‘SharePointFoundation /extract:c:SharePointFiles‘ (the first term is the name of the downloaded exe, in my case the SP Foundation 2010 one)

• The command in the previous step will extract everything to your folder ‘c:SharePointFiles‘

• Now you should also see the executable: PrerequisiteInstaller.exe which will allow us to install the prerequisites.

2. Download your prerequisites

This is a list of items , we have to download for the installation of a -recent- Windows 2008R2 machine:

a. Microsoft SQL Server 2008 Native Client

b. Hotfix for .NET Framework 3.5 Service Pack 1 KB976462)

c. Windows Identity Foundation (KB974405) for Windows Server 2008 R2 / Windows Server 2008

d. Microsoft Sync Framework v1.0

e. Microsoft Chart Controls for Microsoft .NET Framework 3.5

f. Microsoft Filter Packs

g. Microsoft SQL Server 2008 Analysis Services ADOMD.NET

h. Microsoft Server Speech Platform

i. Microsoft Server Speech recognition language for English

j. SQL Server 2008 R2 Reporting Services Add-in for Microsoft SharePoint Technologies 2010

Note : I have already downloaded following prerequisites to \\cocxogspwfe20\e$\Software\SharePoint\Foundation\SPInstallPrerequisites folder

3. Create a PrerequisiteInstaller.Arguments file

• The next step is to create a PrerequisiteInstaller.Arguments.txt file in the SharePointFiles folder. This file will contain arguments, which will be used by the PrerequisiteInstaller executable.

• Each component required by the PrerequisiteInstaller will have its own argument. This argument has a name, and a location where the installer can be found. In our case, we will create a list of arguments for all required components combined with the location of that particular installer.

• In the PrerequisiteInstaller.Arguments.txt file, add the following commands: (All in one line, with only a space between each separate argument)

a. /Unattended /IDFXR2:C:SharePointFilesPrerequisiteInstallerFilesWindows6.1-KB974405-x64.msu /SQLnCli:C:SharePointFilesPrerequisiteInstallerFilessqlncli.msi /ChartControl:C:SharePointFilesPrerequisiteInstallerFilesMSChart.exe /Sync:C:SharePointFilesPrerequisiteInstallerFilesSynchronization.msi /adomd:C:SharePointFilesPrerequisiteInstallerFilesSQLSERVER2008_ASADOMD10.msi /Speech:C:SharePointFilesPrerequisiteInstallerFilesSpeechPlatformRuntime.msi /SpeechLPK:C:SharePointFilesPrerequisiteInstallerFilesMSSpeech_SR_en-US_TELE.msi /ReportingServices:C:SharePointFilesPrerequisiteInstallerFilesrsSharePoint.msi

• Note: Because I’m on a 2008R2 machine, I use the arugment ‘IDFXR2′ instead of ‘IDFX’. Be sure to change this if you’re on a 2008 machine!

Note : I have already created PrerequisiteInstaller.Arguments.txt file in \\cocxogspwfe20\e$\Software\SharePoint\Foundation\SPInstallPrerequisites folder

4. Run the prerequisites installer

• The only step left is to install the prerequisites.

• You can run ‘PrerequisiteInstaller.exe’ manually by double-clicking on it, or using the command line

• Because the file PrerequisiteInstaller.Arguments.txt is in the same directory, the installer will use this file for its own arguments and thus install the prerequisites in an offline mode.

• You’re done!

5. Troubleshooting

• It can be possible (like it was in my case) that the installation using PrerequisiteInstaller.exe did not complete. In my case, it was because there were some arguments missing in my arguments file.

• There are log-files available who can tell you what went wrong. You can find this log-files in folder: ‘C:Users{user}AppDataLocalTemp‘

This is automated process for installing prerequisites in off-line mode using the PrerequistiesInstaller.Arguments.txt or we can also install all Prerequisites manually from specified folder.