Saturday, December 20, 2014

An error has occurred during report processing. (rsProcessingAborted) Cannot impersonate user for data source 'DataSource1'. (rsErrorImpersonatingUser) This data source is configured to use Windows integrated security. Windows integrated security is either disabled for this report server or your report server is using Trusted Account mode. (rsWindowsIntegratedSecurityDisabled)

We were getting above error when trying to open the reports in Sharepoint where everythign seemed to be configured correctly
SP 2010 integration with Report server in Sharepoint Mode, Authentication was correct, reports were correct as was working fine in other environment and Sql server report server was showing integrated secuirty enabled.

Here is the solution that worked in our case.
1) This is related to permission issue.
Open IIS manager, click on the site, click authentication and make sure you have the Windows and ASP.Net impersonation enabled on the site.Try to enabled Anonymous access for few mins and then do the iisreset. Once you do that and after few min, you will see that reports started opening without any errors. Once you conform its working, stop the Anonymous and restart the IIS again.
 Once you do that, you will see site reports opening without any issue.

Sometime it is related to access to a folder or some settings that needs to be enabled but hard to find where is that the reports are looking for. Hope it helps people struglling with this isse as i was .:)

The request failed with HTTP status 401: Unauthorized in Sharepoint logs

Below is one of the solution suggested by microsoft in this types of issue
1) Disable Loopback check on SSRS server (Method 2)
  1. Click Start, click Run, type regedit, and then click OK.
  2. In Registry Editor, locate and then click the following registry key:

    HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\Lsa
  3. Right-click Lsa, point to New, and then click DWORD Value.
  4. Type DisableLoopbackCheck, and then press ENTER.
  5. Right-click DisableLoopbackCheck, and then click Modify.
  6. In the Value data box, type 1, and then click OK.
  7. Quit Registry Editor, and then restart your computer.
 
2) The next thing you want to try to check the authentication level on your IIS. This is related to permission issue. We had the simlar problem in SSRS reporting not opening a custom reporting page containing report viewer webpart in a https site
 Open IIS manager, click on the site, click authentication and make sure you have the Windows and ASP.Net impersonation enabled on the site. Check the same for the Default site if you are using it.

How to enable Incoming email on the list/Library in Sharepoint

Below are the steps that we need to perform to enable a library to receive incoming emails.

1) SMTP service has to be installed and enabled on the SP WFE server. This can be added from Windows Server manager under Features and add the SMTP feahttps://www.blogger.com/blogger.g?blogID=122518409722023608#editor/target=post;postID=695350418594854018ture
2) Next step is to open the IIS 6.0 amangement console and make sure that SMTP virtual server is up and running. If you want to ahve your own name, stop the existing one and create a new one with a good name and run it.
3) Now you open the windows serverices and start the SMTP service in WFE server and make sure it is set on Automatic.
4) By default the port assigned to SMTP service is 25. so make sure you have port open and is not blocked to enable the incoming email service.
5) Now open Central admin, configure Incoming email settings,
Select Yes to “Enable site on this server to receive e-mail”
Select “Automatic” for Setting mode or Advanced (Put the system drive inetpub directory for drop folder)
Select “Yes” to use the SharePoint Directory Management Service to create distributions groups and contacts.
Enter your Active Directory container details, i.e. the Organizational Unit container that we created specifically for our SharePoint 2010 contacts.
Ensure that your SMTP server details are correct, this should be the fully qualified domain name of your SMTP service that was installed on your SharePoint Server.
6) Make sure following accounts are added on drop folder with below permissions
WSS_Admin_WPG – Full Control and
WSS_WPG – Read & Execute / List folder Contents / Read
7) Also make sure that application pool account has read permission on the Drop folder as well to carry email over to the site level.
8)  Now open the list\library and
Click on Incoming e-mail settings.
Select “Yes” to allow this document library to receive e-mail.

Thats it. now try sending email to the address and you will see email in the library

Below is a very good link with screenshots that can help
http://sharepointgeorge.com/2010/configuring-incoming-email-sharepoint-2010/

Powershell throwing error the execution of scripts is disabled on this system.

This is the message we get it when try to run any powershell script on the SP server where execution olicy is disabled. It is based on tht 64 and 32 bit tyoe. We have to ensure that the execution policy is enabled on both types of it.
Run the following command:-
:- Set-ExecutionPolicy RemoteSigned
Once ran, you can verify using following command
:- get-executionpolicy