Problem Solve Report deployment error in SharePoint Integration mode

By -
Today post related to SSRS Access Denied Problem.

I have a two system attached in a farm.
  • SharePoint Site
  • SharePoint SSRS (Reporting)
In SharePoint Site SSO already implemented. I need to move my SharePoint Content database as well as report database server database to new Server.

I have a updated SSRS Project source code so I need not to backup the report database. So took the back up of SharePoint content database and move it to another system. I installed new SharePoint Server in one machine and SharePoint SSRS other machine and add both server to farm. I attached the backup database with new application guess :) what.. it was working fine.

But the problem comes :( when I was going to deploy reports. It was giving me an access denied. When I open my old reports going to SharePoint Site and open report library still It was giving me an error because the reports only available in SharePoint content database not in Report server database.

Also my old database had not accessed to the Reporting Services account user.First I gave access to my SharePoint content database to Report Service account user.Change the authentication claims to windows.Change the site collection username. I added the Report service account user to built in administrator groups.Delete old reports from my report libraries.

I did the following Points to get things worked for me.

Problem to Deploy reports with SQL server business intelligence.
  • Make sure you are using http URL rather than https.
  • SSRS Service Account is a member of Administrator group.
  • SSRS Service Account having an access to the SharePoint Site.
  • SSRS Service Account having a access to the SharePoint Content Database as well as the SharePoint Reporting Service URL (Incase to take a backup your site collection and moving to another server)
  • Change your authentication mode to window authentication while deploying the report if you set the claim based then the current user will you accessible by the visual studio it will give you error. After changing the Authentication mode to claim to window change the site collection administrator (because claim based user attached the claim with it).
  • SharePoint Site URL that is going to use in deployment than it Configured alternate access mapping.
  • Still getting the error then you need to see the Permission because both SharePoint Service account as well as the SSRS Service account having a access to deploy the report as well as render the report in the SharePoint Content database.

Common Errors  

  1. "An unexpected error occurred while connecting to the report server. Verify that the report server is available and configured for SharePoint integrated mode"
  2. "Server was unable to process request. ---> The request failed with HTTP status 401: Unauthorized."

One Solution : Disable Loopback Check 


How to Change the DisableLoopbackCheck Registry Key


  1. Open the Registry Editor (regedit).
  2. Caution: Incorrectly editing the registry can severely damage your system. Before making changes to the registry, you should back up any valued data on the computer.
  3. Open the following key: HKLM\System\CurrentControlSet\Control\Lsa.
  4. Create a new DWORD value called DisableLoopbackCheck.
  5. Set the value to 1.
  6. Reboot the server. 
  7. Note: This is required for the change to take effect.
  8. If this resolves the issue, there is a more secure way of making this change.

New-ItemProperty HKLM:\System\CurrentControlSet\Control\Lsa -Name "DisableLoopbackCheck" -Value "1" -PropertyType dword


Please check the Microsoft link to fix the problem http://msdn.microsoft.com/en-us/library/ee384252(v=sql.100).aspx

Comments

Post a Comment

Popular posts from this blog

SharePoint RPC Protocols Examples Using OWSSVR.DLL

By -
Image
What is SharePoint RPC Protocols? Part 1 This reference includes information about the methods and usage of SharePoint Foundation Remote Procedure Call (RPC) protocol. This protocol can be used in Win32-based applications or in ASPX applications to make HTTP POST requests to the server. Methods in this protocol that do not modify the contents of the database can also be used in URL protocol to make HTTP GET requests. Definition taken from http://msdn.microsoft.com/en-us/library/ms448359.aspx You will find the OWSSVR.DLL in SharePoint 2010 Server Physical Path: C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\14\ISAPI and MOSS C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\12\ISAPI OWSSVR.DLL List of commands DialogView  Display ExportList GetProjSchema GetUsageBlob HitCounter RenderView To read more about the OWSSVR.DLL command Please read the URL Protocol from Microsoft Blog having a URL http://msdn.microsoft.com/en-us/
Read more

Send Email using SharePoint Rest API

By -
We have a requirement to send email vai SharePoint Rest API. We dig and find the below solution to send email using SharePoint API. Point Must be remember End point " /_api/SP.Utilities.Utility.SendEmail " end point to send email.  In JSON __metadata we used the type " SP.Utilities.EmailProperties ". The User / Group must have a read permission for particular site. where we placed this site code. JS Dependency  JQuery Code URL:  https://gist.github.com/BasantPandey/05189832546f2c6cc0bd008fcfec3264#file-sharepointsendemail-js Code  var Email = function (){ // Email Either email groupname or email address var from = ' abc.yahoo.com ' , to = ' abc.yahoo.com ' , cc = ' abc.yahoo.com ' , subject = ' My Email Subject ' ; this . options = this . options || {}; this . options [ ' fromEmail ' ] = this . options [ ' fromEmail ' ] || {}; this . options [ ' toEmail &
Read more

Query suggestions in SP 2013 Using Rest API (/_api/search/suggest)

By -
Image
SharePoint Query suggestions: In this post I am going to share with you code snippets to implement the query suggestion in custom text box. Below are the dependency files  1. Jquery UI : http://code.jquery.com/ui/1.10.0/jquery-ui.js 2. Jquery AutoComplete CSS: http://code.jquery.com/ui/1.10.0/themes/base/jquery-ui.css http://code.jquery.com/ui/1.10.0/themes/base/jquery.ui.autocomplete.css 3. JQuery: http://code.jquery.com/jquery-1.8.3.js Query Suggestion Parameter: Here is the post http://blogs.msdn.com/b/nadeemis/archive/2012/08/24/sharepoint-2013-search-rest-api.aspx that specified the detail query suggestions parameter list. Implementation: I have two vertical examples. 1. People Vertical 2. Everything Vertical I wanted to display the query suggestions on TeamSite pages although my search is configured in one of our serach center, so when user search for a particular term and it contains in the search query completion list t
Read more