Errors while producing reports to RS

Hi,
I am using form authentiacation.
everything is o.k with ReportServer browser i am able to loging on and
running the reports.
But when i am using the same username and password at the time of
producing reports to ReporServer it is not working.
why it is happenning?where i did mistake ?
And also while i am tring to open my ReportManager browser it is saying like
"The request failed with HTTP status 401: Access Denied. "
plz anybody can help me
thanksAre you creating a network credential object on your connection to report
server? This might help:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpref/html/frlrfsystemnetnetworkcredentialclasstopic.asp
-Lukasz
This posting is provided "AS IS" with no warranties, and confers no rights.
"simmi" <simmi@.discussions.microsoft.com> wrote in message
news:CED09F88-47B4-4630-804D-13358616645F@.microsoft.com...
> Hi,
> I am using form authentiacation.
> everything is o.k with ReportServer browser i am able to loging on and
> running the reports.
> But when i am using the same username and password at the time of
> producing reports to ReporServer it is not working.
> why it is happenning?where i did mistake ?
> And also while i am tring to open my ReportManager browser it is saying
> like
> "The request failed with HTTP status 401: Access Denied. "
> plz anybody can help me
> thanks
>
>|||Lukasz,
If Simmi is using Forms Auth he needs to authenticate using LogonUser ;-)
Something like:
ReportingServiceProxy.LogonUser(uid,pwd, null);
Simmi, you also should be able to debug the authentication process. The
forms auth white paper shows you how to do this...
--
Adrian M.
MCP
"Lukasz Pawlowski [MSFT]" <lukaszp@.online.microsoft.com> wrote in message
news:eRDBVQHGFHA.2568@.TK2MSFTNGP10.phx.gbl...
> Are you creating a network credential object on your connection to report
> server? This might help:
> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpref/html/frlrfsystemnetnetworkcredentialclasstopic.asp
> -Lukasz
>
> --
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
>
> "simmi" <simmi@.discussions.microsoft.com> wrote in message
> news:CED09F88-47B4-4630-804D-13358616645F@.microsoft.com...
>> Hi,
>> I am using form authentiacation.
>> everything is o.k with ReportServer browser i am able to loging on and
>> running the reports.
>> But when i am using the same username and password at the time of
>> producing reports to ReporServer it is not working.
>> why it is happenning?where i did mistake ?
>> And also while i am tring to open my ReportManager browser it is saying
>> like
>> "The request failed with HTTP status 401: Access Denied. "
>> plz anybody can help me
>> thanks
>>
>|||Hi,
in MSDN the author said enter ur username and password in "UILogon.aspx"
right?
i could't get where i have to add those.
and one question is should i have adminstrative privillages on IIS for this?
Thanks!
"Adrian M." wrote:
> Lukasz,
> If Simmi is using Forms Auth he needs to authenticate using LogonUser ;-)
> Something like:
> ReportingServiceProxy.LogonUser(uid,pwd, null);
> Simmi, you also should be able to debug the authentication process. The
> forms auth white paper shows you how to do this...
> --
> Adrian M.
> MCP
> "Lukasz Pawlowski [MSFT]" <lukaszp@.online.microsoft.com> wrote in message
> news:eRDBVQHGFHA.2568@.TK2MSFTNGP10.phx.gbl...
> > Are you creating a network credential object on your connection to report
> > server? This might help:
> >
> > http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpref/html/frlrfsystemnetnetworkcredentialclasstopic.asp
> >
> > -Lukasz
> >
> >
> > --
> > This posting is provided "AS IS" with no warranties, and confers no
> > rights.
> >
> >
> >
> > "simmi" <simmi@.discussions.microsoft.com> wrote in message
> > news:CED09F88-47B4-4630-804D-13358616645F@.microsoft.com...
> >> Hi,
> >> I am using form authentiacation.
> >> everything is o.k with ReportServer browser i am able to loging on and
> >> running the reports.
> >> But when i am using the same username and password at the time of
> >> producing reports to ReporServer it is not working.
> >>
> >> why it is happenning?where i did mistake ?
> >>
> >> And also while i am tring to open my ReportManager browser it is saying
> >> like
> >>
> >> "The request failed with HTTP status 401: Access Denied. "
> >>
> >> plz anybody can help me
> >>
> >> thanks
> >>
> >>
> >>
> >
> >
>
>

Errors in SQL Server 2005 Profiler

I notice this running the SQL Server Profiler under the application name Report Server. Every time it runs, it reports an error (in the Error field of Profiler). Does anyone know what this is?

declare @.p1 nvarchar(64)
set @.p1=NULL
exec GetDBVersion @.DBVersion=@.p1 output
select @.p1

Do you mean when running Reporting Service (or just an application named Report Server?), you found errors with the statements you post? If you're talking about Reporting Service, take a look at this post:

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=277072&SiteId=1

To understand the error, you may take a look at:

http://msdn2.microsoft.com/en-us/library/aa256379(SQL.80).aspx

Errors deploying and running reports

I am developing reports on my PC and deploying them to our server. My
PC only has reporting services client components while our server has
the client and server components installed.
Problem 1 :
when I deploy the solution to the server I get this error message:
"The underlying connection was closed: Could not establish trust
relationship with remote server."
Problem 2:
I have created a ASP.NET application on my PC that runs reports on the
server using the reporting service's web service. When I try and
render a report, I get this error message:
The request failed with HTTP status 404: Not Found.
Any help would really be appreciated
CraigIs your report server configured to use SSL? If so, you will need to use
FQDN (full domain name) of
the server in the report project's TargetServerURL property.
--
Ravi Mumulla (Microsoft)
SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Craig HB" <craighb@.bigfoot.com> wrote in message
news:3ba2292b.0407130651.71bf5d0c@.posting.google.com...
> I am developing reports on my PC and deploying them to our server. My
> PC only has reporting services client components while our server has
> the client and server components installed.
> Problem 1 :
> when I deploy the solution to the server I get this error message:
> "The underlying connection was closed: Could not establish trust
> relationship with remote server."
> Problem 2:
> I have created a ASP.NET application on my PC that runs reports on the
> server using the reporting service's web service. When I try and
> render a report, I get this error message:
> The request failed with HTTP status 404: Not Found.
> Any help would really be appreciated
> Craig

Error: Subreport could not be shown 2

Hi
I have a "master" report that has 10 chart sub reports that don't have any
parameter. I get a "Error: Subreport could not be shown" error if one of
them are snapshot based.
Any ideas?
Regards,
AndresOn Apr 14, 8:12 pm, "Andres" <andresfon...@.hotmail.com> wrote:
> Hi
> I have a "master" report that has 10 chart sub reports that don't have any
> parameter. I get a "Error: Subreport could not be shown" error if one of
> them are snapshot based.
> Any ideas?
> Regards,
> Andres
You might be able to resolve this error by returning a default empty
resultset. Also, make sure that all the dependencies of the subreport
are available (i.e., if you are developing reports in a development
environment and then need to transfer them to the production
environment along w/all dependent stored procedures, tables, etc).
Hope this helps.
Regards,
Enrique Martinez
Sr. Software Consultant|||Hi Enrique
Which report should return a default empty resultset?
And, what's a default empty resultset?
The main report don't have any resultset. I think sub reports have all they
need. They work fine when I use them directly in default mode (no snapshot)
and in snapshot mode.
Regards,
Andrés
"EMartinez" <emartinez.pr1@.gmail.com> wrote in message
news:1176659677.215808.157620@.e65g2000hsc.googlegroups.com...
> On Apr 14, 8:12 pm, "Andres" <andresfon...@.hotmail.com> wrote:
>> Hi
>> I have a "master" report that has 10 chart sub reports that don't have
>> any
>> parameter. I get a "Error: Subreport could not be shown" error if one of
>> them are snapshot based.
>> Any ideas?
>> Regards,
>> Andres
>
> You might be able to resolve this error by returning a default empty
> resultset. Also, make sure that all the dependencies of the subreport
> are available (i.e., if you are developing reports in a development
> environment and then need to transfer them to the production
> environment along w/all dependent stored procedures, tables, etc).
> Hope this helps.
> Regards,
> Enrique Martinez
> Sr. Software Consultant
>