Wednesday, May 25, 2016

SharePoint 2013/2010 SSRS Installation

SSRS installation step by step in SharePoint Farm,,

Follow this blog,
https://msdn.microsoft.com/en-us/library/aa905871(v=sql.120).aspx


http://rajeshagadi.blogspot.com/2013/07/installing-reporting-services-in.html

you need license for SQL Server to install SSRS.

where to install SSRS in sp farm?
answer: you can install SSRS on all web front end server of farm which is enough to make it.
reference blog: https://msdn.microsoft.com/en-us/library/aa905871(v=sql.120).aspx

Monday, May 23, 2016

SharePoint Timer Service failed for Email

Error:
Access denied when deploying a timer Job or activating a feature from SharePoint 2010 content web application

Solution:

-You need to run following script using powershell

-make below script in ps1 file,

function Set-RemoteAdministratorAccessDenied-False()
{
    [System.Reflection.Assembly]::LoadWithPartialName("Microsoft.SharePoint") > $null
    [System.Reflection.Assembly]::LoadWithPartialName("Microsoft.SharePoint.Administration") > $null

 
    $contentService = [Microsoft.SharePoint.Administration.SPWebService]::ContentService
 
    $contentService.RemoteAdministratorAccessDenied = $false
   $contentService.Update()        
}

Set-RemoteAdministratorAccessDenied-False


then run using powershell and reset IIS as seen below










That's all!






Tuesday, May 3, 2016

SSRS SharePoint Integrated Mode- SharePoint license Question

Question:
Do you need a SharePoint 2010 server license for the DB in order to install sharepoint components needed by SSRS SharePoint Integrated mode?

Answer:

You need a license to cover SharePoint Server(Standard, enterprise) as well as SQL License to cover SSRS.

Reference site:

http://whitepages.unlimitedviz.com/2010/05/installation-considerations-for-reporting-services-in-sharepoint-integrated-mode/


Thanks,