Reporting Services 2005 - Simple Q

Hi All,

We have an installation of 2005 on Win box. We have deployed reports in one folder Folder A and some reports in a subfolder of A called B.

Now we have put integrated windows authentication. I have edited the security of sub folder B and just provided login to User X. The main folder A has both users X and Y as users, X being content manager and Y being Browser. But whenever I login as User Y I still see the sub folder.

Is there any way to hide that folder?

Also to mention that both users X and Y are part of BUILT IN \ Adminsitrators group

Thanks

Manbish

This is behavior is because we try to prevent you from locking yourself out of the report server.

It is documented here: http://msdn2.microsoft.com/en-us/library/ms157255.aspx

Hope this helps,

-Lukasz

Reporting Services -- Connection issues

RS Web Site and database on the same WIN 2003 Server. Visual Studio dev on
a XP Pro.
Installation was no problem ... installed the AdventureWorks sample reports
(via a Command script).
Able to open http://<servername>/reports however when running the sample
reports the following message is received "An error has occurred during
report processing. (rsProcessingAborted) Get Online Help
Cannot create a connection to data source 'AdventureWorks'.
(rsErrorOpeningConnection)"
I have unsuccessfully reset the "Data Source Properties" several ways
(credential are not required and Use Win credentals with Impersonate, and
etc)
Additionally when creating a report with VS all the dataset queries run fine
... the report "Preview" returns the report and no error when doing a
"Build". However when "Deploying" this error message is returned " The
report server cannot open a connection to the report server database. A
connection to the database is required for all requests and processing."
Some sort of successful connection has to exist to return the Web page with
the sample reports listed and the successful "Preview'. So what's the
problem.
Could this be an issue because the SQL Server installation is a 'Named
Instance' .. If so is there a work around?
Thanks in advance
GeneH
I miss posted this question ... I have move it to sqlserver.reportingsvcs
thanks
"GeneH" wrote:

> RS Web Site and database on the same WIN 2003 Server. Visual Studio dev on
> a XP Pro.
> Installation was no problem ... installed the AdventureWorks sample reports
> (via a Command script).
> Able to open http://<servername>/reports however when running the sample
> reports the following message is received "An error has occurred during
> report processing. (rsProcessingAborted) Get Online Help
> Cannot create a connection to data source 'AdventureWorks'.
> (rsErrorOpeningConnection)"
> I have unsuccessfully reset the "Data Source Properties" several ways
> (credential are not required and Use Win credentals with Impersonate, and
> etc)
> Additionally when creating a report with VS all the dataset queries run fine
> ... the report "Preview" returns the report and no error when doing a
> "Build". However when "Deploying" this error message is returned " The
> report server cannot open a connection to the report server database. A
> connection to the database is required for all requests and processing."
>
> Some sort of successful connection has to exist to return the Web page with
> the sample reports listed and the successful "Preview'. So what's the
> problem.
> Could this be an issue because the SQL Server installation is a 'Named
> Instance' .. If so is there a work around?
> --
> Thanks in advance
> GeneH
sql

Reporting Service

I am trying to write a win app that will display the list of reports on a server that a given user id has access to. For example, if there are 150 reports on a server, how to tell which reports loginA has access to. I can get the list of reports, but I am not sure how to get the security information for each report. Anyone have any ideas?

R

Hi Ron,

Take a look at the ListChildren SOAP method. I believe it does exactly what you are looking for.

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rsprog/htm/rsp_ref_soapapi_service_lz_2yt2.asp

|||

I am using that, and I am getting the report listing. The trouble is I want to know what login has access to which reports. ListChildren doesn't do this and I am REALLY trying not to directly access the RS database. I am assuming that the Profile related tables have the info I want.

R