Showing posts with label properties. Show all posts
Showing posts with label properties. Show all posts

Monday, March 26, 2012

rsAccessDenied even for the Content Manager role

I have the Content Manager rights on a folder and on a report for my user.
When I try to edit ther report properties I got the error
the permissions granted to user `domain\user` are insufficient for
performing this operation (rsAccessDenied)
I am able to upload, create folders, create data source, upload file, but
not to view the report properties
--
AlexSounds like someone changed the Security for that Particular report, so you
can't mess with it...
All of the things you can do, have perms at the folder level...Report
properties can be set at the report level, so if someone removed
ContentManager Role from the specific report, you'd get the behaviour you are
seeing..
Hope this helps.
--
Wayne Snyder MCDBA, SQL Server MVP
Mariner, Charlotte, NC
I support the Professional Association for SQL Server ( PASS) and it''s
community of SQL Professionals.
See you at the PASS Conference!
"Alex" wrote:
> I have the Content Manager rights on a folder and on a report for my user.
> When I try to edit ther report properties I got the error
> the permissions granted to user `domain\user` are insufficient for
> performing this operation (rsAccessDenied)
> I am able to upload, create folders, create data source, upload file, but
> not to view the report properties
> --
> Alex|||I just verified it and It has the Content Manager perms
I even created a new folder with the builtin\Administrators Content
Manager and the Server\user Content Manager too.
I checked the report's security tab, and in all the reports in that folder I
have both, the Builtin\Administrators Content Manager and the Server\user
Content Manager permissions.
But Still having the rsAccessDenied Error
I would appreciate very much any help about it
Thanks
--
Alex
"Wayne Snyder" wrote:
> Sounds like someone changed the Security for that Particular report, so you
> can't mess with it...
> All of the things you can do, have perms at the folder level...Report
> properties can be set at the report level, so if someone removed
> ContentManager Role from the specific report, you'd get the behaviour you are
> seeing..
> Hope this helps.
> --
> Wayne Snyder MCDBA, SQL Server MVP
> Mariner, Charlotte, NC
> I support the Professional Association for SQL Server ( PASS) and it''s
> community of SQL Professionals.
> See you at the PASS Conference!
>
> "Alex" wrote:
> > I have the Content Manager rights on a folder and on a report for my user.
> >
> > When I try to edit ther report properties I got the error
> > the permissions granted to user `domain\user` are insufficient for
> > performing this operation (rsAccessDenied)
> >
> > I am able to upload, create folders, create data source, upload file, but
> > not to view the report properties
> >
> > --
> > Alex|||I had the same problem you described and fixed it by granting the NT group
the 'Content Manager' permissions at the 'Root' of the Report Server site.
After doing this the permissions were applied correctly to the Folders
underneath this.
Hope this helps.
Diran
"Alex" wrote:
> I just verified it and It has the Content Manager perms
> I even created a new folder with the builtin\Administrators Content
> Manager and the Server\user Content Manager too.
> I checked the report's security tab, and in all the reports in that folder I
> have both, the Builtin\Administrators Content Manager and the Server\user
> Content Manager permissions.
> But Still having the rsAccessDenied Error
> I would appreciate very much any help about it
> Thanks
> --
> Alex
>
> "Wayne Snyder" wrote:
> > Sounds like someone changed the Security for that Particular report, so you
> > can't mess with it...
> >
> > All of the things you can do, have perms at the folder level...Report
> > properties can be set at the report level, so if someone removed
> > ContentManager Role from the specific report, you'd get the behaviour you are
> > seeing..
> >
> > Hope this helps.
> > --
> > Wayne Snyder MCDBA, SQL Server MVP
> > Mariner, Charlotte, NC
> >
> > I support the Professional Association for SQL Server ( PASS) and it''s
> > community of SQL Professionals.
> > See you at the PASS Conference!
> >
> >
> > "Alex" wrote:
> >
> > > I have the Content Manager rights on a folder and on a report for my user.
> > >
> > > When I try to edit ther report properties I got the error
> > > the permissions granted to user `domain\user` are insufficient for
> > > performing this operation (rsAccessDenied)
> > >
> > > I am able to upload, create folders, create data source, upload file, but
> > > not to view the report properties
> > >
> > > --
> > > Alex|||Thanks Diran,
It worked, I just granted the "My Reports" permissions.
Thanks again!
--
Alex
"Diran" wrote:
> I had the same problem you described and fixed it by granting the NT group
> the 'Content Manager' permissions at the 'Root' of the Report Server site.
> After doing this the permissions were applied correctly to the Folders
> underneath this.
> Hope this helps.
> Diran
>
> "Alex" wrote:
> > I just verified it and It has the Content Manager perms
> >
> > I even created a new folder with the builtin\Administrators Content
> > Manager and the Server\user Content Manager too.
> >
> > I checked the report's security tab, and in all the reports in that folder I
> > have both, the Builtin\Administrators Content Manager and the Server\user
> > Content Manager permissions.
> >
> > But Still having the rsAccessDenied Error
> >
> > I would appreciate very much any help about it
> > Thanks
> >
> > --
> > Alex
> >
> >
> > "Wayne Snyder" wrote:
> >
> > > Sounds like someone changed the Security for that Particular report, so you
> > > can't mess with it...
> > >
> > > All of the things you can do, have perms at the folder level...Report
> > > properties can be set at the report level, so if someone removed
> > > ContentManager Role from the specific report, you'd get the behaviour you are
> > > seeing..
> > >
> > > Hope this helps.
> > > --
> > > Wayne Snyder MCDBA, SQL Server MVP
> > > Mariner, Charlotte, NC
> > >
> > > I support the Professional Association for SQL Server ( PASS) and it''s
> > > community of SQL Professionals.
> > > See you at the PASS Conference!
> > >
> > >
> > > "Alex" wrote:
> > >
> > > > I have the Content Manager rights on a folder and on a report for my user.
> > > >
> > > > When I try to edit ther report properties I got the error
> > > > the permissions granted to user `domain\user` are insufficient for
> > > > performing this operation (rsAccessDenied)
> > > >
> > > > I am able to upload, create folders, create data source, upload file, but
> > > > not to view the report properties
> > > >
> > > > --
> > > > Alex

Friday, March 23, 2012

RS2005 Print Legal

Hello,
I'm trying to automate printing to legal size paper from the web
ReportViewer control.
In my Report Properties / Layout I have Page Width= 14in and Page
Height= 8.5in.
When the report renders I hit the print icon. It shows that the report
will print to landscape,
but the paper size is set to Letter.
Is there a way to programatically set the paper size to legal?
TIA,
JimNo you can not set this on the fly, and there have been bugs regarding the
portrait/landscape issue..
However you may have the settings backward... Width should be 8.5in and
height should be 14in...(myabe you just typed it backward in your post.)
--
Wayne Snyder MCDBA, SQL Server MVP
Mariner, Charlotte, NC
I support the Professional Association for SQL Server ( PASS) and it''s
community of SQL Professionals.
"jhcorey@.yahoo.com" wrote:
> Hello,
> I'm trying to automate printing to legal size paper from the web
> ReportViewer control.
> In my Report Properties / Layout I have Page Width= 14in and Page
> Height= 8.5in.
> When the report renders I hit the print icon. It shows that the report
> will print to landscape,
> but the paper size is set to Letter.
> Is there a way to programatically set the paper size to legal?
> TIA,
> Jim
>

Saturday, February 25, 2012

RS Designer giving 'Unspecified Error' & 'SR.DESIGNERLOADEREditFai

When I uncheck the 'Snap to Grid' checkbox in the Report properties window,
and attempt to move an element in the report designer, I recieve an
Unspecified error, I continously get this error popping up - I have to close
VS.NET and reopen for the error messeges to stop. I also occasionally get the
'SR.DESIGNERLOADEREditFailed' Messege.
I have uninstalled RS Client and VS.NET, reinstalled both, and still get the
same errors. I have Windows XP SP1, VS.NET 2003 and applied SP1 to RS I don't
know if maybe there is a particular config change or hotfix needed for my
specific configuration for RS Designer to work correctly.
I hope anyone can help, as my group cannot deploy RS if I can't design any
reports.I have resolved the issue in a very bizzare way. So this is an FYI for those
who may encounter similar error messeges.
Upon moving an item after setting the 'Snap to Grid' to uncheck in Report
designer mode. Somehow the app had a conflict with the contents of the
ProviderRegKey ni the registry which was set to Clearcase. When I removed the
value and replaced it with 'Software\Microsoft\SourceSafe'. Everything works
fine.
I don't understand the logic of this, but thanks to a blog by someone with a
similar error in VS.NET but totally unrelated to Reporting Services... got me
to try this.
If an MVP can shine a little light on this... would be greatly appreiciated.
"d pak" wrote:
> When I uncheck the 'Snap to Grid' checkbox in the Report properties window,
> and attempt to move an element in the report designer, I recieve an
> Unspecified error, I continously get this error popping up - I have to close
> VS.NET and reopen for the error messeges to stop. I also occasionally get the
> 'SR.DESIGNERLOADEREditFailed' Messege.
> I have uninstalled RS Client and VS.NET, reinstalled both, and still get the
> same errors. I have Windows XP SP1, VS.NET 2003 and applied SP1 to RS I don't
> know if maybe there is a particular config change or hotfix needed for my
> specific configuration for RS Designer to work correctly.
> I hope anyone can help, as my group cannot deploy RS if I can't design any
> reports.

RS bug

I think I've found small bug.
1. ReportManager
2. Report Properties
3. Execution
when I once change defult option
"Do not cache temporary copies of this report"
to
"Cache a temporary copy of the report. Expire copy of report after a
number of minutes"
then I can not get back to first, defult option.
I can choose one but after selecting Apply button nothing happens.
KamelNothing has changed in SP2 on this page. Do you see a script error in IE?
--
Brian Welcker
Group Program Manager
Microsoft SQL Server
This posting is provided "AS IS" with no warranties, and confers no rights.
"kamel" <kwiciak@.gmail.com> wrote in message
news:1114444103.114031.282320@.f14g2000cwb.googlegroups.com...
>I think I've found small bug.
> 1. ReportManager
> 2. Report Properties
> 3. Execution
> when I once change defult option
> "Do not cache temporary copies of this report"
> to
> "Cache a temporary copy of the report. Expire copy of report after a
> number of minutes"
> then I can not get back to first, defult option.
> I can choose one but after selecting Apply button nothing happens.
> Kamel
>|||ok, this is IE error
IE restart solved the problem
thanks,
Kamel