.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Register
 
Win Surprise Gifts!!!
Congratulations!!!


Top 5 Contributors of the Month
Easy Web
Imran Ghani
Post New Web Links

Prompted for network credentials via internet while accessing SSRS reports in SharePoint integrated

Posted By:      Posted Date: April 10, 2011    Points: 0   Category :C#
 
Hi

We have developed a SharePoint- FBA site and published it through ISA.  The site, among many features, displays SSRS reports through Performance Point Monitoring dashboards.  SSRS is using windows integrated authentication (Kerberos).  Through intranet, the reports are getting displayed without any issue, but, through internet, its getting prompted when we try to access the reports for the first time after logging into the site using FBA credentials.  When we enter valid domain credentials after being prompted, it starts displaying reports without any issues and never prompts again for that FBA session.

We have been trying to eliminate the prompt through internet, but couldn't do so. 

Has anyone experienced the same before?

Any help is appreciated.




View Complete Post


More Related Resource Links

Share Point integrated SSRS reports rendering when access from external site

  

Our client has a SharePoint (moss2007) site on Windows 2008, SQL2008 R2 Enterprise, and Reporting service is integrated with SharePoint

The authentication on the share point integration is set to windows, else the authentication for the SSAS datasource gives and error

The extranet zone ( forms) and intranet (Customer Forms) and default (Windows) zones are all access from inside the firewall and the reports render in each with no issues, as the datasources are configured to pass a sql username and password.

However, report rendering is a problem from the internet (external site), the following error is displayed:

 
An unexpected error occurred while connecting to the report server. Verify that the report server is avai

SSRS - Where are the Sharepoint Report Usage Reports provided by Microsoft

  

HI,

Microsoft provided 3 example reports for Sharepoint report usage. Does anyone know where they are located? I used them about 2 years ago.

Thanks.

John.

 


Schedule reports with integrated authentication SSRS 2008

  
Hi All,  Having an issue with SSRS 2008 at the moment, trying to setup subscriptions. Our system is configured so that any one of 10 users can login to the SSRS website using their windows domain account, and then launch report builder to design and save reports.  This all works very well, however, they have a problem when trying to setup subscriptions - the famous "Subscriptions cannot be created because the credentials used to run the report are not stored....." What the message says is true - the credentials are not stored as they are supplied by the user when they login to report builder. Is the /any/ workaround at all that doesn't involve storing the credentials?  It seems totally crazy that they cannot be prompted for them when setting up the subscription.  For this application its 100% essential to make the user provide their credentials when running reports, because they each see a filtered subset of the data in the report model (this is controlled DB side depeding on the login account), so their domain account needs to be passed to SQL server to enable this filtering to work.  If we saved their credentials then they would see all the data..and thats nasty. The only workaround I can come up with would be to create  a separate datasource for each user and upload a separate model, but thats really nasty to be hones

Setting Title on SSRS (SharePoint Integrated Mode) subscription.

  
I have some subscriptions in SSRS where the report goes directly to a Document Library on Sharepoint.  The subscription works fine, however, I would like to have the Title of the report be the current date that the report is run.  Is there a way to put a formula such as =[today] in the Title field of the File Options section on the Subscription properties?  I have tried this but either it is not possible or I am not using the correct syntax.  Thanks, Tim Olig

Sharepoint and SSRS Sharepoint integrated mode, any side effect ?

  
Hi, We planned to switch from native mode to sharepoint integrated mode our SQL Server Reporting Server. But it is a production server, so we liked to know if any side effect can happened on existing report and if it is possible to switch an existing database into sharepoint integrated mode ? Thanks, Mathieu Perrin.

Building SSRS reports based on SharePoint 2007 lists

  
Hi,   I'm building a SSRS report, and I want to get data out of a SharePoint 2007 list. The difficulty I'm facing is the following: The SharePoint server is behind an ISA Server, and is configured for Form-Based Authentication. Is there a way to keep the FBA and retreve information out of a SharePoint list with reporting services?   Kind Regards,  AVermaas    

SSRS 2008R2 - go back to parent report does not work sharepoint integrated mode

  
I'm currently using SharePoint Foundation 2010 with SQL Server 2008R2 with the SharePoint RS add-in. I have a report with a drilldown to another report.  I can drill down correctly to the other report.  But when I do the "go back to parent report" it will take me back to the parent report, but when I try to drilldown again to another report, I get the following error. "Message: Sys.WebForms.PageRequestManagerParserErrorException: The message received from the server could not be parsed. Common causes for this error are when the response is modified by calls to Response.Write(), response filters, HttpModules, or server trace is enabled. Details: Error parsing near ' <!DOCTYPE html PUB'. Line: 5 Char: 62099" When I run this report in VS 2008 or Report Builder 3, I have no problems drilling down and back and forth. I only have an issue when I deploy the report to SharePoint.  I have also accessed the RDL directly outside of a webpart page, but still get the same error. Wondering if anyone else is experiencing this issue?

Need the old "Browser" access in the new SharePoint Integrated with SSRS

  
0 down vote favorite Does anyone know of a way to add or remove items from the "Actions" menu within a report on SharePoint 2010 Integrated with SSRS 2008 R2? I would like to remove "Open with Report Builder" and add "Subscribe" to the Actions menu. I'm working with my SharePoint Server Admin who is at a loss also. I have found how to remove Report Builder from the server but the Admin doesn't want to do that since I am not his only customer. The "Subscribe" option seems to be driven from permissions but I'm not able to get it to show up for my read-only viewers. It shows up for me but I'm not going to give them admin rights. Basically, what I want is the "Browser" role from Report Manager: "May view folders, reports and subscribe to reports." They couldn't open in Report Builder. It seems so basic. I just want people to view reports and if they'd like, subscribe to them. Thank you

Users being prompted continuously for UN/PW when accessing SharePoint Intranet Site

  

From time to time, we have internal users who are continuously prompted to re-enter their network username and password when accessing any content or data on the SharePoint company intranet.  We use Acitve Directory authentication. Is this a network issue or something with SP? (We're using SP2007)


Looking for guidance: Integrated SharePoint SSRS migration and upgrade from 2007 to 2010

  

Our existing prod farm is MOSS 07 with an integrated SSRS instance using SQL Server 2008, both on Windows Server 2003 64bit boxes. SharePoint databases are on a different SQL Server 2008 server.

I have built a new SharePoint 2010 farm on Windows Server 2008 R2 boxes, using a single SQL Server 2008 R2 Enterprise server as the backend for both SharePoint databases and Reporting Services (installed in Integrated mode). We are going to be using the database-attach method of upgrading our SharePoint farm.

Is there any specific guidance out there on exactly how to migrate/upgrade Reporting Services in this scenario? I've read through some of the MSDN content (How To: Migrate a Reporting Services Installation) but nothing seems to deal specifically with doing this when in Integrated mode with SharePoint. Our business heavily relies on SSRS reports in SharePoint and also shared and custom report subscriptions via email.

We do have a dev SharePoint 2010 farm in a similar configuration that I can test migration/upgrade steps. Thanks.


SSRS Reports Not updating in Sharepoint 2007

  

Hello All,

I created some reports in SSRS 2008, The reports data source is a live transactional data source. The reports are to auto refresh every minute displaying any new info that  was put on to the system in the last minute. The auto refresh property on each report is set to 60 sec. to trigger the refreshing of the reports.

The problem: when i run the reports in the report manager the every thing works fine, the report runs, refreshes, and the figures are updated.

I am now displaying these reports in Sharepoint 2007 via the "report viewer" facilitated by the RSWebPart that i installed on the Sharepoint instance. 

The reports are displayed fine in the viewer, but my problem is that it does not auto refresh with the updated info.

I CANNOT FIGURE OUT HOW TO GET THIS TO HAPPEN, PLEASE ANY HELP WOULD BE APPRECIATED!!

I figure it is a caching issue but how to get around? HELP!


Unable to pass default network credentials from a .NET / SharePoint application to Web Services

  

Require some help in passing the authentication of a logged-in user to a web services (which is a wsdl file added as web reference to the application) from an ASP.NET application/ SharePoint 2010 portal. When the application calls the web service, the default network credentials need to be passed to the web service to get authenticated to use the data repository. This web service is used for searching a data repository depending on the logged in user's credentials and search query.

We have made necessary changes required in the applications like.

Necessary changes in web.config (like authentication mode to Windows, impersonation is made true). Install client certificates to the trusted location.

Enable IE 8.0 to use Integrated Windows authentication (Internet Explorer -->Tools-->Internet Options -->Advanced--> Security --> Enable Integrated Windows Authentication.

Unable to pass default network credentials from a .NET / SharePoint application to Web Services

  

Require some help in passing the authentication of a logged-in user to a web services (which is a wsdl file added as web reference to the application) from an ASP.NET application/ SharePoint 2010 portal. When the application calls the web service, the default network credentials need to be passed to the web service to get authenticated to use the data repository. This web service is used for searching a data repository depending on the logged in user's credentials and search query.

We have made necessary changes required in the applications like.

Necessary changes in web.config (like authentication mode to Windows, impersonation is made true). Install client certificates to the trusted location.

Enable IE 8.0 to use Integrated Windows authentication (Internet Explorer -->Tools-->Internet Options -->Advanced--> Security --> Enable Integrated Windows Authentication.

Even the web services have methods to get the windows network credentials. While trying the following code, to pass current credentials, default credentials is empty.

myProxy.Credentials = System.Net.CredentialCache.DefaultCredentials (Here it is a null value)

Application is using Windows Authentication | NTLM.

The following code works, if the authenticat

Authenticated, when deploying the reports(SSRS 2008) to a sharepoint site

  
I created reports in SSRS 2008 for a sharepoint list. But when I tried to deploy it to the report library I used to get an authentication pop-up box again and again. I used all the username and password. But no luck. Does any one knows how to overcome this situation.

Regarding the Subscription of SSRS reports from the Sharepoint Portal.

  

Hello,

         At present, I am having some SSRS reports hosted on share point portal and For one report, I am subscribing thorugh manage subscription by mentioning the dropdown values (The Selections which are required for the report) as parameters. So that, I am going get a mail for the report for the selection which I made from the report.

Now The Issue is, for every combination I should need to select the parameters and need to subscribe for that. Is it possible to mention all the selection crieteria at once and run it in one shot?

Can we write any backgroud job to complete all the selection criterias at once?

Please help me on this.

Thank you!!

Regards,

Pradeep.


Report Manager URL http:///Reports is not working in SharePoint Integrated Mode

  

Hello Friends,

I am ali, I am so confused why the Report manager URL(http://<servername>/Reports is not working in sharpoint integrated mode. 

In my local system

1. at the time of SQL Server 2008 R2 installation Reporting services enabled In Native mode.
2  In Reporting service config manager tool http://<serverName>/Reports URL is working in Native mode. Here i am able to create New Roles.
3. In Reporting service config tool When i create a new database in sharepoint integrated mode, the the Report Manager URL http://<ServerName>/Reports not working, gettig this error "This operation is not supported on a report server that is configured to run in SharePoint integrated mode. (rsOperationNotSupportedSharePointMode)"
4 . From both databases(In native mode and sharepointmode) the the webservice URL http://<servername>/ReportServer working fine.

Reporting Services Config manager :

Accessing Sharepoint 2010 root throught network drive

  

When I try to go to \\sp_domain\ I am presented with 2 network shares which I can't open afe15108-b347-4a9d-ba3a-1426636526d4-query-1  and afe15108-b347-4a9d-ba3a-1426636526d4-query-2.

If I navigate to \\sp_domain\site I get a list of libraries and sub sites as one would expect.

Does any one have any thoughts as to why I am unable to see list of sites and libraries at the root level?


Categories: 
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend