You’re offline. This is a read only version of the page.
Hi,
I have installed Sharepoint Foundation 2010, configured it to integrate with Reporting Services, and I am unable to deploy the Reports and KPI's using the SSRS wizard for GP 2010.
I have SQL Server 2008 Standard, and the report server database is created in Sharepoint Integrated mode. I have (I think) all the configurations correct but for some reason I get the following error when using hte SSRS wizard for GP2010:
"Client found response content type of 'text/html; charset=utf-8', but expected 'text/xml'. The request failed with the following error message:
<RSError>xmlns="http://www.microsoft.com/sql/reportingservices"><MoreInformation><Message>An unknown error occured with the Reporting Services endpoint on ship SharePoint site. Contact the SharePoint site administrator for help.</Message></MoreInformation></RSError>"
I am trying to deploy the reports to http://servername/Reports/ReportsLibrary (the example in the wizard). Do I have the wrong address?
Does my Report Server database have to be on a SQL Server 2008 R2 installation instead of the regular SQL 2008 standard?
Any help would be greatly appreciated
thanks,
Aaron
*This post is locked for comments
Rob,
You're first question about the report library URL got me thinking. I was never entering the EXACT location of the reports library. When I was entering http://servername/reports, that was only to the site collection not the actual document library. I started the wizard again, this time entering http://servername/reports/reportslibrary (because that's what I called the document library from the example in the SRS wizard). I rec'd the timeout due to the length because I re-installed RS and sharepoint so I modified the web.config again and it all worked. This whole time I was thinking that it had to be something simple. I want to thank you for all of your help with getting this thing configured properly so that I could deploy the SRS reports and KPI's.
Regards,
Aaron
Aaron,
What are you entering for the destination report library? I'm a little confused because you mentioned earlier that items started to deploy, but due to a timeout, they stopped. After you modified the timeout value, I would have expected the deployment to continue. What's different?
Do you have access to create a simple console application and check the permissions you have to the document library? You'd need to create a web reference in VS and do something like the following in code. I'd like to see what you get for returned permissions (should be something like "Create Model", Create data source", etc.) If this isn't an option, I'd recommend opening a case with Microsoft support.
static void Main(string[] args){
string[] permissions = new string[100];<WebReference>.
ReportingService2006 proxy = new <WebReference>.ReportingService2006();proxy.UseDefaultCredentials = true;permissions = proxy.GetPermissions(
@"URL you're entering into deployment wizard");for (int i = 0; i < permissions.Length; i++){
Console.WriteLine(permissions[i].ToString());}
}
Thanks
Rob
Rob,
The Report Server Integration Feautre is listed and is activated for the site collection.
Thanks,
Aaron
Aaron,
Could you check if the Report Server Integration Feature is activated on the site collection where you're trying to deploy reports? (Go to root site > Site Actions > Site Settings > Site collection features > Verify "Report Server Integration Feature" is listed and activated.) If it isn't listed, you'll need to reinstall the SharePoint 2010 Report Services Integration.
Thanks
Rob
Rob,
I am using the NTAdmin account. He is a domain admin, who has been added to the local administrator's account for the server.
Aaron
Aaron,
Who are you running the SRS Deployment Wizard as?
Thanks
Rob
Rob,
UAC is turned off. Just for kicks though, I tried "Run as Administrator", and nothing changed.
Frankly, I got ticked off with the whole thing and un-installed SharePoint. When I re-installed it, I selected "Complete" and set everything up manually on the instance of SQL server that is already installed.
As far as permissions go:
SQL Server RS has a domain admin account called NTAdmin as the service account. The same account is used to connect to the RS databases
In Sharepoint, I have a domain account called wss_user (per the documentation) that is running Sharepoint. This account, along with BUILTIN\Administrator and NTadmin are setup as administrators on the sites, collections, and document libraries within Sharepoint. The farm administrators group also consists of these same three accounts.
wss_user shows up as the service account for all the services in SharePoint
The Sharepoing integration page has been configured for http://servername:8080/ReportServer. it has been configured to use Windows authentication under the account NTAdmin.
Does this combination of users and settings make sense or have I missed something in the documentation?
Thanks,
Aaron
Aaron,
No problem. Let's get this figured out! It definitely looks like a permission issue. Is UAC on? If yes, are you running the wizard as an administrator? What did you change to get around the 401 Unauthorized error?
Thanks
Rob
Rob, I was able to get the wierd message of 401 UNAUTHORIZED to go away, however, now there is an error message from the reporting services wizard that says:
"You do not have security access to deploy reports to the location entered"
I have verified that the user account has access to both the site, collection, and document library that I have created. In answer to your previous post:
1. user is a reporting services admin
2. user is a sharpoing admin/site collection admin
3. RS has been configured through Central Admin. URL and db access granted. What do you mean by server defaults? I am using a named instance of SQL and have sharepoint dbs on that.
4. NTLM
5. nothing in the event log
6. No errors in the RS log files
7. Bunch of stuff in this log, but nothing jumps out as an error. It looks like it's just documenting what is happening with sharepoing. Looked at the end of the log right after the error from the wizard was thrown and didn't see anything relating to that.
I hope I'm not being a pain. Thanks for all of your help.
Aaron
Aaron,
Here are some questions/comments regarding this.
Thanks
Rob
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,253
Super User 2024 Season 2
#2
Martin Dráb
230,188
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (