Need help configuring Report Server permissions

I can't seem to hit on the right combination of roles/persimssions to
set against the Report Server in order to allow my localhost
implementation to access/browse/upload reports. Is there some deFacto
setting(s) that I should be using?
After installation I was able to upload and browse. The trouble
started when I tried to instantiate a ReportingService object (I
wanted to be able to programatically browse the available reports -
previously uploaded). When I tried this I got an insufficient
privilege error for my generic internet user account. After having
tried a number of combinations I'm really stuck.
Any help appreciated! (how-to links, diagrams, recipes,...)
GlennGlenn,
The right question in this case is "Under what identity am I trying to call
the RS Web service?". For example, if it is from a WinForm app, you need to
set proxy credentials to DefaultCredentials, as follows:
rs.Credentials = System.Net.CredentialCache.DefaultCredentials
Please review the "Using the SOAP API in a Windows Application" and "Using
the SOAP API in a Web Application" for more info.
--
Hope this helps.
---
Teo Lachev, MCSD, MCT
Author: "Microsoft Reporting Services in Action"
http://www.prologika.com
"Glenn Owens" <gowens@.nixonpeabody.com> wrote in message
news:bc4291aa.0408121414.5d18bff0@.posting.google.com...
> I can't seem to hit on the right combination of roles/persimssions to
> set against the Report Server in order to allow my localhost
> implementation to access/browse/upload reports. Is there some deFacto
> setting(s) that I should be using?
> After installation I was able to upload and browse. The trouble
> started when I tried to instantiate a ReportingService object (I
> wanted to be able to programatically browse the available reports -
> previously uploaded). When I tried this I got an insufficient
> privilege error for my generic internet user account. After having
> tried a number of combinations I'm really stuck.
> Any help appreciated! (how-to links, diagrams, recipes,...)
> Glenn|||Teo, thanks for the response. I have read several of these how-to
articles (and have attempted to implement the code for my
application/WEB page). That's where I encounter the problems.
The article, which you reference, suggests adding impersonation to the
web.config... - already did that. It suggests setting the
ReportingService object credentials to the Default... - already did
that. There's not much else in the article (or others). What I'm
looking for is a little expertise on WEB/IIS 6.0 setup for using the
SQL Reporting Services in a XP Pro, VB.Net 1.1, SQL 2000 environment.
This can't that big a deal - but I'm swamped with other project issues
and have not had the time to research. I'm hoping that someone has
already gone through this and is willing to do some knowledge-sharing.
Thanks,
Glenn
"Teo Lachev" <teo@.nospam.prologika.com> wrote in message news:<eNMBbwMgEHA.396@.TK2MSFTNGP12.phx.gbl>...
> Glenn,
> The right question in this case is "Under what identity am I trying to call
> the RS Web service?". For example, if it is from a WinForm app, you need to
> set proxy credentials to DefaultCredentials, as follows:
> rs.Credentials = System.Net.CredentialCache.DefaultCredentials
> Please review the "Using the SOAP API in a Windows Application" and "Using
> the SOAP API in a Web Application" for more info.
> --
> Hope this helps.
> ---
> Teo Lachev, MCSD, MCT
> Author: "Microsoft Reporting Services in Action"
> http://www.prologika.com
>
> "Glenn Owens" <gowens@.nixonpeabody.com> wrote in message
> news:bc4291aa.0408121414.5d18bff0@.posting.google.com...
> > I can't seem to hit on the right combination of roles/persimssions to
> > set against the Report Server in order to allow my localhost
> > implementation to access/browse/upload reports. Is there some deFacto
> > setting(s) that I should be using?
> >
> > After installation I was able to upload and browse. The trouble
> > started when I tried to instantiate a ReportingService object (I
> > wanted to be able to programatically browse the available reports -
> > previously uploaded). When I tried this I got an insufficient
> > privilege error for my generic internet user account. After having
> > tried a number of combinations I'm really stuck.
> >
> > Any help appreciated! (how-to links, diagrams, recipes,...)
> >
> > Glenn|||Hi Glenn:
What is the exact error message you get? Is it access denied, or is it
'USERNAME does not have the required permissions' type of error? Do
you have authentication in web.config set to windows and deny
anonymous acess?
I have some information here:
Authentication, Role-based Security, and SQL Reporting Services Web
Services
http://odetocode.com/Articles/216.aspx
Introduction To Role-Based Security In SQL Server Reporting Services
http://odetocode.com/Articles/215.aspx
--
Scott
http://www.OdeToCode.com
On 13 Aug 2004 04:36:02 -0700, gowens@.nixonpeabody.com (Glenn Owens)
wrote:
>Teo, thanks for the response. I have read several of these how-to
>articles (and have attempted to implement the code for my
>application/WEB page). That's where I encounter the problems.
>The article, which you reference, suggests adding impersonation to the
>web.config... - already did that. It suggests setting the
>ReportingService object credentials to the Default... - already did
>that. There's not much else in the article (or others). What I'm
>looking for is a little expertise on WEB/IIS 6.0 setup for using the
>SQL Reporting Services in a XP Pro, VB.Net 1.1, SQL 2000 environment.
>This can't that big a deal - but I'm swamped with other project issues
>and have not had the time to research. I'm hoping that someone has
>already gone through this and is willing to do some knowledge-sharing.
>Thanks,
>Glenn
>sql

NEAR operator

What is the specific function of NEAR?
I'm indexing across 3 text fields and expect hits for 'white NEAR black' and
only getting a hit when the two words are in the same field, but not if they
are spread across two of the fields.
How NEAR does the other word have to be?
Nearness is reflected in rank. The closer together two words are the higher
the rank everything else being equal.
Nearness is calculated on a per column basis, it cannot look across columns.
FreeText factors nearness into rank (everything else being equal) and can
look across columns. FreeText ignores the near operator however, as it is
calcuated in the rank.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
"Bill D" <delaneWC-nospam@.mail.slh.wisc.edu> wrote in message
news:e2kX0QboEHA.3488@.TK2MSFTNGP12.phx.gbl...
> What is the specific function of NEAR?
> I'm indexing across 3 text fields and expect hits for 'white NEAR black'
and
> only getting a hit when the two words are in the same field, but not if
they
> are spread across two of the fields.
> How NEAR does the other word have to be?
>
|||Very helpful. I had found that using Freetext instead of Contains was
getting me more results. Thanks Hilary.
"Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
news:Op2bxxboEHA.1576@.TK2MSFTNGP12.phx.gbl...
> Nearness is reflected in rank. The closer together two words are the
higher
> the rank everything else being equal.
> Nearness is calculated on a per column basis, it cannot look across
columns.
> FreeText factors nearness into rank (everything else being equal) and can
> look across columns. FreeText ignores the near operator however, as it is
> calcuated in the rank.
> --
> Hilary Cotter
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
>
> "Bill D" <delaneWC-nospam@.mail.slh.wisc.edu> wrote in message
> news:e2kX0QboEHA.3488@.TK2MSFTNGP12.phx.gbl...
> and
> they
>