Report Builder Permissions

Hi there,

I created a System Role: Report Builder User (checked "Execute Report Definitions")

Created a folder Home/FolderName/ReportModels

Created a Report Model, deployed it to the above folder.

The are a few users we would like them to run the report model, they belong to a windows group.

I assigned The "Report Builder User" to this Group.

The issue I have that when they run the Report Builder they get a login window (which then doesn't let them to continue).

I managed to overcome this by assiging to this group a "Browser" role at the Home level.

If I remove this assignment and set it in one level underneath the Home folder they can't run the Report Builder.

We don't want them to be able to view the folders at this level, Is there any other option besides setting the Browser role at the Home folder?

Thank you,

Itzhak

I believe users need to have at least Browser permission on all the parent folders of a given folder in addition to the folder itself. So yes, they will need to have permission to the Home folder. However, this will not (by itself) allow them to see subfolders of the Home folder to which they do not have permission. So you should still be able to hide the folders you don't want them to see.

Hope this helps!

|||

That's what I thought.

Yes, it did help.

Thank you,

Itzhak

sql

Report Builder not working - Us Too

Hi, Running RS2005 (was running RS2000 on same system)
When trying to run Report Builder I am getting the following error;

Report Execution Error

The report might not be valid or the server could not process the data.

An attempt has been made to use a rendering extension that is not registered for this report server.

Anyone come across this error before?

Thanks in advance

Scott

anywhere I can go to get an answer to this. Excuse the pun but this renders Report Builder useless

Advaned thanks to anyone who has any idea

Scott

|||

We are getting same error on our shop. Have you found resolution yet?

|||

nothing from anyone....if you find anything I would appreciate anything you find.

I have searched high and low.

One person on another forum said the following;

'Did you upgrade from RS2000 to RS2005? If so, prior to the upgrade, did you have any custom controls or third party controls you may have bought installed? That error message to me seems to say that the report is trying to show a control for which a dll (control source) does not exist. This would lead me to believe - based on you saying RS2000 worked before - that when you did an upgrade, you did not setup these custom controls. '

Maybe it might help

Scott

|||

I spent at lot of time on Friday getting the SelfSSL working on the system. It was set up with the name of the computer, I managed to get it working with ComputerName.domain.com/local etc.

I have just come back to Report builder and it now works!! I am writing this just incase it gives you a clue to how I managed to get it working

Thanks

Scott

Report Builder not working - Us Too

Hi, Running RS2005 (was running RS2000 on same system)
When trying to run Report Builder I am getting the following error;

Report Execution Error

The report might not be valid or the server could not process the data.

An attempt has been made to use a rendering extension that is not registered for this report server.

Anyone come across this error before?

Thanks in advance

Scott

anywhere I can go to get an answer to this. Excuse the pun but this renders Report Builder useless

Advaned thanks to anyone who has any idea

Scott

|||

We are getting same error on our shop. Have you found resolution yet?

|||

nothing from anyone....if you find anything I would appreciate anything you find.

I have searched high and low.

One person on another forum said the following;

'Did you upgrade from RS2000 to RS2005? If so, prior to the upgrade, did you have any custom controls or third party controls you may have bought installed? That error message to me seems to say that the report is trying to show a control for which a dll (control source) does not exist. This would lead me to believe - based on you saying RS2000 worked before - that when you did an upgrade, you did not setup these custom controls. '

Maybe it might help

Scott

|||

I spent at lot of time on Friday getting the SelfSSL working on the system. It was set up with the name of the computer, I managed to get it working with ComputerName.domain.com/local etc.

I have just come back to Report builder and it now works!! I am writing this just incase it gives you a clue to how I managed to get it working

Thanks

Scott

Report Builder not working

Hi, Running RS2005 (was running RS2000 on same system)
When trying to run Report Builder I am getting the following error;

Report Execution Error

The report might not be valid or the server could not process the data.

An attempt has been made to use a rendering extension that is not registered for this report server.

Anyone come across this error before?

Thanks in advance

Scott

anywhere I can go to get an answer to this. Excuse the pun but this renders Report Builder useless

Advaned thanks to anyone who has any idea

Scott

|||

We are getting same error on our shop. Have you found resolution yet?

|||

nothing from anyone....if you find anything I would appreciate anything you find.

I have searched high and low.

One person on another forum said the following;

'Did you upgrade from RS2000 to RS2005? If so, prior to the upgrade, did you have any custom controls or third party controls you may have bought installed? That error message to me seems to say that the report is trying to show a control for which a dll (control source) does not exist. This would lead me to believe - based on you saying RS2000 worked before - that when you did an upgrade, you did not setup these custom controls. '

Maybe it might help

Scott

|||

I spent at lot of time on Friday getting the SelfSSL working on the system. It was set up with the name of the computer, I managed to get it working with ComputerName.domain.com/local etc.

I have just come back to Report builder and it now works!! I am writing this just incase it gives you a clue to how I managed to get it working

Thanks

Scott

Report Builder not working

Hi, Running RS2005 (was running RS2000 on same system)
When trying to run Report Builder I am getting the following error;

Report Execution Error

The report might not be valid or the server could not process the data.

An attempt has been made to use a rendering extension that is not registered for this report server.

Anyone come across this error before?

Thanks in advance

Scott

anywhere I can go to get an answer to this. Excuse the pun but this renders Report Builder useless

Advaned thanks to anyone who has any idea

Scott

|||

We are getting same error on our shop. Have you found resolution yet?

|||

nothing from anyone....if you find anything I would appreciate anything you find.

I have searched high and low.

One person on another forum said the following;

'Did you upgrade from RS2000 to RS2005? If so, prior to the upgrade, did you have any custom controls or third party controls you may have bought installed? That error message to me seems to say that the report is trying to show a control for which a dll (control source) does not exist. This would lead me to believe - based on you saying RS2000 worked before - that when you did an upgrade, you did not setup these custom controls. '

Maybe it might help

Scott

|||

I spent at lot of time on Friday getting the SelfSSL working on the system. It was set up with the name of the computer, I managed to get it working with ComputerName.domain.com/local etc.

I have just come back to Report builder and it now works!! I am writing this just incase it gives you a clue to how I managed to get it working

Thanks

Scott

sql

Report Builder button doesn't appear....

Users must have permission to the Execute Report Definitions task (normally obtained via the System Users role) for the Report Builder button to be displayed.
--Original Message--
From: Jay@.discussions.microsoft.com
Posted At: Friday, October 21, 2005 4:01 PM
Posted To: microsoft.public.sqlserver.reportingsvcs
Conversation: Report Builder button doesn't appear...
Subject: RE: Report Builder button doesn't appear...
I have run into a similar problem on my machine. The Report Builder button
never appears in my report manager home page.
I'm using Windows 2000 workstation with SQL Server 2005 (September)
Jay
"Allan" wrote:
> Hi,
> I have the latest CTP installed. Users do not see the report builder button.
> Only members of the local admin group seem to have it displayed. Can anyone
> steer me in the right direction'
>
> AllanHow do I do this. Please explain step-by-step. This is a third explanation
I have run across. Please see text below that I posted elsewhere:
Report Builder button does not show when an upgrade to Reporting Services
2005 is completed. If a fresh install is done then no problem. I need to do
an upgrade for an existing Reports Server 2000 and want user to have the
Report Builder button. Some docuementation said to set
EnableReportDesignClientDownload to true, but did not say how to do this.
Another document said Enable Report Design Client Button is set to True in
RSWebApplication.config by default. However, this also did not show how to do
this. I need clear and exact step-by-step instructions.
"Bob Meyers MSFT" wrote:
> Users must have permission to the Execute Report Definitions task (normally obtained via the System Users role) for the Report Builder button to be displayed.
>
> --Original Message--
> From: Jay@.discussions.microsoft.com
> Posted At: Friday, October 21, 2005 4:01 PM
> Posted To: microsoft.public.sqlserver.reportingsvcs
> Conversation: Report Builder button doesn't appear...
> Subject: RE: Report Builder button doesn't appear...
>
> I have run into a similar problem on my machine. The Report Builder button
> never appears in my report manager home page.
> I'm using Windows 2000 workstation with SQL Server 2005 (September)
> Jay
> "Allan" wrote:
> > Hi,
> > I have the latest CTP installed. Users do not see the report builder button.
> > Only members of the local admin group seem to have it displayed. Can anyone
> > steer me in the right direction'
> >
> > Allan
>|||I would also appreciate some help on this. The only time I see the
button is when I'm logged onto the machine that's hosting RS.
Users that have all possible roles assigned do not see the button on
the web site.
How can I make the button visible?

Reporing Services not responding

I am having a problem with Reporting Services. I had installed the developer
edition on my system and everything was working fine. Next day, turned my
system on and the report manager no longer responds. I can't access any of
the reports I had developed...nothing.
I am a newbie at reporting services but was making great progress learning
the product. The only indication of a problem I can find is in my event log.
I see that I am getting a SuperSocket bind failed on port 1433.
I have attempted removing and re-installing reporting services, as well as
to delete the reporting services databases but cannot seem to run this
product any more.
Can anyone help point me to what may be wrong?From the error message you are getting "SuperSocket bind failed on port
1433", i would say to have a look and see if your sql server is running
Med Bouchena
"Guy Thornton" <gt@.scd.com> a écrit dans le message de news:
5BEA585E-64F3-415B-A962-0B2F8DD210DD@.microsoft.com...
>I am having a problem with Reporting Services. I had installed the
>developer
> edition on my system and everything was working fine. Next day, turned my
> system on and the report manager no longer responds. I can't access any
> of
> the reports I had developed...nothing.
> I am a newbie at reporting services but was making great progress learning
> the product. The only indication of a problem I can find is in my event
> log.
> I see that I am getting a SuperSocket bind failed on port 1433.
> I have attempted removing and re-installing reporting services, as well as
> to delete the reporting services databases but cannot seem to run this
> product any more.
> Can anyone help point me to what may be wrong?
>|||Thanks for the suggestion Med. I actually thought the same thing. So I did
check my SQL Server installation. That is all working just fine.
I have also been able to track down in the HTTP logs that when I attempt to
access Report Manager, I am getting a 302 error.
"Med Bouchenafa" wrote:
> From the error message you are getting "SuperSocket bind failed on port
> 1433", i would say to have a look and see if your sql server is running
> Med Bouchena
> "Guy Thornton" <gt@.scd.com> a écrit dans le message de news:
> 5BEA585E-64F3-415B-A962-0B2F8DD210DD@.microsoft.com...
> >I am having a problem with Reporting Services. I had installed the
> >developer
> > edition on my system and everything was working fine. Next day, turned my
> > system on and the report manager no longer responds. I can't access any
> > of
> > the reports I had developed...nothing.
> >
> > I am a newbie at reporting services but was making great progress learning
> > the product. The only indication of a problem I can find is in my event
> > log.
> > I see that I am getting a SuperSocket bind failed on port 1433.
> >
> > I have attempted removing and re-installing reporting services, as well as
> > to delete the reporting services databases but cannot seem to run this
> > product any more.
> >
> > Can anyone help point me to what may be wrong?
> >
> >
>
>