Showing posts with label ssrs. Show all posts
Showing posts with label ssrs. Show all posts

Thursday, March 29, 2012

Error installing SSIS

Hello a try installing SQL Server 2005 CTP and have many problem: this install fail when try installing SSIS and SSRS teh error is not update NETWORK AUTHORITY\ IN LOCAL ACCOUNT, what happend? please help me!
MarcoPlease try setup forum, there might be people more qualified to help with setup problem in that forum.

http://forums.microsoft.com/msdn/ShowForum.aspx?ForumID=95

Wednesday, March 21, 2012

Error in SSRS Expressions

I am having an expression which is supposed to give me the values selected in a multivalued input parameter. I have tried following options however everytime it gives me error. Could someone let me know what might be the issue here.

1. Expression: =Parameters!i_Category.Label

Output: The Value expression used in textbox ‘textbox47’ returned a data type that is not valid.

2. Expression: =Parameters!i_Category.Label.ToString()

Output: System.Object[]

3. Expression: =CStr(Parameters!i_Category.Label)

Output: Error: Conversion from type 'String()' to type 'String' is not valid.

Take a look at this link for more information about parameters and working with multi-valued parameters.

http://msdn2.microsoft.com/en-us/library/aa337292.aspx|||Thanks Ian. It helped me a lot.

Sunday, February 26, 2012

Error in deployment of Reports

Hello,
I have built a report on SSRS 2005 and wanted to deploy that report as a
URL. However, it gives me an error which reads - "The permissions granted to
user '<Machine Name>\IUSR_<Machine Name>' are insufficient for performing
this operation. (rsAccessDenied)". Any idea whats causing this error. I get
the same message when I try to log on to http://localhost/reportserver.
The IIS on the machine has anonymous access enabled as well as Integrated
Windows Authentication.
Thanks.Bingo (anonymous access). You are not given the rights to deploy because you
are anonymous.
Turn off anonymous access on Reports and ReportServer webs.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Vince Keller" <siliinvestor@.hotmail.com> wrote in message
news:Ox1%23AujPGHA.532@.TK2MSFTNGP15.phx.gbl...
> Hello,
> I have built a report on SSRS 2005 and wanted to deploy that report as a
> URL. However, it gives me an error which reads - "The permissions granted
> to user '<Machine Name>\IUSR_<Machine Name>' are insufficient for
> performing this operation. (rsAccessDenied)". Any idea whats causing this
> error. I get the same message when I try to log on to
> http://localhost/reportserver.
> The IIS on the machine has anonymous access enabled as well as Integrated
> Windows Authentication.
> Thanks.
>|||That worked!
Thank you very much.
"Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
news:ubRl21jPGHA.4952@.TK2MSFTNGP09.phx.gbl...
> Bingo (anonymous access). You are not given the rights to deploy because
> you are anonymous.
> Turn off anonymous access on Reports and ReportServer webs.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Vince Keller" <siliinvestor@.hotmail.com> wrote in message
> news:Ox1%23AujPGHA.532@.TK2MSFTNGP15.phx.gbl...
>> Hello,
>> I have built a report on SSRS 2005 and wanted to deploy that report as a
>> URL. However, it gives me an error which reads - "The permissions granted
>> to user '<Machine Name>\IUSR_<Machine Name>' are insufficient for
>> performing this operation. (rsAccessDenied)". Any idea whats causing this
>> error. I get the same message when I try to log on to
>> http://localhost/reportserver.
>> The IIS on the machine has anonymous access enabled as well as Integrated
>> Windows Authentication.
>> Thanks.
>