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

RS Utility- preserve folder structure and deploy RDSs

I am trying to figure out the RS command line utility. How do I
create/preserve a folder structure for organizing my reports, and how do I
deploy RDSs with this utility. Also, the sample script just shows how to
create data sources, not deploy the ones I have already created.
--
JasonThe RS.exe simply packages the SOAP API. So if you have an .RDS file,
you'll need to write parsing logic in your script to read the contents of it
and supply them to the CreateDataSource method.
BTW - there is no way to push a .rds file to the server; it's a file that is
used by the report designer while you're designing reports.
-Lukasz
This posting is provided "AS IS" with no warranties, and confers no rights.
"JasonDWilson" <JasonDWilson@.discussions.microsoft.com> wrote in message
news:F75E6394-E1CC-4C03-8F7F-0BC2B8CBFDFC@.microsoft.com...
>I am trying to figure out the RS command line utility. How do I
> create/preserve a folder structure for organizing my reports, and how do I
> deploy RDSs with this utility. Also, the sample script just shows how to
> create data sources, not deploy the ones I have already created.
> --
> Jason

RS utility - folder structure for storing reports

I am trying to use the RS utility for deploying reports I create to our
customers. I need to hand them an install CD that does everything. I can
deploy reports via RS, but I am wondering how to preserve a folder structure
for organizing the reports. Also, how do I script subscriptions, and deploy
RDSs. The sample MS provides creates a new data source, not use the ones I
have already created in report design.
Thanks,
--
JasonYou might want to have a look at Reporting Services Scripter
http://www.sqldbatips.com/showarticle.asp?ID=62
I haven't got around to subscriptions yet but it should handle most of you
requirements
--
HTH
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"JasonDWilson" <JasonDWilson@.discussions.microsoft.com> wrote in message
news:6F2C98BD-CA88-4D6C-9BB9-A33960052690@.microsoft.com...
>I am trying to use the RS utility for deploying reports I create to our
> customers. I need to hand them an install CD that does everything. I can
> deploy reports via RS, but I am wondering how to preserve a folder
> structure
> for organizing the reports. Also, how do I script subscriptions, and
> deploy
> RDSs. The sample MS provides creates a new data source, not use the ones
> I
> have already created in report design.
> Thanks,
> --
> Jason|||Thanks. Like like a great utility. Is it freeware?
"Jasper Smith" wrote:
> You might want to have a look at Reporting Services Scripter
> http://www.sqldbatips.com/showarticle.asp?ID=62
> I haven't got around to subscriptions yet but it should handle most of you
> requirements
> --
> HTH
> Jasper Smith (SQL Server MVP)
> http://www.sqldbatips.com
> I support PASS - the definitive, global
> community for SQL Server professionals -
> http://www.sqlpass.org
> "JasonDWilson" <JasonDWilson@.discussions.microsoft.com> wrote in message
> news:6F2C98BD-CA88-4D6C-9BB9-A33960052690@.microsoft.com...
> >I am trying to use the RS utility for deploying reports I create to our
> > customers. I need to hand them an install CD that does everything. I can
> > deploy reports via RS, but I am wondering how to preserve a folder
> > structure
> > for organizing the reports. Also, how do I script subscriptions, and
> > deploy
> > RDSs. The sample MS provides creates a new data source, not use the ones
> > I
> > have already created in report design.
> >
> > Thanks,
> > --
> > Jason
>
>

RS user management

Does anyone know how to handle assigning permission to user folder without
using the report manager interface?
Through a command line or programmatically'You can do this by writing an application using the Web Service API or via
the Report Server script host (which are basically the same thing).
--
Brian Welcker
Group Program Manager
Microsoft SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Frank" <nospam@.nospam.org> wrote in message
news:uG6FRXddEHA.3148@.TK2MSFTNGP10.phx.gbl...
> Does anyone know how to handle assigning permission to user folder without
> using the report manager interface?
> Through a command line or programmatically'
>|||Some sample security scripting code here:
http://blogs.msdn.com/bryanke/archive/2004/03/17/91736.aspx
--
Bryan Keller
Developer Documentation
SQL Server Reporting Services
A friendly reminder that this posting is provided "AS IS" with no
warranties, and confers no rights.
"Frank" <nospam@.nospam.org> wrote in message
news:uG6FRXddEHA.3148@.TK2MSFTNGP10.phx.gbl...
> Does anyone know how to handle assigning permission to user folder without
> using the report manager interface?
> Through a command line or programmatically'
>|||Thank you all for your help
"Frank" <nospam@.nospam.org> wrote in message
news:uG6FRXddEHA.3148@.TK2MSFTNGP10.phx.gbl...
> Does anyone know how to handle assigning permission to user folder without
> using the report manager interface?
> Through a command line or programmatically'
>

RS installation Problem on Win2000

Hi,
I try to install reporting services on win2000 (sp4), everything went well.
when I try to access reports folder http://servername/reports I am getting
the follwoing error.
server has VS.NET 2003 and all latest service packs. I am trying for past
one three days to resolve this problem.
T I A.,
Nemani
Server Error in '/Reports' Application.
----
--
Configuration Error
Description: An error occurred during the processing of a configuration file
required to service this request. Please review the specific error details
below and modify your configuration file appropriately.
Parser Error Message: The XML file
c:\winnt\microsoft.net\framework\v1.1.4322\Config\machine.config could not
be loaded. Attempted to access an unloaded AppDomain.
Source Error:
[No relevant source lines]
Source File:
c:\winnt\microsoft.net\framework\v1.1.4322\Config\machine.config Line: 0Can you access http://servername/reportserver? It sounds like the ASP.NET
identity does not have access to the configuration files.
--
Brian Welcker
Group Program Manager
SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Nemani" <mnemani@.che.state.nm.us> wrote in message
news:eXNhiJEYEHA.2672@.TK2MSFTNGP09.phx.gbl...
> Hi,
> I try to install reporting services on win2000 (sp4), everything went
> well.
> when I try to access reports folder http://servername/reports I am getting
> the follwoing error.
> server has VS.NET 2003 and all latest service packs. I am trying for past
> one three days to resolve this problem.
> T I A.,
> Nemani
> Server Error in '/Reports' Application.
> ----
> --
> Configuration Error
> Description: An error occurred during the processing of a configuration
> file
> required to service this request. Please review the specific error details
> below and modify your configuration file appropriately.
> Parser Error Message: The XML file
> c:\winnt\microsoft.net\framework\v1.1.4322\Config\machine.config could not
> be loaded. Attempted to access an unloaded AppDomain.
> Source Error:
>
> [No relevant source lines]
>
> Source File:
> c:\winnt\microsoft.net\framework\v1.1.4322\Config\machine.config Line:
> 0
>|||Thank you for your response.
Yes, I can access http://servername/reportserver . I explicitly gave
permission to ASPNET account on Reports folder too. Still the error is same.
When I first installed the RS on the machine at that time it doesn't have
the Visual Studion.NET 2003, all it has is IIS, SQL 2000 (sp3a). I installed
the RS but it didn't worked. Then I installed Visual Studion.NET 2003 on the
machine but still the same problem.
Is Visual Studion.NET 2003 is madatory in order to run RS.
Thanks,
Nemani.
"Brian Welcker [MSFT]" <bwelcker@.online.microsoft.com> wrote in message
news:Ok2qp5MYEHA.2868@.TK2MSFTNGP09.phx.gbl...
> Can you access http://servername/reportserver? It sounds like the ASP.NET
> identity does not have access to the configuration files.
> --
> Brian Welcker
> Group Program Manager
> SQL Server Reporting Services
> This posting is provided "AS IS" with no warranties, and confers no
rights.
> "Nemani" <mnemani@.che.state.nm.us> wrote in message
> news:eXNhiJEYEHA.2672@.TK2MSFTNGP09.phx.gbl...
> > Hi,
> > I try to install reporting services on win2000 (sp4), everything went
> > well.
> > when I try to access reports folder http://servername/reports I am
getting
> > the follwoing error.
> > server has VS.NET 2003 and all latest service packs. I am trying for
past
> > one three days to resolve this problem.
> >
> > T I A.,
> > Nemani
> > Server Error in '/Reports' Application.
> ----
--
> > --
> >
> > Configuration Error
> > Description: An error occurred during the processing of a configuration
> > file
> > required to service this request. Please review the specific error
details
> > below and modify your configuration file appropriately.
> >
> > Parser Error Message: The XML file
> > c:\winnt\microsoft.net\framework\v1.1.4322\Config\machine.config could
not
> > be loaded. Attempted to access an unloaded AppDomain.
> >
> > Source Error:
> >
> >
> > [No relevant source lines]
> >
> >
> > Source File:
> > c:\winnt\microsoft.net\framework\v1.1.4322\Config\machine.config
Line:
> > 0
> >
> >
>

RS doesn't works under ASP.NET 2.0?

Hi,
when I switch my reportserver virtual folder to the ASp.net2.0 I receive
this error:
"Failed to load expression host assembly"
this error appears only when I try to render a report, I can list reports or
I can access the webservice without any error.
any solution?
thanks.
Jerome.RS 2000 is not a ASP.Net 2.0 app. It uses the 1.1 framework. RS 2005 is a
ASP.Net 2.0 app.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Jéjé" <willgart@.BBBhotmailAAA.com> wrote in message
news:%23ndrIwI9FHA.1332@.tk2msftngp13.phx.gbl...
> Hi,
> when I switch my reportserver virtual folder to the ASp.net2.0 I receive
> this error:
> "Failed to load expression host assembly"
> this error appears only when I try to render a report, I can list reports
> or I can access the webservice without any error.
> any solution?
> thanks.
> Jerome.
>|||I know, but, for example Sharepoint works fine under ASP.NET 2.0 and its a
1.1 software.
but if I switch the reportserver virtual directory from v1.1 to v2.0,
rendering a report stop working.
"Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
news:%232wwe4P9FHA.1248@.TK2MSFTNGP14.phx.gbl...
> RS 2000 is not a ASP.Net 2.0 app. It uses the 1.1 framework. RS 2005 is a
> ASP.Net 2.0 app.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Jéjé" <willgart@.BBBhotmailAAA.com> wrote in message
> news:%23ndrIwI9FHA.1332@.tk2msftngp13.phx.gbl...
>> Hi,
>> when I switch my reportserver virtual folder to the ASp.net2.0 I receive
>> this error:
>> "Failed to load expression host assembly"
>> this error appears only when I try to render a report, I can list reports
>> or I can access the webservice without any error.
>> any solution?
>> thanks.
>> Jerome.
>>
>|||If you want RS to work, leave it alone at 1.1 or upgrade to RS 2005. Note
that you can leave SQL Server as 2000 and still upgrade RS to 2005. You do
need a 2005 license though. Beside additional features I noticed significant
performance improvements with RS 2005.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Jéjé" <willgart_A_@.hotmail_A_.com> wrote in message
news:OrI6xeR9FHA.500@.TK2MSFTNGP15.phx.gbl...
>I know, but, for example Sharepoint works fine under ASP.NET 2.0 and its a
>1.1 software.
> but if I switch the reportserver virtual directory from v1.1 to v2.0,
> rendering a report stop working.
> "Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
> news:%232wwe4P9FHA.1248@.TK2MSFTNGP14.phx.gbl...
>> RS 2000 is not a ASP.Net 2.0 app. It uses the 1.1 framework. RS 2005 is a
>> ASP.Net 2.0 app.
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "Jéjé" <willgart@.BBBhotmailAAA.com> wrote in message
>> news:%23ndrIwI9FHA.1332@.tk2msftngp13.phx.gbl...
>> Hi,
>> when I switch my reportserver virtual folder to the ASp.net2.0 I receive
>> this error:
>> "Failed to load expression host assembly"
>> this error appears only when I try to render a report, I can list
>> reports or I can access the webservice without any error.
>> any solution?
>> thanks.
>> Jerome.
>>
>>
>