Saturday, April 12, 2014

Powershell To create a new SSRS Application

If you are not able to create a SSRS service application and proxy from central admin or if you get any error while creating it then please give a try to this PowerShell Script.
Before running this script you have to  download and install rsSharePoint.msi and configure SSRS for SharePoint 2013 from SQL Server installation centre.

# Create service application and service application proxy

$appPool = Get-SPServiceApplicationPool “Your App pool”

$serviceApp = New-SPRSServiceApplication “Your Service Application name” –ApplicationPool $appPool

$serviceAppProxy = New-SPRSServiceApplicationProxy –Name “Your Service App Proxy” –ServiceApplication $serviceApp

 

# Chose your service applications proxy group. Here I am taking the default group

Get-SPServiceApplicationProxyGroup –default | Add-SPServiceApplicationProxyGroupMember –Member $serviceAppProxy

 

# Grant application pool account access to the port 80 web application’s content database.

$webApp = Get-SPWebApplication “http://yoursiteCollectionurl”

$appPoolAccountName = $appPool.ProcessAccount.LookupName()

$webApp.GrantAccessToProcessIdentity($appPoolAccountName)

No comments:

Post a Comment