Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

SQL Server Reporting Services - Error Creating Datasource

Posted on 2009-05-08
5
Medium Priority
?
2,388 Views
Last Modified: 2012-05-06
I'm getting the following error in the Report Viewer when trying to access the Reporting Services Report parameters - but don't know why.  I have Windows Integrated authority (no anonymous allowed) on my report manager web site.


Process

information:
    Process ID: 2840
    Process name: w3wp.exe
    Account name: NT

AUTHORITY\NETWORK SERVICE
 
Exception information:
    Exception type: SoapException
   
Exception message: An attempt was made to set credentials for a data source 'FSCDTA'
associated with the report.  Report data source settings are specified in a way that
prevents credentials from being submitted to the report server. ---> An attempt was made
to set credentials for a data source 'FSCDTA' associated with the report.  Report data
source settings are specified in a way that prevents credentials from being submitted to
FLATIRONCORP\userxxx
    Is authenticated: True
    Authentication Type: NTLM
    Thread

account name: NT AUTHORITY\NETWORK SERVICE

Thread account name: NT AUTHORITY\NETWORK SERVICE
    Is impersonating: False
    Stack

trace:    at System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse
(SoapClientMessage message, WebResponse response, Stream responseStream, Boolean
asyncCall)
   at System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String methodName,

Object[] parameters)
   at ReportService.ReportingService2005.GetReportParameters(String Report, String
HistoryID, Boolean ForRendering, ParameterValue[] Values, DataSourceCredentials[]
Credentials) in c:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET

c:\Inetpub\wwwroot\ReportCenter\BatchReport.aspx.cs:line 28
   at System.Web.Util.CalliHelper.EventArgFunctionCaller(IntPtr fp, Object o, Object t,

EventArgs e)
   at System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Object sender, EventArgs e)
   at System.Web.UI.Control.OnLoad(EventArgs e)
   at System.Web.UI.Control.LoadRecursive()
   at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint,
Boolean includeStagesAfterAsyncPoint)

Any help on this would be greatly appreciated.  I'm guessing it's some type of configuration issue with the way I setup my Reporiting Services.
 
 
0
Comment
Question by:coecho
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
5 Comments
 
LVL 27

Expert Comment

by:Chris Luttrell
ID: 24340653
--"I have Windows Integrated authority (no anonymous allowed) on my report manager web site."
Also check the ReportServer web site, that is what ReportViewer uses to interact with SSRS.  I found a link with a similar error messae that led to a similar conclusion.  Their site was MSCRM but it was still SSRS Data Connector issue.
http://www.eggheadcafe.com/software/aspnet/32593704/ssrs-data-connector-error.aspx
0
 

Author Comment

by:coecho
ID: 24340940
I checked - and it's not set on any of the IIS sites....Also, this is only happening for a new datasource that one of the users just setup.... it's working fine for the other reporting services data source.  

Any ideas on what may be causing this on the Report Services Data Source?  

thanks -
0
 
LVL 27

Accepted Solution

by:
Chris Luttrell earned 1500 total points
ID: 24341169
ah, new datasource.  I have tried to "Create" this error on my box but can't.  Can you verify the datasource settings and connection settings.  Have they messed with some of these and caused the problem.  I just can't find the proper combo to get that error.  Look at the Advanced properties of connecton properties also.  Usually if you put in good properties and "Test Connection" then things will just work.
SSRS2005-Shared-Data-Source-1.png
SSRS2005-Shared-Data-Source-2.png
0
 

Author Comment

by:coecho
ID: 24364881
The datasource seems okay - but now it looks as though there is something wrong with the actual report.  This "Payroll" report was added and was pointed to a "FSCDSN".  But - when I look at the properties of the report itself - the name of the datasource is "FSCDTA" and the "Windows Integrated Authority" (the option I need to use) - is grayed out.  And - here is the error message I'm getting when I try to "get" the Report parameters via the Report Web Service.  Again - it's referencing the wrong datasource? Any ideas on what is setup wrong on this report?

---------------------------------- Error Message in Debug Mode ----------------------

An attempt was made to set credentials for a data source 'FSCDTA' associated with the report.  Report data source settings are specified in a way that prevents credentials from being submitted to the report server.

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Web.Services.Protocols.SoapException: An attempt was made to set credentials for a data source 'FSCDTA' associated with the report.  Report data source settings are specified in a way that prevents credentials from being submitted to the report server.

Source Error:

Line 1502:        [return: System.Xml.Serialization.XmlArrayAttribute("Parameters")]
Line 1503:        public ReportParameter[] GetReportParameters(string Report, string HistoryID, bool ForRendering, ParameterValue[] Values, DataSourceCredentials[] Credentials) {
Line 1504:            object[] results = this.Invoke("GetReportParameters", new object[] {
Line 1505:                        Report,
Line 1506:                        HistoryID,

Source File: c:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET Files\reportscheduleportal\3f360b7c\b9b80bf6\App_WebReferences.jghfprge.0.cs    Line: 1504

Stack Trace:
[SoapException: An attempt was made to set credentials for a data source 'FSCDTA' associated with the report.  Report data source settings are specified in a way that prevents credentials from being submitted to the report server.]

   System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage message, WebResponse response, Stream responseStream, Boolean asyncCall) +1547
   System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String methodName, Object[] parameters) +205
   ReportService.ReportingService2005.GetReportParameters(String Report, String HistoryID, Boolean ForRendering, ParameterValue[] Values, DataSourceCredentials[] Credentials) in c:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET Files\reportscheduleportal\3f360b7c\b9b80bf6\App_WebReferences.jghfprge.0.cs:1504
   BatchReport.LoadPageValues() in c:\Documents and Settings\lhein\My Documents\Visual Studio 2005\Projects\ReportScheduling\ReportSchedulePortal\BatchReport.aspx.cs:72
   BatchReport.Page_Load(Object sender, EventArgs e) in c:\Documents and Settings\lhein\My Documents\Visual Studio 2005\Projects\ReportScheduling\ReportSchedulePortal\BatchReport.aspx.cs:28
   System.Web.Util.CalliHelper.EventArgFunctionCaller(IntPtr fp, Object o, Object t, EventArgs e) +13
   System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Object sender, EventArgs e) +45
   System.Web.UI.Control.OnLoad(EventArgs e) +80
   System.Web.UI.Control.LoadRecursive() +49
   System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +3743


Payroll-Report-Screen.doc
0
 

Author Closing Comment

by:coecho
ID: 31579643
Still can only connect using "prompt for username and password"  insteadof Integrated Authority.  Believe the user setup the data source incorrectlyl;is pointing to an invalid DB which do not have valid permissions set.
0

Featured Post

Veeam Disaster Recovery in Microsoft Azure

Veeam PN for Microsoft Azure is a FREE solution designed to simplify and automate the setup of a DR site in Microsoft Azure using lightweight software-defined networking. It reduces the complexity of VPN deployments and is designed for businesses of ALL sizes.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Introduction Earlier I wrote an article about the new lookup functions (http://www.experts-exchange.com/A_3433.html) that ship with SQL Server 2008 R2.  In this article I’m going to show you another new feature of SSRS 2008 R2, this time in the vis…
This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…
Have you created a query with information for a calendar? ... and then, abra-cadabra, the calendar is done?! I am going to show you how to make that happen. Visualize your data!  ... really see it To use the code to create a calendar from a q…

722 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question