coecho
asked on
SQL Server Reporting Services - Error Creating Datasource
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.Protoc ols.SoapHt tpClientPr otocol.Rea dResponse
(SoapClientMessage message, WebResponse response, Stream responseStream, Boolean
asyncCall)
at System.Web.Services.Protoc ols.SoapHt tpClientPr otocol.Inv oke(String methodName,
Object[] parameters)
at ReportService.ReportingSer vice2005.G etReportPa rameters(S tring Report, String
HistoryID, Boolean ForRendering, ParameterValue[] Values, DataSourceCredentials[]
Credentials) in c:\WINDOWS\Microsoft.NET\F ramework\v 2.0.50727\ Temporary ASP.NET
c:\Inetpub\wwwroot\ReportC enter\Batc hReport.as px.cs:line 28
at System.Web.Util.CalliHelpe r.EventArg FunctionCa ller(IntPt r fp, Object o, Object t,
EventArgs e)
at System.Web.Util.CalliEvent HandlerDel egateProxy .Callback( Object sender, EventArgs e)
at System.Web.UI.Control.OnLo ad(EventAr gs e)
at System.Web.UI.Control.Load Recursive( )
at System.Web.UI.Page.Process RequestMai n(Boolean includeStagesBeforeAsyncPo int,
Boolean includeStagesAfterAsyncPoi nt)
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.
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.Protoc
(SoapClientMessage message, WebResponse response, Stream responseStream, Boolean
asyncCall)
at System.Web.Services.Protoc
Object[] parameters)
at ReportService.ReportingSer
HistoryID, Boolean ForRendering, ParameterValue[] Values, DataSourceCredentials[]
Credentials) in c:\WINDOWS\Microsoft.NET\F
c:\Inetpub\wwwroot\ReportC
at System.Web.Util.CalliHelpe
EventArgs e)
at System.Web.Util.CalliEvent
at System.Web.UI.Control.OnLo
at System.Web.UI.Control.Load
at System.Web.UI.Page.Process
Boolean includeStagesAfterAsyncPoi
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.
ASKER
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 -
Any ideas on what may be causing this on the Report Services Data Source?
thanks -
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
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.Protoc ols.SoapEx ception: 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.X mlArrayAtt ribute("Pa rameters") ]
Line 1503: public ReportParameter[] GetReportParameters(string Report, string HistoryID, bool ForRendering, ParameterValue[] Values, DataSourceCredentials[] Credentials) {
Line 1504: object[] results = this.Invoke("GetReportPara meters", new object[] {
Line 1505: Report,
Line 1506: HistoryID,
Source File: c:\WINDOWS\Microsoft.NET\F ramework\v 2.0.50727\ Temporary ASP.NET Files\reportscheduleportal \3f360b7c\ b9b80bf6\A pp_WebRefe rences.jgh fprge.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.Protoc ols.SoapHt tpClientPr otocol.Rea dResponse( SoapClient Message message, WebResponse response, Stream responseStream, Boolean asyncCall) +1547
System.Web.Services.Protoc ols.SoapHt tpClientPr otocol.Inv oke(String methodName, Object[] parameters) +205
ReportService.ReportingSer vice2005.G etReportPa rameters(S tring Report, String HistoryID, Boolean ForRendering, ParameterValue[] Values, DataSourceCredentials[] Credentials) in c:\WINDOWS\Microsoft.NET\F ramework\v 2.0.50727\ Temporary ASP.NET Files\reportscheduleportal \3f360b7c\ b9b80bf6\A pp_WebRefe rences.jgh fprge.0.cs :1504
BatchReport.LoadPageValues () in c:\Documents and Settings\lhein\My Documents\Visual Studio 2005\Projects\ReportSchedu ling\Repor tScheduleP ortal\Batc hReport.as px.cs:72
BatchReport.Page_Load(Obje ct sender, EventArgs e) in c:\Documents and Settings\lhein\My Documents\Visual Studio 2005\Projects\ReportSchedu ling\Repor tScheduleP ortal\Batc hReport.as px.cs:28
System.Web.Util.CalliHelpe r.EventArg FunctionCa ller(IntPt r fp, Object o, Object t, EventArgs e) +13
System.Web.Util.CalliEvent HandlerDel egateProxy .Callback( Object sender, EventArgs e) +45
System.Web.UI.Control.OnLo ad(EventAr gs e) +80
System.Web.UI.Control.Load Recursive( ) +49
System.Web.UI.Page.Process RequestMai n(Boolean includeStagesBeforeAsyncPo int, Boolean includeStagesAfterAsyncPoi nt) +3743
Payroll-Report-Screen.doc
--------------------------
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.Protoc
Source Error:
Line 1502: [return: System.Xml.Serialization.X
Line 1503: public ReportParameter[] GetReportParameters(string
Line 1504: object[] results = this.Invoke("GetReportPara
Line 1505: Report,
Line 1506: HistoryID,
Source File: c:\WINDOWS\Microsoft.NET\F
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.Protoc
System.Web.Services.Protoc
ReportService.ReportingSer
BatchReport.LoadPageValues
BatchReport.Page_Load(Obje
System.Web.Util.CalliHelpe
System.Web.Util.CalliEvent
System.Web.UI.Control.OnLo
System.Web.UI.Control.Load
System.Web.UI.Page.Process
Payroll-Report-Screen.doc
ASKER
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.
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