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

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!

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,

User profile service stuck in stopping/starting SharePoint 2010

follow below steps to fix stuck service,

1. run this on powershell command or command prompt,
 stsadm -o enumservices > c:services.txt

you will get all services in file and check user profile service tag in it as  following,


<Service>
    <Type>Microsoft.Office.Server.Administration.UserProfileService, Microsoft.Office.Server.UserProfiles, Version=14.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c</Type>
    <Name />
    <DisplayName>User Profile Service</DisplayName>
    <Status>Unprovisioning</Status>
  </Service>

2. run using powershell command for user profile service,

  stsadm -o provisionservice -action stop -servicetype “Microsoft.Office.Server.Administration.UserProfileService, Microsoft.Office.Server.UserProfiles, Version=14.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c” -servicename

- you will get "operation completed successfully" message.

- Restart IIS server.

- You can do same thing for USER profile synchronization service to stop it if it stuck in starting/stopping.

- run following for USER PROFILE Synchronization service,
- you can find tag in file,

<Service>
    <Type>Microsoft.Office.Server.Administration.ProfileSynchronizationService, Microsoft.Office.Server.UserProfiles, Version=14.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c</Type>
    <Name>FIMSynchronizationService</Name>
    <DisplayName>User Profile Synchronization Service</DisplayName>
    <Status>Disabled</Status>
  </Service>

- run using powershell command,

stsadm -o provisionservice -action stop -servicetype “Microsoft.Office.Server.Administration.UserProfileService, Microsoft.Office.Server.UserProfiles, Version=14.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c” -servicename FIMSynchronizationService

- you will get completed successfully message.

- Restart IIS.

install dll to gac using command prompt

xcopy "D:\source folder\dllname.dll" "C:\Windows\assembly\" /y /e

Building Single Page Applications (SPA) with AngularJS and SharePoint 2013

You can learn most favorite way to create Single Page Application using AngularJS using follwowling links,

part:1

http://www.sathishtk.com/blog/post/2014/06/23/building-single-page-applications-spa-with-angularjs-and-sharepoint-2013-part-i.aspx

part: 2

http://sathishtk.com/blog/post/2014/06/25/building-single-page-applications-spa-with-angularjs-and-sharepoint-2013-part-ii.aspx

Part: 3

http://sathishtk.com/blog/post/2014/06/27/building-single-page-applications-spa-with-angularjs-and-sharepoint-2013-part-iii.aspx

SharePoint Timer service is stopping - SharePoint 2013 /2010

Error:

Timer service is stopping every weekend. we have been using SP farm account which has all administrative access though timer service is stopping every weekend.

start type is selected automatic but it does not make any sense as well.

Causes:

-Couple of reasons are being come up while digging this issue as following: 

After checking system event viewer, found following error which is occurring often,

"Cannot connect to SQL Server. DSQL not found. Additional error information from SQL Server is included below.

Connection Timeout Expired.  The timeout period elapsed while attempting to consume the pre-login handshake acknowledgement.  This could be because the pre-login handshake failed or the server was unable to respond back in time.  The duration spent while attempting to connect to this server was - [Pre-Login] initialization=2; handshake=14985;"

Suggestions to Check to fix this issues are:

- Friday evening there's maintenance jobs running which are bringing down the SQL environment. Check server backup schedules, SQL DB backup schedules, full crawl times and SAN backup times.

- only one server(in my case) which is being served as web front end and apps server for dev environment and it has only 12 GB RAM. 

Solution:

-it was database back up schedule which caused this issue. 

- if the resources (disk, CPU, or network) consumed by performing that backup are so high, it is possible that the SQL Server isn't able to respond in time for SharePoint's requests.

-we did backup schedule on other day and checked whether it generates error or not and we got same error.

- end of day, after adding memory to RAM of Sql server, it solved the issue and no more timer service is breaking. it is running without error or stopped.
- That's all!!

SharePoint 2010 Cumulative Updates Error: Some farm products and patches were not detected

Error: 
I got error while running SharePoint Products configuration wizard after deploying Feb 2016 CU for SharePoint 2010 servers as following,

Solution:

 1. run Powershell command using sp admin account
2. then run Get-SPProduct -Local
3. (Get-SPServer $env:ComputerName).NeedsUpgrade
4. confirm that you get true as returned at last

5. run SharePoint Products Configuration wizard and it will run be fine.

That's all.

Error when doing site search after 2013 upgrade

I got following error while searching on home page after migration from sharepoint 2010 to sharepoint 2013,
Error:

Unable to display this Web Part. To troubleshoot the problem, open this Web page in a Microsoft SharePoint Foundation-compatible HTML editor such as Microsoft SharePoint Designer. If the problem persists, contact your Web server administrator.

Correlation ID:6474799c-e8bf-80ef-0089-f1547f35a6db

Unable to display this Web Part. To troubleshoot the problem, open this Web page in a Microsoft SharePoint Foundation-compatible HTML editor such as Microsoft SharePoint Designer. If the problem persists, contact your Web server administrator.

I found in ULS log,

Error while executing web part: System.Xml.Xsl.XslLoadException: XSLT compile error. An error occurred at (0,0). ---> System.Xml.XmlException: Root element is missing. at System.Xml.XmlTextReaderImpl.ThrowWithoutLineInfo(String res) at System.Xml.XmlTextReaderImpl.ParseDocumentContent() at System.Xml.Xsl.Xslt.XsltInput.ReadNextSibling() at System.Xml.Xsl.Xslt.XsltInput.FindStylesheetElement() at System.Xml.Xsl.Xslt.XsltLoader.LoadDocument() at System.Xml.Xsl.Xslt.XsltLoader.LoadStylesheet(XmlReader reader, Boolean include) - -- End of inner exception stack trace ---

at System.Xml.Xsl.Xslt.XsltLoader.LoadStylesheet(XmlReader reader, Boolean include) at System.Xml.Xsl.Xslt.XsltLoader.Load(Compiler compiler, Object stylesheet, XmlResolver xmlResolver) at System.Xml.Xsl.Xslt.Compiler.Compile(Object stylesheet, XmlResolver xmlResolver, QilExpression& qil) at System.Xml.Xsl.XslCompiledTransform.LoadInternal(Object stylesheet, XsltSettings settings, XmlResolver stylesheetResolver) at Microsoft.SharePoint.WebPartPages.DataFormWebPart.LoadXslCompiledTransform(WSSXmlUrlResolver someXmlResolver) at Microsoft.SharePoint.WebPartPages.DataFormWebPart.GetXslCompiledTransform() at Microsoft.SharePoint.WebPartPages.DataFormWebPart.PrepareAndPerformTransform(Boolean bDeferExecuteTransform)

Solution:

run follwoing command using PS,

$ssa = Get-SPEnterpriseSearchServiceApplication "My Search Service App"

$ssa.Status = "Disabled"

$ssa.Update()

$ssa.Provision()

refresh page or wait for next day sometimes it takes much time to reflect solution.

Cheers.....

installation of Azure AD Connect Azure

I followed this blog and successfully able to synchronize  users from local ad to azure ad.
make sure username and password used to synchronize here while configuring it,

https://azure.microsoft.com/en-us/documentation/articles/active-directory-aadconnect-get-started-custom/

Cheers...