Authentication hell report builder RS 2005

I started playing with VS 2005 and SQL 2005 to try to get ready to migrate
some of our apps. I ended up in authentication hell. I am trying to play
with it on my XP machine before I do some real world stuff.
I first tried the new report builder and was able to generate a data model
and build a report. But when I try to run it I get a logon failure with bad
user name and password.
So I thought I would fall back and create a rdl from VS and publish that
(i've done this hundreds of times in VS 2003). I am able to build the
report...preview it in VS. But I am unable to view in my browser
http://localhost...Again logon failure.
I checked IIS settings (I thought we did not need to do this in VS 2005? Ya
right). And it is using Windows Auth. but it is not identifying me correctly?
I tried enabling anonymous and setting the the anonymous account=to me but
that did not work either?
What am I missing?
Bill
--
Message posted via SQLMonster.com
http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server-reporting/200512/1I am also having this problem. I am able to create a connection, generate a
data model and am attempting to use the Report Builder application to design
a report. I am able to design the report, save it to the server but when I
use the "Run Report" from the Report Builder I receive:
"The permissions granted to user '<domain user>' are insufficient for
performing this operation. (rsAccessDenied)"
I am able to access the report from the RS web interface and run the report
without errors so it seems to be some sort of action that the "Run Report"
feature in the Report Builder client is making.
If any one has any suggestions please let me know as I cannot find any
solutions on line. Thanks.
"William N via SQLMonster.com" wrote:
> I started playing with VS 2005 and SQL 2005 to try to get ready to migrate
> some of our apps. I ended up in authentication hell. I am trying to play
> with it on my XP machine before I do some real world stuff.
> I first tried the new report builder and was able to generate a data model
> and build a report. But when I try to run it I get a logon failure with bad
> user name and password.
> So I thought I would fall back and create a rdl from VS and publish that
> (i've done this hundreds of times in VS 2003). I am able to build the
> report...preview it in VS. But I am unable to view in my browser
> http://localhost...Again logon failure.
> I checked IIS settings (I thought we did not need to do this in VS 2005? Ya
> right). And it is using Windows Auth. but it is not identifying me correctly?
> I tried enabling anonymous and setting the the anonymous account=to me but
> that did not work either?
> What am I missing?
> Bill
> --
> Message posted via SQLMonster.com
> http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server-reporting/200512/1
>