Forms authentication sample

After successfully setting up RS on a Win2k server I've been trying to
get forms authentication sample working. I went through all the steps
given at
http://msdn.microsoft.com/sql/sqlwarehouse/reportingservices/default.aspx?pull=/library/en-us/dnsql2k/html/ufairs.asp
but when I get to the login page and try to register a user I get the
following:
An error occurred while attempting to add the account. SQL Server does
not exist or access denied.
I am having trouble finding any documentation on this. Has anyone run
into a similar problem before, and if so, what was the solution?See my other post regarding forms authentication and mixed security. Does
that solve the problem?
--
Cheers,
'(' Jeff A. Stucker
\
Business Intelligence
www.criadvantage.com
---
"Oleg Raskin" <oleg@.rhd.org> wrote in message
news:1103132329.322870.140150@.f14g2000cwb.googlegroups.com...
> After successfully setting up RS on a Win2k server I've been trying to
> get forms authentication sample working. I went through all the steps
> given at
> http://msdn.microsoft.com/sql/sqlwarehouse/reportingservices/default.aspx?pull=/library/en-us/dnsql2k/html/ufairs.asp
> but when I get to the login page and try to register a user I get the
> following:
> An error occurred while attempting to add the account. SQL Server does
> not exist or access denied.
> I am having trouble finding any documentation on this. Has anyone run
> into a similar problem before, and if so, what was the solution?
>sql

Forms Authentication sample

After successfully setting up RS on a Win2k server I've been trying to
get forms authentication sample working. I went through all the steps
given in the MSDN article but when I get to the login page and try to
register a user I get the following:
An error occurred while attempting to add the account. SQL Server does
not exist or access denied.
It's worth mentioning that RS and the database reside on 2 different
servers, but this setup was working just fine with NT-based
authentication.
I am having trouble finding any documentation on this. Has anyone run
into a similar problem before, and if so, what was the solution?
Thanks for any info.Hope you implemented your Custom Security correctly...
Try to debug -custom security- when trying to login.
b/w are you trying to login using using "Username" ?
I am able to get this(form authen) working in my last two projects and it
always works like a charm
"Oleg Raskin" wrote:
> After successfully setting up RS on a Win2k server I've been trying to
> get forms authentication sample working. I went through all the steps
> given in the MSDN article but when I get to the login page and try to
> register a user I get the following:
> An error occurred while attempting to add the account. SQL Server does
> not exist or access denied.
> It's worth mentioning that RS and the database reside on 2 different
> servers, but this setup was working just fine with NT-based
> authentication.
> I am having trouble finding any documentation on this. Has anyone run
> into a similar problem before, and if so, what was the solution?
> Thanks for any info.
>|||Is your database set to mixed security? I've had some problems with the
ReportServer service connecting to a database using SQL authentication until
I changed the Log On account (Control Panel > Administrative Tools >
Services > ReportServer) to an account that the database recognizes. I
know, that seems weird to me too, since I'm using SQL authentication for
this connection.
--
Cheers,
'(' Jeff A. Stucker
\
Business Intelligence
www.criadvantage.com
---
"Oleg Raskin" <oleg@.rhd.org> wrote in message
news:1103133182.531381.92650@.z14g2000cwz.googlegroups.com...
> After successfully setting up RS on a Win2k server I've been trying to
> get forms authentication sample working. I went through all the steps
> given in the MSDN article but when I get to the login page and try to
> register a user I get the following:
> An error occurred while attempting to add the account. SQL Server does
> not exist or access denied.
> It's worth mentioning that RS and the database reside on 2 different
> servers, but this setup was working just fine with NT-based
> authentication.
> I am having trouble finding any documentation on this. Has anyone run
> into a similar problem before, and if so, what was the solution?
> Thanks for any info.
>

Forms Authentication + Report Builder 2005

I've got Reporting Services 2005 successfully setup using the forms
authentication extension sample that ships with 2005, and have even got
Report Builder up and running having followed a workaround involving a
HTTP filter
(http://blogs.msdn.com/bimusings/archive/2005/11/29/497848.aspx).
The problem that I have is that I cannot view reports through Report
Builder as any user other than the default administrator, get the error
message:
The permissions granted to user '<formsuser>' are
insufficient for performing this operation. (rsAccessDenied)
Anyone any similar experiences? Any user can create and deploy reports
but it is only the admin that can view reports in Report Builder.
Thanks,
SiThis is exactly the behavior you should see if the user does not have
permission to the Execute Report Definitions system task. This permission is
required to view reports in Report Builder because RB executes the
(potentially modified) report definitions on-the-fly, without saving them to
the report server first.
If you go to Site Settings->Configure Site-wide Security in Report Manager,
you should be able to add your non-admin user to the System User role, which
has permission to the Execute Report Definitions task by default (unless you
upgraded your server from 2000, in which case you will need to add the
permission to the role manually).
Hope this helps!
"si.downes@.gmail.com" wrote:
> I've got Reporting Services 2005 successfully setup using the forms
> authentication extension sample that ships with 2005, and have even got
> Report Builder up and running having followed a workaround involving a
> HTTP filter
> (http://blogs.msdn.com/bimusings/archive/2005/11/29/497848.aspx).
> The problem that I have is that I cannot view reports through Report
> Builder as any user other than the default administrator, get the error
> message:
> The permissions granted to user '<formsuser>' are
> insufficient for performing this operation. (rsAccessDenied)
> Anyone any similar experiences? Any user can create and deploy reports
> but it is only the admin that can view reports in Report Builder.
> Thanks,
> Si
>|||that's fixed it. thanks!
Bob Meyers - MSFT wrote:
> This is exactly the behavior you should see if the user does not have
> permission to the Execute Report Definitions system task. This permission is
> required to view reports in Report Builder because RB executes the
> (potentially modified) report definitions on-the-fly, without saving them to
> the report server first.
> If you go to Site Settings->Configure Site-wide Security in Report Manager,
> you should be able to add your non-admin user to the System User role, which
> has permission to the Execute Report Definitions task by default (unless you
> upgraded your server from 2000, in which case you will need to add the
> permission to the role manually).
> Hope this helps!
> "si.downes@.gmail.com" wrote:
> > I've got Reporting Services 2005 successfully setup using the forms
> > authentication extension sample that ships with 2005, and have even got
> > Report Builder up and running having followed a workaround involving a
> > HTTP filter
> > (http://blogs.msdn.com/bimusings/archive/2005/11/29/497848.aspx).
> > The problem that I have is that I cannot view reports through Report
> > Builder as any user other than the default administrator, get the error
> > message:
> >
> > The permissions granted to user '<formsuser>' are
> > insufficient for performing this operation. (rsAccessDenied)
> >
> > Anyone any similar experiences? Any user can create and deploy reports
> > but it is only the admin that can view reports in Report Builder.
> >
> > Thanks,
> >
> > Si
> >
> >|||Si,
Are you having users access report builder from the internet? When using the
forms authentication is there any loss of features in reporting services? I
thought I read somewhere that if forms authentication was used, either not
all of the features of reporting services were available or you had to
manually do a lot of coding to enable all of the features. I may have
misunderstood the article however.
Thanks,
--
Dan D.
"si.downes@.gmail.com" wrote:
> that's fixed it. thanks!
> Bob Meyers - MSFT wrote:
> > This is exactly the behavior you should see if the user does not have
> > permission to the Execute Report Definitions system task. This permission is
> > required to view reports in Report Builder because RB executes the
> > (potentially modified) report definitions on-the-fly, without saving them to
> > the report server first.
> >
> > If you go to Site Settings->Configure Site-wide Security in Report Manager,
> > you should be able to add your non-admin user to the System User role, which
> > has permission to the Execute Report Definitions task by default (unless you
> > upgraded your server from 2000, in which case you will need to add the
> > permission to the role manually).
> >
> > Hope this helps!
> >
> > "si.downes@.gmail.com" wrote:
> >
> > > I've got Reporting Services 2005 successfully setup using the forms
> > > authentication extension sample that ships with 2005, and have even got
> > > Report Builder up and running having followed a workaround involving a
> > > HTTP filter
> > > (http://blogs.msdn.com/bimusings/archive/2005/11/29/497848.aspx).
> > > The problem that I have is that I cannot view reports through Report
> > > Builder as any user other than the default administrator, get the error
> > > message:
> > >
> > > The permissions granted to user '<formsuser>' are
> > > insufficient for performing this operation. (rsAccessDenied)
> > >
> > > Anyone any similar experiences? Any user can create and deploy reports
> > > but it is only the admin that can view reports in Report Builder.
> > >
> > > Thanks,
> > >
> > > Si
> > >
> > >
>

Forms Authentication

I've successfully set up RS to use Forms Authentication. However, here's
something strange. The first time I access Report Manager (say after a
reboot) and enter the admin credentials, RS churns and churns, then I end up
back at the login screen. If I enter the same credentials again, I get
logged in successfully.
Any one else experience this issue?
ThxAre you using the same server name to access the report server in your
browser as is set in the config files? If not, the cookie won't be getting
through due to cross-(web)domain security.
--
Cheers,
'(' Jeff A. Stucker
\
Business Intelligence
www.criadvantage.com
---
"FNDS" <absolutelynospam@.nodomain_.com> wrote in message
news:ezRzXl%239EHA.1396@.tk2msftngp13.phx.gbl...
> I've successfully set up RS to use Forms Authentication. However, here's
> something strange. The first time I access Report Manager (say after a
> reboot) and enter the admin credentials, RS churns and churns, then I end
> up back at the login screen. If I enter the same credentials again, I get
> logged in successfully.
> Any one else experience this issue?
> Thx
>|||"Jeff A. Stucker" <jeff@.mobilize.net> wrote in
news:ugC03WC#EHA.3708@.TK2MSFTNGP14.phx.gbl:
> Are you using the same server name to access the report server in your
> browser as is set in the config files? If not, the cookie won't be
> getting through due to cross-(web)domain security.
>
So, how do you address this issue in a hardware load balanced, web farm?
We have a single URL (domain) (ex. http://reporting.xxxxxxx.com/Reports)
but each machine naturally maintains a unique IP that I'm assuming is being
used by each machine when setting the cookie. The web.config files have
matching <machinekey> values to allow for Forms Auth in a web farm but I
don't know how to control the domain of the cookie.