is NOT a parameter

When I use this line of code:

CASE WHEN d.StatusId IN ('XF','?','XT') THEN 1 ELSE 0 END AS Status

MS Reporting Services 2005 thinks that ? is a parameter. I know that I can use a stored proc to prevent this, but I would rather not.

Does anyone have suggestions on how to prevent this from occuring?

How about (not testing but it should work):

Code Snippet

CASE WHEN d.StatusID IN ('XF',CHAR(63),'XT') THEN 1 ELSE 0 END AS Status

>L<|||

Thanks Lisa,

That works. I also found that you can remove the <Parameter> tag from the code to fix it.

floyd

|||Nice username. HAHAHA sql

datetime Parameter issue

I'm using a sproc to insert the time (Now()) into a datetime field. Somehow the time "seconds" are not making it into the field. For example, the variable grabs the value of Now() - "9/16/2005 01:58:15 AM" to insert into the field. But when I view the records, the datetime value is "2005-09-16 13:58:00.000".
What am I doing wrong?
Thanks for your help!
Lynnette
Here is a snippet of the code and the sproc:

Dim recDateAs DateTime = Now()
cmd.Parameters.Add(New SqlParameter("@.DELastChg", SqlDbType.DateTime)).Value = recDate

ALTER PROC usp_AddTmpFLSAfromPT
@.dtWdate datetime,
@.whereString as varchar(255),
@.DEuser as varchar(30),
@.DELastChg datetime

AS

DECLARE @.strSQL as varchar(2000)

SET @.strSQL =
'
INSERT INTO tmpFLSAEmpInfo
( Emp_Number,
PT_ID,
Emp_Division,
Emp_Dept,
--Emp_DeptInfo,
Emp_Supervisor,
Emp_Location,
Emp_Union,
Emp_SG,
Emp_Shift,
DEusername,
DELastChg,
WrkDate
)
SELECT
Employee2.Emp_Number,
Employee2.[ID],
Employee2.Division,
Employee2.Job_Dept_Code,
Employee2.Job_Supervisor,
Employee2.Loc_Name,
Employee2.[Union],
Employee2.Sched_Group,
Employee2.Shift,
''' + @.DEUser + ''',
''' + CONVERT(varchar, @.DELastChg) + ''',
''' + CONVERT(varchar, @.dtWdate) + '''

FROM Employee2
WHERE '
+ @.whereString

EXEC(@.strSQL)

You are prbly losing the seconds because of the conversion to varchar in your code above. Put in the size also. Perhaps something like this :CONVERT(varchar(20), @.dtWdate) might help.|||Thanks for the response! I tried your suggestion, but it had no effect - still losing the seconds. I tried using CONVERT(datetime, @.DELastChg, 131) but then I get an error that I cannot convert string to DATETIME. I am hopelessly stuck.
Any other suggestions?
Thanks!
Lynnette|||Changed it toCONVERT(varchar, @.DELastChg, 113) and it works!

* * * Passing Parameter - Urgent * * *

I program an ASP.NET application that uses SQL Server 2005 Reporting
Services.
Recently I came into a dead end when I had to pass a parameter from my
application
to the report. I 've looked over the Internet and found absolutely nothing.
If someone is
capable of doing that he/she doesn't have to be shy to share it with me.
Thanks in advance,
Nick Hatzis
P.S. : To answer by e-mail remove the "bog" from the username.Hi,
What kind of parameter you must pass?|||Hi Cesar,
I have to pass four string parameters.
Two that will appear in the report and two
(from-to) that will be used in the query.
Thanks in advance,
Nick Hatzis
P.S. : To answer by e-mail remove the "bog" from the username.
"Cesar" <Cesar@.discussions.microsoft.com> wrote in message
news:490E74EF-519C-4D5E-BB69-C8412CB909C2@.microsoft.com...
> Hi,
> What kind of parameter you must pass?|||Are you using an URL to open the report? In that case, you should look at
the topic "URL access" in the SQL Server 2005 Books Online.
If you have it locally, this should be the URL
ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/rptsprg9/html/52c3f2a3-3d6d-4fee-9c46-83f366919398.htm
Or find it online at
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rsprog/htm/rsp_prog_urlaccess_374y.asp
Kaisa M. Lindahl Lervik
"Nick Hatzis" <boghatzisn@.panafonet.gr> wrote in message
news:%23MK70oQ7GHA.1012@.TK2MSFTNGP05.phx.gbl...
>I program an ASP.NET application that uses SQL Server 2005 Reporting
> Services.
> Recently I came into a dead end when I had to pass a parameter from my
> application
> to the report. I 've looked over the Internet and found absolutely
> nothing.
> If someone is
> capable of doing that he/she doesn't have to be shy to share it with me.
> Thanks in advance,
> Nick Hatzis
> P.S. : To answer by e-mail remove the "bog" from the username.
>|||On Wed, 11 Oct 2006 11:01:52 +0300, "Nick Hatzis"
<boghatzisn@.panafonet.gr> wrote:
>I program an ASP.NET application that uses SQL Server 2005 Reporting
>Services.
>Recently I came into a dead end when I had to pass a parameter from my
>application
>to the report. I 've looked over the Internet and found absolutely nothing.
>If someone is
>capable of doing that he/she doesn't have to be shy to share it with me.
>Thanks in advance,
>Nick Hatzis
>P.S. : To answer by e-mail remove the "bog" from the username.
>
Are you using reportviewer or just going direct to the URL? If direct
to the URL, something like this:
Response.Redirect("http://199.199.199.199/ReportServer?%2fReportProjectName%2fReportName&rs:Command=Render&rs:Format=PDF&IssueID=11000")
That IssueID at the end is a parameter. Note the rs:Format that gets
the report directly as a PDF.
If you're using a reportviewer control, parameters are done like this:
Dim RptParm As New
Microsoft.Reporting.WebForms.ReportParameter("FileNumParam",
lblFileNum.Text) ' name/value pair for a parameter
Dim RptParms As New Generic.List(Of
Microsoft.Reporting.WebForms.ReportParameter)
RptParms.Add(RptParm)
' add more parameters as necessary to RptParams
Reportviewer1.ServerReport.SetParameters(RptParms)

(urgent) How can I solve this error

Hi i am trying to implement Multivalue parameter in my report....

So for the Parameter PlanId i have selected multivalue parameter... and the avialable values are from a query...

when i run the report and just check 1 Plan it works fine.. but when i go to check more than one plan.. I get this error

An error has occured duing local report processing.

an error has occured during report processing.

Query exceution failed for data set Statement.

Error converting data type nvarchar to int.

any help will be appreciated.

Regards

Karen

How are you using the parameter in the SQL?

Can you post an example?

BobP

|||

BobP,

thanks for ur answer.. I have a dataset called statements which is a sproc and is as follows

Code Snippet

ALTER PROCEDURE [dbo].[rpt_Statements]

@.PeriodId int,

@.ClientId int,

@.PlanId int = NULL,

@.StartPart int = NULL,

@.StopPart int = NULL

AS

IF @.StartPart IS NULL

SELECT @.StartPart = MIN(ParticipantId)

FROM Participant

IF @.StopPart IS NULL

SELECT @.StopPart = MAX(ParticipantId)

FROM Participant

SELECT DISTINCT

s.PlanId,

PeriodId,

s.ParticipantId,

p.AddrZip, -- Added by Karen

dbo.udf_BeginDate(@.PeriodId) BeginDate,

dbo.udf_EndDate(@.PeriodId) EndDate

FROM

vwParticipantSourceSummary s

JOIN ClientPlan c

ON s.PlanId = c.PlanId

Join Participant p

ON s.ParticipantId = p.ParticipantId

WHERE

ClientId = @.ClientId

AND

PeriodId = @.PeriodId

AND

(

s.PlanId = @.PlanId

OR

(

s.PlanId = s.PlanId

AND

@.PlanId IS NULL

)

)

AND

(

BeginningBalance <> 0

OR

Contributions <> 0

OR

EndingBalance <> 0

)

AND

s.ParticipantId BETWEEN @.StartPart AND @.StopPart

ORDER BY

s.PlanId,

p.AddrZip DESC--ParticipantId

in the report parameter for the parameter @.PlanId i am giving a queried value and selecting a particular dataset.. which is as follows

Code Snippet

ALTER PROCEDURE [dbo].[usp_GetPlansByClient]

@.ClientId int = NULL

AS

--Temp Debug Code

/*declare @.ClientId int

set @.ClientId = 1

*/

SELECT

NULL PlanId,

'< All Plans >' PlanName

UNION

SELECT

PlanId,

PlanName

FROM

ClientPlan

WHERE

ClientId = @.ClientId

OR

(

ClientId = ClientId

AND

@.ClientId IS NULL

)

so when i run the sproc get plans i will get

1

2

3

etc....

but when i try to put it as a multivalue parameter its gonna 1,2,3

i think there is some conversion problem

any help will be appreciated.

Regards

Karen

|||

Ok, on multivalue parameters, you shuold use an IN clause in the sql...

So...

Where PlanID in (@.PlanID)

That is what is causing your error, i beleive.

HtH

BobP

|||i changed my sproc to as follows

* rpt_Statements

*

* Main stored procedure for Statement reports.

*

* HISTORY

* 3/2006 - Stephen Garrett

* Created.

* 1/28/2007 - Stephen Garrett

* Updated to allow reports to be run for all plans for a client in a given period.

**************************************************************************************************/

Code Snippet

ALTER PROCEDURE [dbo].[rpt_Statements]

@.PeriodId int,

@.ClientId int,

@.PlanId int = NULL,

@.StartPart int = NULL,

@.StopPart int = NULL

AS

IF @.StartPart IS NULL

SELECT @.StartPart = MIN(ParticipantId)

FROM Participant

IF @.StopPart IS NULL

SELECT @.StopPart = MAX(ParticipantId)

FROM Participant

SELECT DISTINCT

s.PlanId,

PeriodId,

s.ParticipantId,

p.AddrZip,

dbo.udf_BeginDate(@.PeriodId) BeginDate,

dbo.udf_EndDate(@.PeriodId) EndDate

FROM

vwParticipantSourceSummary s

JOIN ClientPlan c

ON s.PlanId = c.PlanId

Join Participant p

ON s.ParticipantId = p.ParticipantId

WHERE

ClientId = @.ClientId

AND

PeriodId = @.PeriodId

AND

s.PlanId In (@.PlanId)

--(

-- s.PlanId = @.PlanId

-- OR

-- (

-- s.PlanId = s.PlanId

-- AND

-- @.PlanId IS NULL

-- )

-- )

AND

(

BeginningBalance <> 0

OR

Contributions <> 0

OR

EndingBalance <> 0

)

AND

s.ParticipantId BETWEEN @.StartPart AND @.StopPart

ORDER BY

s.PlanId,

p.AddrZip Desc--ParticipantId

and in my sql query window , i gave this

rpt_statements 6,1,'374,375'

and got this error

Msg 8114, Level 16, State 5, Procedure rpt_Statements, Line 0

Error converting data type varchar to int.

Hope u can help me out here.

Regards

Karen

|||

Since you are using a proc, you will have to pass in the parameter as a string and build your sql as a string and then execute it.

Whenever I use Multi-Valued parameters, I use embedded SQL, not a stored proc, just so I can use the IN clause. It seems to be faster executing than passing the list of values to a proc.

BobP

|||

can u pls give me a example as to how u do it..

Regards

Karen

|||

Sure. What I do is not use a stored proc, and just put the SQL in the report dataset.

However, you can also pass the parameter string to the proc and build the SQL that way. It makes it harder to test/debug, but it is doable.

here is an example:

Code Snippet

ALTER PROCEDURE [dbo].[rpt_Statements]

@.PeriodId int,

@.ClientId int,

@.PlanId nvarchar(max) = NULL,

@.StartPart int = NULL,

@.StopPart int = NULL

AS

IF @.StartPart IS NULL

SELECT @.StartPart = MIN(ParticipantId)

FROM Participant

IF @.StopPart IS NULL

SELECT @.StopPart = MAX(ParticipantId)

FROM Participant

Declare @.SQLText nvarchar(max)

if @.PlanID is null

Begin

SELECT DISTINCT

s.PlanId,

PeriodId,

s.ParticipantId,

p.AddrZip, -- Added by Karen

dbo.udf_BeginDate(@.PeriodId) BeginDate,

dbo.udf_EndDate(@.PeriodId) EndDate

FROM

vwParticipantSourceSummary s

JOIN ClientPlan c

ON s.PlanId = c.PlanId

Join Participant p

ON s.ParticipantId = p.ParticipantId

WHERE

ClientId = @.ClientId

AND PeriodId = @.PeriodId

AND (

BeginningBalance <> 0

OR

Contributions <> 0

OR

EndingBalance <> 0

)

AND s.ParticipantId BETWEEN @.StartPart AND @.StopPart

ORDER BY

s.PlanId,

p.AddrZip DESC--ParticipantId

End

Else

Begin

Select @.SQLText = 'SELECT DISTINCT

s.PlanId,

PeriodId,

s.ParticipantId,

p.AddrZip, -- Added by Karen

dbo.udf_BeginDate(@.PeriodId) BeginDate,

dbo.udf_EndDate(@.PeriodId) EndDate

FROM

vwParticipantSourceSummary s

JOIN ClientPlan c

ON s.PlanId = c.PlanId

Join Participant p

ON s.ParticipantId = p.ParticipantId

WHERE

ClientId = @.ClientId

AND PeriodId = @.PeriodId

AND s.PlanID in (' + @.PlanID + ')

AND (

BeginningBalance <> 0

OR

Contributions <> 0

OR

EndingBalance <> 0

)

AND s.ParticipantId BETWEEN @.StartPart AND @.StopPart

ORDER BY

s.PlanId,

p.AddrZip DESC--ParticipantId'

execute (@.SQLText)

End

I didn't test that, but it should work fine. (No tables, etc)

BobP

|||

Bob

thanks for ur answer... but when i run the sproc i am getting this error

Msg 137, Level 15, State 2, Line 6

Must declare the scalar variable "@.PeriodId".

|||

Ahhhh.. sorry about that... here is the corrected code:

Code Snippet

ALTER PROCEDURE [dbo].[rpt_Statements]

@.PeriodId int,

@.ClientId int,

@.PlanId nvarchar(max) = NULL,

@.StartPart int = NULL,

@.StopPart int = NULL

AS

IF @.StartPart IS NULL

SELECT @.StartPart = MIN(ParticipantId)

FROM Participant

IF @.StopPart IS NULL

SELECT @.StopPart = MAX(ParticipantId)

FROM Participant

Declare @.SQLText nvarchar(max)

if @.PlanID is null

Begin

SELECT DISTINCT

s.PlanId,

PeriodId,

s.ParticipantId,

p.AddrZip, -- Added by Karen

dbo.udf_BeginDate(@.PeriodId) BeginDate,

dbo.udf_EndDate(@.PeriodId) EndDate

FROM

vwParticipantSourceSummary s

JOIN ClientPlan c

ON s.PlanId = c.PlanId

Join Participant p

ON s.ParticipantId = p.ParticipantId

WHERE

ClientId = @.ClientId

AND PeriodId = @.PeriodId

AND (

BeginningBalance <> 0

OR

Contributions <> 0

OR

EndingBalance <> 0

)

AND s.ParticipantId BETWEEN @.StartPart AND @.StopPart

ORDER BY

s.PlanId,

p.AddrZip DESC--ParticipantId

End

Else

Begin

Select @.SQLText = 'SELECT DISTINCT

s.PlanId,

PeriodId,

s.ParticipantId,

p.AddrZip, -- Added by Karen

dbo.udf_BeginDate(' + convert(varchar,@.PeriodId) + ') BeginDate,

dbo.udf_EndDate' + convert(varchar,@.PeriodId) + ') EndDate

FROM

vwParticipantSourceSummary s

JOIN ClientPlan c

ON s.PlanId = c.PlanId

Join Participant p

ON s.ParticipantId = p.ParticipantId

WHERE

ClientId = ' + convert(varchar,@.ClientId) + '

AND PeriodId = ' + convert(varchar,@.PeriodId) + '

AND s.PlanID in (' + @.PlanID + ')

AND (

BeginningBalance <> 0

OR

Contributions <> 0

OR

EndingBalance <> 0

)

AND s.ParticipantId BETWEEN ' + Convert(varchar, @.StartPart) + ' AND ' + Convert(varchar, @.StopPart) + '

ORDER BY

s.PlanId,

p.AddrZip DESC--ParticipantId'

execute (@.SQLText)

End

Try that... again, i cant really test with out the tables, but that should give you a really good starting point.

BobP

|||

Thanks a lot bob, with works great..

I have a another quick question... is it possible to give a case statement in the order by... Like for examples.. suppose the user will be wanting to send some plans to the client and some plans to the participant.. and if the plans that are selected are to be sent to the client i want them to sort by planId and Addr zip else i want them to sort by.. Addrzip only...

Regards.

Karen

|||

It sure is. The only issue that I have found with that is the ASC/DESC flag sometimes will not work with a case...

Order by Case When @.SortBy = 'name'

Then Name

else

City

end

BobP

|||

is this right

ORDER BY

Case when psi.MailMethodId = 1

Then

p.AddrZip Desc

Else

s.PlanId,

p.AddrZip desc

End '

cause when i run the sproc i am getting a error that says incorrect syntax near the keyword desc

|||The asc/desc has to go outside of the case statement.

ORDER BY

Case when psi.MailMethodId = 1

Then

p.AddrZip

Else

s.PlanId,

p.AddrZip

End desc '

BobP

|||

BobP - BIM wrote:

The asc/desc has to go outside of the case statement.

ORDER BY

Case when psi.MailMethodId = 1

Then

p.AddrZip

Else

s.PlanId,

p.AddrZip

End desc '

BobP

Looks likes its not accepting

the Else part... cause i am getting an error saying Incorrect syntax near ','

Regards

Kareb

(Select All) value

I would like to display "ALL" in a text box if the (Select All) option is
selected as a parameter.
I can display 1, 2, 5 to every single selected value in the textbox using
the JOIN function. But if the (Select All) parameter is selected, I would
rather display "All" in my textbox instead of 50+ parameters.
I have tried something of the following
=IIf(Parameters!param.Value = "Select All" , "All",
Join(Parameters!param.Value, " | "))
But this does not work.
Any suggestions out there?
Thanks
RobRob,
I have an idea, but I don't know how good it is...
If there is a way to count the number of values selected, you could
compare that with a count of the records in the dataset. However, since
I don't know if that is possible, here is an idea...
You are using a dataset to generate the "Available Values" for one
parameter. Use this same dataset as the default value for a new,
internal parameter. This parameter will not be used for anything other
than holding all of the values that could be selected.
Then, use an expression to compare the 2 JOIN results.
Iif(JOIN(Parameters!mainParm.Value,",") =JOIN(Parameters!internalParm.Value,","), "All",
JOIN(Parameters!mainParm.Value,",") )
Hope this helps!
-Josh
Rob wrote:
> I would like to display "ALL" in a text box if the (Select All) option is
> selected as a parameter.
> I can display 1, 2, 5 to every single selected value in the textbox using
> the JOIN function. But if the (Select All) parameter is selected, I would
> rather display "All" in my textbox instead of 50+ parameters.
> I have tried something of the following
> =IIf(Parameters!param.Value = "Select All" , "All",
> Join(Parameters!param.Value, " | "))
> But this does not work.
> Any suggestions out there?
> Thanks
> Rob|||Ok, I figured it out and I wanted to put my solution here for others in the
same boat.
Problem: In SSRS 2005 (non SP1) there is the Multi-value option for a
parameter. If you want to display the parameter list in a text box, you use
something like:
=Join(Parameters!param_mso.Label, ", ") //this goes in textbox
and (m.mso_num IN (@.param_mso)) //this goes in the query
This will display every select parameter in a textbox. But what happens if
you have 100+ parameters? Then you have an unmanageable list of parameters
being displayed on the report.
So, if the user selects (Select All) from the dropdown list, only display
"All" in the textbox.
Solution: You need to create a new dataset that only returns the row count
of the parameter list. So, for example: this is the SQL query that returns a
list of MSO objects that are associated with a NETWORK parameter
SELECT s.network_id, ms.mso_num, m.mso_name
FROM service s, mso_service ms, mso m
WHERE s.service_id = ms.service_id
and ms.mso_num = m.mso_num
and s.network_id = @.param_network
GROUP BY s.network_id, ms.mso_num, m.mso_name
ORDER BY ms.mso_num
I create a new DATASET just to get the count of the above query:
SELECT count(*)
FROM(
SELECT s.network_id, ms.mso_num, m.mso_name
FROM service s, mso_service ms, mso m
WHERE s.service_id = ms.service_id
and ms.mso_num = m.mso_num
and s.network_id = :param_network
GROUP BY s.network_id, ms.mso_num, m.mso_name
ORDER BY ms.mso_num)x
This way I know the max number of row items that the original query is going
to return. I then use the following formula in my textbox:
=IIf(Parameters!param_mso.Count = Parameters!param_count.Value, "ALL",
Join(Parameters!param_mso.Label, ", "))
So if the count of my MSO parameter equals the total count of the query,
then display "ALL", otherwise display all of the parameters selected.
I hope that this helps out.
Rob
"Josh" wrote:
> Rob,
> I have an idea, but I don't know how good it is...
> If there is a way to count the number of values selected, you could
> compare that with a count of the records in the dataset. However, since
> I don't know if that is possible, here is an idea...
> You are using a dataset to generate the "Available Values" for one
> parameter. Use this same dataset as the default value for a new,
> internal parameter. This parameter will not be used for anything other
> than holding all of the values that could be selected.
> Then, use an expression to compare the 2 JOIN results.
> Iif(JOIN(Parameters!mainParm.Value,",") => JOIN(Parameters!internalParm.Value,","), "All",
> JOIN(Parameters!mainParm.Value,",") )
> Hope this helps!
> -Josh
>
> Rob wrote:
> > I would like to display "ALL" in a text box if the (Select All) option is
> > selected as a parameter.
> >
> > I can display 1, 2, 5 to every single selected value in the textbox using
> > the JOIN function. But if the (Select All) parameter is selected, I would
> > rather display "All" in my textbox instead of 50+ parameters.
> >
> > I have tried something of the following
> >
> > =IIf(Parameters!param.Value = "Select All" , "All",
> > Join(Parameters!param.Value, " | "))
> >
> > But this does not work.
> >
> > Any suggestions out there?
> >
> > Thanks
> > Rob
>|||You can just use Count(Fieldname, "Dataset") to retrieve the number instead
of creating a seperate dataset.
"Rob" wrote:
> Ok, I figured it out and I wanted to put my solution here for others in the
> same boat.
> Problem: In SSRS 2005 (non SP1) there is the Multi-value option for a
> parameter. If you want to display the parameter list in a text box, you use
> something like:
> =Join(Parameters!param_mso.Label, ", ") //this goes in textbox
> and (m.mso_num IN (@.param_mso)) //this goes in the query
> This will display every select parameter in a textbox. But what happens if
> you have 100+ parameters? Then you have an unmanageable list of parameters
> being displayed on the report.
> So, if the user selects (Select All) from the dropdown list, only display
> "All" in the textbox.
> Solution: You need to create a new dataset that only returns the row count
> of the parameter list. So, for example: this is the SQL query that returns a
> list of MSO objects that are associated with a NETWORK parameter
> SELECT s.network_id, ms.mso_num, m.mso_name
> FROM service s, mso_service ms, mso m
> WHERE s.service_id = ms.service_id
> and ms.mso_num = m.mso_num
> and s.network_id = @.param_network
> GROUP BY s.network_id, ms.mso_num, m.mso_name
> ORDER BY ms.mso_num
> I create a new DATASET just to get the count of the above query:
> SELECT count(*)
> FROM(
> SELECT s.network_id, ms.mso_num, m.mso_name
> FROM service s, mso_service ms, mso m
> WHERE s.service_id = ms.service_id
> and ms.mso_num = m.mso_num
> and s.network_id = :param_network
> GROUP BY s.network_id, ms.mso_num, m.mso_name
> ORDER BY ms.mso_num)x
> This way I know the max number of row items that the original query is going
> to return. I then use the following formula in my textbox:
> =IIf(Parameters!param_mso.Count = Parameters!param_count.Value, "ALL",
> Join(Parameters!param_mso.Label, ", "))
> So if the count of my MSO parameter equals the total count of the query,
> then display "ALL", otherwise display all of the parameters selected.
> I hope that this helps out.
> Rob
>
>
> "Josh" wrote:
> >
> > Rob,
> >
> > I have an idea, but I don't know how good it is...
> >
> > If there is a way to count the number of values selected, you could
> > compare that with a count of the records in the dataset. However, since
> > I don't know if that is possible, here is an idea...
> >
> > You are using a dataset to generate the "Available Values" for one
> > parameter. Use this same dataset as the default value for a new,
> > internal parameter. This parameter will not be used for anything other
> > than holding all of the values that could be selected.
> >
> > Then, use an expression to compare the 2 JOIN results.
> > Iif(JOIN(Parameters!mainParm.Value,",") => > JOIN(Parameters!internalParm.Value,","), "All",
> > JOIN(Parameters!mainParm.Value,",") )
> >
> > Hope this helps!
> >
> > -Josh
> >
> >
> > Rob wrote:
> > > I would like to display "ALL" in a text box if the (Select All) option is
> > > selected as a parameter.
> > >
> > > I can display 1, 2, 5 to every single selected value in the textbox using
> > > the JOIN function. But if the (Select All) parameter is selected, I would
> > > rather display "All" in my textbox instead of 50+ parameters.
> > >
> > > I have tried something of the following
> > >
> > > =IIf(Parameters!param.Value = "Select All" , "All",
> > > Join(Parameters!param.Value, " | "))
> > >
> > > But this does not work.
> > >
> > > Any suggestions out there?
> > >
> > > Thanks
> > > Rob
> >
> >|||Won't let me edit my post. Something like this.
=IIF(Count(Fields!AcctCode.Value, "AcctCode") =Parameters!AcctCode.Count,"All",Join(Parameters!AcctCode.Label,","))
"Rob" wrote:
> I would like to display "ALL" in a text box if the (Select All) option is
> selected as a parameter.
> I can display 1, 2, 5 to every single selected value in the textbox using
> the JOIN function. But if the (Select All) parameter is selected, I would
> rather display "All" in my textbox instead of 50+ parameters.
> I have tried something of the following
> =IIf(Parameters!param.Value = "Select All" , "All",
> Join(Parameters!param.Value, " | "))
> But this does not work.
> Any suggestions out there?
> Thanks
> Rob

(select all) member of querried parameter in SSRS

Dear all
I use a querried parameter in a SSRS report. This works fine. I now have
difficulties to decide if I should eather use the dimension.all member or the
ssrs (select all) member. What I do not like is to use both, because I think
this confuses the user.
Is there a way to hide the (select all) member? And what happens if the
(select all) member and the dimension.all member is selected?
Kind regards,
MarcHello Marc,
Could you please let me know which version of SQL Server Reporting Services
you are using?
In SRS 2005 SP1, product team remove the (select all) option which may
cause the slow performance for cube data.
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
ications.
Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
http://msdn.microsoft.com/subscriptions/support/default.aspx.
==================================================(This posting is provided "AS IS", with no warranties, and confers no
rights.)|||Hello Wei
Thanks for your answer. I'm using SQL Server 2005 SP2.
Kind Regards,
Marc|||Hello Marc,
I am performing research now, I appreciate your patience.
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
ications.
Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
http://msdn.microsoft.com/subscriptions/support/default.aspx.
==================================================(This posting is provided "AS IS", with no warranties, and confers no
rights.)|||Hello Marc,
Sorry for the delay update.
I did not found any resolution to remove the (select all) option in the
SSRS 2005 SP2. I will confirm with producet team.
As for the result when select (select all) and All member option, based on
my research, this will perform the query to all the members in the Cube.
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights.|||Hi ,
How is everything going? Please feel free to let me know if you need any
assistance.
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights.|||Hi Wei, thanks for your help!

(Select All) Checkbox As Default

All,

When creating a dynamic parameter list from a query, Reporting Services graciously provides a "(Select All)" checkbox. How can I select this checkbox by default so that when a user generates the report, all of the values are selected?

Thanks

The "select all" item is just a UI concept at this point. You could setup a default value for the report parameter that contains all values of the valid values list - but in that case all the checkboxes for individual items would be pre-selected, but the "select all" would still not be pre-selected.

-- Robert

|||Thanks for the reply. I actually tried your approach before posting my question. The problem that I am facing when using this approach is that the pre-selection is always static so this will not work when my checkbox list is populated from a query. Since the results of the query are dynamic, I can't setup a default list with any degree of accuracy.|||

Robert,

Is there any way to tell when the Select All option is selected?

R

|||

I don't know if this works

But if my dropdown source is Query, and with "Multi-Value items" checkbox checked

Under Default Values, If I choose "Query", pick the Dataset, put in the value field -> it will select all rows in the query by default

When I go to Preview, all items from the query ARE checked in the dropdown. Even the "ALL" option I created myself

(now the problem is, how do you uncheck them all with ease...)

I hope that's what you're looking for, I wish there's easy way to post pictures

|||

The closest you can get is to compare the number of rows in the dataset used for the valid values list (e.g. =CountRows("ParameterDataSetName")) with the number of selected parameter values (e.g. =Parameters!P1.Count)

-- Robert

(Select All) Checkbox As Default

All,

When creating a dynamic parameter list from a query, Reporting Services graciously provides a "(Select All)" checkbox. How can I select this checkbox by default so that when a user generates the report, all of the values are selected?

Thanks

The "select all" item is just a UI concept at this point. You could setup a default value for the report parameter that contains all values of the valid values list - but in that case all the checkboxes for individual items would be pre-selected, but the "select all" would still not be pre-selected.

-- Robert

|||Thanks for the reply. I actually tried your approach before posting my question. The problem that I am facing when using this approach is that the pre-selection is always static so this will not work when my checkbox list is populated from a query. Since the results of the query are dynamic, I can't setup a default list with any degree of accuracy.|||

Robert,

Is there any way to tell when the Select All option is selected?

R

|||

I don't know if this works

But if my dropdown source is Query, and with "Multi-Value items" checkbox checked

Under Default Values, If I choose "Query", pick the Dataset, put in the value field -> it will select all rows in the query by default

When I go to Preview, all items from the query ARE checked in the dropdown. Even the "ALL" option I created myself

(now the problem is, how do you uncheck them all with ease...)

I hope that's what you're looking for, I wish there's easy way to post pictures

|||

The closest you can get is to compare the number of rows in the dataset used for the valid values list (e.g. =CountRows("ParameterDataSetName")) with the number of selected parameter values (e.g. =Parameters!P1.Count)

-- Robert

(Select All) Checkbox As Default

All,

When creating a dynamic parameter list from a query, Reporting Services graciously provides a "(Select All)" checkbox. How can I select this checkbox by default so that when a user generates the report, all of the values are selected?

Thanks

The "select all" item is just a UI concept at this point. You could setup a default value for the report parameter that contains all values of the valid values list - but in that case all the checkboxes for individual items would be pre-selected, but the "select all" would still not be pre-selected.

-- Robert

|||Thanks for the reply. I actually tried your approach before posting my question. The problem that I am facing when using this approach is that the pre-selection is always static so this will not work when my checkbox list is populated from a query. Since the results of the query are dynamic, I can't setup a default list with any degree of accuracy.|||

Robert,

Is there any way to tell when the Select All option is selected?

R

|||

I don't know if this works

But if my dropdown source is Query, and with "Multi-Value items" checkbox checked

Under Default Values, If I choose "Query", pick the Dataset, put in the value field -> it will select all rows in the query by default

When I go to Preview, all items from the query ARE checked in the dropdown. Even the "ALL" option I created myself

(now the problem is, how do you uncheck them all with ease...)

I hope that's what you're looking for, I wish there's easy way to post pictures

|||

The closest you can get is to compare the number of rows in the dataset used for the valid values list (e.g. =CountRows("ParameterDataSetName")) with the number of selected parameter values (e.g. =Parameters!P1.Count)

-- Robert

(Report Model Deployment Error) The value of parameter 'DataSources' is not valid

I've got a report model I am trying to move from a development server to a production server. I published it to my development RS, exported the SMDL file, then uploaded it to the production server. At that point, I tried assigning the data source to the model and got the error:

The value of parameter 'DataSources' is not valid in the browser.
Looking in the logs, the following trace is there:

w3wp!library!7!12/12/2005-13:23:00:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.LogonFailedException: Logon failed., ;
Info: Microsoft.ReportingServices.Diagnostics.Utilities.LogonFailedException: Logon failed. > System.Runtime.InteropServices.COMException (0x8007052E): Logon failure: unknown user name or bad password. (Exception from HRESULT: 0x8007052E)
at System.Runtime.InteropServices.Marshal.ThrowExceptionForHRInternal(Int32 errorCode, IntPtr errorInfo)
at RSRemoteRpcClient.RemoteLogon.GetRemoteImpToken(String pRPCEndpointName, Int32 type, Guid dataSourceId, String pUserName, String pDomain, String pPassword)
at Microsoft.ReportingServices.Diagnostics.ImpersonationContext.Login(CredentialsType credType, Guid dataSourceId, String userName, String userPwd, String domain)
End of inner exception stack trace
w3wp!webserver!7!12/12/2005-13:23:00:: e ERROR: Reporting Services error Microsoft.ReportingServices.Diagnostics.Utilities.RSException: Logon failed. > Microsoft.ReportingServices.Diagnostics.Utilities.LogonFailedException: Logon failed. > System.Runtime.InteropServices.COMException: Logon failure: unknown user name or bad password. (Exception from HRESULT: 0x8007052E)
w3wp!library!5!12/12/2005-13:23:49:: i INFO: Call to GetPermissions:/ADS Reports/Production Data Sources/ADS
w3wp!library!1!12/12/2005-13:23:49:: i INFO: Call to GetSystemPermissions
w3wp!library!7!12/12/2005-13:23:50:: i INFO: Call to GetPermissions:/ADS Reports/Production Data Sources/ADS
w3wp!library!7!12/12/2005-13:23:51:: i INFO: Call to GetSystemPermissions
w3wp!library!5!12/12/2005-13:23:52:: i INFO: Call to GetPermissions:/ADS Reports/Production Data Sources/ADS
w3wp!library!5!12/12/2005-13:23:52:: i INFO: Call to GetSystemPermissions
w3wp!library!5!12/12/2005-13:23:52:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.InvalidParameterException: The value of parameter 'DataSources' is not valid., ;
Info: Microsoft.ReportingServices.Diagnostics.Utilities.InvalidParameterException: The value of parameter 'DataSources' is not valid.
w3wp!library!7!12/12/2005-13:30:18:: Using folder C:\Program Files\Microsoft SQL Server 2005\MSSQL.3\Reporting Services\RSTempFiles for temporary files.
w3wp!library!7!12/12/2005-13:30:18:: i INFO: Cleaned 0 batch records, 0 policies, 1 sessions, 0 cache entries, 1 snapshots, 1 chunks, 0 running jobs, 0 persisted streams

The problem is that the data source is selected to be Integrated Windows Authentication, so I'm a bit confused as to what's up with the model.

PS I am local admin on the machine as well as System Admin for reporting services.

I have a similar problem. I do not yet have a resolution:

Can't call reports from Report Manager.

I've installed Reporting Services 2005 on a Windows 2003 Server. The server has a successful side by side install of VS2003 and VS2005 and a successful side by side install of SQL Server 2000 and SQL Server 2005. It also is a Domain Controller [I know that this is suboptimal, but I don't have enough machines to avoid this right now]. I am Domain Administrator and did the install as domain admin. Also, the domain admin account is the default dbo for the SQLServer 2005 install. I followed a default install of Reporting Services [under the default web site] and it worked properly. I then had an issue where I needed another site under the default web site to use ASP.NET 1.1, so I moved the Reporting Services website to a separate web site with a distinct assigned IP. I did this by "hand" in the IIS Manager. Since then I've had a rsLogonFailed error when trying to access reports from the Report Server. I reinstalled Reporting Services, but got a cryptic message indicating that the deinstall was not perfectly clean.

Since I really don't want to launch a major rebuilding effort on this computer, I've been trying to find the special sauce to put this back together again. I've adjusted the Reporting Services Configuration, the ASP.NET application pools, and the SQL DB logins and permissions. No success.

The executionlog table in the ReportServer$SQLServer2005 database records the failed logins. It indentifies the UserName and the status "rsLogonFailed", along with the reportID, timestamp, etc.

I have noticed, via Google, other users having similar problems. For instance, someone trying to establish an email subscription has an rsLogonFailed problem at: http://www.sqltalk.org/ftopic7220.html

Here is my trace:

w3wp!chunks!5!12/18/2005-22:19:49:: v VERBOSE: ### CopyImages(d221ebad-7547-4c48-9324-90a21d66a168,715a6af3-dd95-44f7-b3c5-c660f3c3393f)
w3wp!library!5!12/18/2005-22:19:49:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.LogonFailedException: Logon failed., ;
Info: Microsoft.ReportingServices.Diagnostics.Utilities.LogonFailedException: Logon failed. > System.Runtime.InteropServices.COMException (0x8007052E): Logon failure: unknown user name or bad password. (Exception from HRESULT: 0x8007052E)
at System.Runtime.InteropServices.Marshal.ThrowExceptionForHRInternal(Int32 errorCode, IntPtr errorInfo)
at RSRemoteRpcClient.RemoteLogon.GetRemoteImpToken(String pRPCEndpointName, Int32 type, Guid dataSourceId, String pUserName, String pDomain, String pPassword)
at Microsoft.ReportingServices.Diagnostics.ImpersonationContext.Login(CredentialsType credType, Guid dataSourceId, String userName, String userPwd, String domain)
End of inner exception stack trace
w3wp!library!5!12/18/2005-22:19:49:: v VERBOSE: Transaction rollback.
w3wp!dbcleanup!5!12/18/2005-22:25:28:: v VERBOSE: Starting database cleanup.

The error that you are getting is the closest to mine that I've seen on the net. Does anyone have any ideas?

Best,

Mike

|||

Have you received any solution for this problem? I am having the same problem and in desparate need for a fix.

I heard from the below site/comments that there is a problem with SQL Reporting Services 2005 and Windows Server 2003 SP1.

Apparently there are some issues with Windows 2003 when trying to
impersonate a user to a remote resource. We stumbled across a similar issue
when using SQL Reporting Services hosted on Windows 2003. We reinstalled the
entire reporting environment onto a Windows 2000 Server and the problem
immediately disappeared. These issues related to security problems access
resources on remote machines via a web application.

http://groups.google.com/group/microsoft.public.dotnet.framework.webservices/browse_thread/thread/bb9f3db6230a04ed/3d342d8c40e6aede?lnk=st&q=Reporting+Services+referenced+account+locked+out&rnum=1&hl=en#3d342d8c40e6aede

Thanks for any assistance, anyone can give me.

|||Open the datasource properties and make sure that credentials are either "Credentials stored securely in report server" or "Windows integrated security"|||Also make sure that you have a fully qualified user name, i.e. domain\username or machine\username.|||

If the suggestions above don't fix this error, try to update the password for the unattended execution account: rsconfig.exe -e ... - or through the RsConfigTool in RS 2005

Thanks

tudor

|||

I follow this thread and found the source of my problem. I had lost the execution account definition. when I restored that in reporting Services Configuration manager, the login failures stopped.

thank you

Tebby Wafer

|||Just an FYI. I had the very same problem, but in order to correct, I had to remove the execution account credentials. After doing so, my reports worked again. I'll try re-adding the execution account again at a later time if needed.|||I also had this problem on a development machine and it appeared to be because the password had changed on the Execution Account (it had been set as a user account). To resolve the problem I had to change the stored password on the execution account by going into the Reporting Services Configuration Manager (under Configuration Tools in the Start Menu) and clicking on the Execution Account option. You can change the account or reset the password here.|||I am experiencing the same issue with SSRS and Windows 2003 I now have WMI errors and the reinstallation of SSRS is a nightmare which I still haven't solved yet. This is just POOR product service by Microsoft. I am so frustrated I am considering discontinuing all reporting services and switch to another reporting platform.|||I was having a similar error just viewing a report. Reconfiguring the Execution Account solved my problem as well.|||

Hello, I am new to MS CRm and everything. Where can i find this execution account ?

Kumail

(Report Model Deployment Error) The value of parameter 'DataSources' is not valid

I've got a report model I am trying to move from a development server to a production server. I published it to my development RS, exported the SMDL file, then uploaded it to the production server. At that point, I tried assigning the data source to the model and got the error:

The value of parameter 'DataSources' is not valid in the browser.
Looking in the logs, the following trace is there:

w3wp!library!7!12/12/2005-13:23:00:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.LogonFailedException: Logon failed., ;
Info: Microsoft.ReportingServices.Diagnostics.Utilities.LogonFailedException: Logon failed. > System.Runtime.InteropServices.COMException (0x8007052E): Logon failure: unknown user name or bad password. (Exception from HRESULT: 0x8007052E)
at System.Runtime.InteropServices.Marshal.ThrowExceptionForHRInternal(Int32 errorCode, IntPtr errorInfo)
at RSRemoteRpcClient.RemoteLogon.GetRemoteImpToken(String pRPCEndpointName, Int32 type, Guid dataSourceId, String pUserName, String pDomain, String pPassword)
at Microsoft.ReportingServices.Diagnostics.ImpersonationContext.Login(CredentialsType credType, Guid dataSourceId, String userName, String userPwd, String domain)
End of inner exception stack trace
w3wp!webserver!7!12/12/2005-13:23:00:: e ERROR: Reporting Services error Microsoft.ReportingServices.Diagnostics.Utilities.RSException: Logon failed. > Microsoft.ReportingServices.Diagnostics.Utilities.LogonFailedException: Logon failed. > System.Runtime.InteropServices.COMException: Logon failure: unknown user name or bad password. (Exception from HRESULT: 0x8007052E)
w3wp!library!5!12/12/2005-13:23:49:: i INFO: Call to GetPermissions:/ADS Reports/Production Data Sources/ADS
w3wp!library!1!12/12/2005-13:23:49:: i INFO: Call to GetSystemPermissions
w3wp!library!7!12/12/2005-13:23:50:: i INFO: Call to GetPermissions:/ADS Reports/Production Data Sources/ADS
w3wp!library!7!12/12/2005-13:23:51:: i INFO: Call to GetSystemPermissions
w3wp!library!5!12/12/2005-13:23:52:: i INFO: Call to GetPermissions:/ADS Reports/Production Data Sources/ADS
w3wp!library!5!12/12/2005-13:23:52:: i INFO: Call to GetSystemPermissions
w3wp!library!5!12/12/2005-13:23:52:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.InvalidParameterException: The value of parameter 'DataSources' is not valid., ;
Info: Microsoft.ReportingServices.Diagnostics.Utilities.InvalidParameterException: The value of parameter 'DataSources' is not valid.
w3wp!library!7!12/12/2005-13:30:18:: Using folder C:\Program Files\Microsoft SQL Server 2005\MSSQL.3\Reporting Services\RSTempFiles for temporary files.
w3wp!library!7!12/12/2005-13:30:18:: i INFO: Cleaned 0 batch records, 0 policies, 1 sessions, 0 cache entries, 1 snapshots, 1 chunks, 0 running jobs, 0 persisted streams

The problem is that the data source is selected to be Integrated Windows Authentication, so I'm a bit confused as to what's up with the model.

PS I am local admin on the machine as well as System Admin for reporting services.

I have a similar problem. I do not yet have a resolution:

Can't call reports from Report Manager.

I've installed Reporting Services 2005 on a Windows 2003 Server. The server has a successful side by side install of VS2003 and VS2005 and a successful side by side install of SQL Server 2000 and SQL Server 2005. It also is a Domain Controller [I know that this is suboptimal, but I don't have enough machines to avoid this right now]. I am Domain Administrator and did the install as domain admin. Also, the domain admin account is the default dbo for the SQLServer 2005 install. I followed a default install of Reporting Services [under the default web site] and it worked properly. I then had an issue where I needed another site under the default web site to use ASP.NET 1.1, so I moved the Reporting Services website to a separate web site with a distinct assigned IP. I did this by "hand" in the IIS Manager. Since then I've had a rsLogonFailed error when trying to access reports from the Report Server. I reinstalled Reporting Services, but got a cryptic message indicating that the deinstall was not perfectly clean.

Since I really don't want to launch a major rebuilding effort on this computer, I've been trying to find the special sauce to put this back together again. I've adjusted the Reporting Services Configuration, the ASP.NET application pools, and the SQL DB logins and permissions. No success.

The executionlog table in the ReportServer$SQLServer2005 database records the failed logins. It indentifies the UserName and the status "rsLogonFailed", along with the reportID, timestamp, etc.

I have noticed, via Google, other users having similar problems. For instance, someone trying to establish an email subscription has an rsLogonFailed problem at: http://www.sqltalk.org/ftopic7220.html

Here is my trace:

w3wp!chunks!5!12/18/2005-22:19:49:: v VERBOSE: ### CopyImages(d221ebad-7547-4c48-9324-90a21d66a168,715a6af3-dd95-44f7-b3c5-c660f3c3393f)
w3wp!library!5!12/18/2005-22:19:49:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.LogonFailedException: Logon failed., ;
Info: Microsoft.ReportingServices.Diagnostics.Utilities.LogonFailedException: Logon failed. > System.Runtime.InteropServices.COMException (0x8007052E): Logon failure: unknown user name or bad password. (Exception from HRESULT: 0x8007052E)
at System.Runtime.InteropServices.Marshal.ThrowExceptionForHRInternal(Int32 errorCode, IntPtr errorInfo)
at RSRemoteRpcClient.RemoteLogon.GetRemoteImpToken(String pRPCEndpointName, Int32 type, Guid dataSourceId, String pUserName, String pDomain, String pPassword)
at Microsoft.ReportingServices.Diagnostics.ImpersonationContext.Login(CredentialsType credType, Guid dataSourceId, String userName, String userPwd, String domain)
End of inner exception stack trace
w3wp!library!5!12/18/2005-22:19:49:: v VERBOSE: Transaction rollback.
w3wp!dbcleanup!5!12/18/2005-22:25:28:: v VERBOSE: Starting database cleanup.

The error that you are getting is the closest to mine that I've seen on the net. Does anyone have any ideas?

Best,

Mike

|||

Have you received any solution for this problem? I am having the same problem and in desparate need for a fix.

I heard from the below site/comments that there is a problem with SQL Reporting Services 2005 and Windows Server 2003 SP1.

Apparently there are some issues with Windows 2003 when trying to
impersonate a user to a remote resource. We stumbled across a similar issue
when using SQL Reporting Services hosted on Windows 2003. We reinstalled the
entire reporting environment onto a Windows 2000 Server and the problem
immediately disappeared. These issues related to security problems access
resources on remote machines via a web application.

http://groups.google.com/group/microsoft.public.dotnet.framework.webservices/browse_thread/thread/bb9f3db6230a04ed/3d342d8c40e6aede?lnk=st&q=Reporting+Services+referenced+account+locked+out&rnum=1&hl=en#3d342d8c40e6aede

Thanks for any assistance, anyone can give me.

|||Open the datasource properties and make sure that credentials are either "Credentials stored securely in report server" or "Windows integrated security"|||Also make sure that you have a fully qualified user name, i.e. domain\username or machine\username.|||

If the suggestions above don't fix this error, try to update the password for the unattended execution account: rsconfig.exe -e ... - or through the RsConfigTool in RS 2005

Thanks

tudor

|||

I follow this thread and found the source of my problem. I had lost the execution account definition. when I restored that in reporting Services Configuration manager, the login failures stopped.

thank you

Tebby Wafer

|||Just an FYI. I had the very same problem, but in order to correct, I had to remove the execution account credentials. After doing so, my reports worked again. I'll try re-adding the execution account again at a later time if needed.|||I also had this problem on a development machine and it appeared to be because the password had changed on the Execution Account (it had been set as a user account). To resolve the problem I had to change the stored password on the execution account by going into the Reporting Services Configuration Manager (under Configuration Tools in the Start Menu) and clicking on the Execution Account option. You can change the account or reset the password here.|||I am experiencing the same issue with SSRS and Windows 2003 I now have WMI errors and the reinstallation of SSRS is a nightmare which I still haven't solved yet. This is just POOR product service by Microsoft. I am so frustrated I am considering discontinuing all reporting services and switch to another reporting platform.|||I was having a similar error just viewing a report. Reconfiguring the Execution Account solved my problem as well.|||

Hello, I am new to MS CRm and everything. Where can i find this execution account ?

Kumail

(Report Model Deployment Error) The value of parameter 'DataSources' is not valid

I've got a report model I am trying to move from a development server to a production server. I published it to my development RS, exported the SMDL file, then uploaded it to the production server. At that point, I tried assigning the data source to the model and got the error:

The value of parameter 'DataSources' is not valid in the browser.
Looking in the logs, the following trace is there:

w3wp!library!7!12/12/2005-13:23:00:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.LogonFailedException: Logon failed., ;
Info: Microsoft.ReportingServices.Diagnostics.Utilities.LogonFailedException: Logon failed. > System.Runtime.InteropServices.COMException (0x8007052E): Logon failure: unknown user name or bad password. (Exception from HRESULT: 0x8007052E)
at System.Runtime.InteropServices.Marshal.ThrowExceptionForHRInternal(Int32 errorCode, IntPtr errorInfo)
at RSRemoteRpcClient.RemoteLogon.GetRemoteImpToken(String pRPCEndpointName, Int32 type, Guid dataSourceId, String pUserName, String pDomain, String pPassword)
at Microsoft.ReportingServices.Diagnostics.ImpersonationContext.Login(CredentialsType credType, Guid dataSourceId, String userName, String userPwd, String domain)
End of inner exception stack trace
w3wp!webserver!7!12/12/2005-13:23:00:: e ERROR: Reporting Services error Microsoft.ReportingServices.Diagnostics.Utilities.RSException: Logon failed. > Microsoft.ReportingServices.Diagnostics.Utilities.LogonFailedException: Logon failed. > System.Runtime.InteropServices.COMException: Logon failure: unknown user name or bad password. (Exception from HRESULT: 0x8007052E)
w3wp!library!5!12/12/2005-13:23:49:: i INFO: Call to GetPermissions:/ADS Reports/Production Data Sources/ADS
w3wp!library!1!12/12/2005-13:23:49:: i INFO: Call to GetSystemPermissions
w3wp!library!7!12/12/2005-13:23:50:: i INFO: Call to GetPermissions:/ADS Reports/Production Data Sources/ADS
w3wp!library!7!12/12/2005-13:23:51:: i INFO: Call to GetSystemPermissions
w3wp!library!5!12/12/2005-13:23:52:: i INFO: Call to GetPermissions:/ADS Reports/Production Data Sources/ADS
w3wp!library!5!12/12/2005-13:23:52:: i INFO: Call to GetSystemPermissions
w3wp!library!5!12/12/2005-13:23:52:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.InvalidParameterException: The value of parameter 'DataSources' is not valid., ;
Info: Microsoft.ReportingServices.Diagnostics.Utilities.InvalidParameterException: The value of parameter 'DataSources' is not valid.
w3wp!library!7!12/12/2005-13:30:18:: Using folder C:\Program Files\Microsoft SQL Server 2005\MSSQL.3\Reporting Services\RSTempFiles for temporary files.
w3wp!library!7!12/12/2005-13:30:18:: i INFO: Cleaned 0 batch records, 0 policies, 1 sessions, 0 cache entries, 1 snapshots, 1 chunks, 0 running jobs, 0 persisted streams

The problem is that the data source is selected to be Integrated Windows Authentication, so I'm a bit confused as to what's up with the model.

PS I am local admin on the machine as well as System Admin for reporting services.

I have a similar problem. I do not yet have a resolution:

Can't call reports from Report Manager.

I've installed Reporting Services 2005 on a Windows 2003 Server. The server has a successful side by side install of VS2003 and VS2005 and a successful side by side install of SQL Server 2000 and SQL Server 2005. It also is a Domain Controller [I know that this is suboptimal, but I don't have enough machines to avoid this right now]. I am Domain Administrator and did the install as domain admin. Also, the domain admin account is the default dbo for the SQLServer 2005 install. I followed a default install of Reporting Services [under the default web site] and it worked properly. I then had an issue where I needed another site under the default web site to use ASP.NET 1.1, so I moved the Reporting Services website to a separate web site with a distinct assigned IP. I did this by "hand" in the IIS Manager. Since then I've had a rsLogonFailed error when trying to access reports from the Report Server. I reinstalled Reporting Services, but got a cryptic message indicating that the deinstall was not perfectly clean.

Since I really don't want to launch a major rebuilding effort on this computer, I've been trying to find the special sauce to put this back together again. I've adjusted the Reporting Services Configuration, the ASP.NET application pools, and the SQL DB logins and permissions. No success.

The executionlog table in the ReportServer$SQLServer2005 database records the failed logins. It indentifies the UserName and the status "rsLogonFailed", along with the reportID, timestamp, etc.

I have noticed, via Google, other users having similar problems. For instance, someone trying to establish an email subscription has an rsLogonFailed problem at: http://www.sqltalk.org/ftopic7220.html

Here is my trace:

w3wp!chunks!5!12/18/2005-22:19:49:: v VERBOSE: ### CopyImages(d221ebad-7547-4c48-9324-90a21d66a168,715a6af3-dd95-44f7-b3c5-c660f3c3393f)
w3wp!library!5!12/18/2005-22:19:49:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.LogonFailedException: Logon failed., ;
Info: Microsoft.ReportingServices.Diagnostics.Utilities.LogonFailedException: Logon failed. > System.Runtime.InteropServices.COMException (0x8007052E): Logon failure: unknown user name or bad password. (Exception from HRESULT: 0x8007052E)
at System.Runtime.InteropServices.Marshal.ThrowExceptionForHRInternal(Int32 errorCode, IntPtr errorInfo)
at RSRemoteRpcClient.RemoteLogon.GetRemoteImpToken(String pRPCEndpointName, Int32 type, Guid dataSourceId, String pUserName, String pDomain, String pPassword)
at Microsoft.ReportingServices.Diagnostics.ImpersonationContext.Login(CredentialsType credType, Guid dataSourceId, String userName, String userPwd, String domain)
End of inner exception stack trace
w3wp!library!5!12/18/2005-22:19:49:: v VERBOSE: Transaction rollback.
w3wp!dbcleanup!5!12/18/2005-22:25:28:: v VERBOSE: Starting database cleanup.

The error that you are getting is the closest to mine that I've seen on the net. Does anyone have any ideas?

Best,

Mike

|||

Have you received any solution for this problem? I am having the same problem and in desparate need for a fix.

I heard from the below site/comments that there is a problem with SQL Reporting Services 2005 and Windows Server 2003 SP1.

Apparently there are some issues with Windows 2003 when trying to
impersonate a user to a remote resource. We stumbled across a similar issue
when using SQL Reporting Services hosted on Windows 2003. We reinstalled the
entire reporting environment onto a Windows 2000 Server and the problem
immediately disappeared. These issues related to security problems access
resources on remote machines via a web application.

http://groups.google.com/group/microsoft.public.dotnet.framework.webservices/browse_thread/thread/bb9f3db6230a04ed/3d342d8c40e6aede?lnk=st&q=Reporting+Services+referenced+account+locked+out&rnum=1&hl=en#3d342d8c40e6aede

Thanks for any assistance, anyone can give me.

|||Open the datasource properties and make sure that credentials are either "Credentials stored securely in report server" or "Windows integrated security"|||Also make sure that you have a fully qualified user name, i.e. domain\username or machine\username.|||

If the suggestions above don't fix this error, try to update the password for the unattended execution account: rsconfig.exe -e ... - or through the RsConfigTool in RS 2005

Thanks

tudor

|||

I follow this thread and found the source of my problem. I had lost the execution account definition. when I restored that in reporting Services Configuration manager, the login failures stopped.

thank you

Tebby Wafer

|||Just an FYI. I had the very same problem, but in order to correct, I had to remove the execution account credentials. After doing so, my reports worked again. I'll try re-adding the execution account again at a later time if needed.|||I also had this problem on a development machine and it appeared to be because the password had changed on the Execution Account (it had been set as a user account). To resolve the problem I had to change the stored password on the execution account by going into the Reporting Services Configuration Manager (under Configuration Tools in the Start Menu) and clicking on the Execution Account option. You can change the account or reset the password here.|||I am experiencing the same issue with SSRS and Windows 2003 I now have WMI errors and the reinstallation of SSRS is a nightmare which I still haven't solved yet. This is just POOR product service by Microsoft. I am so frustrated I am considering discontinuing all reporting services and switch to another reporting platform.|||I was having a similar error just viewing a report. Reconfiguring the Execution Account solved my problem as well.|||

Hello, I am new to MS CRm and everything. Where can i find this execution account ?

Kumail

(Report Model Deployment Error) The value of parameter 'DataSources' is not valid

I've got a report model I am trying to move from a development server to a production server. I published it to my development RS, exported the SMDL file, then uploaded it to the production server. At that point, I tried assigning the data source to the model and got the error:

The value of parameter 'DataSources' is not valid in the browser.
Looking in the logs, the following trace is there:

w3wp!library!7!12/12/2005-13:23:00:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.LogonFailedException: Logon failed., ;
Info: Microsoft.ReportingServices.Diagnostics.Utilities.LogonFailedException: Logon failed. > System.Runtime.InteropServices.COMException (0x8007052E): Logon failure: unknown user name or bad password. (Exception from HRESULT: 0x8007052E)
at System.Runtime.InteropServices.Marshal.ThrowExceptionForHRInternal(Int32 errorCode, IntPtr errorInfo)
at RSRemoteRpcClient.RemoteLogon.GetRemoteImpToken(String pRPCEndpointName, Int32 type, Guid dataSourceId, String pUserName, String pDomain, String pPassword)
at Microsoft.ReportingServices.Diagnostics.ImpersonationContext.Login(CredentialsType credType, Guid dataSourceId, String userName, String userPwd, String domain)
End of inner exception stack trace
w3wp!webserver!7!12/12/2005-13:23:00:: e ERROR: Reporting Services error Microsoft.ReportingServices.Diagnostics.Utilities.RSException: Logon failed. > Microsoft.ReportingServices.Diagnostics.Utilities.LogonFailedException: Logon failed. > System.Runtime.InteropServices.COMException: Logon failure: unknown user name or bad password. (Exception from HRESULT: 0x8007052E)
w3wp!library!5!12/12/2005-13:23:49:: i INFO: Call to GetPermissions:/ADS Reports/Production Data Sources/ADS
w3wp!library!1!12/12/2005-13:23:49:: i INFO: Call to GetSystemPermissions
w3wp!library!7!12/12/2005-13:23:50:: i INFO: Call to GetPermissions:/ADS Reports/Production Data Sources/ADS
w3wp!library!7!12/12/2005-13:23:51:: i INFO: Call to GetSystemPermissions
w3wp!library!5!12/12/2005-13:23:52:: i INFO: Call to GetPermissions:/ADS Reports/Production Data Sources/ADS
w3wp!library!5!12/12/2005-13:23:52:: i INFO: Call to GetSystemPermissions
w3wp!library!5!12/12/2005-13:23:52:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.InvalidParameterException: The value of parameter 'DataSources' is not valid., ;
Info: Microsoft.ReportingServices.Diagnostics.Utilities.InvalidParameterException: The value of parameter 'DataSources' is not valid.
w3wp!library!7!12/12/2005-13:30:18:: Using folder C:\Program Files\Microsoft SQL Server 2005\MSSQL.3\Reporting Services\RSTempFiles for temporary files.
w3wp!library!7!12/12/2005-13:30:18:: i INFO: Cleaned 0 batch records, 0 policies, 1 sessions, 0 cache entries, 1 snapshots, 1 chunks, 0 running jobs, 0 persisted streams

The problem is that the data source is selected to be Integrated Windows Authentication, so I'm a bit confused as to what's up with the model.

PS I am local admin on the machine as well as System Admin for reporting services.

I have a similar problem. I do not yet have a resolution:

Can't call reports from Report Manager.

I've installed Reporting Services 2005 on a Windows 2003 Server. The server has a successful side by side install of VS2003 and VS2005 and a successful side by side install of SQL Server 2000 and SQL Server 2005. It also is a Domain Controller [I know that this is suboptimal, but I don't have enough machines to avoid this right now]. I am Domain Administrator and did the install as domain admin. Also, the domain admin account is the default dbo for the SQLServer 2005 install. I followed a default install of Reporting Services [under the default web site] and it worked properly. I then had an issue where I needed another site under the default web site to use ASP.NET 1.1, so I moved the Reporting Services website to a separate web site with a distinct assigned IP. I did this by "hand" in the IIS Manager. Since then I've had a rsLogonFailed error when trying to access reports from the Report Server. I reinstalled Reporting Services, but got a cryptic message indicating that the deinstall was not perfectly clean.

Since I really don't want to launch a major rebuilding effort on this computer, I've been trying to find the special sauce to put this back together again. I've adjusted the Reporting Services Configuration, the ASP.NET application pools, and the SQL DB logins and permissions. No success.

The executionlog table in the ReportServer$SQLServer2005 database records the failed logins. It indentifies the UserName and the status "rsLogonFailed", along with the reportID, timestamp, etc.

I have noticed, via Google, other users having similar problems. For instance, someone trying to establish an email subscription has an rsLogonFailed problem at: http://www.sqltalk.org/ftopic7220.html

Here is my trace:

w3wp!chunks!5!12/18/2005-22:19:49:: v VERBOSE: ### CopyImages(d221ebad-7547-4c48-9324-90a21d66a168,715a6af3-dd95-44f7-b3c5-c660f3c3393f)
w3wp!library!5!12/18/2005-22:19:49:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.LogonFailedException: Logon failed., ;
Info: Microsoft.ReportingServices.Diagnostics.Utilities.LogonFailedException: Logon failed. > System.Runtime.InteropServices.COMException (0x8007052E): Logon failure: unknown user name or bad password. (Exception from HRESULT: 0x8007052E)
at System.Runtime.InteropServices.Marshal.ThrowExceptionForHRInternal(Int32 errorCode, IntPtr errorInfo)
at RSRemoteRpcClient.RemoteLogon.GetRemoteImpToken(String pRPCEndpointName, Int32 type, Guid dataSourceId, String pUserName, String pDomain, String pPassword)
at Microsoft.ReportingServices.Diagnostics.ImpersonationContext.Login(CredentialsType credType, Guid dataSourceId, String userName, String userPwd, String domain)
End of inner exception stack trace
w3wp!library!5!12/18/2005-22:19:49:: v VERBOSE: Transaction rollback.
w3wp!dbcleanup!5!12/18/2005-22:25:28:: v VERBOSE: Starting database cleanup.

The error that you are getting is the closest to mine that I've seen on the net. Does anyone have any ideas?

Best,

Mike

|||

Have you received any solution for this problem? I am having the same problem and in desparate need for a fix.

I heard from the below site/comments that there is a problem with SQL Reporting Services 2005 and Windows Server 2003 SP1.

Apparently there are some issues with Windows 2003 when trying to
impersonate a user to a remote resource. We stumbled across a similar issue
when using SQL Reporting Services hosted on Windows 2003. We reinstalled the
entire reporting environment onto a Windows 2000 Server and the problem
immediately disappeared. These issues related to security problems access
resources on remote machines via a web application.

http://groups.google.com/group/microsoft.public.dotnet.framework.webservices/browse_thread/thread/bb9f3db6230a04ed/3d342d8c40e6aede?lnk=st&q=Reporting+Services+referenced+account+locked+out&rnum=1&hl=en#3d342d8c40e6aede

Thanks for any assistance, anyone can give me.

|||Open the datasource properties and make sure that credentials are either "Credentials stored securely in report server" or "Windows integrated security"|||Also make sure that you have a fully qualified user name, i.e. domain\username or machine\username.|||

If the suggestions above don't fix this error, try to update the password for the unattended execution account: rsconfig.exe -e ... - or through the RsConfigTool in RS 2005

Thanks

tudor

|||

I follow this thread and found the source of my problem. I had lost the execution account definition. when I restored that in reporting Services Configuration manager, the login failures stopped.

thank you

Tebby Wafer

|||Just an FYI. I had the very same problem, but in order to correct, I had to remove the execution account credentials. After doing so, my reports worked again. I'll try re-adding the execution account again at a later time if needed.|||I also had this problem on a development machine and it appeared to be because the password had changed on the Execution Account (it had been set as a user account). To resolve the problem I had to change the stored password on the execution account by going into the Reporting Services Configuration Manager (under Configuration Tools in the Start Menu) and clicking on the Execution Account option. You can change the account or reset the password here.|||I am experiencing the same issue with SSRS and Windows 2003 I now have WMI errors and the reinstallation of SSRS is a nightmare which I still haven't solved yet. This is just POOR product service by Microsoft. I am so frustrated I am considering discontinuing all reporting services and switch to another reporting platform.|||I was having a similar error just viewing a report. Reconfiguring the Execution Account solved my problem as well.|||

Hello, I am new to MS CRm and everything. Where can i find this execution account ?

Kumail

(Report Model Deployment Error) The value of parameter 'DataSources' is not valid

I've got a report model I am trying to move from a development server to a production server. I published it to my development RS, exported the SMDL file, then uploaded it to the production server. At that point, I tried assigning the data source to the model and got the error:

The value of parameter 'DataSources' is not valid in the browser.
Looking in the logs, the following trace is there:

w3wp!library!7!12/12/2005-13:23:00:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.LogonFailedException: Logon failed., ;
Info: Microsoft.ReportingServices.Diagnostics.Utilities.LogonFailedException: Logon failed. > System.Runtime.InteropServices.COMException (0x8007052E): Logon failure: unknown user name or bad password. (Exception from HRESULT: 0x8007052E)
at System.Runtime.InteropServices.Marshal.ThrowExceptionForHRInternal(Int32 errorCode, IntPtr errorInfo)
at RSRemoteRpcClient.RemoteLogon.GetRemoteImpToken(String pRPCEndpointName, Int32 type, Guid dataSourceId, String pUserName, String pDomain, String pPassword)
at Microsoft.ReportingServices.Diagnostics.ImpersonationContext.Login(CredentialsType credType, Guid dataSourceId, String userName, String userPwd, String domain)
End of inner exception stack trace
w3wp!webserver!7!12/12/2005-13:23:00:: e ERROR: Reporting Services error Microsoft.ReportingServices.Diagnostics.Utilities.RSException: Logon failed. > Microsoft.ReportingServices.Diagnostics.Utilities.LogonFailedException: Logon failed. > System.Runtime.InteropServices.COMException: Logon failure: unknown user name or bad password. (Exception from HRESULT: 0x8007052E)
w3wp!library!5!12/12/2005-13:23:49:: i INFO: Call to GetPermissions:/ADS Reports/Production Data Sources/ADS
w3wp!library!1!12/12/2005-13:23:49:: i INFO: Call to GetSystemPermissions
w3wp!library!7!12/12/2005-13:23:50:: i INFO: Call to GetPermissions:/ADS Reports/Production Data Sources/ADS
w3wp!library!7!12/12/2005-13:23:51:: i INFO: Call to GetSystemPermissions
w3wp!library!5!12/12/2005-13:23:52:: i INFO: Call to GetPermissions:/ADS Reports/Production Data Sources/ADS
w3wp!library!5!12/12/2005-13:23:52:: i INFO: Call to GetSystemPermissions
w3wp!library!5!12/12/2005-13:23:52:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.InvalidParameterException: The value of parameter 'DataSources' is not valid., ;
Info: Microsoft.ReportingServices.Diagnostics.Utilities.InvalidParameterException: The value of parameter 'DataSources' is not valid.
w3wp!library!7!12/12/2005-13:30:18:: Using folder C:\Program Files\Microsoft SQL Server 2005\MSSQL.3\Reporting Services\RSTempFiles for temporary files.
w3wp!library!7!12/12/2005-13:30:18:: i INFO: Cleaned 0 batch records, 0 policies, 1 sessions, 0 cache entries, 1 snapshots, 1 chunks, 0 running jobs, 0 persisted streams

The problem is that the data source is selected to be Integrated Windows Authentication, so I'm a bit confused as to what's up with the model.

PS I am local admin on the machine as well as System Admin for reporting services.

I have a similar problem. I do not yet have a resolution:

Can't call reports from Report Manager.

I've installed Reporting Services 2005 on a Windows 2003 Server. The server has a successful side by side install of VS2003 and VS2005 and a successful side by side install of SQL Server 2000 and SQL Server 2005. It also is a Domain Controller [I know that this is suboptimal, but I don't have enough machines to avoid this right now]. I am Domain Administrator and did the install as domain admin. Also, the domain admin account is the default dbo for the SQLServer 2005 install. I followed a default install of Reporting Services [under the default web site] and it worked properly. I then had an issue where I needed another site under the default web site to use ASP.NET 1.1, so I moved the Reporting Services website to a separate web site with a distinct assigned IP. I did this by "hand" in the IIS Manager. Since then I've had a rsLogonFailed error when trying to access reports from the Report Server. I reinstalled Reporting Services, but got a cryptic message indicating that the deinstall was not perfectly clean.

Since I really don't want to launch a major rebuilding effort on this computer, I've been trying to find the special sauce to put this back together again. I've adjusted the Reporting Services Configuration, the ASP.NET application pools, and the SQL DB logins and permissions. No success.

The executionlog table in the ReportServer$SQLServer2005 database records the failed logins. It indentifies the UserName and the status "rsLogonFailed", along with the reportID, timestamp, etc.

I have noticed, via Google, other users having similar problems. For instance, someone trying to establish an email subscription has an rsLogonFailed problem at: http://www.sqltalk.org/ftopic7220.html

Here is my trace:

w3wp!chunks!5!12/18/2005-22:19:49:: v VERBOSE: ### CopyImages(d221ebad-7547-4c48-9324-90a21d66a168,715a6af3-dd95-44f7-b3c5-c660f3c3393f)
w3wp!library!5!12/18/2005-22:19:49:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.LogonFailedException: Logon failed., ;
Info: Microsoft.ReportingServices.Diagnostics.Utilities.LogonFailedException: Logon failed. > System.Runtime.InteropServices.COMException (0x8007052E): Logon failure: unknown user name or bad password. (Exception from HRESULT: 0x8007052E)
at System.Runtime.InteropServices.Marshal.ThrowExceptionForHRInternal(Int32 errorCode, IntPtr errorInfo)
at RSRemoteRpcClient.RemoteLogon.GetRemoteImpToken(String pRPCEndpointName, Int32 type, Guid dataSourceId, String pUserName, String pDomain, String pPassword)
at Microsoft.ReportingServices.Diagnostics.ImpersonationContext.Login(CredentialsType credType, Guid dataSourceId, String userName, String userPwd, String domain)
End of inner exception stack trace
w3wp!library!5!12/18/2005-22:19:49:: v VERBOSE: Transaction rollback.
w3wp!dbcleanup!5!12/18/2005-22:25:28:: v VERBOSE: Starting database cleanup.

The error that you are getting is the closest to mine that I've seen on the net. Does anyone have any ideas?

Best,

Mike

|||

Have you received any solution for this problem? I am having the same problem and in desparate need for a fix.

I heard from the below site/comments that there is a problem with SQL Reporting Services 2005 and Windows Server 2003 SP1.

Apparently there are some issues with Windows 2003 when trying to
impersonate a user to a remote resource. We stumbled across a similar issue
when using SQL Reporting Services hosted on Windows 2003. We reinstalled the
entire reporting environment onto a Windows 2000 Server and the problem
immediately disappeared. These issues related to security problems access
resources on remote machines via a web application.

http://groups.google.com/group/microsoft.public.dotnet.framework.webservices/browse_thread/thread/bb9f3db6230a04ed/3d342d8c40e6aede?lnk=st&q=Reporting+Services+referenced+account+locked+out&rnum=1&hl=en#3d342d8c40e6aede

Thanks for any assistance, anyone can give me.

|||Open the datasource properties and make sure that credentials are either "Credentials stored securely in report server" or "Windows integrated security"|||Also make sure that you have a fully qualified user name, i.e. domain\username or machine\username.|||

If the suggestions above don't fix this error, try to update the password for the unattended execution account: rsconfig.exe -e ... - or through the RsConfigTool in RS 2005

Thanks

tudor

|||

I follow this thread and found the source of my problem. I had lost the execution account definition. when I restored that in reporting Services Configuration manager, the login failures stopped.

thank you

Tebby Wafer

|||Just an FYI. I had the very same problem, but in order to correct, I had to remove the execution account credentials. After doing so, my reports worked again. I'll try re-adding the execution account again at a later time if needed.|||I also had this problem on a development machine and it appeared to be because the password had changed on the Execution Account (it had been set as a user account). To resolve the problem I had to change the stored password on the execution account by going into the Reporting Services Configuration Manager (under Configuration Tools in the Start Menu) and clicking on the Execution Account option. You can change the account or reset the password here.|||I am experiencing the same issue with SSRS and Windows 2003 I now have WMI errors and the reinstallation of SSRS is a nightmare which I still haven't solved yet. This is just POOR product service by Microsoft. I am so frustrated I am considering discontinuing all reporting services and switch to another reporting platform.|||I was having a similar error just viewing a report. Reconfiguring the Execution Account solved my problem as well.|||

Hello, I am new to MS CRm and everything. Where can i find this execution account ?

Kumail

(Report Model Deployment Error) The value of parameter 'DataSources' is not valid

I've got a report model I am trying to move from a development server to a production server. I published it to my development RS, exported the SMDL file, then uploaded it to the production server. At that point, I tried assigning the data source to the model and got the error:

The value of parameter 'DataSources' is not valid in the browser.
Looking in the logs, the following trace is there:

w3wp!library!7!12/12/2005-13:23:00:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.LogonFailedException: Logon failed., ;
Info: Microsoft.ReportingServices.Diagnostics.Utilities.LogonFailedException: Logon failed. > System.Runtime.InteropServices.COMException (0x8007052E): Logon failure: unknown user name or bad password. (Exception from HRESULT: 0x8007052E)
at System.Runtime.InteropServices.Marshal.ThrowExceptionForHRInternal(Int32 errorCode, IntPtr errorInfo)
at RSRemoteRpcClient.RemoteLogon.GetRemoteImpToken(String pRPCEndpointName, Int32 type, Guid dataSourceId, String pUserName, String pDomain, String pPassword)
at Microsoft.ReportingServices.Diagnostics.ImpersonationContext.Login(CredentialsType credType, Guid dataSourceId, String userName, String userPwd, String domain)
End of inner exception stack trace
w3wp!webserver!7!12/12/2005-13:23:00:: e ERROR: Reporting Services error Microsoft.ReportingServices.Diagnostics.Utilities.RSException: Logon failed. > Microsoft.ReportingServices.Diagnostics.Utilities.LogonFailedException: Logon failed. > System.Runtime.InteropServices.COMException: Logon failure: unknown user name or bad password. (Exception from HRESULT: 0x8007052E)
w3wp!library!5!12/12/2005-13:23:49:: i INFO: Call to GetPermissions:/ADS Reports/Production Data Sources/ADS
w3wp!library!1!12/12/2005-13:23:49:: i INFO: Call to GetSystemPermissions
w3wp!library!7!12/12/2005-13:23:50:: i INFO: Call to GetPermissions:/ADS Reports/Production Data Sources/ADS
w3wp!library!7!12/12/2005-13:23:51:: i INFO: Call to GetSystemPermissions
w3wp!library!5!12/12/2005-13:23:52:: i INFO: Call to GetPermissions:/ADS Reports/Production Data Sources/ADS
w3wp!library!5!12/12/2005-13:23:52:: i INFO: Call to GetSystemPermissions
w3wp!library!5!12/12/2005-13:23:52:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.InvalidParameterException: The value of parameter 'DataSources' is not valid., ;
Info: Microsoft.ReportingServices.Diagnostics.Utilities.InvalidParameterException: The value of parameter 'DataSources' is not valid.
w3wp!library!7!12/12/2005-13:30:18:: Using folder C:\Program Files\Microsoft SQL Server 2005\MSSQL.3\Reporting Services\RSTempFiles for temporary files.
w3wp!library!7!12/12/2005-13:30:18:: i INFO: Cleaned 0 batch records, 0 policies, 1 sessions, 0 cache entries, 1 snapshots, 1 chunks, 0 running jobs, 0 persisted streams

The problem is that the data source is selected to be Integrated Windows Authentication, so I'm a bit confused as to what's up with the model.

PS I am local admin on the machine as well as System Admin for reporting services.

I have a similar problem. I do not yet have a resolution:

Can't call reports from Report Manager.

I've installed Reporting Services 2005 on a Windows 2003 Server. The server has a successful side by side install of VS2003 and VS2005 and a successful side by side install of SQL Server 2000 and SQL Server 2005. It also is a Domain Controller [I know that this is suboptimal, but I don't have enough machines to avoid this right now]. I am Domain Administrator and did the install as domain admin. Also, the domain admin account is the default dbo for the SQLServer 2005 install. I followed a default install of Reporting Services [under the default web site] and it worked properly. I then had an issue where I needed another site under the default web site to use ASP.NET 1.1, so I moved the Reporting Services website to a separate web site with a distinct assigned IP. I did this by "hand" in the IIS Manager. Since then I've had a rsLogonFailed error when trying to access reports from the Report Server. I reinstalled Reporting Services, but got a cryptic message indicating that the deinstall was not perfectly clean.

Since I really don't want to launch a major rebuilding effort on this computer, I've been trying to find the special sauce to put this back together again. I've adjusted the Reporting Services Configuration, the ASP.NET application pools, and the SQL DB logins and permissions. No success.

The executionlog table in the ReportServer$SQLServer2005 database records the failed logins. It indentifies the UserName and the status "rsLogonFailed", along with the reportID, timestamp, etc.

I have noticed, via Google, other users having similar problems. For instance, someone trying to establish an email subscription has an rsLogonFailed problem at: http://www.sqltalk.org/ftopic7220.html

Here is my trace:

w3wp!chunks!5!12/18/2005-22:19:49:: v VERBOSE: ### CopyImages(d221ebad-7547-4c48-9324-90a21d66a168,715a6af3-dd95-44f7-b3c5-c660f3c3393f)
w3wp!library!5!12/18/2005-22:19:49:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.LogonFailedException: Logon failed., ;
Info: Microsoft.ReportingServices.Diagnostics.Utilities.LogonFailedException: Logon failed. > System.Runtime.InteropServices.COMException (0x8007052E): Logon failure: unknown user name or bad password. (Exception from HRESULT: 0x8007052E)
at System.Runtime.InteropServices.Marshal.ThrowExceptionForHRInternal(Int32 errorCode, IntPtr errorInfo)
at RSRemoteRpcClient.RemoteLogon.GetRemoteImpToken(String pRPCEndpointName, Int32 type, Guid dataSourceId, String pUserName, String pDomain, String pPassword)
at Microsoft.ReportingServices.Diagnostics.ImpersonationContext.Login(CredentialsType credType, Guid dataSourceId, String userName, String userPwd, String domain)
End of inner exception stack trace
w3wp!library!5!12/18/2005-22:19:49:: v VERBOSE: Transaction rollback.
w3wp!dbcleanup!5!12/18/2005-22:25:28:: v VERBOSE: Starting database cleanup.

The error that you are getting is the closest to mine that I've seen on the net. Does anyone have any ideas?

Best,

Mike

|||

Have you received any solution for this problem? I am having the same problem and in desparate need for a fix.

I heard from the below site/comments that there is a problem with SQL Reporting Services 2005 and Windows Server 2003 SP1.

Apparently there are some issues with Windows 2003 when trying to
impersonate a user to a remote resource. We stumbled across a similar issue
when using SQL Reporting Services hosted on Windows 2003. We reinstalled the
entire reporting environment onto a Windows 2000 Server and the problem
immediately disappeared. These issues related to security problems access
resources on remote machines via a web application.

http://groups.google.com/group/microsoft.public.dotnet.framework.webservices/browse_thread/thread/bb9f3db6230a04ed/3d342d8c40e6aede?lnk=st&q=Reporting+Services+referenced+account+locked+out&rnum=1&hl=en#3d342d8c40e6aede

Thanks for any assistance, anyone can give me.

|||Open the datasource properties and make sure that credentials are either "Credentials stored securely in report server" or "Windows integrated security"|||Also make sure that you have a fully qualified user name, i.e. domain\username or machine\username.|||

If the suggestions above don't fix this error, try to update the password for the unattended execution account: rsconfig.exe -e ... - or through the RsConfigTool in RS 2005

Thanks

tudor

|||

I follow this thread and found the source of my problem. I had lost the execution account definition. when I restored that in reporting Services Configuration manager, the login failures stopped.

thank you

Tebby Wafer

|||Just an FYI. I had the very same problem, but in order to correct, I had to remove the execution account credentials. After doing so, my reports worked again. I'll try re-adding the execution account again at a later time if needed.|||I also had this problem on a development machine and it appeared to be because the password had changed on the Execution Account (it had been set as a user account). To resolve the problem I had to change the stored password on the execution account by going into the Reporting Services Configuration Manager (under Configuration Tools in the Start Menu) and clicking on the Execution Account option. You can change the account or reset the password here.|||I am experiencing the same issue with SSRS and Windows 2003 I now have WMI errors and the reinstallation of SSRS is a nightmare which I still haven't solved yet. This is just POOR product service by Microsoft. I am so frustrated I am considering discontinuing all reporting services and switch to another reporting platform.|||I was having a similar error just viewing a report. Reconfiguring the Execution Account solved my problem as well.|||

Hello, I am new to MS CRm and everything. Where can i find this execution account ?

Kumail

(Report Model Deployment Error) The value of parameter 'DataSources' is not valid

I've got a report model I am trying to move from a development server to a production server. I published it to my development RS, exported the SMDL file, then uploaded it to the production server. At that point, I tried assigning the data source to the model and got the error:

The value of parameter 'DataSources' is not valid in the browser.
Looking in the logs, the following trace is there:

w3wp!library!7!12/12/2005-13:23:00:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.LogonFailedException: Logon failed., ;
Info: Microsoft.ReportingServices.Diagnostics.Utilities.LogonFailedException: Logon failed. > System.Runtime.InteropServices.COMException (0x8007052E): Logon failure: unknown user name or bad password. (Exception from HRESULT: 0x8007052E)
at System.Runtime.InteropServices.Marshal.ThrowExceptionForHRInternal(Int32 errorCode, IntPtr errorInfo)
at RSRemoteRpcClient.RemoteLogon.GetRemoteImpToken(String pRPCEndpointName, Int32 type, Guid dataSourceId, String pUserName, String pDomain, String pPassword)
at Microsoft.ReportingServices.Diagnostics.ImpersonationContext.Login(CredentialsType credType, Guid dataSourceId, String userName, String userPwd, String domain)
End of inner exception stack trace
w3wp!webserver!7!12/12/2005-13:23:00:: e ERROR: Reporting Services error Microsoft.ReportingServices.Diagnostics.Utilities.RSException: Logon failed. > Microsoft.ReportingServices.Diagnostics.Utilities.LogonFailedException: Logon failed. > System.Runtime.InteropServices.COMException: Logon failure: unknown user name or bad password. (Exception from HRESULT: 0x8007052E)
w3wp!library!5!12/12/2005-13:23:49:: i INFO: Call to GetPermissions:/ADS Reports/Production Data Sources/ADS
w3wp!library!1!12/12/2005-13:23:49:: i INFO: Call to GetSystemPermissions
w3wp!library!7!12/12/2005-13:23:50:: i INFO: Call to GetPermissions:/ADS Reports/Production Data Sources/ADS
w3wp!library!7!12/12/2005-13:23:51:: i INFO: Call to GetSystemPermissions
w3wp!library!5!12/12/2005-13:23:52:: i INFO: Call to GetPermissions:/ADS Reports/Production Data Sources/ADS
w3wp!library!5!12/12/2005-13:23:52:: i INFO: Call to GetSystemPermissions
w3wp!library!5!12/12/2005-13:23:52:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.InvalidParameterException: The value of parameter 'DataSources' is not valid., ;
Info: Microsoft.ReportingServices.Diagnostics.Utilities.InvalidParameterException: The value of parameter 'DataSources' is not valid.
w3wp!library!7!12/12/2005-13:30:18:: Using folder C:\Program Files\Microsoft SQL Server 2005\MSSQL.3\Reporting Services\RSTempFiles for temporary files.
w3wp!library!7!12/12/2005-13:30:18:: i INFO: Cleaned 0 batch records, 0 policies, 1 sessions, 0 cache entries, 1 snapshots, 1 chunks, 0 running jobs, 0 persisted streams

The problem is that the data source is selected to be Integrated Windows Authentication, so I'm a bit confused as to what's up with the model.

PS I am local admin on the machine as well as System Admin for reporting services.

I have a similar problem. I do not yet have a resolution:

Can't call reports from Report Manager.

I've installed Reporting Services 2005 on a Windows 2003 Server. The server has a successful side by side install of VS2003 and VS2005 and a successful side by side install of SQL Server 2000 and SQL Server 2005. It also is a Domain Controller [I know that this is suboptimal, but I don't have enough machines to avoid this right now]. I am Domain Administrator and did the install as domain admin. Also, the domain admin account is the default dbo for the SQLServer 2005 install. I followed a default install of Reporting Services [under the default web site] and it worked properly. I then had an issue where I needed another site under the default web site to use ASP.NET 1.1, so I moved the Reporting Services website to a separate web site with a distinct assigned IP. I did this by "hand" in the IIS Manager. Since then I've had a rsLogonFailed error when trying to access reports from the Report Server. I reinstalled Reporting Services, but got a cryptic message indicating that the deinstall was not perfectly clean.

Since I really don't want to launch a major rebuilding effort on this computer, I've been trying to find the special sauce to put this back together again. I've adjusted the Reporting Services Configuration, the ASP.NET application pools, and the SQL DB logins and permissions. No success.

The executionlog table in the ReportServer$SQLServer2005 database records the failed logins. It indentifies the UserName and the status "rsLogonFailed", along with the reportID, timestamp, etc.

I have noticed, via Google, other users having similar problems. For instance, someone trying to establish an email subscription has an rsLogonFailed problem at: http://www.sqltalk.org/ftopic7220.html

Here is my trace:

w3wp!chunks!5!12/18/2005-22:19:49:: v VERBOSE: ### CopyImages(d221ebad-7547-4c48-9324-90a21d66a168,715a6af3-dd95-44f7-b3c5-c660f3c3393f)
w3wp!library!5!12/18/2005-22:19:49:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.LogonFailedException: Logon failed., ;
Info: Microsoft.ReportingServices.Diagnostics.Utilities.LogonFailedException: Logon failed. > System.Runtime.InteropServices.COMException (0x8007052E): Logon failure: unknown user name or bad password. (Exception from HRESULT: 0x8007052E)
at System.Runtime.InteropServices.Marshal.ThrowExceptionForHRInternal(Int32 errorCode, IntPtr errorInfo)
at RSRemoteRpcClient.RemoteLogon.GetRemoteImpToken(String pRPCEndpointName, Int32 type, Guid dataSourceId, String pUserName, String pDomain, String pPassword)
at Microsoft.ReportingServices.Diagnostics.ImpersonationContext.Login(CredentialsType credType, Guid dataSourceId, String userName, String userPwd, String domain)
End of inner exception stack trace
w3wp!library!5!12/18/2005-22:19:49:: v VERBOSE: Transaction rollback.
w3wp!dbcleanup!5!12/18/2005-22:25:28:: v VERBOSE: Starting database cleanup.

The error that you are getting is the closest to mine that I've seen on the net. Does anyone have any ideas?

Best,

Mike

|||

Have you received any solution for this problem? I am having the same problem and in desparate need for a fix.

I heard from the below site/comments that there is a problem with SQL Reporting Services 2005 and Windows Server 2003 SP1.

Apparently there are some issues with Windows 2003 when trying to
impersonate a user to a remote resource. We stumbled across a similar issue
when using SQL Reporting Services hosted on Windows 2003. We reinstalled the
entire reporting environment onto a Windows 2000 Server and the problem
immediately disappeared. These issues related to security problems access
resources on remote machines via a web application.

http://groups.google.com/group/microsoft.public.dotnet.framework.webservices/browse_thread/thread/bb9f3db6230a04ed/3d342d8c40e6aede?lnk=st&q=Reporting+Services+referenced+account+locked+out&rnum=1&hl=en#3d342d8c40e6aede

Thanks for any assistance, anyone can give me.

|||Open the datasource properties and make sure that credentials are either "Credentials stored securely in report server" or "Windows integrated security"|||Also make sure that you have a fully qualified user name, i.e. domain\username or machine\username.|||

If the suggestions above don't fix this error, try to update the password for the unattended execution account: rsconfig.exe -e ... - or through the RsConfigTool in RS 2005

Thanks

tudor

|||

I follow this thread and found the source of my problem. I had lost the execution account definition. when I restored that in reporting Services Configuration manager, the login failures stopped.

thank you

Tebby Wafer

|||Just an FYI. I had the very same problem, but in order to correct, I had to remove the execution account credentials. After doing so, my reports worked again. I'll try re-adding the execution account again at a later time if needed.|||I also had this problem on a development machine and it appeared to be because the password had changed on the Execution Account (it had been set as a user account). To resolve the problem I had to change the stored password on the execution account by going into the Reporting Services Configuration Manager (under Configuration Tools in the Start Menu) and clicking on the Execution Account option. You can change the account or reset the password here.|||I am experiencing the same issue with SSRS and Windows 2003 I now have WMI errors and the reinstallation of SSRS is a nightmare which I still haven't solved yet. This is just POOR product service by Microsoft. I am so frustrated I am considering discontinuing all reporting services and switch to another reporting platform.|||I was having a similar error just viewing a report. Reconfiguring the Execution Account solved my problem as well.|||

Hello, I am new to MS CRm and everything. Where can i find this execution account ?

Kumail