Posts

Showing posts from January, 2016

Workflow Manager Architecture SharePoint 2013

Image
Hi There, There are a lot of material to guide you how to install Workflow Manager with SharePoint 2013. I'll try to cover the points mentioned below in few words only, 1. Where to install Workflow Manager in SharePoint 2013 farm? 2. Do i need to install Workflow Manager on all SharePoint servers in the farm? 3. Do i need to install Workflow Manager on WFE's too in my farm? 4. Minimum which version of Workflow Manager is stable till today? (24-Jan-2016) 5. What is the sequence of installing Workflow Manager in SharePoint farm? My SharePoint architecture is like below. 2 WFE, 2 APP and 2 DB servers with failover. 1. Where to install Workflow Manager in SharePoint 2013 farm? Well its totally vary according to your architecture and need. In my case first of all i installed it on my APP1 server and tested the workflows which went fine. However when i tested the same from WFE's it threw me error of file not found. Simply it was pointing

SharePoint: The EXECUTE permission was denied on the object 'xp_sqlagent_notify

Image
Hi There, I was working with SharePoint SSRS and the reports were working fine. However when i click "View Report History" it gave me the below error. Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerStorageException: An error occurred within the report server database.  This may be due to a connection failure, timeout or low disk condition within the database. ---> System.Data.SqlClient.SqlException: The EXECUTE permission was denied on the object 'xp_sqlagent_notify', database 'mssqlsystemresource', schema 'sys'.     I found an answer here  but i was looking for some systematic way than running SQL Server queries. So i found a solution here which worked for me. So the solution is: 1. Open SharePoint Central Administration >  Application Management >  Manage Service Applications 2. Click on your SQL Server Reporting Services Service Application 3. Click on “Provision Subscriptions and Alerts” link 4

FIM Groups Missing SharePoint UPS (User Profile Service)

Image
Hi There, Note: This article applies on SharePoint 2010, SharePoint 2013. Its a brand new server with Windows Server 2012 R2 and SharePoint 2013 with October 2015 CU installed on it. I created the User Profile Service Application and as usual (from past experiences) it didn't start on first attempt and stuck on starting or sometimes User Profile Service stopped after being in Starting state for few minuets. Strange....! But that's another side of UPS issue. I read many articles including the best ones  Harber1  and Harber2 . These articles are in very much detail and helps you to fix the UPS Stuck problem. However my problem was, the below FIM Security groups were not present in Local Users and Group s for User Profile Service Application . FIMSyncBrowse FIMSyncJoiners FIMSyncOperators FIMSyncPasswordSet In most of the posts on internet regarding this issue (like this ) its stated that to check the FIM groups and many people also commented the sa