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

Need basic SQL query help

Trying to select unique records from a database. A combination of 2 variables make the record unique. Need to export all rows of the return. I have below rudimentary sql skills (select/where) and cannot figure this one out. The database has ~ 180k rows, of which there are only ~ 50k unique records.

The data is on a single table, 15 seperate columns. It is a table containing network router data. The existing table set up shows the historical progression of changes/updates to these routers. I am trying to determine the latest records of the routers in question. Since some of the IP addresses have been used multiple times (moved from site A to site B for example), there are multiple dupe records that I do not want.
The two fields I need to use to identify unique records are:
serial_IP and site_id
In addition to that, I would also like to know how to format "max date" query, so that I get the latest information. I can do that manually if I must via a sort when I export the data, but it would be nice to know how to do that in the future.

thanks

noclueAs those two columns make a unique key on the table, there is possibility of use of a DISTINCT keyword, such as

SELECT DISTINCT serial_IP, site_id FROM your_table;

However, regarding your next request (selecting records with the latest date), there's need to use a subquery:SELECT DISTINCT t.serial_IP, t.site_id
FROM your_table t
WHERE t.date_column = (SELECT max(t1.date_column)
FROM your_table t1
WHERE t1.serial_IP = t.serial_IP
AND t1.site_id = t.site_id
);The DISTINCT keyword might, or might not be needed in this case: if table has only one record per "date_column", you won't need that. If there are multiple records per every "date_column" value, you'll still need it to eliminate multiple records.