You are using SQL Server Business Intelligence Development Studio to deploy a report project to a SQL Server Reporting Server in SharePoint Integrated Mode
You are attempting to use the SharePoint Server address with "/reportserver/" or the Report Library address.
Note: BIDS asks for this format which may not work: "http://<servername>/reportserver"
Issue
You repeatedly receive "Reporting Services Login" authentication prompts when attempting to deploy and eventually fail to deploy
Resolution
Use "http://servername/" or "/_layouts/ReportServer" in the TargetServerURL path in the project properties
Ex: "http://intranet.company.com/" or "http://intranet.company.com/_layouts/ReportServer"
If you use the server name, make sure to include the trailing forward slash
Use the Report Library/Folder location in the Target*****Folder settings
Note: You can use folder paths if your library contains folders.
Ex: ".../Reports/Folder1/Folder2"
Here's an example of the settings (Right Click the project and select properties)
Hello Freeman, I have not yet succeeded in using ssrs 2008 because i get a login prompt to which i dont have the input. i am an administrator on my laptop, windows 7 ultimate, my account was added as sqlserver administrator at installation, i am using local system account on all my services, please help. (All my reports build successfully but i havenot deployed them.) Andre
I have also discovered that my homepage is blank wiouth links to the content, properties and site settings, please help me figure out what i need to do to get it running.
Thanks for pointing me in the right direction ... finally got it to deploy with the following configuration ... /localhost/sites/AdvWorks/TheBICentre/Data%20Connections for the Target Data source folder .... /localhost/sites/AdvWorks/TheBICentre/ReportsLibrary for the Target report folder and http://localhost/ReportServer for the Target Server URL
I've tried your method but it still has not worked for me. I am able to upload the reports through the SharePoint interface but I cannot deploy them through Visual Studio. I am using SharePoint 2013 w/SSRS 2012. I also have Claims and Windows Authentication enabled. Here are my settings:
Web Application = https://client.test.com/ Site Collection = https://client.test.com/ Site = https://client.test.com/Client1/ Document Library = https://client.test.com/Client1/Reports/
Is there anything that I have entered incorrectly? In the SharePoint logs I see the "Access Denied" error with the request targeting "SPRequest.OpenWeb: UserPrincipalName=, AppPrincipalName= ,bstrUrl=https://client.test.com/Client1/ReportService2006.asmx"
Sorry for too late. But now we facing the same issue, is there anyone who respond on this. We are facing same error on log file: Is there anything that I have entered incorrectly? In the SharePoint logs I see the "Access Denied" error with the request targeting "SPRequest.OpenWeb: UserPrincipalName=, AppPrincipalName= ,bstrUrl=https://client.test.com/Client1/ReportService2006.asmx"
Motivation:
I am saved through Christ. I believe our creator developed everything in our universe (including time) and that the evidence for Intelligent Design is compelling. I believe based on historical evidence, personal experience, and reasoned faith. Gratitude and submission to this creator fuel my mission of altruism.
Posts
Hello Freeman, I have not yet succeeded in using ssrs 2008 because i get a login prompt to which i dont have the input.
ReplyDeletei am an administrator on my laptop, windows 7 ultimate, my account was added as sqlserver administrator at installation, i am using local system account on all my services, please help.
(All my reports build successfully but i havenot deployed them.)
Andre
I have also discovered that my homepage is blank wiouth links to the content, properties and site settings, please help me figure out what i need to do to get it running.
ReplyDeleteHi Andre,
DeleteYou may need to engage with a consultant. You can hire a SharePoint contractor through http://www.votematrix.com/ or you can try MS support.
Good luck!
Thanks for pointing me in the right direction ... finally got it to deploy with the following configuration ... /localhost/sites/AdvWorks/TheBICentre/Data%20Connections for the Target Data source folder .... /localhost/sites/AdvWorks/TheBICentre/ReportsLibrary for the Target report folder and http://localhost/ReportServer for the Target Server URL
ReplyDeleteHi Robert,
ReplyDeleteI've tried your method but it still has not worked for me. I am able to upload the reports through the SharePoint interface but I cannot deploy them through Visual Studio.
I am using SharePoint 2013 w/SSRS 2012. I also have Claims and Windows Authentication enabled. Here are my settings:
Web Application = https://client.test.com/
Site Collection = https://client.test.com/
Site = https://client.test.com/Client1/
Document Library = https://client.test.com/Client1/Reports/
TargetDatasetFolder = https://client.test.com/Client1/Reports/Datasets
TargetDataSourceFolder = https://client.test.com/Client1/Reports/DataSources
TargetReportFolder = https://client.test.com/Client1/Reports/Reports
TargetReportPartFolder = https://client.test.com/Client1/Reports/ReportParts
TargetServerUrl = https://client.test.com/Client1/
Is there anything that I have entered incorrectly? In the SharePoint logs I see the "Access Denied" error with the request targeting
"SPRequest.OpenWeb: UserPrincipalName=, AppPrincipalName= ,bstrUrl=https://client.test.com/Client1/ReportService2006.asmx"
did you make any progress on this?
DeleteSorry for too late.
DeleteBut now we facing the same issue, is there anyone who respond on this.
We are facing same error on log file:
Is there anything that I have entered incorrectly? In the SharePoint logs I see the "Access Denied" error with the request targeting
"SPRequest.OpenWeb: UserPrincipalName=, AppPrincipalName= ,bstrUrl=https://client.test.com/Client1/ReportService2006.asmx"
This comment has been removed by the author.
ReplyDelete